each date opening data

mkpjsr

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 ?

Peter76

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.