web
You’re offline. This is a read only version of the page.
close
Skip to main content
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.

(0) ShareShare
ReportReport
Posted on by 140

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
    Joseph Markovich Profile Picture
    3,972 on at
    RE: How to correct wrong payables invoice rather than voiding the invoice and recreating.

    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

  • AccountinginGA Profile Picture
    25 on at
    RE: How to correct wrong payables invoice rather than voiding the invoice and recreating.

    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

  • Joseph Markovich Profile Picture
    3,972 on at
    RE: How to correct wrong payables invoice rather than voiding the invoice and recreating.

    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

  • Cheryl Waswick Profile Picture
    on at
    RE: How to correct wrong payables invoice rather than voiding the invoice and recreating.

    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. 

  • AccountinginGA Profile Picture
    25 on at
    RE: How to correct wrong payables invoice rather than voiding the invoice and recreating.

    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

  • James Hobbs Profile Picture
    5 on at
    RE: How to correct wrong payables invoice rather than voiding the invoice and recreating.

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

  • Suggested answer
    Cheryl Waswick Profile Picture
    on at
    RE: How to correct wrong payables invoice rather than voiding the invoice and recreating.

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,352

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 810 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 616 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans