The Title Landing Charges facility provides the ability to calculate and manipulate the estimated costs of purchased products.
Costing factors and formulae can be defined and maintained, by Title hierarchy, for normal Titles and for new Titles. A range of costing factors can be created, with the help of sequence fields, as well as the basis on which the costing factors are to be calculated. The costing factors are used in budgets, PSI (Spreadsheet Planning), PSM (Price Simulation Module) and purchasing. The costing formulas must be unique by shipping method, buying method and effective date.
Landed costs must be simulated and manipulated via the Landed Cost Breakdown Inquiry which is found on the Purchase Control Module.
Add landing charges definition
- In the menu, expand Base Modules > Distribution > Masterfiles >Database Management > Database Management > Item Masterfiles > Item masterfiles and double-click IM Landing Charges Definition. DSM245 Landing Charge Detail Definition panel appears.
- Enter a Key Level and click function Add.
| Field | Description |
| Port of embarkation |
In Landing Charge Definition this field contains a four character, user defined code used to identify from which location the goods are shipped. This field relates to functions such as purchasing and bill of landing. In Work with Purchasing Parameters select the city or country from where the goods will be shipped. |
| Ship method |
This code identifies how a shipment of goods is sent. Shipping Method codes have additional parameters. These are Extra copies of Invoice, Summary by Country of Origin on Invoice and Label/Cartons. |
| Warehouse | Identifies the warehouse into which the title is received. |
| Key level |
Title levels group or summarise product details into different levels for analysis purposes and to create definitions that relate to various groups of titles. It is a hierarchical structure. The title levels or title key levels are system defined, however, each level can hold an unlimited number of user defined codes to identify the various groupings within the level. |
| Class type |
Title classification type Titles can be categorized into several Classification Types. In Minimum Margin Maint, this field is optional depending on the selection made in the Title Level field. If for example the Title Key level is I7, then search for a list of valid Classification Types in TMSDS/IC-TYPES. Landing Charge Definition includes Classification Types |
| Actual key | The entry in this field depends on the selections made in Title Level code or Title Key level and Classification Type. Title Key Levels that require entry here are: IZ and I1. |
| Sequence number | In Landing Charge Maintenance a Sequence number allows for the creation of multiple landing charges. In Buying Price Maintenance the system defaults the sequence number by increasing the last sequence number by 10. |
| Charge type |
This field identifies a specific type of landing charge, for a title or group of titles. Other parameters on the above Control File are used to determine what to do with the Charge Types as they represent various landing charges that are part of a title’s total landed cost. For example the cost can be excluded or included for Bond Store costing, include in Financial Costs and displayed on reports in a nominated report column with a specific report heading. |
| Charge code |
This Landed Charge Rate/Value/Duty Code field identifies how the landing charges for a title or group of titles are calculated: C=Calculated, not allowed in definition. D=Defaulted value is from Title Masterfile Duty Field. F=Fixed Value, the value is entered and Charge Basis must be blank. P=Percentage, not used with Charge Basis K=Weight, V=Volume, W=Volumetric weight. T=Total is used with Memory field and not allowed in the definition. U=Unit value charge which is multiplied by volume (Charge Basis V, K, W). |
| Charge value |
The percentage rate or fixed value that is used by the landing charge calculation routine, in combination with the Charge Basis, to determine the landing charge for a title or group of titles. The Charge code determines whether this entry is a percentage rate (charge code of P) or a fixed amount (charge code of F). If defaulted to the duty rate on the Title Masterfile, this entry field must remain blank. |
| Charge basis |
Charge basis is the basis on which the landing charges for a title or group of titles are calculated. The Landing Charge Basis Control File stores system defined codes which represent for example, the buying price of the product, the weight and the total calculated landing charges so far plus the buying price etc. This value is retrieved during shipment receipt, together with the charge rate/value, to calculate the landing charge for this specific landing charge type. |
| Memory total |
The memory total field is used by calculation routines such as the Landing Cost calculation program. Once you have specified how an individual cost type should be calculated (the charge basis, and the rate/value), you are able to identify into which memory column the calculated amount is to be stored. There are 9 memory columns and each is identified by a number ranging from 1 to 5. The numbering of the memory columns enables you to store the calculated charge in more than one memory column. This is done for each cost type, so that calculated amounts for multiple cost types can be accumulated in a single memory column. A maximum of five memory columns can be nominated for one cost type. In order to create a charge total, the relevant memory column number is specified in the Memory Total field, and all charges that have been accumulated in this memory column are totaled into one amount. |
| Memory allocation | The calculated charge is stored in this Memory Allocation field and is used for Landing Charges calculation. |
- Select the Levels required for the summarisation of data into different levels and enter the appropriate General Ledger Account.
- Click OK to confirm.
