Finance | Project Operations, Human Resources, ...

GeneralJournalEntry Accounting vs Document Date

(0) Share

Report

Posted on by PucciaF

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?

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

BillurSamdancioglu 21,121 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi,

Accounting data is posting date.

Document date is the date of the original document.

For example you have a vendor invoice dated 30.09 but your period is closed. So document date is 30.09 but posting date can be 01.10.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 15,110 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi PucciaF,

In your case, you can use "AccountingDate"

Accounting date is voucher date that used for posting a record (e.g. Free text invoice, sales order, general journal, payment journal etc.). This used as posting date.

Document date is a additional date fields that can be used as an invoice date. This will not necessarily indicate posting date while it can be used same as posting date. A common reason that Document date and Accounting date is different can be related to when a document date falls into a fiscal period that is closed.

Was this reply helpful? Yes No