Dynamics GP - How to use the Landed Cost Module in Trinidad

• Landed Cost Process
• Setup Cards>Inventory>Landed Costs
• Setup Card>Inventory>Landed Cost Groups
• Setup Default Landed Cost Groups for each Item (and for each location if applicable)
• Cards>Inventory>Quantities/Sites>Select a site
• Enter Landed Cost in field at the bottom of the page
• When the item is used on a PO, it will use the default landed cost group
• You can modify this on the PO Line Detail if necessary
• When the PO is received, Item-Specific Landed Costs are visible in the Unit Cost blue arrow
• The Landed Cost Functional Total blue arrow shows a summary of all landed costs
• Overall transaction landed costs can be additionally added using the Landed Cost button at the bottom of the screen
• Post Receipt as Shipment/Invoice, or as Shipment only
• To generate the invoice to the landed cost vendor
• Go to Enter/Match Invoices
• Enter Landed Cost Vendor
• Tick the LC box on the line to indicate this is a Landed Cost Invoice Line
• Use the Item Lookup to select an outstanding Landed Cost to be paid to this vendor
• Enter the Landed Cost amount to be invoiced
• Click on the blue arrow next to "Matched to Shipment" to match the values to the total amount to be invoiced
• Any variances here will revalue the cost of received inventory if the revalue inventory box is ticked
• Post the Landed Cost Invoice
• 
  
• Trinidad Duty Calculations
• Import Duty - % of Item Cost
• Insurance - 8% of (Item Cost + Import Duty)
• Freight Charge - based on weight
• Fuel Surcharge - based on weight
• VAT - 15% of (Item Cost + Import Duty + Freight Charge)
• 
  
• The landed costs do not calculate properly for Trinidad & Tobago because we have compound charges that GP cannot automatically calculate (Vat on Duty) 
• Method 1 - Total Shipment Value Apportion
• To handle this properly in GP, all charges have to be manually calculated on a spreadsheet first for the entire shipment, then applied to the entire shipment as afixed amount, apportioned by Value
• Setup each item with it's own Import Duty Landed Cost as a % of value - This gives you the correct duty per line item
• The total Insurance, Freight, Fuel and VAT are added using the Landed cost button, and are applied over the entire shipment as a fixed amount, apportioned by Value
• Print and Attach your excel costing sheet to the receipt printout to keep a detailed record of how the costs were calculated
• This method is relatively quick, but higher value goods will always attract higher costs due to the apportionment method
• This method may or may not make sense depending on the weight and value of the goods you are importing

Method 2 - Manual Line Item Values

• To handle this properly in GP, all charges have to be manually calculated on a spreadsheet first for the entire shipment. A Factor is calculated for each line item, which is then used to distribute the other costs to that line item.
• Setup each item with it's own Import Duty Landed Cost as a % of value - This gives you the correct duty per line item
• Your excel sheet will calculate the Insurance, Freight, Fuel and VAT for each line item separately
• Enter each one of these as a fixed value cost on each line item using the blue cost arrow in the line item detail
• Print and Attach your excel costing sheet to the receipt printout to keep a detailed record of how the costs were calculated
• This method is much more time consuming, but will capture accurate apportionment of landed costs