FrontAccounting forum — QOH different on Planning Report and Item Movements

Re: QOH different on Planning Report and Item Movements

null@example.com (joe) — Wed, 04 Dec 2013 23:21:54 +0000

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

Re: QOH different on Planning Report and Item Movements

null@example.com (ckrosco) — Wed, 04 Dec 2013 22:53:18 +0000

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

Re: QOH different on Planning Report and Item Movements

null@example.com (joe) — Wed, 04 Dec 2013 22:33:48 +0000

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

/Joe

Re: QOH different on Planning Report and Item Movements

null@example.com (ckrosco) — Wed, 04 Dec 2013 22:08:08 +0000

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?

QOH different on Planning Report and Item Movements

null@example.com (ckrosco) — Wed, 04 Dec 2013 21:48:53 +0000

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.