Set up 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:

   Field	Description
   No.	Specifies the number series defined on the Trade Management Setup page. If the Manual No. field is selected for the number series, then you can manually enter any number.
   Description	Specifies the description of the trade plan. A trade plan contains sales price increases, discounts or cost components that are applicable when selling/buying a specific item to/from a certain customer/vendor.
   Applies-to	Specifies if this trade plan should apply to a document header or to a document line. When Header is selected, the trade rates and costs apply to the complete sales/purchase order document and when Line is selected, the trade rates and costs apply to a line of the document.
   Price Rule	Specifies how rates linked to this trade plan affect the unit price or unit cost on document lines. This field applies when the Applies To field is set to Line. Blank: Does not impact the unit price or unit cost but adds to the accrual calculation. Unit Price: Increases the unit price on the sales order line. Discount: Impacts the line discount percentage without affecting the unit price or unit cost, adjusting the line amount. Unit Cost: Increases the unit cost on the purchase order line. For purchase documents, unit cost directly affects the Direct Unit Cost field, similar to how unit price works for sales documents. The Discount option influences the Line Discount % field. Trade plans in purchase documents also use the Calculation Base field to determine whether calculations are based on the base price (line amount before trade plans) or the current price (line amount after trade plans), following the same logic as sales documents.
   Accrual Type	Specifies the type of accrual. Depending on if the trade plan applies to a document header or to a document line, different options can be selected. Note that actual cost or actual revenue will be first posted as an expected cost/revenue and will later be reversed and replaced by the actual cost/revenue. This enables you to define whether the accruals calculated from the trade plans impact the unit price on the sales order line.
   Starting Date	Specifies the starting date from which this trade plan is applicable.
   Ending Date	Specifies the ending date until which this trade plan is applicable.
   Status	Specifies the status of the trade plan. Options include Draft, Active, and Inactive. The newly created trade plan is automatically assigned the Draft status, so that the trade plan can be edited. To activate it, set the Status field to Active. The trade plan rates cannot be edited or deleted when the trade plan is in Active status. Only trade plans with the status Active are used in sales and purchase documents. If the trade plan is no longer valid, set the Status field to Inactive.
   Trade Plan Type	Specifies the type of trade plan. The available options are: Blank Freight: The trade plan includes freight transactions. Ensure that the Applies-to field value is set to Header and the Accrual Type field value is set to Standard Cost, Actual Cost, or Item Charge. Periodic: The trade plan is to allocate periodic costs. These costs are time-dependent, for example, cooling and ripening. For more information, see Manage periodic costs. Production: The trade plan is to allocate production costs, for example, packing. For more information, see Manage production costs.
   Manual Freight	Specifies whether the trade plan will be marked as manual and assign the costs on the associated transport order documents manually. When the toggle is turned on, the system restricts the editing access to the fields on the Trade Plan Setup Freight FastTab.
   Expense Item No.	Specifies the non-inventory item number associated with the trade plan. You cannot select this checkbox when the Document Type field is set as Transfer Order.
   Non-Reversible	Turn on the toggle to exclude trade costs associated with the trade plan when creating return orders, ensuring that costs which should not be reversed, such as original transport, are excluded from reversal. The system applies this selection when using the Get Posted Document Lines to Reverse action or through the Aptean Claims extension. However, when the Cancel, Correct, or Create Corrective Credit Memo action is used, trade plans are copied from the original invoice. This toggle can be turned on only when the Price Rule field value is set to blank, ensuring that return orders are not affected by different prices or costs when compared to the original orders. If this toggle is turned off, the system copies the document trade line from the original transaction and sets the Document Trade Source field value set to Reversal, which implies that the financial posting of the cost will be reversed on the Document Trade Lines page to include the trade plan. For more information, see Manage the reversal of posted documents.
   Invalid	The system automatically turns on this toggle when a trade plan has an incorrect setup and requires modification. To update the trade plan, you must first set the Status field to Open and then to Active. The system displays errors that guide you to make the necessary changes to the trade plan. After the errors are resolved, the system turns off the toggle, allowing you to change the Status field to Active to use the trade plan.

   If the Applies-to field value is set to Header, the allowed Rate Types are Amount per Order or Percentage of Order Amount.

   When Use in Transfer toggle is turned on, the only allowed Rate Type is Amount per Order.

   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.

   When the Applies-to field value is set to Header, the allowed Accrual Type are Actual Cost, Item Charge, and Standard Cost.

   You must set the Applies-to field to Header and Price Rule field as blank to turn on the Manual Freight toggle.

   You cannot select Accrual Type as Item Charge and define the Expense Item No. field value. It will throw an error. In a single trade plan, you can only define item charge in the accrual type field or an expense item.

   When the Accrual Type is set to Actual Cost or Standard Cost, the Use in Sales Return and Use in Purchase Return toggles can be adjusted without constraints.

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

   Field	Description
   Currency Code	Select the required currency code from the drop-down menu for the currency to which the trade plan rates apply. If the field is left as blank, the trade rates are set in the local currency. 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.
   Calculation Base	Select the preferred option to which price the trade plan rate should be applied. This is applicable for the first trade plan line in the trade calculation and for trade plan lines in the calculation for which the Price Rule field is set as Percentage.
   Calculation Level	Select the order of calculation of the trade plan within a total trade rate calculation in a document in case multiple trade plans are applicable. It will define the order in which the trade plan lines are calculated.
   Trade Rate Setup	Choose if the rates in this trade plan must be set up per trade group, or per customer, vendor, and/or item individual.When the Trade Rate Setup field is set as Per Group, a combination of trade product groups and trade business groups must be linked to the trade plan. See [Trade Plan Groups](Trade-Plans.md#Trade Plan Groups) for more information about how to link the groups. When the Trade Rate Setup field is set as Specific, the customers, vendors, and/or items can be set in the trade rates themselves.
   Trade Plan Exclusions	specifies the number of trade plan exclusions set up for this trade plan, which are used to exclude the trade costs and prices for certain sales and purchase documents. Selecting the number opens the Trade Plan Exclusions page.
   Rate Type	Select the required rate type. The available options are: Amount per Unit: The specified rate(s) in this trade plan applies per unit. Amount per Net Weight: The specified rate(s) in this trade plan applies per net weight. Amount per Gross Weight: The specified rate(s) in this trade plan applies per Gross Weight. Percentage of Line Amount: The specified rate(s) applies as a percentage on the line amount. The line amount used depends on the setting of the Calculation Base field value. If the Calculation Base field value is set as Current Price, the percentage is calculated over the previous current line amount. If the Calculation Base field value is set as Base Price, the percentage is calculated over the base price for the calculation. And when the Calculation Base field value is set as Unit Cost, then the percentage is calculated over the unit cost of the document line. Amount per Shipping Container: The specified rate(s) in this trade plan applies per shipping container. This option is visible only when the Aptean Packaging extension is installed, the Applies-to field value is set to Line, and the Accrual Type field value is set to Actual Cost or Standard Cost. When the Trade Rate Setup field value is set to Specific and the Use in Sales and/or Use in Purchase toggles on the Trade Plan page are turned on, you can define trade plan rates for multiple shipping containers in the Packaging Code field value on the Trade Plan Rates page. For more information, see Set up trade plan rates for specific sources. Amount per Shipping Unit: The specified rate(s) in this trade plan applies per shipping unit. This option is visible only when the Aptean Packaging extension is installed, the Applies-to field value is set to Line, and the Accrual Type field value is set to Actual Cost or Standard Cost.
   Include Lines Discount	Turn on the toggle to factor in discounts from either the sales price list or manual setup while calculating the eligible base for the trade plan when the Rate Type field is set to Percentage of Line Amount. This ensures that the trade plan rates accurately consider any applied discounts with the actual values.
   Volume Trade Rate	Select the required option from the drop-down menu. When different rates are applicable when a minimum value is reached, you can set up volume rates. The volume type specifies the type for this volume rates. Units Line: the minimum value on the Volume Trade Rate is the number of units of the document line. Line Amount: the minimum value on the Volume Trade Rate is the amount of the document line. Net Weight Line: the minimum value on the Volume Trade Rate is the net weight of the document line. Gross Weight Line: the minimum value on the Volume Trade Rate is the gross weight of the document line. This field is visible only when Applies-to field is set to Line.
   Packaging Type	Specifies the required packaging type for which you want to set the rates. You can only select the packaging type that has the item bound.It is set to Shipping Container by default. This field is not editable.
   Packaging Code	Specifies the code assigned to the defined packaging type. It is possible to set up a single trade plan for each packaging code.

   You must set the Applies-to field to Header, the Accrual Type field must have a value, the Rate Type field value set to Amount per Order, and the Trade Plan Type field value set to Freight to access the Trade Plan Setup Freight FastTab.

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

   Field	Description
   Item Charge No.	Select the number of the item charge that the trade plan uses to allocate trade costs. This field is mandatory when the Accrual Type field value is defined. However, this field value is not editable when the G/L Account No. and/or Balance Account No. field values are defined.
   G/L Account No.	Select the general ledger (G/L) account where the trade costs is posted directly, instead of using item charges. This can be used when you want to post costs such as service fees or handling charges directly to a G/L account without affecting the inventory value of items traded. This field value is not editable when the Item Charge No. field value is defined and is editable only when the Accrual Type field value is set to Standard Cost.
   Balance Account No.	Select the G/L account where the balancing entries can be posted. This field value is not editable when the Item Charge No. field value is defined and is editable only when the Accrual Type field value is set to Standard Cost.
   Allocation Method	Select how to divide the cost over multiple lines when applicable. The available options are: Equally, Amount, Gross Weight, Volume, Floor Space, Unit of Measure, and Net Weight.
   Trade Partner Source	Specify whether Document Trade Lines are calculated using the trade partner from this trade plan, or if they are calculated using the trade partner(s) associated with the source document based on the trade partner allocations.
   Trade Partner No.	Select the trade partner that is linked to the accrual. For example, an external commissioner who is paid a commission or a customer who is paid a rebate at the end of the year. If the accrual type is Actual Cost, the trade partner must be a vendor; if the accrual type is Actual Revenue, it must be a customer.
   Trade Partner Group Code	Select which Trade Partners are applicable for a Trade Plan, based on its trade plan group filter and this applies when the Trade Partner Source field is set as Source Document.
   Use in Sales	Turn on this toggle to use this trade plan in a sales document (when manually selecting a trade plan).
   Use in Purchase	Turn on this toggle to use this trade plan in a purchase document (when manually selecting a trade plan). This field is editable only when the Freight Cost Calculation field on the Trade Management Setup page is set as Documents.
   Use in Transfer	Turn on this toggle to use this trade plan in a transfer document (when manually selecting a trade plan). This field is editable only when the Freight Cost Calculation field on the Trade Management Setup page is set as Documents.
   Use in Transport Order	Turn on this toggle to use this trade plan in a transport order document for freight cost calculation (when manually selecting a trade plan). This field is editable only when the Freight Cost Calculation field on the Trade Management Setup page is set as Transport Order.
   Use in Sales Return	Turn on this toggle to use this trade plan in a sales return document (when manually selecting a trade plan). This field is editable only when the Freight Cost Calculation field on the Trade Management Setup page is set as Documents
   Use in Purchase Return Order	Turn on this toggle to use this trade plan in a purchase return order document (when manually selecting a trade plan). This field is editable only when the Freight Cost Calculation field on the Trade Management Setup page is set as Documents

   • When Accrual Type field is set to Line, the Allocation Method field becomes non-editable. The Allocation Method field, in this case, is set to Equally by default. This field becomes editable based on the options selected in the Accrual Type field on the Trade Plan page.
   • When the Freight Cost Calculation field on the Trade Management Setup page is set to Both, you can edit either the Use in Transport Order toggle or the Use in Purchase, Use in Transfer, Use in Sales Return, and Use in Purchase Return Order toggles.

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

   Field	Description
   Shipping Agent	Specifies the code assigned to the agent responsible for handling the shipping of goods. This field identifies the company or individual managing the logistics and transportation of the shipment.
   Calculation Per	Specifies the basis on which calculations are performed, typically referring to the individual routes used for shipping. This allows for cost and rate calculations to be tailored to specific transport routes.
   Type Code	Specifies the code for the type of transport route used. This code is derived from the Transport Routes page and helps in categorizing and managing different shipping routes efficiently.
   Description	Specifies the description associated with the defined route code.
   Arrival Code	Specifies the freight region code where the shipment arrives. This code is linked to the customer, vendor, or location's freight region and is used to calculate freight costs for the document.
   Departure Code	Specifies the freight region code from which the shipment departs. This code is linked to the location, vendor, or customer’s freight region and is used to calculate freight costs for the document.
   Document Type	Select the type of document related to the trade plan. The available options are: Sales and Purchase: Indicates whether the trade plan is for a sales transaction or a purchase order. Transfer Order: Indicates whether the trade plan is configured for a transfer document. The freight setup of the trade plan applies to transfer documents. All: Indicates the trade plan is for each document type.
   Calculation Type	Specifies the calculation method to be used for the defined trade plan. The available options are: Floor Space: Indicates the calculation of the cost for each floor space code. Packaging: Freight costs are calculated based on the packaging unit of the items. This option requires the Aptean Packaging extension to be installed and provides two methods of packaging calculation on the Packaging Setup page: Manual: Freight costs for packaging are calculated when the document is posted. You can review whether freight costs for packaging have been applied once the document is posted. On Release: Freight costs are calculated when the document is released. You can view the assigned trade plans related to packaging immediately after release. Unit of Measure: Freight costs are calculated based on the unit of measure defined for the items (e.g., boxes, pallets). The system calculates freight costs by multiplying the total quantity of items by the assigned cost for each unit of measure. This method is flexible and adjusts to the size or number of units in the document. Note: If multiple freight calculation methods (e.g., Floor Space and Unit of Measure) apply to the same document, the system will use the method that results in the highest freight cost.
   Calculation Rate Type No.	Specifies the calculation rate type number, inherited from the Transport Floor Space Types page. This value is essential for defining the rate at which calculations are performed based on the floor space types.
   From	Specifies the decimal values displaying the starting range of the floor space. This field is used to input the minimum floor space value, allowing users to define the lower limit of the range for trade plans. It ensures that only plans within the specified floor space starting from this value are considered.
   To	Specifies the decimal values displaying the ending range of the floor space. This field is used to input the maximum floor space value, allowing users to set the upper limit of the range for trade plans. It ensures that only plans within the specified floor space up to this value are considered.
   Cost in LCY	Specifies the cost in local currency (LCY) associated with the defined floor space range.
   Lump Sum	Specifies if the freight setup is configured for a specific floor space or as a lump sum. When the checkbox is selected, the Calculation Rate Type No., From, or To fields can not be filled and the cost amount refers to the whole document.

   • Ensure all trade plan lines are unique when creating a new trade plan. If a trade plan setup freight line matches an existing line, the system indicates that trade plan setup freight lines must be unique.
   • If you enter a freight setup line with overlapping From and To field value ranges, the system displays an error informing you of the overlap. This ensures each trade plan line is distinct and not overlapping.
   • You cannot select a trade plan with Accrual Type field set as Item Charge when the Document Type field is set as Transfer Order.

   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.

The system restricts updating the trade plan after trade plan rate lines have been created. However, the system allows updating the followings fields when the Trade Plan Type field value is set to blank.

Field	Condition
Applies-to	Displays a confirmation message before updating the field value.
Accrual Type	Updates the field value without confirmation or notification.
Currency Code	Displays a notification to inform you of the change.
Trade Partner No.	Updates the field value without confirmation or notification.

These exceptions allow you to adjust the trade plan setup without deleting existing trade plan rate lines. The changes made to these fields do not affect documents that are already using the trade plan.