In-House MRP/ERP System

ABS easily interfaces with many in-house accounting and MRP systems. This is accomplished with import files to ABS and with transaction files back to the in-house system. Some of the MRP/ERP systems that have been interfaced with ABS include: Oracle Manufacturing, Oracle Financials, MAPICS, BPICS, EFAX, MOVEX, J.D. Edwards, Baan, and several home-grown systems.

The ABS Inventory Control System’s “EXPORT” function creates an ASCII transaction file of all ABS receipts and/or usage activity. The transaction file can then be processed by various in-house accounting, database, and reporting systems. The EXPORT function eliminates the necessity of having to enter material receipts or usage information more than once. One typical use for this feature would be to update an in-house material inventory system. This function also allows ABS to provide transactions for use by third-party ERP systems.

The ABS Material Editor’s “IMPORT” function is primarily used to import raw material information from an outside source (i.e., another computer) into your ABS raw material database. You can import either all data fields or partial data. When performing a full import, the records being added will first be checked against the existing material database. If the record already exists, the import function will not update or modify the following fields: 1) Furnace Codes, 2) Date Last Changed, 3) Date Last Used, and 4) Quantity Reserved. All other fields will be replaced with the imported values.

Keystone Systems has the capability to read or write directly to any ODBC compliant database or product, including Microsoft Excel and Access. This capability is not part of our standard product offering; instead, it is done on a client by client “as needed” basis.