Within the current BI solution, we are trying to establish the posting date of GL transactions. There are two columns within the general journal table - accounting date and document date.
Having checked numerous examples, it's unclear, at a database level, which is populated and when.
For transactions that come from a sub-ledger, these seem to have document date stamped as the posting date, and the accounting as the transaction date.
Whereas, for example, reversals in the GL, the accounting date is populated and document date left as '1900-01-01'. Although, this isn't always the case, but could be down to migrated records.
The end goal is a single column that represents the posting date in the GL, so that it can be effectively used within a data warehouse.
Any thoughts or experience on handling this?
