Document date is greater than posting date

(0) Share

Report

Posted on by Sugano

105

We are in the testing phase of our Dynamics implementation and are getting an error when trying to process an invoice journal. Document date is greater than the posting date.

This is something that we do all the time in our current system and i cant seem to find any reason why this would be an issue.

Any help would be appreciated.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

David Massey on at

Like (0)

Report

Can you explain your business process to have the dates specified this way?

Technically you are stating you want to post amounts from a document to the general ledger (posting date) which are before the existence of the business document. (Document date).

Was this reply helpful? Yes No
Sugano 105 on at

Like (0)

Report

Yes.

Example: We receive some product in April, but do not receive the invoice until May. Right now we use a GL Posting date that matches the receipt, even though the document date is in the next month.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,915 Super User 2025 Season 2 on at

Like (0)

Report

Normally, if you receive products there must be a packing slip included with a document date for the delivery. The invoice is a separate document with a separate document date.

I would suggest to use this dates per document and thus post the product receipt in April and the invoice in May.

Or is there something else we don't know?

Was this reply helpful? Yes No
David Massey on at

Like (0)

Report

Are you using the GL to simulate PO/PackingSlip/Vendor Invoice matching or similar process?

What you describe is actually two separate business document. The receipt document, and the invoice document. Each have their own document date and can affect posting and currency evaluation.

Since you mentioned "Product", what happens if there is price variances between purchase, receipt an invoice prices? The procurement process in AX handled these scenarios.

Was this reply helpful? Yes No
Sugano 105 on at

Like (0)

Report

Our terms are FOB shipping point, so it is our liability the day it is shipped to us. We are on an accrual basis accounting, so we record our liabilities based on when the expenses incurred.

Was this reply helpful? Yes No
mukri_4@yahoo.com 345 on at

Like (0)

Report

Dear Sugano ,

I can try to sort out your issue. U want to book an liability since your term are FOB shippin point. You can create an seperate account under payable - say for example Order L/C _________( and vendor name). This account you can credit when u get the information of Shipping and Debit Accrued Purchase - L/C. By doing this your liability will be booked. One actual receipt of the material you have to follow normal proceedure in AX. After confirmation of Quantity and invoicing you can reverse the first entry. This is a long cut but we are also following this since AX do not allow this functionality.

If you find this solution is ok then follow it or if you have find any other work around then please share with me.

Was this reply helpful? Yes No
Harisgillani 291 on at

Like (0)

Report

Hi,

Can any one tell me where is the field of document date in vendor invoice form

Regards

Haris Gillani

Was this reply helpful? Yes No
André Arnaud de Cal... 300,915 Super User 2025 Season 2 on at

Like (0)

Report

Hi Haris,

You have responded on a very old question. Also your question is changing the original subject. Can you create a new question on the forum?

Was this reply helpful? Yes No