Trade plans

Before costs, revenues, price increases or discounts can be assigned to an order, the price or cost component must be specified.

A trade plan specifies a price rule and/or accrual which can be applied automatically when creating a sales/purchase document or is manually inserted by a user. For each accrual or price rule, you can enter the value of the price rule or accrual and select for which customers/vendors/items these rules apply.

1. Select the Search icon , enter Trade Plans, and then choose the related link.
   The Trade Plans list page opens.
2. On the action bar, select New.
   The Trade Plan Card page opens.
3. On the General FastTab, enter the required information in the following fields:

The starting date and ending dates are transferred to the Trade Plan Rates page. These dates can be adjusted on the trade plan rates page within these selected dates. On a sales, purchase, and transfer order, the dates will be compared with the price reference setup (as specified on the customer card). For all other sales and purchase documents, the dates will be compared with the order date or work date (if the order date is empty). These fields are optional.

6. On the Details FastTab, enter the required information in the following fields:

7. On the Accruals FastTab, enter the required information in the following fields:

8. On the Trade Plan Setup Freight FastTab, enter the required information in the following fields:

When sales prices in a sales document are specified in another currency than in the trade plans, then trade plans for which the Accrual Type field is specified are applied (currency is recalculated). Still, trade plans in which Price Rule is specified, are not applied.

The trade plan is now set up.

Copy Trade Plan

The Copy Trade Plan action allows you to enhance the productivity of creating a new Trade Plan by allowing the copy of an existing record.

1. Select the search icon , enter Trade Plans and then choose the related link.
   The Trade Plans list page opens.
2. Select the required No.
3. On the action bar, select Actions > Functions > Copy Trade Plan. The Copy Trade Plan dialog box opens.
4. Select the required Trade Plan No. from the AssistEdit button.
   You can view the list of trade plan records based on the options (Per Group, Specific, Per Trade Business Group with Specific Item, and Per Trade Product Group with Specific Source) selected in the Trade Rate Setup field.
5. Click OK.
6. To include Groups, Exclusions and Rates associated with the original trade plan turn on the respective toggles.
   When copying the trade plan, the Item Exclusions, Locations Exclusions, Shipment Method Exclusions, Vendor Exclusions, Customer Exclusions, and Global Lot Attribute Exclusions are included if the Include Rates toggle is turned on.

Now, you can see the records of the copied trade plan that have been updated on the existing trade plan card page. It helps you to edit, update or modify only the required details in the respective fields.

Trade Plan Groups

After setting up the trade business groups and trade product groups, these groups can be assigned to a trade plan. A trade plan group is always a combination of a trade business group and a trade product group.

When creating a sales/purchase document, the trade plan rates from this trade plan will be used when the trade business group and trade product group are available on the sales/purchase document.

1. On the Trade Plans list page, select Groups.

Opening the Trade Plan Groups page from a specific trade plan, the Trade Plan No. filter is set for the trade plan. To see all trade plan groups (and delete all), open the filter pane, and delete the filter.

2. In the Trade Business Group field, select the required Code from the drop-down menu.
3. In the Trade Product Group field, select the required Code from the drop-down menu.
   The trade plan group is now set up.

Set up Trade Plan Groups for specific item/source

You can effectively configure trade plan groups and trade rates for specific customer/item rates, enhancing the flexibility of your trade rate setup. The system will automatically grant access to the related Trade Plan Groups page upon selecting the desired Trade Rate Setup field option.

If the Trade Rate Setup field is set as Per Trade Business Group with Specific Item, the corresponding Trade Plan Groups page is displayed only with the Trade Business Group field. The system will prevent entry with the Trade Product Group field record.

If the Trade Rate Setup field is set as Per Trade Product Group with Specific Source, the corresponding Trade Plan Groups page is displayed only with the Trade Product Group field. The system will prevent entry with the Trade Business Group field record.

Trade Plan Exclusions

After setting up the trade order types, you can link them to a trade plan. When a sale document, a purchase order, and/or a purchase return order is created where this order type is selected, the trade plan rates in this trade plan are not used.

For example, sales orders for a customer are usually placed through a commissioner (sales agent that earns a commission via the sales price) and some costs are added to the sales price to cover this commission cost. Occasionally, a sales order for the same customer is placed, but not via the commissioner. In this case, it should be easy to prevent the cost from being added, without changing the system setup.

1. .On the Trade Plans list page, select Exclusions.

2. In the Value field, select the required Code from the drop-down menu.

The trade plan exclusions are now set up. You can set up multiple exclusions.

Trade Plan Rates

Per trade plan, multiple trade plan rates can be set up. The rates can be set up per group or specific for customers, vendors, and/or items, depending on the setting trade rate set up on the trade plan.

1. On the Trade Plans list page, select Rates.
   The Trade Plan Rates page opens.

2. In the Trade Rate Setup field, fill in the required details.
   The trade plan rate is now set up.

Set up Trade Plan Rates for specific item/source

After selecting the desired Trade Rate Setup field option on the Trade Plan Card page, the system will automatically grant access to the related Trade Plan Rates page.

If the Trade Rate Setup field is set as Per Trade Business Group with Specific Item, the corresponding Trade Plan Rates page is displayed with the relevant Item Type, Item No., and Variant Code fields, defining rates applicable for item groups.

If the Trade Rate Setup field is set as Per Trade Product Group with Specific Source, the corresponding Trade Plan Rates page is displayed with the relevant Source Type, Source No., and Source Address Code fields, defining rates applicable to customer groups.

Trade Plan Rates Exclusions

Setting up the exclusions allows you to exclude specific items, locations, shipment methods, customers, vendors, and global lot attributes from the trade plan. With this, you can prevent trade costs and pricing from being applied to sales and purchase documents.

The Trade Plan Rates page incorporates Item Exclusions, Location Exclusions, Shipment Method Exclusions, Vendor Exclusions, Customer Exclusions, and Global Lot Attribute Exclusions functions to establish exclusions for the trade rate calculations. If any order line includes one of the specified excluded records, the trade rate/price will not be applied to that specific document line. When creating a sales and purchase document with selected exclusions, the trade plan rates associated with that trade plan will not be utilized.

For example, when placing sales orders for a customer through a sales agent who earns a commission based on the sales price, additional costs are typically included to cover the commission. However, in certain cases, a sales order for the same customer may be placed directly without involving the sales agent. In such scenarios, preventing the cost from being added without changing the system setup should be easy.

The Excluded Values FactBox displays the exclusion sets already assigned to the trade plan rate line on the Trade Plan Rates page. You can access and view the specific exclusion records by clicking the corresponding number (e.g., “2”) in FactBox.

The following procedure explains how to set customer exclusion. The steps are similar for all other exclusions.

1. On the Trade Plan Rates page, select Customer Exclusions.
2. In the Value field, select the required code from the drop-down menu.
   The trade plan rate exclusions are now set up.

   Note

   You can add multiple records by adding ”|” between each value.

When exclusions are added or deleted to the trade plan, a notification will appear in a blue bar at the top of the Trade Plan Rates page.

The following procedure explains how to remove the exclusions that have been set. The process is similar for all exclusions except for global lot attributes exclusions.

1. Open the Trade Plan Rates page.
2. In the Excluded Values FactBox, select the No. of Customer Exclusion.
   The Trade Plan Customer Exclusions page opens.
3. Select the required exclusion that you want to delete.
4. On the action bar, select Manage > Delete.
   The selected customer exclusion is successfully removed.

Trade Plan with Trade Rate Setup

Depending on the option selected in the Trade Rate Setup field, the trade plan rates are determined. Additionally, you have the flexibility to create multiple trade plan rates as described below:

Per Group

When the trade rates are set up as Per Group, it is only necessary to set up the rate and unit of measure that applies to the rate.

The following fields will be copied from the trade plan and cannot be changed on the rates.

• Trade Plan Description
• Rate Type
• Currency Code
• Packaging Type
• Packaging Code

1. In the Rate field, enter a rate which can be a positive or negative value.

The rate is valid from volume 0. Other Volumes are registered in the Volume Rate table. See Volume Trade Rates for more information.

2. In the Unit of Measure Code field, select the required Code from the drop-down menu.
   Select a unit of measure to which this rate applies. This is only necessary when the trade plan is set up with rate type Amount per Unit. When an item is set up with multiple units of measure, the rate will be retrieved where the unit of measure is the same as the price unit of measure. Suppose the sales price unit of measure is not applicable in a trade rate. In that case, the rate is picked with the unit of measure available for the item and will be recalculated to the price unit of measure.
3. In the Starting Date and Ending Date fields, select the respective dates.
   When a starting or ending date is selected in a trade plan, these dates are copied to the trade rates. You can change these dates between the dates selected on the trade plan. If no dates are selected in the trade plan, the dates can be selected in the rates but they are optional. On a sales and purchase order, the dates will be compared with the price reference setup (as specified on the customer card). For all other sales and purchase documents, the dates will be compared with the order date or workdate (if the order date is empty).
4. In the Location Code and Shipment Method Code fields, select the required value.
   The trade plans will be filtered and displayed on the Document Trade Costs (for header) or Document Trade Lines (for lines) page if the values entered in these fields match the location code and shipment method on the sales or purchase documents.

The trade plan rate is now set up for the groups linked to this trade plan. You can create multiple trade plan rates. When there are multiple trade plan rates available for one trade plan, the most specific trade plan rate according to a hierarchy as shown below, is chosen.

Specific

On the Details FastTab, in the Trade Rate Setup field, select Specific option from the drop-down menu.

When the trade rates are set up specifically for a customer, vendor, and/or item, it is necessary to set up for each rate which customer, vendor, and/or item the rate applies.

The following fields will be copied from the trade plan and cannot be changed on the Trade Plan Rates Page.

• Trade Plan Description
• Rate Type
• Currency Code
• Packaging Type
• Packaging Code
  

On the Trade Plan Rates page:

1. In the Source Type field, choose the required options from the drop-down menu.
2. In the Source No. field, choose the required code.
3. In the Source Address Code field, choose the required code.
4. In the Item Type field, choose an option from the drop-down menu. The available options include All Items, Item, and Item Category.
5. In the Item No. and Variant Code field, choose the required option.
6. In the Rate field, enter a rate which can be a positive or negative value. When the rate type is a Percentage of the Line amount, the rate must be between 0 and 100 because it is a percentage. The rate is valid from volume 0. Other Volumes are registered in the Volume Rate table. See chapter Volume Trade Rates for more information.
7. Select the Unit of Measure Code.
8. In the Unit of Measure Code, select a unit of measure to which this rate applies. This is only necessary when the trade plan is set up with rate type Amount per Unit. When an item is set up with multiple units of measure, the rate will be retrieved where the unit of measure is the same as the price unit of measure. Suppose the price unit of measure is not applicable in a trade rate. In that case, the rate is picked with the unit of measure available for the item and will be recalculated to the price unit of measure.
9. In the Starting Date and Ending Date fields, select the respective dates.
   When a starting or ending date is selected in a trade plan, these dates are copied to the trade rates. You can change these dates between the dates selected on the trade plan. If no dates are selected in the trade plan, the dates can be selected in the rates but they are optional. On a sales and purchase order, the dates will be compared with the price reference setup (as specified on the customer card). For all other sales and purchase documents, the dates will be compared with the order date or workdate (if the order date is empty).
10. In the Location Code and Shipment Method Code fields, select the required value.
    The trade plans will be filtered and displayed on the Document Trade Costs (for header) or Document Trade Lines (for lines) page if the values entered in these fields match the location code and shipment method on the sales or purchase documents.
    

The trade plan rate is now set up. You can create multiple trade plan rates.
When there are multiple trade plans, rates are available for one trade plan, and the most specific trade plan, rate according to a hierarchy as shown below, is chosen.

Specific (with Global Lot Attributes)

You can view the global lot attribute fields along the lines of the trade plan rates. The Trade Plan Rates page will display global lot attributes only if the following conditions are applied:

• The system should have the Aptean Advanced Attributes extension installed.
• The Applies-to field on the Trade Plan Card page has the Line option selected.
• The Trade Rate Setup field on the Trade Plan Card page has the Specific option selected.

On the Details FastTab, in the Trade Rate Setup field, select Specific option from the drop-down menu.

When the trade rates are set up specifically for a customer, vendor, and/or item, it is necessary to set up for each rate which customer, vendor, and/or item the rate applies.

The following fields will be copied from the trade plan and cannot be changed on the Trade Plan Rates Page.

• Trade Plan Description
• Rate Type
• Currency Code
  

On the Trade Plan Rates page:

1. In the Source Type field, choose the required options from the drop-down menu.
2. In the Source No. field, choose the required code.
3. In the Source Address Code field, choose the required code.
4. In the Item Type field, choose an option from the drop-down menu. The available options include All Items, Item, and Item Category.
5. In the Item No. and Variant Code field, choose the required option.
6. In the global lot attributes fields, select the required option.
   The global lot attributes defined in the Advanced Attribute Setup page are displayed as fields on the Trade Plan Rates page. It is only possible to edit the value of the global lot attribute fields if the Item Type field has a value as Item and the corresponding item number is specified for the line.
7. In the Rate field, enter a rate which can be a positive or negative value. When the rate type is a Percentage of the Line amount, the rate must be between 0 and 100 because it is a percentage. The rate is valid from volume 0. Other Volumes are registered in the Volume Rate table. See chapter Volume Trade Rates for more information.
8. Click on the cell Unit of Measure Code.
9. In the Unit of Measure Code, select a unit of measure to which this rate applies. This is only necessary when the trade plan is set up with rate type Amount per Unit. When an item is set up with multiple units of measure, the rate will be retrieved where the unit of measure is the same as the price unit of measure. Suppose the price unit of measure is not applicable in a trade rate. In that case, the rate is picked with the unit of measure available for the item and will be recalculated to the price unit of measure.
10. In the Starting Date and Ending Date fields, select the respective dates.
    When a starting or ending date is selected in a trade plan, these dates are copied to the trade rates. You can change these dates between the dates selected on the trade plan. If no dates are selected in the trade plan, the dates can be selected in the rates but they are optional. On a sales and purchase order, the dates will be compared with the price reference setup (as specified on the customer card). For all other sales and purchase documents, the dates will be compared with the order date or workdate (if the order date is empty).
11. In the Location Code and Shipment Method Code fields, select the required value.
    The trade plans will be filtered and displayed on the Document Trade Lines page if the values entered in these fields match the location code and shipment method on the sales or purchase documents.
    

The trade plan rate is now set up. You can create multiple trade plan rates.
When there are multiple trade plans, rates are available for one trade plan, and the most specific trade plan, rate according to a hierarchy as shown below, is chosen.

Trade plan with trade group sets on sales and purchase orders

When entering or selecting the required item number on the sales line of a sales order, the system will verify the status of the Enable Trade Group Set 2 and Enable Trade Group Set 3 toggles on the Trade Management Setup page. Depending on which toggle is enabled, the system will then check the corresponding trade group sets fields on the Purchase Order page.

The system examines the trade business group fields on the purchase header. If any of these fields contain a value, the system will look for the same value on the Trade Plan Groups page associated with the relevant trade plan.

This verification occurs for trade plans where the Trade Rate Setup field is set to Per Trade Business Group with Specific Item. The system will consider the trade plan that matches the value of the trade business groups.

The system checks the trade product group fields on the purchase header. If any of these fields contain a value, the system will look for the same value on the Trade Plan Groups page associated with the relevant trade plan.

This occurs for trade plans where the Trade Rate Setup field is set to Per Trade Product Group with Specific Source. The system will consider the trade plan that matches the value in the trade product groups. To know more, see Set up Trade Plan Groups for specific item/source.

After determining the relevant trade plan, the system checks the trade plan rates on the Trade Plan Rates page associated with the trade plan. To know more, see Set up Trade Plan Rates for specific item/source.

Based on the trade plan rate hierarchy, the system automatically identifies and applies the appropriate trade plan rate to the sales order to calculate the document trade lines. To know more about the trade plan hierarchy, see Trade plan rate hierarchy.

For details on how the system filters the relevant trade plan rate using global lot attributes, see Trade plan rate hierarchy with global lot attribute values.

The functionality works similarly to filter out the appropriate trade plan to be applied to the purchase order for calculating the document trade lines. Also, the system ensures that the correct trade plan is applied to the sales or purchase order, based on the configuration and values set in the trade business and product groups.

Trade Plan Translations

When a trade plan description is used on documents to foreign business partners, you can set up trade plan translations. These translated trade plan descriptions are automatically inserted into documents according to the language code.

1.On the Trade Plan list page, select Related > Translations.

1. In the Language Code field, select the required code from the drop-down menu.
   It is used when translating specific text on documents to foreign business partners.
2. In the Description field, specify the trade plan description.

The trade plan translation is now set up. You can set up multiple trade plan translations.

Volume Trade Rates

The rates are valid for a volume starting at zero. Rates for higher volumes can be set up as volume trade rates.

1. In the Trade Plans list page, select Rates > Volume Rates.

2. In the Minimum Value field, enter the required details.
   Depending on the volume type from the trade plan, this can include a number, weight or amount.
3. In the Rate field, enter a rate which can be a positive or negative value. When the Rate Type is Percentage of Line Amount, the rate must be between 0 and 100 because it is a percentage.When the Rate type is Percentage of Line amount, the rate must be between 0 and 100 because it is a percentage.

The volume trade rates are now set up. You can create multiple trade plan rates. When the minimum value is reached, the entered rate is used.