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

Posting Error when Create Purchase Invoice from Getting Receipt Lines: the Quantity you are trying to invoice is larger than the quantity in the item ledger...

(0) Share

Report

Posted on by B@houston

Hello friends,

I got a posting error when I posted a purchase invoice by getting the receipt lines. The Error reads: the Quantity you are trying to invoice is larger than the quantity in item ledger with the entry number 65700. I confirmed that the quantity on invoice and receipt/item ledger are the same.

I investigated the Purchase & Payable setup, item master and found nothing wrong. We are BC Version 17.0 on-premises. Have you encountered the similar errors and any ideas where the error coming from?

If I post directly from the PO and I have no error. But it makes more business sense to invoice by getting the receipt lines. Thank you for your kind help in advance.

All responses (6)

Answers (0)

B@houston on at

Like (0)

Report

RE: Posting Error when Create Purchase Invoice from Getting Receipt Lines: the Quantity you are trying to invoice is larger than the quantity in the item ledger...

Thank you Steve
Suggested answer

Community Member on at

Like (0)

Report

RE: Posting Error when Create Purchase Invoice from Getting Receipt Lines: the Quantity you are trying to invoice is larger than the quantity in the item ledger...

Hello,

OK. I see the flow and scenario... I just ran a test exactly as you have it in my Cronus Sandbox and cannot recreate. In fact, the issue that bothers me is that the Warehouse Entry has a different UOM than that of the ILE UOM. I tried this 3 different ways with a UOM of PI2, then a BOX of 150 and Pallet of 300 and it posted the UOM correctly each time.

Not sure what might have occurred while the Post Receipt took place, not that there was anything, but for now I would do 2 things: 1) Can you test this in a Sandbox of your Production database and recreate? If not, I am not sure if we will ever know.

2) Post from the Purchase Order to close this document.

Hope this helps.

Thanks,

Steve
B@houston on at

Like (0)

Report

RE: Posting Error when Create Purchase Invoice from Getting Receipt Lines: the Quantity you are trying to invoice is larger than the quantity in the item ledger...

Hi Steve,

Pls find the another example.

1. Error: Purchase invoice #109857 cannot be posted due to the quantity that you are trying to post (80 P12) is larger than the qty in the item ledger with entry number 65211

2. Purchase Invoice is getting a posted receipt 109813 and entry no 65211 of qty 80 P12.

3. Posted Purchase Receipt 109813 Find Entries: Entry 65211 qty 80 P12

4. Posted Purchase Receipt 109813 the warehouse entry is strange, the quantity is 80 PO2.

5. When post the invoice preview from PO directly, I have no error.

Please advise where the error is coming from and how to trouble shooting, thank you.
Suggested answer

Community Member on at

Like (0)

Report

RE: Posting Error when Create Purchase Invoice from Getting Receipt Lines: the Quantity you are trying to invoice is larger than the quantity in the item ledger...

Hello,

Your initial question said the Entry No. was 65700. Your picture is showing a different entry. Check 65700.

Thanks,

Steve
B@houston on at

Like (0)

Report

RE: Posting Error when Create Purchase Invoice from Getting Receipt Lines: the Quantity you are trying to invoice is larger than the quantity in the item ledger...

Thanks, Steve.

The ILE is checked. The Invoiced Qty is zero (available qty to invoice is valid).
Suggested answer

Community Member on at

Like (1)

Report

RE: Posting Error when Create Purchase Invoice from Getting Receipt Lines: the Quantity you are trying to invoice is larger than the quantity in the item ledger...

Hello,

My first instinct is to look at the Item Ledger Entries and filter to Entry No. 65700 to see the Quantity and what was Invoiced and available to Invoice. I see you state if you Post Invoice from the Purchase Order all is OK, but this is troubling since the action is the same whether PO - Post Invoice or Purchase Invoice Get Receipt Lines. I would look at the ILE and entry to see if the Invoiced Quantity is greater than what you are trying to Invoice.

Hope this helps.

Thanks,

Steve