External Warehouse Stock Status Report

Product : Sage MAS500
Description : Compare stock status report and warehouse quantities
Project Type : Custom project
Customized Screens : None
New Screens : Data compare. Excel import
Versions : 7.6 and later

The requirement for this customization was to be able to compare a stock status report received from an external warehouse to the corresponding stock status report from MAS500.

The warehouse’s report is transmitted in Excel format and then imported into MAS500 where it is compared to the inventory valuation report up to an including the ending date of the warehouse export. Variances are calculated as

  1. Differences between matching items’ onhand quantities in the two warehouses
  2. Items in the external warehouse and not in MAS500
  3. Items in MAS500 and not in the external warehouse.

There is the ability to report all records or just records where there are mismatches. Both the quantity variance and also the dollar impact of the variance is displayed. The modification can import 12,000 items and compare them in less than a minute.