Fix error in calculation logic for the Quantity Opening Balance. For an inventory item, changes in a Conversion rate for a particular Unit of measure are correctly accounted for in table ICIVAL but, with the passage of time, result in the ICMVMT02 report incorrectly showing Quantities in the Balance column.

Note this error occurs when the report is run for, say, the last 6 months of transactions. The report works correctly when run right back to include the very first inventory transaction for an item (but providing an 800 page to a business user to ensure the quantities are correct isn't much use to us).

We have a number of inventory items where changed assumptions have led to changes to Conversion rates for different units of measure. E.g. we initially estimated getting 15 patient usages per bottle of anaesthetic fluid but have changed this to 20 patient usages per bottle to better reflect reality.

Hence the I/C Inventory Movement (ICMVMT02) Report on our system [Sage ERP Accpac 500 (Version 6.0A)] frequently gives quantity errors when run, say, to give the last 6 months of transactions. This undermines confidence in our ERP system when the report is provided to business users.

The Opening balance calculation logic is flawed - the report should use historic Conversion factors recorded in field CONVERSION in table ICIVAL (IC0352), or alternatively use field STKQTY (which is the historic calculation QUANTITY x CONVERSION). Instead the report seems to calculate the Quantity opening balance by applying current Unit-of-measure conversion rates to accumulated quantities for each Unit type, provided the transaction date is before the date set on the report filter.

It would be great to get the Quantity Opening Balance correctly calculated by this report - whether the start date entered is 1 Jan 2008, 1 Jan 2011 or 1 Jan 2014! This would mean all the Quantity running balances would show correctly on the report.

Cheers, Andrew

Written 2:53pm Friday 29 August 2014

by: Andrew T. | over a year ago | Financial Management