Difference b/w Quantity & Remaining Quantity in Item Ledger table

Business Central/NAV User Forum
1

My item R46 have inventory is 960 for location 09 but Remaining Quantity at I.L.E table is 460 only.

When I am posting Item Reclassfication Journal from Location 09 to Location10 then I am getting a customized error that you cannot post outbound quanity less then accepted quantity.

Item No - R46 , Location - 09,Quantity 960. Variant = blank

I analyzed code and found that system is setting some filter in function

Codeunit 22 ApplyItemLedgEntry ()

IF FirstApplication THEN BEGIN
FirstApplication := FALSE;
ItemLedgEntry2.SETCURRENTKEY(
“Item No.”,Open,“Variant Code”,Positive,“Location Code”,“Posting Date”);
ItemLedgEntry2.SETRANGE(“Item No.”,ItemLedgEntry.“Item No.”);
ItemLedgEntry2.SETRANGE(Open,TRUE);
ItemLedgEntry2.SETRANGE(“Variant Code”,ItemLedgEntry.“Variant Code”);
ItemLedgEntry2.SETRANGE(Positive,NOT ItemLedgEntry.Positive);
ItemLedgEntry2.SETRANGE(“Location Code”,ItemLedgEntry.“Location Code”);

ExcludeQCItem(ItemLedgEntry2) //Customized Function

on base of above filter system sum the Remaining Quanitity and found 460 and compare with the 960 Quantity(Actual Posted Quantity) and error appears.

My Question is how system can make this much difference i.e 960-460=500.?

Version is NAV 6.0 Classic client

any expert please guide me…?

2

please, check value Open and Positive for all lines where item R46 (I remember apply-issue in the CU22)

If these check-marks are corrrect, when we need to see ILE-lines

3

Thanks for update…hope you well…

I tried to find but nothing found.

Do you know what are possible reasons…any guess…?

4

OK, next check links&corectness of the information in the “Item Application Entry” table

5

Hai Suman,

As per functional point of View Quantity means what ever the quantity you are posted related to that Document no, and Remaining quantity means after posting the Quantity what are the remaining quantity for the respective item.

Regards

RamakrishnaReddy Y