Correcting Prepayment Final Invoice

Before you begin: 

  1. Prepayment G/L Accounts may be different than the provided screenshots or examples,

      refer to your Posting Groups or Chart of Accounts for the correct G/L Account. 

  2. Do not use the Correct feature on the final invoice, otherwise the entire order will be produced. 

  3. The documented correction below only addresses the correction of the final invoice. Example scenarios: 

• Incorrect Sales Tax listed
• Incorrect Shipping Information
• Incorrect Posting Date
• Incorrect Salesperson code, Your Reference or External Document Number

  4. If the entire order is incorrect, review Correcting Prepayment Invoice KB, then process the below steps. 

Scenario: 

In the process of closing a prior period, a Sales Order was accidently left open. An associate had their Work Date set to the current period, 

and now sales are off. To have the final invoice be produced in the correct period, we will credit the Invoice and post it again with the proper

Posting Date. 

1. Navigate to Customers, select the Customer, on customer card, select Customer > Ledger Entries
2. Select the Invoice requiring reversal
3. 
4. Note the line quantity and Total Including Tax. The Credit Memo will need to relate in a contra format to offset these values: 
   • 
5. Within the Invoice, select Home > click the chevron to the right of "Correct" > choose Create Corrective Credit Memo
6.  Business Central will bring in a comment line referencing the document reversal. Entering your own comment or note to document reversal is recommended: 
   • 
   • Note: G/L Account is missing
     • Business Central does not copy in G/L Account lines. Add the missing G/L Account or refer back to the original invoice as necessary.
     • Our Credit Memo now balances with the Invoice: 
       • 
   • Review with a Test Report to check our work: 
     • 
     • 
       • Our Credit Memo is reducing the overall Credit Memo to match the Invoice and putting back an open Prepayment Entry
       • Sales Tax Amounts are also being reduced in Sales Tax Entries. 
       • After reviewing, our entries are correct. Download report for reference (recommended). Close the Report. 
     • Prior to posting the Credit Memo, ensure Applies-to Doc No. is set. Our example is PS-INV103217
       • 
7. Post the Credit Memo
   • In review: 
     • Our Prepayment Account increased correctly by 8,383.80
     • 
     • Customer Ledger is in Balance: 
       • 
8.  Create the Invoice to post in the correct period: 
   • 
   • 
   • 
   •  
   • 
     • NOTICE: Remember to Update your Header Information if anything was incorrect!
     • 
9.  Update your sales lines. Insert a comment or note documenting reason for new invoice is recommended. 
10. Add the G/L Account for Prepayment to bring it back in Balance: 
    •   
    • Review document with a Test Report. Double Check all information is correct!
11. Post the Invoice
    • Note: Our Prepayment Account is back in balance: 
      • 

Conclusion

With this process, we successfully correct a final Posted Invoice associated with a Prepayment Order. 

In each step, we verified the documents were in balance to ensure the end result would be correct.