Quantity on Hand for the Item Card

mtnbuzz
mtnbuzz Member Posts: 3
edited 2008-05-07 in Navision Attain
I understand its a Flow field but what tables/columns (sql2k) does it use to calculate this? Thanks.

Comments

  • mleser
    mleser Member Posts: 1
    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
    mtnbuzz Member Posts: 3
    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
    i4tost Member Posts: 208
    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
    farrel Member Posts: 25
    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..

Categories