Reverse receipt when inventory WAS negative

sdomingo · 2006-09-21

i need to reverse out a purchase receipt BUT when the receipt was done, inventory was negative. For example:

Inventory was sitting at -2, guy came and received 3 on purcahse receipt bringing inventory up to +1. He realizes that he shouldn't have done the receipt and ask me to reverse it for him. When I try to reverse the 3, I get an error telling me:

Remaining Quantity must be 3 in Item Ledger Entry Entry No.='13468'.

I figured out that it is talking about the Remaining Qty field on the Item Ledger Entries. When looking at this field, it has a one.

So the questions are what do I need to do to get the Remaining Qty to 3 and what does the remaining quantity mean in the first place?!!

Savatage · 2006-09-21

How are you reversing the 3?

Are you negative receiving? (Recieve a -3)?
Are you using the item journal to make a negative adjustment of 3?
Are you using the item journalto make a negative purchase?

sdomingo · 2006-09-21

I'm going into the receipt, hitting the Function button and choosing "Undo Receipt", this should redo the receipt of 3 but I get that error instead.

ara3n · 2006-09-21

The reason you are getting the error is because Navision has allready applied the inventory for the receipt to an entry that had gone negative. You cannot do anything about this. Invoice the line and then create a Credit memo, and then add another PO line.

sdomingo · 2006-09-28

But what if it was a partial receipt? what about the other receipts on the same line item? This three was the final three to be received out of a total of 11. so i can't just trash the line.

ara3n · 2006-09-28

Just fully invoice that line.

Alex_Chow · 2006-09-28

sdomingo wrote:

But what if it was a partial receipt? what about the other receipts on the same line item? This three was the final three to be received out of a total of 11. so i can't just trash the line.

Like ara3n said, you need to reverse this the old fashion way.

Fully invoice that line and create a credit memo for it. To keep the original purchase order content, you can delete that line (after it's invoiced) then re-create that line with the original quantity.

David_Cox · 2006-09-29

If the Purchase Order is still on the system, not Invoiced, just insert a line below the over received line and make the detail the same Item No., unit cost, location etc:

Item 2000 ~ My Item ~ Quantity 11 ~ Received Qty. 11
Item 2000 ~ Adjustment ~ Quantity -3 ~ Received Qty. -3

So just make the Quantity -3, change the description, so you know it is an adjustment, when you receive this line, and later invoice, your inventory, remmitance advice, Purchase Order and Invoice, quantities and values will all be correct.

Always look for the simple solution! :roll: =D>

Howdy, Stranger!

Quick Links

Categories

Reverse receipt when inventory WAS negative

Comments