Costed date older than Transaction date
Summary
Costed date older than Transaction dateContent
Hi,
I am observing Costed date is older than the Transaction date in a custom report output. However, UIs show a different picture altogether.
Please refer to the images attached for a complete picture.
Transaction date in the UIs visible is 9-Aug-2021 7:45 PM at both Review Cost Accounting Distributions UI (Costing) and Review Completed Transactions UI (Inventory). However, the report fetches this value from the database as 10-Aug-2021 2:45 AM.
Cost Date is same at all the three places: 9-Aug-2021 7:45 PM.
It looks like the Transaction date is in UTC and other dates are in PST Timezone. Strangely, UIs know that only one of the dates needs Timezone conversion i.e. Transaction Date.