Costing Setup
This chapter describes al setup involved to make use of the SmartTrade Costing module. This requires setup like Export/Import Duties, Transport Route Prices, etc.
SmartTrade Setup
The SmartTrade Setup contains some important fields for using the Costing Module. Use the Tell me what you want to do function searching for SmartTrade Setup and click the related link.
On the SmartTrade Setup page scroll to the Costprice and Currency tab.
Journalize indirect cost If this is turned on, extra journal lines will be created upon receipt of the goods or posting of the invoice. The total amount of the indirect cost will be divided by all the expected cost lines for the lines in a purchase document.
Post Indirect Purchase Cost Here you can setup the moment you want the system to journalize the indirect cost. Options are On receipt of goods or On invoice of goods
Indirect Cost Posting Method This indicate whether actual costs are posted via Item Charges or G/L Accounts
Calculate Ind.Cost Percentage When turned on all Indirect Cost from the Cost Calculation will be calculated as an Indirect Cost % for that transaction. This can not be used when the Indirect Cost Posting Method is set to Item Charges.
Automatic Update Costprice With this turned on Item Costprices are automatically updated when new indirect costs are posted based on the Automatic Cost Adjustment setting within the Inventory setup
Post receipt for direct cost With setting turned on, the posting of the receipt will be done for the direct cost only, not for the total cost (direct+indirect cost)
Gen.Jnl Template/Batch Indirect Cost Defines the template and batch used for posting the indirect cost.
On the SmartTrade Setup page scroll to the Administration tab.
Sales cost reservation posting With this you can determine at which moment accruals are posted for sales transactions, at Shipment or Invoice.
Jnl template/batch sales reservation Defines the template and batch used for posting the indirect cost.
Use expected cost sales order Select this if you want to use the total expected cost of an item (variant) on the sales line. Standard Business Central always uses the actual cost, but if landed costs are not posted, this will not be very accurate.
On the Number Series tab you need to setup No. Series for Purchase / Sales Calculations.
Cost Types
The SmartTrade Costing module is based on so called Costing Types. Search for Cost Types via the Tell me what you want to do function or click related link on the SmartTrade Setup page.
For each type of indirect cost a Cost Type need to be setup. Following most important fields to enter.
For each Cost Type the Code and Description are mandatory. Code is the unique identifier and the Description is used in lots of pages to display the Cost Type of your choice.
Use description in G/L Entries with this you can indicate the Cost Type description needs to be copied to the G/L entries when posting indirect costs. If false the default Business Central way is used to post the description
Invoice G/L Account No. G/L account used for posting the actual costs of this cost type. Is used in combination with G/L Accounts as an option in the SmartTrade Setup Indirect Cost Posting Method field.
Item Charge No. Item Charge used for posting the actual costs of this cost type. Is used in combination with Item Charges as an option in the SmartTrade Setup Indirect Cost Posting Method field.
Purchase Cov. Account G/L account used for posting the Accruals for this cost type. Is used in combination with the SmartTrade Journalize Indirect cost setting
Types Each Cost Type can be setup as a specific type. This means calculation is done based on different setup done somewhere else in the system. Following types are available. Per type setup needed is described shortly
- Storage Cost: Based on Tariff structure setup per location code
- Inbound freight: Based on Transport Route Prices per Exit/Entry point combination
- Transport: Based on Shipping Cost/Charges per Shipping Agent
- Documents: tbd
- THC: tbd
- Insurance: tbd
- Test: tbd
- Intrest: Based on the Template line % and number of interest weeks for a calculation
- Import duty: The percentage field is calculated, using the tariff number of the item and the country of origin code.
- Export duty: The percentage field is calculated, using the tariff number of the item and the country of origin code.
- Outbound freight: Based on Price per pallet in the Tariff structure per location code and the number of pallet for a calculation
Calculation Base Amount With this field you can setup the value for the Base Amount field. This can be an automatic calculation or manual input. If automatic is selected, the system tries to follow a standard calculation based on setup done somewhere in the system. This is depending on the chosen type (Inbound Freight, Transport, Duty, etc.)
Calculation Amount This field is used to define the way the Amount field is calculated, using the Base Amount field (Base Amount * Percentage / Base Amount * Container %)
Container % Calculation Defines how the Container % is calculated. Based on Weight, Volume of Max. Content
Formula Amount/UoM this field is used to define the way the Amount per UoM field is calculated, using the Amount Field
Multiple Invoices Defines if multiple invoices can be expected for one Calculation line for this Cost Type
Calculate percentage Over Select the cost types that are used in a calculation to determine the base amount for the % setup for this Cost Type
Percentage inc. Costprice Indicates if the base amount for the calculation includes the direct cost for the line
In Currency Indicates if this cost type is always calculated in foreign currency
Purchase/Sales Cost Indicates if the cost is part of your cost price (purchase) or if these are additional cost without effect on the cost price
Sales cost reservation Indicates if accruals for sales cost most be posted and if this is done by using Journal lines of Purchase Orders
Cost Templates
Use the Tell me what you want to do function searching for SmartTrade Cost Template and click the corresponding link.
You can create multiple Cost Templates used in different situations. They can be selected manually or setup as default to use in certain combinations of Exit/Entry points within the SmartTrade Transport Method Setup.
On the Cost Template header you will enter a Code and description and define if the Calculation is Based on Container Quantity or Item Base Unit of Measure.
On line level you can select on or more of the predefined Cost Types. The default setting per Cost Type are copied but may be adjusted for this specific template only.
A default Base Amount value can only be set when the line is set to Manual in the Calculation Base Amount field.
A Default Percentage can only be used when the Calculation Amount field is set to Base Amount * Percentage
After all settings are done the Cost Template needs to be released. Only Released Cost Templates can be used in the process.
Tariff Structure
Search for Locations using the Tell me what you want to do function and select the relevant link to open the Location list. Select a Location code to setup a Tariff structure for and click Edit. On the Location Card click Tariff Cost on the ribbon.
On the SmartTrade Tariffstructures page press New and select the Location Code. The No. will be entered from the Number Series setup in the SmartTrade Setup table.
In the Pay-to Vendor field you may select the vendor the Invoices will be received from. With the Valid From- and Valid To Date you can select the period this Tariff Structure is valid.
Click the Lines option to enter the SmartTrade Tariff Lines page. On this page you can enter different types of Warehouse related costs which can be used in the Document Cost Calculations.
Following types can be selected:
- Stock
Additional Stock costs not being Storage like inbound costs for unloading containers, etc. - Storage
Storage cost per pallet per week. - Removal
- Approval
- Transport
Transport cost per Country per pallet used to calculate the total transport cost from Warehouse to customer.
For each type it is possible to setup an amount based on pallets, weight, Ton or just a Fixed amount. It also can add a Diesel Charge %.
Transport Route
Costs for transport can diver depending of the route the transport is taking. Routes are setup using Exit and Entry points. Exit points are harbors, airports and trainstations used as the place of departure for the transport. Entry points are the harbors, airports and trainstations used as place of arrival for the transport.
Exit Point
Exit points can be found by using the Tell me what you want to do (Ctrl + Q) function searching for Entry/Exit Points.
On the Entry/Ext point list you can create new Entry/Exit points.
You are only able to setup Route Transport Times and Rout Transport Prices for Entry/Exit Points with the Departure/Arrival field set to Departure or Both.
Transport Prices
Select an Entry/Exit Point with Departure/Arrival type Departure or Both and click on Route / Transport Price via the Action tab.
The ST Transport Route Prices page is filtered on the Exit Point you selected above.
Choose the Entry Point Code from the list and select the Transport Method, and Container Type. If applicable you can set the Starting- and Ending date for this line. The transport price can be entered in the Amount field and you may choose the Currency for this amount in the Currency Code.
If a foreign currency is set to this line, the Amount (LCY) is calculated based on current Exchange Rate.
It is also possible to setup prices per Shipping Agent is needed.
Transport Method Setup
To make use of default Cost Templates for certain Transport Routes and corresponding costs used the Tell me what you want to do function (Ctrl + Q) and search for Vendors.
Select a vendor and press Edit. On the Vendor card open the Transport Method Setup page via Actions > SmartTrade > Setup > Transport Setup.
Enter a specific situation by selecting Exit- and Entry Point and/or Transport Method Code and/or Shipment Method and/or Shipping Agent + Services). Select the Cost Template which should be used for that specific situation.
Quantity per Pallet/Container
Many costs are calculated based on the number of pallets or containers. To calculate this number you need to specify the number of units fit on different pallet- and container types used in the Calculation Process.
Search for Items using the Tell me what you want to do function (Ctrl + Q) and click the relevant link. Click Edit to enter the Item card and select Quantities per Pallet/Container via Actions > SmartTrade > Setup.
Per Unit of Measure and Pallet/Container type you can setup the Maximum Quantity used to calculate the number of pallets/containers during the process. You also may also use the Quantity per layer and Number of layers fields to calculate the Maximum Quantity field.
Item Charges
If you want to make use of Item Charges to post actual costs it is advised to setup an Item Charge per cost type. More information on setting up and use Item Charges by clicking the relevant link in the Links section on the bottom of this page.
Posting Setup
SmartTrade uses the default posting process with the G/L Accounts setup via the General Posting Setup. Below fields are important form posting the accruals.
- Purch. Account - For posting actual costs via Item Charges
- Overhead Applied Account - For posting/reversing purchase accruals
- Sales Overhead Applied Account - For posting/reversing sales accruals
All other G/L accounts used are setup on the Cost Types or Business Central default posting setups (General, Inventory, etc.).
More information on these default setups can be found in the Links section at the bottom of this page.
Note
©HB Software B.V.