How can I get my existing data into Resource Manager  from Baan or other MRP system?

Products and Operations lists can be copied and pasted, linked, etc. directly from any system into the Product and Operation Lists. Configured BORs\BOMs can be copy and pasted directly into the Resource Manager BOR Input Table. You can match up the fields directly and use Copy, Paste Special, Values (skip blanks) to keep from overwriting formats, headers, etc.

After either case, Process Error check after data has been entered. The robust error checking built into the Resource Manager will find and auto correct many errors, and notify the user when it needs help (such as finding a duplicate Product Number -- which one to edit\delete).

For copied BORs that are missing key data, the error checking will even establish the logical linkages for all levels and routings in a simple click and choose format.

To bring over a string of completely pre configured BORs, you may consider copying the complete range of preconfigured BORs to filed BOR area, then saving model as MRPDATA.xls then opening new copy of Resource Manager and running the upgrade process. The program will find all data and redefine range names.

Other areas (order entry, inventory levels, master schedule) can be copy and pasted or linked directly to these areas. Once you are past the Master Lists and BOR\BOM configuration, there is no further error checking required.

Resource Manager for Excel Main Page

Business Software

MS Excel Add-ins, Spreadsheets, Templates