Quantity on Hand for the Item Card

mtnbuzz

I understand its a Flow field but what tables/columns (sql2k) does it use to calculate this? Thanks.

mleser

The Qty On Hand on the Item Card is getting it's info from the Item Ledger Entries. Below are the filters used to get the On Hand Qty.

Sum("Item Ledger Entry".Quantity WHERE (Item No.=FIELD(No.),Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Drop Shipment=FIELD(Drop Shipment Filter),Variant Code=FIELD(Variant Filter),Bin Code=FIELD(Bin Filter)))

mtnbuzz

mleser wrote:

The Qty On Hand on the Item Card is getting it's info from the Item Ledger Entries. Below are the filters used to get the On Hand Qty.

Sum("Item Ledger Entry".Quantity WHERE (Item No.=FIELD(No.),Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Drop Shipment=FIELD(Drop Shipment Filter),Variant Code=FIELD(Variant Filter),Bin Code=FIELD(Bin Filter)))

I followed the logic and the only place where there are inventory Qty's is Item Ledger Entry.Quantity. The remaining fields contain other data.

i4tost

It depends on what is a size of table, what statistic information has SQL and so on.
It can be calculated from few tables
First one in table "<company name>_$Item Ledger Entry"
Also you can try to get information from tables like
"<company name>_$32$0" ot 1... at the end. In these tables there is an information for SumIndexFieds. More information you can get from Navision solution center in your country.

farrel

mleser wrote:

The Qty On Hand on the Item Card is getting it's info from the Item Ledger Entries. Below are the filters used to get the On Hand Qty.

Sum("Item Ledger Entry".Quantity WHERE (Item No.=FIELD(No.),Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Drop Shipment=FIELD(Drop Shipment Filter),Variant Code=FIELD(Variant Filter),Bin Code=FIELD(Bin Filter)))

Hello, Just wondering if you manually add the Bin filter cause I can't find the Bin Code on the Item Ledger Entry... BTW i'm using NAV 5.0..