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..?
SumanYadav501 said:ItemLedgEntry2.SETRANGE(Positive,NOT ItemLedgEntry.Positive);
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
Thanks for update..hope you well....
I tried to find but nothing found.
Do you know what are possible reasons..any guess..?
OK, next check links&corectness of the information in the "Item Application Entry" table
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.