OM Service Mapping - GL Date and Trx Date
Summary: Hello All - we are using the OM service mapping to set the time zone for the GL Date and Trx Date for AR Interface table.
We are able to do this using below expression to set the timezone as MYT / IST or GMT.
Name FulfillmentIntegration
Sources -InvoiceSources
Entity - ARInterfaceLine
Attribute Mapping
GL Date Expression - CategoryCode == "ORDER"? new Date().format("yyyy-MM-dd", timezone=TimeZone.getTimeZone("MYT")) : null
TrxDate Expression - CategoryCode == "ORDER"? new Date().format("yyyy-MM-dd", timezone=TimeZone.getTimeZone("GMT")) : null
Our challenge is we are doing mutli country rollout and we would like to set up this expression based on the Business unit.For example if it is Malaysia Business unit - it should take MYTif it is New Zealand Business unit - it should take NZT