OM Service Mapping - GL Date and Trx Date — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OM Service Mapping - GL Date and Trx Date

edited Jul 23, 2025 11:38AM in Order Management 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!