Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

How do I fix a posted sales order/invoice that was already shipped in the system?

Posted on by 31
We'd like it to reflect on the original sales order for the corrected amount but it seems not doable in BC.
I tried doing a Corrective Credit Memo and noticed that it also reversed the shipment? It shows as Available Inventory again so did it reverse my shipment anyhow?
 
It appears the only way is to cancel/correct which then we'd have to re-enter the sales order/pick/ship. 
 
We do have a bunch might have to re-do but I guess it's a learning lesson not to post right away.
 
Thanks in advance.
Categories:
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 6,092 Super User on at
    How do I fix a posted sales order/invoice that was already shipped in the system?
    The sales journal can work but if you do any reporting based on your inventory subledger then it won't be accurate as the sales journal will not adjust the inventory subledger. Likewise with the posted sales invoice. 
     
  • lilly45 Profile Picture
    lilly45 on at
    How do I fix a posted sales order/invoice that was already shipped in the system?
    Fixing a posted sales order or invoice that was already shipped typically involves a few key steps to ensure that all records remain accurate and consistent. The exact steps may vary depending on the system you are using, but the general approach can be applied to most enterprise resource planning (ERP) systems such as SAP, Microsoft Dynamics, QuickBooks, etc. Here's a step-by-step guide:
    ### Step-by-Step Guide
    #### 1. **Identify the Issue**
       - **Determine the Error**: Understand what needs to be corrected (e.g., incorrect quantities, prices, shipping address, etc.).
       - **Impact Assessment**: Assess how the correction will impact inventory, financial records, and customer satisfaction.
    #### 2. **Check System Permissions**
       - Ensure you have the necessary permissions to make changes to posted transactions. If not, contact your system administrator.
    #### 3. **Void or Cancel the Invoice**
       - **ERP Systems**: Most ERP systems allow you to void or cancel a posted invoice. This action will reverse the financial transactions associated with the invoice.
       - **Accounting Software**: In software like QuickBooks, you can void an invoice which will keep the invoice number but reset the amounts to zero.
    #### 4. **Reverse the Shipment**
       - **Return to Inventory**: If items were shipped incorrectly, create a return order to bring the items back into inventory.
       - **Shipping System**: Update your shipping system to reflect that the shipment was reversed or corrected.
    #### 5. **Create a Corrected Order/Invoice**
       - **New Order**: Create a new sales order with the correct information.
       - **Invoice Generation**: Generate a new invoice from the corrected sales order.
    #### 6. **Adjust Inventory**
       - Ensure inventory levels are adjusted to reflect the returned items and the new shipment.
    #### 7. **Communicate with the Customer**
       - Inform the customer about the correction and provide them with the updated invoice and shipment details.
    ### Detailed Steps in Specific Systems
    #### SAP
    1. **Cancel the Invoice**:
       - Use the transaction code `VF11` to cancel the invoice.
       - Follow the prompts to reverse the financial entries.
    2. **Create a Credit Memo**:
       - Use the transaction code `VA01` to create a credit memo request if necessary.
       - Process the credit memo to adjust customer balances.
    3. **Adjust Delivery**:
       - Use the transaction code `VL09` to reverse goods movement if the goods have been issued.
       - Create a new delivery document if necessary.
    #### Microsoft Dynamics 365
    1. **Cancel the Invoice**:
       - Navigate to the sales order and select `Cancel` or `Correct`.
       - Use the `Correct` function to make adjustments directly.
    2. **Create a Credit Note**:
       - Create a credit note to reverse the invoice.
    3. **Adjust Shipment**:
       - If items were shipped, process a return order to adjust inventory.
    #### QuickBooks
    1. **Void the Invoice**:
       - Open the invoice and select `More > Void`.
       - QuickBooks will void the invoice, resetting amounts to zero but retaining the record.
    2. **Create a New Invoice**:
       - Enter the corrected information and create a new invoice.
    3. **Adjust Inventory**:
       - Create an inventory adjustment if needed to reflect returned or corrected items.
    ### Conclusion
    Correcting a posted sales order or invoice involves several steps to ensure that all records—financial, inventory, and customer-facing—are accurately updated. Always follow the specific procedures outlined by your ERP or accounting software and ensure that you have the necessary permissions to make these changes. Communicate clearly with all stakeholders, including your customers, to maintain trust and transparency.
    For more specific guidance, refer to the help documentation of your particular ERP or accounting system:
    - [SAP Help Portal](https://help.sap.com/)
    - [Microsoft Dynamics 365 Documentation](https://docs.microsoft.com/en-us/dynamics365/)
    - [QuickBooks Support](https://quickbooks.intuit.com/learn-support/)Click here
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 62,477 Super User on at
    How do I fix a posted sales order/invoice that was already shipped in the system?
    Hi, if you just want to cancel the amount, you can also try Sales Journals, which I think will be simpler.
     
    Hope this helps as well.
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 6,092 Super User on at
    How do I fix a posted sales order/invoice that was already shipped in the system?
    Yes a credit memo will reverse both the item quantity and amount. If you're only looking to correct the item amount without affecting the item quantity, you can use a credit memo with an item charge. I wrote a blog post how to do this - https://valentincastravet.com/how-to-credit-an-item-without-putting-it-back-in-inventory/
     

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,860 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,155 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans