Hello, we are currently in the middle of our migration into AX 2012 R2 and have a few posted PO Invoices that need to reverse due to a glitch in one of our mods. I have yet to find any answer on how to do this from Microsoft or from the web. Even our AX Partner has been unable to give us an answer on how this is done.
I would greatly appreciate anyone that could help me with the correct steps on how to properly reverse these PO Invoices.
Thank You.
*This post is locked for comments
Hi,
This is due to accounting rules. It is not allowed to delete posted transactions. So Microsoft follows the regulations.
Well. I would like to ask you to mark one or more answers which helped you most, so the question will get the status 'Answered'.
Well I would like to thank everyone that helped me on this. I found what was causing our issue with updating the PO. The PO's we are trying to fix are linked to SO’s with item reservations which needed to be removed before updating the PO. Once the item reservations where removed, I was able to add a negative Qty for the item that was incorrect and then added another line for the correct item to the PO. Then I could invoice it out to $0.00 while updating correct items and inventory postings. Then just had to go back and update the SO with the correct item and re-add the reservation to the corrected PO item.
Even though this works, I still find it to be a very unorthodox and almost broken way to fix things. I really think Microsoft may want to look into a better way to perform this task and try to find a way that is less messy as this is.
Hi mharsh,
You could eventually use the Data Import Export Framework (or another tool) to import files with the correct data. Then it is possible to setup that the import will skip business logic. So in this way you could correct the data from source files.
I would really try to avoid deleting records as there are many related transaction tables which you will not easily think of.
You can either -qty that you have received in or create a new line with the minus qty that you want to offset the other. Example: let's say the quantity is 6, so under Receive now put -6 and post it. You should be able to go back and fix whatever you would like to fix. Most things in AX are fixable so don't be panic. Let me know how it turns out.
The problem here is that all this data is historical information that we are manually imputing and we need to maintain the SO-PO-INV link for our records. The issue is the PO information has been messed up from a glitch in a mod that has just been discovered and since it was invoiced. We are unable to simply correct the data on the PO.
What we need to happen is the invoice to be reversed, so we can go back update the original PO and make a new invoice with all the correct data. So then we can go in and marry all our financial data that was imported with Atlas. If know of the correct way this can be done, I would greatly appreciate any help or direction.
Hi,
Like Caroline stated, you cannot delete posted invoices without using a script. I would not recomend to do this as it will be very easy to create database corruption.
To prevent situations like this, please ensure proper testing and checking all records.
Perhaps it is better to fix the data instead of deleting the transactions. Or isn't this possible?
You would have to write a job to do that. There is no function to delete an invoice from the system. Once a transaction is posted in the GL, there is no way to delete that transaction, you can only create a new transaction to reverse it.
You will need to ensure your GL is also adjusted if you do that.
I did what you suggested but it only cleared out the pending Invoice on the account. It did not reverse the AP entry and it did not cancel the invoice out of the system. We need to be able to remove and clear the invoice out of the system as if it never happened.
Hi,
If I understand the question correctly, you can create a debit note from your purchase order that will be settled against your PO invoice to essentially cancel that balance on the vendor profile.
To process the debit note, you can add a new line on your PO with a negative quantity. Once confirmed and invoice is posted, you will need to go on the vendor profile to settle the original invoice with the new debit note so that balance will be gone from the vendor profile.
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
233,017
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
