Skip to content

What Causes COP Invoice Posting to Back Date?

Date: 03/31/2023
Version: 7.5 & Up

QWe have had a few transactions that are posting on incorrect dates. In the example of credit memo 514633, the credit memo was posted on 3/30/23, but the GL distribution goes to 3/21/23 and the the general ledger is out of balance. Is there a way to see why this is happening? It is causing problems for us on the accounting side.

AThe key is the “Invoice Date.” The GL distribution date is based on the invoice date regardless of what date you post the sales journal. In the example below, the credit memo 514633 invoice date is 3/21/23, even though it was posted on 3/30/23. 


The logical explanation is that someone chose to “back date” when they printed the credit memo. During invoice (and credit memo) printing, the system will prompt the user for an invoice date. The default is the system date. Users can override to another date. According to your current practice in Global Setup -> System -> System Period Control, the invoice date can be any date in the allowed period (i.e., 3/1/23 – 3/31/23). See sample System Period Control setup below:


Please verify which user processed this credit memo, see what his or her practice is, and stop them from overriding the invoice date if that causes problem on the GL side.


EMK

Feedback and Knowledge Base