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

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

    • CP1700 Customer Order Processing Invoice History Inquiry

      Invoice History Inquiry Application Overview This function gives you fast and easy access to all the necessary information to provide customer service for posted invoices on file for a customer. It allows you to quickly access and display a customer ...

    • CP0400V Customer Order Processing Void Invoice

      Void Invoice Application Overview This enhancement allows users to void a printed invoice before it is posted to Accounts Receivable. If already posted to Accounts Receivable, you must back it out (void) with a Credit memo. Run Instructions From COP ...