Small and medium business | Business Central, N...

Remaining Quantity must be equal to in item ledger entry

(0) Share

Report

Posted on by Samer Baskhayroun

559

Hi all

I Recived a PO and did not invoice it

Try to do Undo Receipt from Posted Purchase Receipt > Function >Undo Receipt

But i got the beloww error

I checked the item ledger entries abd found the remainning qty is zero

How can i solve that issue ?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

This is because your team consumed what you received in this PO. BC needs 27.98 for this item for exact ledger entry to reverse this transaction but since your team consumed this item BC cannot do that. The zero means your team consumed them all.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (2)

Report

Hi, MahGah is correct, because this Item Ledger Entry has been consumed, which may be a sale, or it may be a transfer and other reasons.

You can choose Releated -> Application -> Applied Entries to find where it is consumed.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi,

In this case I think the quantity is already consumed after your receipt. Can you please confirm if there is a shipment done of that quantity for that Item?

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

You can invoice the PO after the receipt is done. The PO should still remain and just needs to be invoiced. BC will take the dollar values and flow them through the various transactions where the inventory was used so that you have accurate costing and inventory value.

Was this reply helpful? Yes No
Samer Baskhayroun 559 on at

Like (0)

Report

Hi

Yes they did Negative Inventory adjustment for that Qty

How can i fix this in order to make the Undoreceipt ?

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (1)

Report

You will never be able to use the Undo Receipt.

Your original post stated that you received but did not invoice. If you are truly just needing to invoice the receipt, post the invoice only.

If you did not receive and you adjusted the inventory out, you still need to post the receipt through to an invoice. There are two ways to do this..

1) invoice at zero dollars-pro is that the vendor ledger is clear but con is that you affect the cost of the item.

2) invoice at the PO cost-pros is item cost is not adversely affected but the con is that you need to issue a credit to clear the vendor AND the credit will remove inventory quantity, so you might need to adjust inventory back to zero.

Though option #2 is more work, it's the better option.

Was this reply helpful? Yes No