Supply chain management SuiteApp
This tip will show you how to extend NetSuite’s Landed Cost feature and automate the calculation of landed cost estimates to apply to transactions.
Why estimate and track landed costs?
- Improve visibility and control of all costs associated with getting inventory to your warehouse.
- Track actual product costs and inventory value.
- Multiple cost categories can be used on one template.
- Make informed purchasing and pricing decisions.
- Automatically calculate landed costs.
- Allocate landed costs proportionately — different percentages based on weight etc.
Prerequisites for Estimated Landed Cost
- Install the Supply Chain Management SuiteApp
- Bundle Name: Supply Chain Management
- Bundle Id: 47193
- Enable the Landed Cost feature
- Set the Supply Chain Preferences
- Edit custom roles for those users who will be using the feature.
- Set up Cost Categories – used to classify different types of costs associated with your items.
How to use the Estimated Landed Cost Feature
- Create Landed Cost Templates – when a Landed Cost Template is applied to a transaction, landed costs are calculated based on the Cost Categories, allocation method and cost factor setup on the template.
- Name the template
- Enter a Description
- Select the Currency
- Select one or more Cost Categories
- For each Cost Category select the following:
- Select the appropriate allocation method (Weight, Quantity, Flat Amount, % Value)
- Enter the value of the Cost Factor
- Save the Cost Template
- Assign Landed Cost Templates to item records – After setting up landed cost templates, you can map items to the estimated landed cost templates. NOTE: ensure that the ‘Track Landed Cost’ box is checked on the item record.
- Create a transaction: Purchase Orders or Standalone Vendor Bills. Add items with a default Estimated Landed Cost template or select the Estimated Landed Cost to apply to the transaction.
- Item Receipt: The cost calculation on the Item Receipt record is based on the Landed Cost Template inherited from the PO.
Example: On the PO below a Landed Cost Template defaulted to the transaction from the Item Record:
Receive the PO
In the above example, the Inventory (Asset) account will be debited by ($77.33). This is the sum of the direct item costs plus the Estimated Landed Costs from the Purchase Order. The offsets are as follows:
- PO Value = $65.00 Offset: Inventory Received Not Billed
- Duty = $5.00 Offset: Duty Expense
- Freight = $7.00 Offset: Freight Expense
- Expense = $0.33
Total = $77.33
After receiving the actual charges for delivering your inventory, you can edit the Item Receipt to enter the actual Landed Costs. You can use only either estimated or actual landed cost. When both are set up in a line item, actual landed cost entries are overwritten when you save the record. If you want to switch from estimated to actual landed cost, verify that no landed cost template is selected for the line item.
- Compare the cost associated to an item against the budget allocated to that item
- Calculate the estimated cost of an item and edit the cost manually to project actual costs