Calculate Child Line Quantity and Value

This Optional Feature, when enabled, provides you with improved calculations of the quantity and value of child transaction lines when they are created by GTM. Specifically, when you assign a Trade Item Structure to a trade transaction line using actions, GTM can calculate the quantity and value of the child transaction lines based on the quantity and value of the parent transaction line and the quantities found on the item structure.

For example, if you are shipping eyeglasses, you may have a trade item structure for 1 pair of eyeglasses with the following component quantities:

Eyeglass frame = 1 EA
Eyeglass lens = 2 EA
Eyeglass temple sticks = 2 EA

When the trade item structure is assigned to a trade transaction, the quantities of the child transaction lines are calculated based on the quantity of the parent transaction line. If the trade transaction you are assigning the trade item structure to has a quantity of eyeglasses = 50 EA, then the child lines should reflect the following quantities based on the quantity in the trade item structure component multipled by the quantity of the parent transaction line:

Eyeglass frame - 1 X 50 = 50 EA
Eyeglass lens - 2 X 50 = 100 EA
Eyeglass temple sticks - 2 X 50 = 100 EA

To enable GTM to calculate the child line quantity and value, the following objects need to be configured:

Trade Item Structure containing a list of trade item structure components
Constraint Set
Compliance Rule, Compliance Rule Set, and Compliance Rule Set Group
Trade Transaction with a Trade Transaction Line

Trade Item Structure

Before you can assign a trade item structure to a trade transaction line, you must have trade item structures configured in GTM. The trade item structure should contain an item, quantities, values and components. Each of the trade item structure components should contain an item, quantities and values. In this example, you have a trade item structure called 'EYEGLASS PARTS' containing 3 components: EYEGLASS LENS FRAME, EYEGLASS TEMPLE STICK, and EYEGLASS LENS. For EYEGLASS PARTS, note the quantity and value. If the Quantity and Quantity UOM are left blank, GTM assumes the quantity = 1 EA.

Example, trade item structure called 'EYEGLASS PARTS'

In this example, one of the components is EYEGLASS LENS. Note the Quantity and Values for the component.

Example, trade item structure components EYEGLASS LENS

Constraint Set

A constraint set is used to match a trade item structure to a trade transaction line during assignment. When creating a constraint set, the Constraint Set Type = TRANSACTION-LINE ITEM STRUCTURE ASSIGNMENT. Once created, you can assign the constraint set to the compliance rule. In this example, the constraint set is matching based on involved party and item information.

Example constraint set used to match a trade item structure to a trade transaction line

Compliance Rule Data

You can assign a trade item structure to a transaction line using compliance rules. When creating the compliance rule, the Control Category = ITEM STRUCTURE. On the Compliance Rule tab, enter the criteria you want to use to match the compliance rule to the transaction line. On the Controls tab, enter the Date Qualifier to be matched to the transaction/transaction line and the constraint set you created. In this example, the criteria to match the compliance rule is Item ID and Ship From Country. In the Controls, the Date Qualifier being used is TRANSACTION DATE and the constraint set is the one you previously created.

Example - Compliance Rule to assign a trade item structure to a transaction line using compliance rules

Once the compliance rule is created, you need to add it to a Compliance Rule Set. Then, add the compliance rule set to a Compliance Rule Set Group.

Trade Transaction

Once configured, you can assign a trade item structure to a transaction line. To do this, you can run one of the following actions:

Execute Compliance Rules - available as a UI action or agent action from the Trade Transaction, Trade Transaction Line, Declaration (Agent Type: GTM Shipment) or Declaration Line (Agent Type: GTM Shipment Line)

Execute Policy - available as a UI action or agent action from the Trade Transaction or Declaration (Agent Type: GTM Shipment)

Once you assign a trade item structure to a transaction line, GTM assigns child lines to the parent line based on the components in the trade item structure. In this example, notice that the Item ID of EYEGLASSES in the parent transaction line is the same Item ID as on the trade item structure. The child transaction lines contain the same items as the trade item structure components.

Example - child transaction lines contain the same items as the trade item structure components

Notice that the Item Structure ID field on the parent transaction line is not populated with the trade item structure that is assigned. Instead, a Transaction Item Structure is created and each of the child lines point to it. Within the Transaction Item Structure, you can see the Compliance Rule Set Group and Compliance Rule used for assignment.

Example - Transaction Item Structure is created with child lines pointing to it, within Transaction Item Structure, Compliance Rule Set Group and Compliance Rule are assignment

Business Benefit

The feature reduces setup effort required during implementation for when creating child lines from item structures.

Steps to Enable

To enable GTM to calculate the child line quantity and value, the following setup is required:

Set the Optional Feature called 'Calculate Child Line Quantity and Value' to TRUE/enabled. Accessed via Configuration and Administration > Property Management > Optional Features.

NOTE: Only the DBA.ADMIN user can access and use the Optional Features page.

Create a trade item structure containing an item and a list of trade item structure components. Other information such as quantities and values should be specified.

Create a constraint set with a type = TRANSACTION-LINE ITEM STRUCTURE ASSIGNMENT.

Create a Compliance Rule with a category = ITEM STRUCTURE. On the controls tab, specify the constraint set you just created.

Create a Compliance Rule Set specifying the compliance rule you created.

Create a Compliance Rule Set Group specifying the compliance rule set you created.

Create a Trade Transaction with a Trade Transaction Line including the same Item as on the trade item structure. Other information such as quantities and values should be specified.

Assign the trade item structure to the trade transaction line using an action from the UI or agent action.

Tips And Considerations

When configuring agents for Declarations and Declaration Lines, the Agent Type is GTM SHIPMENT and GTM SHIPMENT LINE respectively.