Inventory report

lally
lally Member Posts: 323
edited 2010-05-27 in NAV/Navision Classic Client
Hi all,

How can i create the Report for an item with the Details Item Code , Qty , BIN code , Value .

I gone through the Bin content table and Ware House entry table , but i could not get the value.

Please throw some useful information .
lally

Comments

  • ara3n
    ara3n Member Posts: 9,258
    Value are stored at Item Ledger Entry level. Bin are stored at warehouse entry.
    There is no relationship between ILE and Warehouse entry.
    If you have avg costing method, you can get the avg value for that day.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • FDickschat
    FDickschat Member Posts: 380
    You could use the "Calculate Inventory" function in the "Phys. Inventory Journal". This will fill a journal with the necessary data which you could use to print.

    Be aware that items with specific cost will not have the correct value in the phys. inventory journal but will be valued as average.
    Frank Dickschat
    FD Consulting
  • lally
    lally Member Posts: 323
    Thanks for the help.

    When it comes to Inventory Valuation Purchase cost will differ for every vendor .

    Client is asking the Purchase cost against that Entry .

    Please help me.
    lally

Categories