How to Reverse Posted Purchase Receipt done in the Previous Month.

Question Status

Verified
Teo Balgos asked a question on 13 Nov 2017 4:21 PM

Hi hope someone can help.

Using Microsoft Navision 2009 | Printvis.

I have an Posted Purchase Receipt that was done last month for a PO with an item.  Stock is still in the location that it was receipted into, however when I try to perform "Function | Undo Receipt" I receive;

{Posting Date is not within your range of allowed posting dates in Item Journal Line Journal Template Name=",Journal Batch Name=",Line No.='0'}

I assume I am receiving this error because the receipt was completed last month. 

-  How do I now reverse this receipt out, remove the stock from inventory, and cancel/amend the original PO?

-  Is my only option to perform an Item Journal to remove the stock from inventory?

Note:  I was able to perform the "Function | Undo Receipt" process for a similar PO that was receipted this month.

Reply
Suggested Answer
AJ Ansari responded on 14 Nov 2017 1:04 AM

Have you tried to change your Posting Date ranges from either the General Ledger Setup (global) or for your specific User from the User Setup page? On the User Setup page, each user can be assigned a narrower or wider Posting Date range?

If you are not a NAV admin, you may need your admin to make these changes for you. Then, exit NAV for good measure and restart it and try again.

I hope this helps. If this answers your question, please verify by clicking “Yes” next to “Did this answer your question?”

Reply
Manish Sharma responded on 14 Nov 2017 1:18 AM

Did you check the allow posting from and allow posting to date in,

1. User Setup - Specific user.

2. General Ledger Setup - Universal.

Many companies block back & future date entries into Navision using these two setups.

Reply
Verified Answer
Robertas Rackauskas responded on 14 Nov 2017 1:34 AM

Hi Teo

'Undo Receipt' only works for the same date as the original receipt. So if the month is 'closed', system will not allow you to undo the receipt. There are a couple of ways to get round it (not as easy as 'Undo Receipt' though):

- Invoice the receipt at zero value and then write item off the stock using item journal

- Invoice the receipt at zero value and then process the purchase return document (ship back to vendor & credit) for these items at zero value.

First one is quicker but will show items bought from the supplier if you do any reporting by supplier / item. Second one would be the most correct way to deal with the wrong receipt in NAV terms.

Hope that helps.

Robertas

Reply
Suggested Answer
Ishan Patel responded on 14 Nov 2017 3:51 AM

Did you checked whether the inventory period for last month is closed?

If not then please check your allowed for posting dates should be aligned with posting dates range in general ledger setup.

Reply
Suggested Answer
Teo Balgos responded on 19 Nov 2017 6:35 PM

Thank you Robertas.  Although this process was the most transaction intensive, it did provide the cleanest alternative ensuring that all transactions were matched off.

Appreciate your assistance.

Reply
Verified Answer
Robertas Rackauskas responded on 14 Nov 2017 1:34 AM

Hi Teo

'Undo Receipt' only works for the same date as the original receipt. So if the month is 'closed', system will not allow you to undo the receipt. There are a couple of ways to get round it (not as easy as 'Undo Receipt' though):

- Invoice the receipt at zero value and then write item off the stock using item journal

- Invoice the receipt at zero value and then process the purchase return document (ship back to vendor & credit) for these items at zero value.

First one is quicker but will show items bought from the supplier if you do any reporting by supplier / item. Second one would be the most correct way to deal with the wrong receipt in NAV terms.

Hope that helps.

Robertas

Reply
Suggested Answer
AJ Ansari responded on 14 Nov 2017 1:04 AM

Have you tried to change your Posting Date ranges from either the General Ledger Setup (global) or for your specific User from the User Setup page? On the User Setup page, each user can be assigned a narrower or wider Posting Date range?

If you are not a NAV admin, you may need your admin to make these changes for you. Then, exit NAV for good measure and restart it and try again.

I hope this helps. If this answers your question, please verify by clicking “Yes” next to “Did this answer your question?”

Reply
Suggested Answer
Ishan Patel responded on 14 Nov 2017 3:51 AM

Did you checked whether the inventory period for last month is closed?

If not then please check your allowed for posting dates should be aligned with posting dates range in general ledger setup.

Reply
Suggested Answer
Teo Balgos responded on 19 Nov 2017 6:35 PM

Thank you Robertas.  Although this process was the most transaction intensive, it did provide the cleanest alternative ensuring that all transactions were matched off.

Appreciate your assistance.

Reply