Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Enter Type of charge
    1. Charges are setup at Administration > configuration > Lookups > "ChargeType"
  2. enter Method of apportioning the charge
    1. By weight will look at the weight of each item and allocate by weight and is useful for shipping or air freight that is charged by weight
    2. By Dollar value uses the dollar value on the purchase order
    3. By volume uses the article volume
    4. Manual enables you to manually allocate the charges across all related lines
  3. Foreign currency and conversion rate if required
  4. Description - add a note to so you can remember what this charge was intended to cover

Image Added

View the Estimated charges by Purchase Order Line

...

New Average cost = (current average cost * current stock qty + qty from the PO * final cost ea) / (current stock qty + PO stock Qty)

Supplier direct to customer (Drop Ship Purchase orders)

Where the supplier is sending direct to a customer a Sales Order lines is marked as Supplier Direct to Customer and on Authorise this creates a PO to the supplier with final address at the customer.

Where the PO has a Complex Landed Cost - the value of the final landed costs in the Sales Order currency is shown for clarity on margin in the sales order currency

Image Added

Set the Estimate Ready to Use

...

Gliffy
nameLanded costing flow
pagePin2

Accounting Journals

Journals for receipt of Stock item with locked estimateDebitCreditEstimate of $20 costs
Stock on Hand - assets120
Increase in stock value
Trade Creditors Liabilities
100Amount paid to stock supplier
Landed cost clearing account - liabilities
20Total allocated other costs for these items based on the estimate
Totals120120




Stock Supplier InvoiceDrCrPayment to supplier for stock
Trade Creditors - Liabilities
100
Goods Received not Invoiced100

Total100100




CR Invoice Journal for a cost paid (customs) = must be linked to landed cost clearing accountDrCrPayment of $25 costs
Trade Creditors - Liabilities
25
Landed cost clearing account25

Totals2525




Once a journal line is linked to a landed cost account














Adjustment journal required once actuals are associatedDrCrAdjustment of stock from $20 estimate to $25 Actual
Landed Cost Expenses To Stock - Expense Account
25Expense account tracking landed costs in separate account
Landed cost clearing account - liabilities20
Clear the clearing account of the estimate value
Stock on Hand - Assets - Credit5
Update the stock on hand with the increase (Decrease) in value required
Totals2525

Result = Stock increases $5 (now $25 more than paid to stock supplier)

and Landed Cost Clearing account = 0

Landed cost expense account = Actual = $25





Adjustment Journal if Actuals are used prior to stock receiptDrCrWhen $25 actuals are known prior to receipt of stock
Stock on Hand - assets125
Increase in stock value
Trade Creditors Liabilities
100Amount to be paid to stock supplier
Landed cost expenses to stock - expense account
25Expense account tracking landed costs in separate account
Totals125125

Result = Stock increases $25 more than paid to stock supplier

Landed cost expense account = Actual = $25

GL Control Accounts for Landed Costing

...