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

    • 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 ...

    • Disk Write Back Latency Issue with AWS Servers

      Release Date: 02/10/2022 Version: All For the past two-plus years, Netcellent has migrated all of its in-house servers to AWS (Amazon Web Services). We also help some of our customers in implementing their servers on AWS. We can advise you that ...

    • Feature - Invoice Log Report

      Release date: 4/10/19 Version: 8.5 and up We recently added a new Invoice Cross Reference File (CPINVXRF) table to Version 8.5. This table is updated when invoices are printed. Read ...