You’re offline. This is a read only version of the page.
37
Hi 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.
Hello Zafar,
you do not miss anything. In the past, the decision had been made, not to support the functionality setting a Date Filter. This was due to the fact, that this rose too many problems that could not be accounted for as there apparently were some unknown scenarios where the code would be unaware of how to handle the qty.
Also, to find QOH on a certain date, you can use the Inventory Valuation Report.
I hope this clarifies your question.
BR
Franziska
#1
Sohail Ahmed
1,382
#2
YUN ZHU
1,008
Super User 2025 Season 1
#3
Mansi Soni
880
Share
Report
All responses (
Answers (
