Update - Data import / export from / to SAP Business One

Importing data from SAP Business One

Click the first button under the Update menu item to import data from SAP Business One.

The following data will be imported into Schedule:

Resource groups

Resources

• Name
• Resource group
• Type

Production orders (only planned and released production orders will be imported)

• Doc Number
• Item No
• DueDate
• ProductDescription
• PlannedQuantity
• ProductionOrderStages
  1. SequenceNumber
  2. Name
  3. Resource Requirements
  4. PlannedQuantity
  5. IssuedQuantity
  6. Time Requirements

Schedule will be populated by these data points imported from your SAP Business One database, and will provide a detailed plan for your production.

Due to limitations in data availability in SAP B1 and/or exposure in the service layer, Schedule makes the following assumptions:

• Schedule will import your resources with a default weekly calendar for availability. You can change that calendar in Schedule
• To reflect your progress during production Schedule will interpret any ProductionOrderStage with an IssuedQuantity above 0 and below its PlannedQuantity as started Likewise any ProductionOrderStage with IssuedQuantity above its PlannedQuantity will be interpreted as finished
• To allow for more advanced use of Schedule features, Resources with the type “Other” will be interpreted differently. Other will be interpreted as a marker to take the earliest available Resource of the given Resource Group

Exporting data to SAP Business One

To export data to SAP Business One, click the second button under the Update menu item, as indicated by the red frame below.

This will start writing back the following data into SAP Business One:

Production Orders

• Scheduled start date of operations
• Scheduled end date of operations

In case you work with Produce and enabled the use of Schedule date/time in Produce / Manager settings, remember to export your data to SAP Business One in order to update the start and end date/time information in Produce.