October

IMFX utility rebuilds your MAS 90 & 200 Inventory, Sales Order and Customer sales history files

Posted By: Wayne Schulz - Contact the author

Not what you're looking for? Check out Schulz Consulting Prior MAS90 News Post Archives or send me an email. Thanks for visiting!

dsd IMFX Customer Sales History Rebuild.jpg

Has a data problem caused you to doubt the accuracy of the totals in your Inventory Item Sales History file (IM9)? If you’ve recently experienced a data glitch of perhaps you’ve changed your fiscal basis for tracking inventory from a calendar to a new fiscal period. IMFX from DSD Associates will rebuild and correct your totals.

Rebuilding detailed customer sales history is not covered by any of the utilities included with Sage MAS 90 or 200. In the past some consultants have taken to extreme measures to rebuild these files manually for clients.

IMFX rebuilds the following files in all versions of Sage MAS 90 and Sage MAS 200:

IM9 – I/M Inventory Item Sales History
IM_13 – I/M Customer Item Sales History
SO_SalesHistory – S/O Item Sales History
AR_CustomerSalesHistory – A/R Customer Sales History

IMFX is a rebuild utility designed to rebuild the Inventory Item Sales History and Customer Item Sales History files.

The Warehouse Item Sales History, Customer Item Sales History, SO SalesHistory, and Customer Sales History tables are rebuilt from data in the AR Invoice History Header and AR Invoice History Detail files.

What Are Your Alternatives To This Utility?

You may think that rebuilding your Sage MAS 90 or 200 sort files will resolve situations such like this? It won’t. The sort file rebuild contained within Sage MAS 90 and 200 will rebuild a limited number of totals including items like quantity on Sales Order. It won’t rebuild the detailed history that many people rely upon for their sales reports.

If you’re thinking that you could re-key the data directly into the above data tables or use Visual Integrator – you might be right. But think about the time you’d spend extracting the data, accumulating the totals, checking the math, designing the Visual Integrator import job and suddenly this utility has the potential to be a huge timesaver.

If you’re in a situation where you need to rebuild sales history in any of the above data files then this is the utility for you. DSD Associates is a Master Developer for Sage Software and they’ve been around since before I started working with Sage MAS 90 (1986). Their catalog of enhancements is pretty popular with users – especially their magnetic media.

Contact person at DSD for sales questions :
Sedal Legesse – 858-550-5900 x133

Cost of enhancement:
$ 708.33 (includes first year maintenance of $208.33)

Introductory Promotion – 15% off through 10/31/08

Links:
IMFX program manual (PDF)

IMFX Rebuild MAS90 & MAS 200 Inventory History Utility

Related posts you might want to review:
Service Update 17 for Sage MAS 90 and 200 4.30 (4.30.17) released 12/24/09

About Wayne Schulz

Wayne is a Sr Consultant who has worked with Sage MAS 90 and MAS 200 since 1986. He provides technical support to companies located throughout the United States on all versions of MAS90 and MAS200. Contact him on Twitter or Facebook or email wayne@s-consult.com. Review a list of all Schulz Consulting Prior MAS90 News Post Archives here. The views expressed on this site are solely those of the author and do not reflect the opinion or position of any other person or company. We are NOT in the business of providing tax, accounting or audit advice and you are advised to consult with your tax professional in such matters and not to rely on any information here as authoritative tax, technology or accounting advice.

Filed Under MAS90, MAS90 Tips and Tricks