web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

How to correct wrong payables invoice rather than voiding the invoice and recreating.

(1) ShareShare
ReportReport
Posted on by 142

HI All,


By mistake we have created an invoice with wrong total. Now its not fully applied . How to nullify this unapplied amount without voiding this invoice.



Regards,
Priya

Categories:
I have the same question (0)
  • Suggested answer
    Cheryl Waswick Profile Picture
    Microsoft Employee on at

    Hello Priya,  

    The supported method would be to void the invoice, and then use the 'remove Transaction history' purchasing utility to completely remove it from the system as if it was never keyed before, and then rekey it back in brand new.   However, some users also just void the invoice, and don't remove it from the system and rekey it back in with a period after the invoice number.  (Payables setup also has an option to allow you to key duplicate invoice numbers per vendor if you prefer to key it in the exact same doc number as before.)

    As far as updating the SQL tables for the date, that would not be supported and you would be on your own to do that and test it out.  The tables needed would depend on if the invoice is applied or not, has taxes or not, where it came from, what type, have workflow turned on, etc, so could vary.   Although you could do that in the SQL tables and then reconcile when you are done, it should work, but it's risky to miss a table and therefore is not supported, when you could simply void it and rekey it in the front-end.

    I hope this information helps.  Let me know if any further questions.

    Cheryl

    Microsoft Dynamics GP Support

  • James Hobbs Profile Picture
    5 on at

    I appreciate the information and advice you have shared. I will try to figure it out for more for MyHTSpace.com

  • AccountinginGA Profile Picture
    25 on at

    Hi Cheryl,

    For an invoice related to a Purchase Order, once the invoice has been voided the line items are not automatically available to re-invoice. Will utilizing 'remove transaction history' allow me to re-invoice the same line items?

    Thank you,

    GA

  • Cheryl Waswick Profile Picture
    Microsoft Employee on at

    No, voiding it and removing it from history would only remove it from the Payables (PM) tables, and not touch the POP tables.  If you void it and remove it in Payables, then you would just key it back into Payables (Transactions | Purchasing | Transaction entry) as a lump sum invoice to pay out, and leave the POP side alone. 

  • Joseph Markovich Profile Picture
    4,007 on at

    You can use Returns Transaction Entry to back out the shipment/invoice. It will reopen the PO lines and you can enter and post the shipment and invoice again.

    Thanks.

    Joe

  • AccountinginGA Profile Picture
    25 on at

    Hi Joe,

    Thank you for your message. This is the direction I was headed in; however, the simple "Return" entry does not allow the items to be returned. Only when I use "Return w/Credit" does it allow me to return the selected line items. The distributions seem wrong to me at this point though, as the Accounts Payable Account (01-20050-00) has already been debited and credited by the void.

    Could you explain how I should use the Returns Transaction Entry to re-invoice the items?

    Unposted-Return-Entry.pngAP-Debit-and-Credit-Voided-PO-Invoice.pngUnposted-Return-Entry-Distributions.png

  • Suggested answer
    Joseph Markovich Profile Picture
    4,007 on at

    Luckily, you are able to still use Returns Transaction Entry because POP doesn't know that you voided the POP Invoice match. Only AP knows this and is affected!

    The "Return" type can only be used if the items are received, but not invoiced yet. "Return with Credit" lets you back out the shipment AND the invoice already entered and posted. This will "undo" for lack of a better term the quantities on the PO and let you receive against the PO again.

    Make sure to check Replace Returned Goods too. This is the magic that resets the PO line quantities.

    When you voided the transaction in AP, did it also back out the $10 to the 01-58050-00 account? Is there a credit showing there too?

    You're going to have to reenter the invoice you voided (as just an AP transaction now) with the same amounts and GL accounts as the original invoice. The reason is by doing the return with credit, you need to apply the credit GP is going to create for the vendor to something. It would have been the original invoice entered, but that's been voided.

    Then you'll be able to enter/post the shipment again, match the invoice and all the accounts will be OK.

    I always tell everyone I train this: if you make a mistake (we all do), you can always fix it in the originating module and everything will roll up to the GL nicely.

    I hope this helps and make sense!

    Joe

  • Giorgio Bonacorsi Profile Picture
    3,271 on at
    Hello, 
     
    Unfortunately we need voiding the invoice and recreating.
    The invoice is even a fiscal document and it's illegal to delete or modify an invoice posted.
     
    Max: the new invoice could contains only the delta amount.
     
    Thank you,
    Giorgio

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 797

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 589 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 534

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans