each date opening data

mkpjsr
mkpjsr Member Posts: 587
edited 2013-07-02 in NAV/Navision Classic Client
hi experts


I am creating a daily stock register report using item ledger entry table . I have to display the opening closing balance of each item of each date if the entry is not present into the item ledger entry table . please mention a coding logic how can i do this ?

Comments

  • Peter76
    Peter76 Member Posts: 10
    I don't understand that request. What do you mean with "if the entry is not present in the item ledger entry table"? What entry should not be present? And how do you define "opening closing balance"? Since NAV has perpetual inventory, there are no balances, so whatever you want to do, you have to calculate the inventory on hand as of one day and as of another day using the date filter.
    Peter Zentner
    NAV Practice Manager at Clients First Business Solutions

    Did you check out our free training videos at www.dynamics-nav-training.com?
    Look at our blogs.

Categories