Skip to main content
Solved

An Error in Beginning Qty and Ending Qty - Inventory Transaction Details Report

  • 8 September 2022
  • 4 replies
  • 142 views

Hi All,

 

I have a question regarding the inventory report:

 

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

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 report is working as expected. 

Hi @nadia02 

I dont have any idea of the issue here but I just want to check below parameter to investigate the issues 

If required I have GI in hand to show the beginning qty, sold qty, and in and Out qty details based on the date filter.

Let me know if you need GI to investigate the issue 

Hi @nadia02 - were you able to find a solution? Thank you!

Hi @nadia02, I was wondering if you can share the GI mentioned above. That looks like something I am looking for.

Reply


Terms & ConditionsCookie settings