Share
Report
35Hi All,
I have a question about the Phys. Inventory journal and specifically the field qty(calculated). Is there a way to calculate the stock level qty on a specific date. We have performed a physical count on march 31st. But now when I calculate the inventory of a certain location, with a date filter, I do not get the expected quantities for certain items on the list.
When I go into the item ledger entries for these items and filter on location and sort by posting date. I get a different qty again. Then when I check availability by period, and then filter on location I get o whole different qty again. I am confused as to how to correctly calculate the actual system qty per a specific date. To me I would expect the Item ledger entries sorted by date and filtered by location the be the same as the calculated qty's.
What am I missing? I have seen the qty (calculated) field in the Phys Journal seems to be the remaining amount per location, but it omits the filtered date. Any way to get the date entered in the date filter to be included in the calculation? Cause If I had a receipt for one item a day after the date counted, I will be comparing wrong quantities and entering posting the qrond actual quantaties in the system.
Please let me know If I need to clear up anything.
All responses (
Answers (
