5.2 Order Information

New or updating of existing orders in Handyman.

When exporting order(s) from the ERP system to Handyman we have some guidelines:

• Similar to the IDs for basic data records, each entry on an order (individual entry of a description, hours&cost, material, checklist, document) has two IDs to define the individual entry: the Handyman internal ID - typically the XML-tag is called  HSxyzID, e.g. HSMaterialID -  and the ID provided by the ERP (“Back office ID/line number”)  - typically the XML-tag is called xyzID, e.g. MaterialID.
• For creating new records, the HS-ID must be 0 while the ERP-ID should be provided. For updating existing records alternatively one or the other ID may be used. Be aware tha the HS-ID is a mandatory numeric tag. This type of tag must be filled with 0 if it is not used.
• You should create a field for Handyman order number in the order header table in the ERP system`s database. This field should be exported together with the order as described in the Handyman Programmers Reference Guide (HSOrderNumber). When importing orders from Handyman this field has to be updated.
• You should create a field for HSDescriptionID in the table for order description in the ERP system. This field should be exported together with the order as described in the Handyman Programmers Reference Guide. When importing orders from Handyman this field has to be updated.  Remember that order descriptions created in the ERP system can be edited in Handyman
• You should create a field for HSMaterialID in the table for order materials in the ERP system. This field should be exported together with the order as described in the Handyman Programmers Reference Guide. When importing orders from Handyman this field has to be updated.  Items/material added to the order in the ERP system and exported to Handyman cannot be edited in Handyman
• You should create a field for HSSalaryCodeID in the table for order hours in the ERP system. This field should be exported together with the order as described in the Handyman Programmers Reference Guide. When importing orders from Handyman this field has to be updated.  Hours added to the order in the ERP system and exported to Handyman cannot be edited in Handyman
• If items connected to an order are added to the order from a purchase order, remember to send the WholesalerID, PurchaseOrderID and LineNumber. This is used to identify registration origin from wholsesaler purchase order

If you are importing the remaining nodes, DocumentList and ChecklistList, do the same for those Handyman id`s.

In addition to this you need to use all the mandatory nodes as described in the Handyman Programmers Reference Guide.

• When you have imported order(s) into the ERP system you should send a “receipt”, iOrdr file, back to Handyman.  This is to update the orders in Handyman with correct status.  If you have created a order control in the ERP, its normal to send a receipt back to Handyman when approving the order(s) the this order control picture
• The node for MakeStoreMovement in the materialist should always be 1 if no special rules apply.

This document contains new or altered orders. It also contains orders that have been exported from Handyman and imported in the back office system.

 

 

File	COM
Create file iOrdr#####################################################.###	Set property XMLOrderList