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

AR Interface GL Date and Trx Date time zone

in Receivables & Collections

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.

NameFulfillmentIntegrationSources -InvoiceSourcesEntity - ARInterfaceLineAttribute MappingGL Date Expression - CategoryCode == "ORDER"? new Date().format("yyyy-MM-dd", timezone=TimeZone.getTimeZone("MYT")) : nullTrxDate 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 NZTCan anyone suggest to add the Business unit condition in above expression? I have checked that we can use SourceOrgId but we are not able to write the case statement or If Else statement to use it

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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