Ready-To-Use Integration to synchronize Purchase Order data from CRIBWISE to MONITOR ERP G5 for reasons like:
- View purchased quantities and values in MONITOR
- View delivery status for orders in MONITOR
- Facilitate supplier invoice handling/approval – Match invoice with order
The integration is activated as a CRIBWISE Subscription Add-on and is available for all customers using MONITOR ERP G5.
The integration creates “Free text orders” (Row type 2) in MONITOR ERP, meaning there is no connection to Parts in the MONITOR inventory. Orders must have at least status “Active” in CRIBWISE to be synchronized to MONITOR ERP. Synchronization is triggered immediately whenever the order is created or updated in CRIBWISE. This means the Purchase Order is created in MONITOR when it is Sent to Vendor.
Detailed description
The synchronization is one-way only, CRIBWISE is the master for these Purchase Orders. Changes on orders in MONITOR ERP are not reflected back to CRIBWISE.
It’s possible to set up a separate order type in MONITOR ERP to use for these CRIBWISE created orders. Which order type to use is configurable in the integration. See more in the configuration section further down.
Purchase orders for all suppliers in CRIBWISE are synchronized. This means all suppliers (vendors) in CRIBWISE used for Purchase Orders must match a supplier in MONITOR. The match is CRIBWISE VendorId = MONITOR ERP Supplier Code. See picture below.
The match is case-sensitive which means “Cy34” will NOT match “CY34”.
It’s a prerequisite to make sure the vendor/supplier identities match between the systems before the integration is activated. The Integration Verification will check that every Vendor in CRIBWISE also exists as a supplier in MONITOR ERP. Vendors not found in MONITOR ERP will be listed in the Verification response. The list can then be used to see which vendors needs attention, either by changing the Vendor ID in CRIBWISE or to add it as a Supplier in MONITOR ERP.
The CRIBWISE Purchase Order number is used as order number in MONITOR ERP. Order numbers in MONITOR ERP must be no longer than 15 characters. If the order in CRIBWISE has a number containing more than 15 characters, there will be an error in the synchronization and the order will not be created in MONITOR ERP. The error will be visible in the integration execution log.
Data mapping between CRIBWISE and MONITOR ERP
Information on the Purchase Order is mapped from CRIBWISE to MONITOR ERP as follows.
If the order acknowledgment contains a tracking number from the vendor (supplier) that number is mapped to Supplier’s order no in MONITOR ERP.
The order item information is mapped to MONITOR Order row as in picture below.
It’s optional to have the Item Description added as a Sub Row to the MONITOR PO row. This is controlled from the configuration setting “Set Item Description as MONITOR PO Row Sub Content”. Read more about the configuration here.
If there is an Expected date on the order item in CRIBWISE that date will be set as Delivery date on the order row in MONITOR ERP.
Delivery date is mandatory in MONITOR ERP and if it’s not supplied from CRIBWISE, then Order date will be used as Delivery date. This is set automatically by MONITOR ERP during creation of the row.
Device
Device is specified on Order level or for each individual order item (row level). If the device is specified on order level the name of the device will be set as “Goods label” in MONITOR. See more in the Goods label section below.
When the device is specified on item level there could be multiple different devices connected to the same order. It’s then also possible to order the same Item (order code and description) for different devices on the same order. To be able to see which device the item is order for the name of the device will be added as a Sub Row text for the order row. See picture below.
Report arrivals
When the order item in CRIBWISE is updated with Received quantity this triggers the synchronization to MONITOR ERP by creating an Arrival Report to update received quantity for the Purchase order rows.
When all ordered quantities for a row is received the status of the row is changed to “Completely delivered”. If only a part of the order quantity is delivered the row status is changed to “Partially delivered”. When all Purchase order rows is completely delivered the Order status is changed to “Completely delivered” meaning it can no longer be changed.
Goods label
A Goods Label in MONITOR ERP can consists of up to two rows, like in the example below.
Purchase Orders synchronized from CRIBWISE will create a Goods label according to following business rules.
If there is a “Shipping note” specified on the Vendor connected to the Purchase Order, then this text is added as the 1st row of the Goods Label.
If the Purchase Order is created for a unique Device, then the name of that Device will be added to the 2nd row of the Goods Label.
If the Vendor doesn’t have a shipping note specified, then the Device name will be added to the 1st row instead.
Purchase Currency
The system currency in CRIBWISE must match the default purchase currency in MONITOR ERP. If the purchase in CRIBWISE is made in another currency than system currency, then this currency must also exist in MONITOR ERP.
Limitations
MONITOR doesn’t have an equivariant to the CRIBWISE order status. This means that there’s not possible to distinguish between Active, Closed or Cancelled orders in MONITOR.
When all rows in MONITOR are fully received, the order will automatically change its status to 9 – History (Completely delivered). When the order enters this status it’s no longer possible to update it.
There is not possible to delete order rows in MONITOR via API. If an order row is deleted in CRIBWISE then the order quantity will be set to 0 (zero) in MONITOR. Same will happen if the complete order is Cancelled, all rows will be set to zero.
There is not possible to set the Purchase Account number to use from CRIBWISE. The account is specified as a default setting in MONITOR. Same applies for cost center.
Purchase order number must not be longer than 15 characters. If an order in CRIBWISE has more than 15 characters, it will not be synchronized to MONITOR, and an error will be displayed in the execution log for the integration.
By-Default, all purchase orders will be synchronized regardless of Vendor, Stock or Device. Therefor it’s required to have the Vendor Id in CRIBWISE to match a supplier in MONITOR. Otherwise, the synchronization will fail, and an error will be displayed in the execution log.
It’s possible to slow-start the integration with only one or a few Vendors. This then makes it possible to verify the integration before enabling the synchronization for all the Vendors. See more regarding this in the Configuration section below, setting CRIBWISE – Suppliers to Synchronize.