Skip to main content
Solved

How to fix the Inventory Summary not tally in Purchase Receipts (Total Receipts of items)


Forum|alt.badge.img

Hi all,

 

Can you help me about the Tally of records in Inventory Summary to Purchase Receipts because when I create a Purchase Order then Purchase Receipts the quantity is correct but when I go to Inventory Summary the total of Purchase Receipts is double (Please see the screenshot below)

 

This is the total of Purchase Receipts (On-hand, Available, and Shipping are 100)

 

But in the Inventory Summary is double the digit of quantity that I received in Purchase Receipts

 

 

and in the Inventory Balance are the same reports 

 

 

Please help me to fix this bugs.

Best answer by Ahmed

@acumaticapm182 can you clear this Location field on Inventory Summary? It looks like you have one extra item somewhere else in the warehouse:
 

Also, can you show what the item general settings look like? Your sales UOM and base UOM seem different.

View original
Did this topic help you find an answer to your question?

4 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3375 replies
  • June 18, 2022

Hi @acumaticapm182  Can you please run the Recalculate Inventory for the RESTHAVEN warehouse and verify.

 


Forum|alt.badge.img

Hi Naveen Boga,

 

Nothing happen, it’s the same when I process the Recalculate Inventory


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3375 replies
  • June 18, 2022

@acumaticapm182  It seems according to the Availability Calculation Rules. Purchase Receipt Qty is also included in the Available Qty.

 

You can check the Availability Calculation Rules on below screen.

 

 

To see the difference, you can update the Purchase Receipt Qty and verify in the Inventory Summary OR Inventory Allocation details screen.


Ahmed
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • 50 replies
  • Answer
  • June 18, 2022

@acumaticapm182 can you clear this Location field on Inventory Summary? It looks like you have one extra item somewhere else in the warehouse:
 

Also, can you show what the item general settings look like? Your sales UOM and base UOM seem different.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings