undo a posted purchase invoice from a future date

Ercan82 · 2017-01-25

Hello wise people of NAV
A user has posted a zero value purchase invoice in 2019. I need to undo this transaction and post it in the correct period. I have complications because the item is Lot Tracked and part of the stock has been consumed from the warehouse for this reason a return purchase order doesn't work because you cannot return stock which no longer exists.
The reason the invoice is zero value is that a prepayment invoice had already been correctly posted, this final invoice is to finish the transaction.

Any ideas how i could fix this?

Regards
Ercan
(NAV 2013)

rehansatti · 2017-01-26

Hi @Ercan82 ,
I have drilled down little more on this issue. As there is no option in NAV 2013.
The solution to this problem is you have to create a negative adjustment entry for this invoice. In case of posting mistake this is the way to cater the problem. In older version of NAV you have to do it manually. Bu in recent version NAV gives this option. In both the cases what NAV does is it created two entries. In older version you have to create it manually (adjustment entry), Which might not linked to the actual entry. you have to remember that in audit. SO convenience in recent version is that it links the negative adjustment entry to some posted invoice. It helps to navigate to actual enter.
Following link will more elaborate this scenerio.
https://msdn.microsoft.com/en-us/library/hh936396(v=nav.90).aspx
http://www.archerpoint.com/blog/Posts/managing-negative-inventory-microsoft-dynamics-nav

rehansatti · 2017-01-25

Hi Ercan,
Which version of NAV are you using? See the option of reversing a transaction in the below screen shot.
Hope It helps you.

Ercan82 · 2017-01-25

hi Rehan
Unfortunately I do not have the correct option, I'm using NAV 2013, I guess this is only available in newer versions.

Ercan

rehansatti · 2017-01-26

Hi @Ercan82 ,
I have drilled down little more on this issue. As there is no option in NAV 2013.
The solution to this problem is you have to create a negative adjustment entry for this invoice. In case of posting mistake this is the way to cater the problem. In older version of NAV you have to do it manually. Bu in recent version NAV gives this option. In both the cases what NAV does is it created two entries. In older version you have to create it manually (adjustment entry), Which might not linked to the actual entry. you have to remember that in audit. SO convenience in recent version is that it links the negative adjustment entry to some posted invoice. It helps to navigate to actual enter.
Following link will more elaborate this scenerio.
https://msdn.microsoft.com/en-us/library/hh936396(v=nav.90).aspx
http://www.archerpoint.com/blog/Posts/managing-negative-inventory-microsoft-dynamics-nav

Ercan82 · 2017-02-03

hi all, thank you for your help. thankfully the finance director has ok'd the transaction to remain in the future. so no longer a problem.

Ercan

undo a posted purchase invoice from a future date

Best Answer

Answers

Categories