This article explains how to integrate production orders from any ERP into RS Production using the Standard Integration PINT-205.
We also cover how to retrieve production data from these orders.
|Table of Contents|
What is the standard integration
The standard integration is a way to integrate production orders, production plan and articles from any system into RS Production. It's also a used to input information about the production from RS Production into a ERP-system.
The interface between RS Production and the ERP-system is made out of two predefined sql-tables (Microsoft SQL). RS Production read and write to these tables cyclically. In the following guide we talk a bit about how it works and where we need database tables and integrations services to be installed.
The installation of the RS Integration service is preferably installed by technicians at Good Solutions. Thecreation of integration tables can be done by either side but it's important that the integration service can access the tables. It's also important that the tables are created by the provided sql-scripts.
The integration consists out of two sql tables. We continually read and write from/to these tables.
We read from the table and add all the information to RS Production.
Some things to note
We write a new row to this table when the status of the production order is changed.
- When the order is started.
- (Optional) When the order is paused
- (Optional) This report can contain information about produced quantities.
- (Optional) When the order is resumed after a paused
- When the order is finished
- This is the only report to contain setup time and production time
- (Optional) It possible to give the machine operators the ability to create a progress report that contains the produced quantity and an optional print flag.
For troubleshooting purposes it's appreciated if the Executed, ExecutionDate and ExecutionMessage fields are filled after retrieving/reading a report.
The Executed field should be filled when the ERP has retrieved the report.
Rows are not updated by RSP by default but if there has been a problem with a report it's possible for the customer to, for example, set Executed to false. This is done to trigger a reread of the report in the ERP.
Some things to note
Information that will be visible to the machine operators
If the I button will only be visible if there is an article instruction and if it is clicked it will be displayed.
In the administrative UI the following information will be displayed.
Order number, Article number, Article name and Article type will be available in reports when analyzing data.
Some of the data in the ERPReports table will be provided by the operator but most will be calculated automatically by the system.