1 Topic by ckrosco (edited by ckrosco 12/04/2013 10:03:07 pm)

  • From: Canada
  • Registered: 06/12/2010
  • Posts: 69

Topic: QOH different on Planning Report and Item Movements

My inventory counts as reported in Inventory Planning Report and Inventory Item Movement do not match.

e.g. for one product, Inventory Planning Report shows 1,125, but Inventory Item Movement shows -225. Both for December 4, 2013.

FA 2.3.18

Any ideas why this is happening?

Just to clarify - Items & Inventory -> Inventory Item Movement is reporting the wrong inventory count. All other reports and pages dealing with inventory are correct.

  • From: Canada
  • Registered: 06/12/2010
  • Posts: 69

Re: QOH different on Planning Report and Item Movements

I see where this error is coming from.

Items & Inventory -> Inventory Item Movement always starts with 0

e.g. Quantity on hand before 11/05/2013           0

No matter what date I start this on, the starting quantity is always 0.

This is wrong, isn't it?

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: QOH different on Planning Report and Item Movements

You are right. I will have a look at this.

/Joe

  • From: Canada
  • Registered: 06/12/2010
  • Posts: 69

Re: QOH different on Planning Report and Item Movements

Thanks. This can be a useful report for tracking inventory.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: QOH different on Planning Report and Item Movements

You are right. Bug has now been fixed. Repository for stable is updated. You can also download and replace the fixed file here:

movement_types_db.inc

Thanks for detecting this bug.

/Joe