Asprova can be integrated with any ERP system. It is ready to be interfaced with SAP, Oracle EBS, JD Edwards, Dynamics AX, QAD and legacy systems.
The table below shows how Asprova is integrated with an ERP system – the data can be interchanged using Tab Separated Value (TSV) files.
There are several data tables in ERP, such as: Planned independent requirement, Customer requirement, Planned order, Production order or Process order, Purchase requisition, and Inventory. For master data, there are Material, BOM (input items and quantity), and Routing.
In Asprova, there are 3 corresponding data tables related to an ERP System – Order, Item, and M-BOM (Manufacturing Bill of Materials).
There are several types of orders, such as Sales, Manufacturing, Purchase and Inventory.
There are 2 types of instructions in M-BOM: Input and Use instructions. Input instruction includes input items and its quantities as it relates to an ERP system’s master data BOM. Use instruction includes usable resource and production capacity of each process as it relates to an ERP system’s master data Routing.
It is necessary to prepare the interface program for the ERP side.The typical interface program for SAP is BAPI interface. In Asprova, data import/export is implemented by the DBIO feature. Thus, in most cases, there is no need to develop the software from Asprova’s side.
To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s online help and its e-Learning videos at http://lib.asprova.com/ (see 25. ERP Interface).