How to add new allowed/functional types into currency fields from ITSM . If you trying to add a new currency field on ITSM, you can use ITSM currency default field or developer studio.
|
This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.
1. Set the ARS server "Currency Type" on the "General Information" server administration. 2. Gather the list of forms to modify 3. Modify the relevant CMDB fields on CMDB using the Class Manager 4. Modify the currency ALLOWED and FUNCTIONAL currency fields for the relevant forms. 4.A Manually modify all the currency ALLOWED and FUNCTIONAL currency fields for the forms or 4.B Use the ITSM "default currency tool" (NOTE it can also add NON-DEFAULT currencies) 5. Flush your mid-tier and browser cache. In more detail, STEP 1. Set the ARS server "Currency Type" on the "General Information" server administration.
To allow developer studio and other tools to add other currency fields to the forms, add the current and NEW currency fields to the 'Allowable types' and 'Functional Types' table. USD\2, EUR\2, GBP\2, JPY\0, CAD\2
To perform that task, open AR System Administration Console from the Home page. Then select System > General > Server Information: Click 'Currency Types' tab, then add All relevant currencies to Allowable and Functional Type on the right panes. Click on the Apply button on the Server Information. There is no need to restart the AR server. STEP 2. Gather the list of forms to modify A quick way to retrieve the list of forms related to a currency field is using SQL ALL FORMS WITH CURRENCY FIELDS To retrieve the list of forms related to a currency-field, in the database use the following: SQL> SELECT a.name FROM ARSCHEMA a, FIELD f WHERE ((a.schemaid = f.schemaId) AND (f.datatype = 12)) group by a.name
ALL FORMS WITHOUT THE CURRENCY wanted To retrieve the list of forms related to a currency-field, in the database use the following: SQL> SELECT a.name FROM ARSCHEMA a, FIELD_CURR f WHERE ((a.schemaid = f.schemaId) AND NOT ((f.funcCurr LIKE '%\<currency-code>\<precision>\%') AND (f.allowCurr LIKE '%\<currency-code>\<precision>\%'))) group by a.name e.g SQL> SELECT a.name FROM ARSCHEMA a, FIELD_CURR f WHERE ((a.schemaid = f.schemaId) AND NOT ((f.funcCurr LIKE '%\CNY\3\%') AND (f.allowCurr LIKE '%\CNY\3\%'))) group by a.name
There are many other ways. Please choose the most relevant for your delivery. Then from the list, please pick the relevant forms for you to change.
NOTE Please the JOIN FORMS at the end of your LIST.
STEP 3. Modify the relevant fields on CMDB using the Class Manager if they belong to CMDB. The known CMDB Classes to modify are: - BMC.CORE:BMC_ContractLine --> Change field 'PriceAmount' (id:530065100) - BMC.CORE:BMC_Cost --> Change field 'CostAmount' (id:530065300) - BMC.CORE:BMC_Price --> Change field 'PriceAmount' (id:530065100)
Check your list. Do not change - NO OBJSTR:AttributeDefinition - NO OBJSTR:Template:AttributeFields
STEP 4. Modify the currency ALLOWED and FUNCTIONAL currency fields for the relevant forms. You could either STEP 4.A Manually modify all the currency ALLOWED and FUNCTIONAL currency fields for the forms This step is relevant if you are using OVERLAYS. Just open developer studio, then search for the relevant forms, then modify the currency fields. Once the form is open, you can sort the field list by 'Type'. Select Currency.
STEP 4.B Use the ITSM "default currency tool" (NOTE it can also add NON-DEFAULT currencies) DO NOT USE ON OVERLAYED FORMS. You use it as follow: CMD>java -jar JARCurrencyDefault.jar -x "ARServer" -u "userName"-p "password" -t "TCPport" -F inputforms.txt -c currency/precision -l . NOTE: You need to create a file named "inputforms.txt" with one form name per line. Use a text editor. For more information on syntax refer below doc link: CMD> java -jar JARCurrencyDefault.jar -x "localhost" -u "Demo" -F inputforms.txt -c "CNY/3" -c "USD/2" -c "EUR/2" -c "GBP/2" -c "JPY/2" -c "CAD/2" -l . it will add "CNY/3" as I already have the other fields CMD> java -jar JARCurrencyDefault.jar -x "localhost" -u "Demo" -F inputforms.txt -c "CNY/3" -c "USD/2" -c "EUR/2" -d -c "GBP/2" -c "JPY/2" -c "CAD/2" -l . It will add "CNY/3" as I already have the other fields. It will also ensure "EUR\2" is the default (-d option). Then check arcurrencydefault.txt and arcurrencydefault_error.txt for any errors/messages. Finally, validate the form changes by exporting the definition file and validating the field allowed/functional currencies.
Here is an example of the list of the forms with currency fields for ITSM 8.1 SP2: **20150313_itsmformswithcurreny.txt********** AAS:Activity AAS:LoadActivity AP:Detail AP:Detail-Signature APR:Approver Lookup APR:SYS-Approval Definition AST:AUD_AssetAssociations AST:Account AST:Activity AST:AdditionalInfoTab AST:AdminDomain AST:Application AST:ApplicationInfrastructure AST:ApplicationService AST:ApplicationSystem AST:AssetCost AST:AssetCostDepreciationHeader AST:AssetLease_ AST:AssetMaintenance AST:AssetPeople_AssetBase AST:AssetSoftware AST:AssetSupport AST:AssetWarranty AST:Attributes AST:BIOSElement AST:BaseElement AST:BulkInventory AST:BusinessProcess AST:BusinessService AST:CDROMDrive AST:CI Associations Search AST:CI Unavailability AST:CIU Search-Associations AST:Card AST:CertificateBySoftwareContract AST:Chassis AST:Cluster AST:CommunicationEndpoint AST:ComputerSystem AST:ConcreteCollection AST:Configuration AST:ConnectivityCollection AST:ConnectivitySegment AST:Contract-CIAssociations AST:ContractRelationshipAndLicenseCertificate AST:DataBase AST:DataBaseStorage AST:DiskDrive AST:DiskPartition AST:Document AST:Equipment AST:FileSystem AST:FloppyDrive AST:HardwarePackage AST:HardwareSystemComponent AST:IPConnectivitySubnet AST:IPEndpoint AST:IPXConnectivityNetwork AST:InventoryStorage AST:Keyboard AST:LAN AST:LANEndpoint AST:LNsCollection AST:LicenseCertificateUpgradeDlg AST:LicenseCertificates AST:LoadAttributes AST:LoadComplianceMultiplierLookupTbl AST:LoadConfigRuleSet AST:LocalFileSystem AST:LogicalSystemComponent AST:Mainframe AST:Media AST:Memory AST:Monitor AST:NTDomain AST:NetworkPort AST:OperatingSystem AST:Organization AST:Package AST:Patch AST:Person AST:PhysicalLocation AST:PointingDevice AST:Printer AST:Processor AST:Product AST:ProtocolEndpoint AST:PurchaseLineItem AST:PurchaseLineItemInterface AST:PurchaseLineItemInterface_Create AST:PurchaseLineItem_Processing AST:PurchaseOrder AST:PurchaseOrderInterface AST:PurchaseRequisition AST:PurchaseRequisition-Detail AST:PurchaseRequisition-Detail-Signature AST:PurchaseRequisitionInterface AST:Purchasing Console AST:Rack AST:RemoteFileSystem AST:ResourceAllocationSettingData AST:ResourcePool AST:Role AST:ServiceOfferingInstance AST:Share AST:SoftwareServer AST:SoftwareUsage AST:SystemResource AST:SystemSoftware AST:TapeDrive AST:Transaction AST:UPS AST:UserCommunity AST:VirtualSystemEnabler AST:VirtualSystemSettingData AST:WAN CBK:ChargeBack CHG:Change Dialogs CHG:Change Dialogs Classic CHG:ChangeAPDetailSignature CHG:ChangeASI:ChgCI_ComputerSystemBaseRelationships CHG:CostAllocation CHG:Infrastructure Change CHG:Infrastructure Change Classic CHG:InfrastructureChangeAPDetail CMDB:DataModelReference_Attribute CMDB:USMAPIInterface CTM:LoadPeople CTM:LoadPeopleModification CTM:People CTM:Ppl Search-PermissionGrp CTM:Ppl Search-SupportGrpAssoc CTM:Ppl Search-SupportGrpFuncR CTM:Ppl Search-Worklog CTM:UpdatePeople CTR:ContractBase CTR:ContractBase_Locale CTR:Contract_Relationship CTR:Contract_Relationship_Child CTR:Contract_Relationship_Child_Locale CTR:Contract_Relationship_Parent CTR:Contract_Relationship_Parent_Locale CTR:GenericContract CTR:LoadContractBase CTR:LoadContract_Relationship CTR:MasterContract FIN:ConfigCostRates FIN:CostInterface FIN:Costs FIN:LoadCosts FIN:LoadPayments FIN:Payments FIN:TemplateCosts HPD:Help Desk HPD:Help Desk Classic HPD:Help Desk Dialogs HPD:Help Desk Dialogs Classic HPD:Search-Assignment Logs HPD:Search-Associations HPD:Search-Worklog IAM:RequestApDetail IAM:RequestApDetailSignature IAM:SRM:Access_RequestAccessRights_AIF IAM:SRM:Access_RevokeAccessRights_AIF IAM:SRM:ApplicationURL_AIF IAM:SRM:EUA:EnableAccountRequest_AIF IAM:SRM:EUA:UnlockAccountRequest_AIF IAM:SRM:PasswordChangeRequest_AIF INT:SLMSRS:ConfigServiceTarget:Defaults INT:SLMSRS:Request_Measurement INT:SLMSRS:ServiceRequestDefinition_Association INT:SLMSRS:ServiceRequestDefinition_Association_Measurement INT:SRMRKM:7_6_03:SRS:AIF_OpenIncidentRequest PBM:Costs PBM:Dialogs PBM:Known Error PBM:Pbm Search-Associations PBM:Pbm Search-Worklog PBM:Pke Search-Associations PBM:Pke Search-Worklog PBM:Problem Investigation PBM:Solution Database PCM:ProductCatalogSearchChanges PCT:LoadProdModelVersion PCT:Product Catalog PCT:Product Catalog Setup PCT:Product Cost PCT:Product Cost LookUp PCT:Product Distribution PCT:Product Model-Version PCT:ProductCatalogAliasMappingForm RMS:Dialogs RMS:LoadRelease RMS:Release RMS:ReleaseAPDetail RMS:ReleaseAPDetailSignature RMS:ReleaseInterface SHRAAS:SHR-SearchPanel SHRAXS:SHR-SearchAsset SLM:AssociationSVTCompMeas SLM:CloneBase SLM:Contract SLM:CostCalculator SLM:GoalSchedule SLM:LoadContract SLM:LoadGoalSchedule SLM:LoadMeasurement SLM:LoadMeasurementChild SLM:LoadPenaltyRewards SLM:LoadSLAAssociation SLM:LoadSLACompliance SLM:LoadSLAComplianceHistory SLM:LoadSLADefinition SLM:LoadServiceTarget SLM:Measurement SLM:MeasurementChild SLM:MeasurementChild_Association SLM:PenaltyRewards SLM:SLAAssociation SLM:SLACompliance SLM:SLAComplianceHistory SLM:SLACompliance_Category SLM:SLACompliance_ContractAssoc_Outer SLM:SLADefinition SLM:SampleComplianceOnly SLM:ServiceRequest_SLA SLM:ServiceTarget SRD:ApprovalMigration SRD:Categories_ServiceRequestDefinition SRD:STAGE:ServiceRequestDefinition_Base SRD:STAGE:ServiceRequestDefinition_DispProp SRD:ServiceRequestDefinition SRD:ServiceRequestDefinitionApproversLookup SRD:ServiceRequestDefinition_Base SRD:ServiceRequestDefinition_DispProp SRD:ServiceRequestDefinition_DispPropCreate SRD:ServiceRequestDefintionApDetail SRM:AppInstanceBridge SRM:MSM:SRMS SRM:Process SRM:ProcessProducts SRM:QuestionDetails SRM:Request SRM:RequestApDetail SRM:RequestApDetailSignature SRM:RequestInterface SRM:RequestInterface_Create SRM:SampleAppInstance SRM:SelectedProducts SRS:AdvanceInterfaceProductOrdering SRS:AdvancedInterface_FieldsReference SRS:AdvancedInterface_PasswordReset SRS:AdvancedInterface_WithBackendMapping SRS:AdvancedInterface_WithoutBackendMapping SRS:BundleProductAssociation SRS:MarketingSlide_ServiceRequestDefinitionBase SRS:Product SRS:ProductBundle SRS:ProductDetails_Base SRS:ProductOrder:SelectedProducts SRS:ProductOrderingAdmin_AddProducts SRS:Product_Base SRS:RequestApproversLookup SRS:RequestDetails SRS:SREC_BrowseCategories SRS:SREC_Cart SRS:SREC_Favorites SRS:SREC_PopularServices SRS:SREC_ProvideInformation SRS:ServiceCall SRS:ServiceCatalogManagerConsole SRS:ServiceRequestConsole SRS:ServiceRequestDesigner SRS:ServiceRequest_MyFavorites SYS:SLM:Measurement_Clone SYS:TempHolder TMS:LoadTask TMS:Task AST:AssetConfigAssociationJoin AST:AssetCostCIJoin AST:AssetCostJoinFINCost AST:AssetCostJoinFINCostAssoJoin AST:AssetLease AST:CI-CostAssociationJoin AST:CertificateBySoftwareContractJoinContract_Relationship AST:CertificatesJoinConfigLicenseTypeRegistryJoinFINCosts AST:CertificatesJoinConfigLicenseTypeRegistryJoinFINCostsJoinAssetSoftware AST:CertificatesJoinConfigLicenseTypeRegistry_Join AST:CertificatesJoinLicenseTypeJoinFINCostsJoinContractJoinCTR_Rel AST:ComputerSystemATT_Join AST:ConfigItemsAssociationJoin AST:ConfigScheduleAssociationJoin AST:LicenseCertificateProductAssocJoin AST:OperatingSystemComponentJoin AST:PurchaseLineItemAssetJoin AST:PurchaseOrderLineItemJoin AST:PurchaseOrderLineItemSupplierJoin AST:PurchaseRequisitionLineItemInnerJoin AST:PurchaseRequisitionLineItemOuterJoin CHG:ChangeASI:CHGCI_FinCostAssociationJoin CHG:ChangeASI:ChgCI_ComputerSystemBaseRelationships_Join CHG:CostAssociationJoin CTR:ContractBasePaymentJoin FIN:CostAssocJoin_SHRSchemaName FIN:CostAssociationJoin OBO:Ppl Search-SupportGrpAssoc_Outer_Join PBM:ProblemAssetCostJoin RKM:KAM_Detail_Join RKM:KAM_Detail_Sign_Join RMS:FINCostsOJoinManifestAssoc RMS:RLMFINCostAssociationJoin RMS:ReleaseAssociationJoinCI SLM:SLAComplianceContract_Join SRD:SRJoinSRD SRS:MarketingSlide_SRDServiceRequestDefinition_Join **20150313_itsmformswithcurreny.txt**********
5. Flush your mid-tier and browser cache. Refresh your mid-tier by flushing your cache
|