Example

This is a model example for importing quantity.

Example 1

Scenario 1: Import quantities for regular class Products

These criteria must be met before importing:

  • Resource reference must be provided for the Products class in the mapping.
  • Referenced Product resources must be imported before importing the quantities for Products.

This table describes the mapping process to import quantity values for Products at Locations:

Mapped field Description Import Value (for example)
Products.name Reference to Products resource Product A
Products.units per transport unit Value of property “units per transport unit” for Products resource and bucket 100
bucket Bucket reference in which to import property value FY19 W42

These resources must exist for references before importing:

  • Products resource: ‘Product A’
  • bucket: ‘FY19 W42’

The units per transport unit property is updated with quantity value 100, for Products resource ‘Product A’ at bucket ‘FY19 W42’.

Scenario 2: Import quantities for Products At Locations Allocation class with components Products and Locations

These criteria must be met before importing:

  • Resource references must be provided for Products and Locations in the mapping.
  • Referenced resources for Products and Locations must exist.
  • Products At Locations resources must be imported before importing the quantities for Products At Locations.

This table describes the mapping process to import quantity values for Products at Locations:

Mapped Description Import value (for example)
Products.name Reference to Products resource Product A
Locations.name Reference to Locations resource Location X
Products At Locations.qty on hand Value of ‘qty on hand’ property for Products At Locations resource 100
Products At Locations.shelf life Value of ‘shelf life’ property for Products At Locations resource 180
bucket Bucket reference in which property value is to be imported FY19 W42

These resources must exist for references before import:

  • Products resource: ‘Product A’
  • Locations resource: ‘Location X’
  • Products At Locations Allocation resource for components: Product ‘Product A’ and Location ‘Location X’
  • bucket: ‘FY19 W42’

The qty on hand and shelf life property values are updated with 100 and 180 respectively, for Products At Locations resource ‘Product A@Location X’ at bucket ‘FY19 W42’.

Scenario 3: Import quantities for ‘Customer Allocations’ allocation class with components Products At Locations and Customers

These criteria must be met before importing:

  • Resource references must be provided for Products At Locations and Customers. References to Products At Locations must be provided as references to the Products and Locations components as Products At Locations is an Allocation class.
  • Customer Allocations resources must be imported before importing quantities for Customer Allocations.

This table describes the mapping process to import quantity values for Customer Allocation:

Mapped field Description Import value (for example)
Products.name Reference to Products resource Product A
Locations.name Reference to Locations resource Location X
Customer.name Reference to Customers resource Customer 1
Customer Allocations.forecast Value of property “forecast” for Customer Allocation resource 100
Customer Allocations.orders Value for property “orders” for Customer Allocation resource 85
Bucket Bucket reference in which to import property value FY19 W42

It is determined that the import process considers ‘Customer Allocations’ class based on the property references specified for Customer Allocation.

These resources must exist for references before importing:

  • Product: ‘Product A’
  • Location: ‘Location X’
  • Customers: ‘Customer 1’
  • Products At Locations Allocation resource: ‘Product A@Location X’
  • Customer Allocations Allocation resource: ‘Product A@Location X@Customer 1’
  • Bucket: ‘FY19 W42’

The forecast and orders property values are updated with 100 and 85 respectively, for Customer Allocation resource ‘Product A@Location X@Customer 1’ at bucket ‘FY19 W42’.