Friday, June 28, 2013

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

    No comments:

    Post a Comment