I checked on my Inventory Transaction Detail for Beginning and Ending Qty. Please refer to the first page on period August 2022 screenshot document below:
The beginning balance is correct because I just created the stock item so the beginning balance is zero and the ending balance is also correct because I purchased 400 item in August 2022.
However, when I changed the next period, instead of reflecting the ending quantity from last period, the beginning quantity begins with zero again. Thus, the ending quantity is minus. Please refer to the second first page on Period September 2022 screenshot document below:
The beginning balance starts with zero again, resulting the ending qty balance become minus.
When I checked the report, it reflected right quantity balance.
Please advise how to fix the information regarding beginning and ending balances in Inventory Transaction Detail.
Regards,
Nadia
Best answer by Kandy Beatty
HI @nadia02
The Inventory Transaction Details report shows the transactions by the selected period. It basically gives you a clean slate every period.
According to your report, you brought in 200 on 9/1/2022 (or the date your period started)
I looked in my local to verify this and I placed an order yesterday for an item and the report tells me the beginning qty is 0, then it reflected the 2 that I sold.
The Inventory Transaction Details report shows the transactions by the selected period. It basically gives you a clean slate every period.
According to your report, you brought in 200 on 9/1/2022 (or the date your period started)
I looked in my local to verify this and I placed an order yesterday for an item and the report tells me the beginning qty is 0, then it reflected the 2 that I sold.
