What Causes COP Invoice Posting to Back Date?

What Causes COP Invoice Posting to Back Date?

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

Q - We 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.

A - The 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


    • Related Articles

    • Presales Posting

      Release Date: 3/1/24 Version: 8.6 and Above Presales Posting will move Presales Transactions to Presales Pending. This can be done either after performing the import or manually adding the Presales Transactions. Presales posting will cause the ...

    • Feature - Automatically Reapply Credit Memo to Charge-Back Debit Memo

      Release Date: 3/23/22 Revised: 3/29/22 Version: 8.5 and Above This feature will reapply an existing open credit memo to a debit memo the system just created during cash receipt posting. This will reduce the user’s database entry burden involved in ...

    • Automatically Create Invoice History Summary by Date Through Defer Processing

      Release Date: 09/26/2017 Updated: 12/4/2024 Q - Is there a way to enter responses to reports that will run deferred so that the responses change from run to run? Example: As per the attached screenshot to print an invoice summary, the goal is to have ...

    • Feature - Prevent Duplicate Invoice Numbers with Invoice Cross Reference File

      Release Date - 3/25/19 Version: 8.5 and Up This feature uses a new table, the Invoice Cross Reference table, to determine if an invoice has already been used by another unposted or posted order. The Invoice Cross Reference is updated at the time of ...

    • What Causes Load Error 198?

      Modified Date: 6/7/2019 Q - One of our computers received an error 198 load error randomly. The message looked like the following sample screen: Load error: file "SYCONSEL" error code: 198, pc=0, call=15, seq=0 or Load error: file "SYACTCHK" error ...