ManualDoc:T1C05058D61AC4B69A7E550F32F9F2873
Some fields to note are:
- Landed Cost Type: that is the landed cost type that is going to be allocated to the receipt(s) or receipt line(s) selected in Receipt tab.
- Invoice line: that is to select the corresponding landed cost invoice line if already booked that matches the landed cost type being entered.
If an invoice line is selected invoice line amount gets populated in the next field "Amount". - Amount: that is the landed cost type amount. This amount can be "estimated" or "actual" in case of selecting an invoice line.
- Currency: that is the currency of the landed cost type.
- It is important to remark that a landed cost document can include as many landed cost types as required in the currency required.
For instance, a landed cost document can include two landed cost type lines one in USD and the other one in EUR.
In this scenario a landed cost adjustment will be created including two lines, cost adjustment amounts will be calculated in the currency configured for the legal entity product transaction belongs to.
- It is important to remark that a landed cost document can include as many landed cost types as required in the currency required.
- Landed Cost Distribution Algorithm: there is one algorithm available distributed by Openbravo that is "Distribution by Amount".
This algorithm distributes landed cost type amount proportionally by receipt line(s) amount among the receipt(s) selected.
Once a receipt(s) have been selected in Receipt tab, landed cost document (header) can be processed by using the process button "Process".
This action creates a landed cost adjustment linked to the landed cost document.
This cost adjustment has as many adjustment lines as products included in the goods receipt(s) selected, therefore the cost of those products is adjusted as applicable.
Once processed a landed cost document can be:
- "Reactivated", this actions voids the landed cost adjustment linked to the landed cost document.
- or "Post", therefore products asset accounting is also adjusted accordingly.
Landed Cost posting creates the following accounting entries in case of a "Product" landed cost type:
Account | Debit | Credit |
Product Asset | "Estimated" Landed Cost Amount. (*)This ledger entry gets goods receipt "accounting dimensions" such as "Vendor" or "Product". See "Detail" link. | |
Product Expense | "Estimated" Landed Cost Amount |
Landed Cost posting creates the following accounting entries in case of an "Account" landed cost type:
Account | Debit | Credit |
Product Asset | "Estimated" Landed Cost Amount. (*)This ledger entry gets goods receipt "accounting dimensions" such as "Vendor" or "Product". See "Detail" link. | |
G/L Item | "Estimated" Landed Cost Amount |
Process Matching
Matching between an "estimated" landed cost and an "invoiced" landed cost can be processed in:
1. the GOODS RECEIPT window before processing and by using the process button "Complete"
This scenario takes place whenever all landed cost related information below is available and entered in the Landed Cost tab of the Goods Receipt :
- landed cost types
- landed cost amounts
- related landed cost invoice lines
- This scenario automatically creates:
- a landed cost document in the landed cost window related to the goods receipt that contains all the information entered in the "Landed Cost" tab of the Goods Receipt.
This landed cost document is already processed and matched, therefore only actions missing are to post the landed cost document (header) and to post the landed cost matching. - a landed cost adjustment that adjust the cost of each product included in the Goods Receipt.
2. the Landed Cost PURCHASE INVOICE window, by using the process button Match LC Cost which can be found in each landed cost purchase invoice line. After that "Process Matching" check-box is selected.
This scenario takes place whenever:
- all landed cost related data but landed cost invoice line information was entered in the Landed Cost tab of Goods Receipt window.
- all landed cost related data but landed cost invoice line information was entered in the Cost tab of Landed Cost window.
- This scenario automatically creates:
- a new landed cost adjustment that adjust once more the cost of each product included in the Goods Receipt if:
- the landed cost type amount booked is not the same as the one invoiced
- and the check-box "Is matching adjusted" is selected.
- only action missing is to post the landed cost matching.
3. the LANDED COST window, by using the process button "Process Matching"
This scenario takes place whenever the matching has been executed in the landed cost purchase invoice, see scenario 2 above, but the check-box "Process Matching" was not selected there.
- This scenario automatically creates:
- a new landed cost adjustment that adjust once more the cost of each product included in the Goods Receipt if the landed cost type amount booked is not the same as the one invoiced and the check-box "Is matching adjusted" is selected.
- only action missing is to post the landed cost matching.
4. the LANDED COST window, by using the process button "Process".
This scenario takes place whenever all landed cost related information is entered in the landed cost window.:
- landed cost types
- landed cost amounts
- related landed cost invoice lines
- and goods receipt(s)
- This scenario automatically creates:
- a landed cost adjustment that adjust the cost of each product included in the Goods Receipt(s).
- only actions missing are to post the landed cost document (header) and to post the landed cost matching.
Post Matching
A landed cost matching can be posted, after being processed. This posting will have different ledger entries depending on the scenarios listed below:
1. "estimated" landed cost equal to "invoiced" landed cost
- In the case of a "product" landed cost type
Account | Debit | Credit |
Product Expense | "Estimated"="Invoiced" Landed Cost Amount | |
Product Expense | "Estimated"="Invoiced" Landed Cost Amount (*)This ledger entry gets landed cost invoice "accounting dimensions" such as "Business Partner". See "Detail" link. |
- In the case of an "account" landed cost type
Account | Debit | Credit |
G/L Item | "Estimated"="Invoiced" Landed Cost Amount | |
G/L Item | "Estimated"="Invoiced" Landed Cost Amount (*)This ledger entry gets landed cost invoice "accounting dimensions" such as "Business Partner". See "Detail" link. |
The purpose of above ledger entries is to get that landed cost expense accounting gets invoice landed cost "accounting dimensions".
2. "estimated" landed cost not equal to "invoiced" landed cost & "Is matching adjusted" = No.
This last setup ("Is matching adjusted" = No) leads to NOT creating a landed cost adjustment which takes the difference to the product cost (product accounting), therefore that difference remains either in the credit side (estimated>invoiced) or in the debit side (estimated<invoiced) of the product expense account.
- In the case of a "product" landed cost type
Account | Debit | Credit |
Product Expense | "Invoiced" Landed Cost Amount | |
Product Expense | "Invoiced" Landed Cost Amount (*)This ledger entry gets landed cost invoice "accounting dimensions" such as "Business Partner". See "Detail" link. |
- In the case of an "account" landed cost type
Account | Debit | Credit |
G/L Item | "Invoiced" Landed Cost Amount | |
G/L Item | "Invoiced" Landed Cost Amount (*)This ledger entry gets landed cost invoice "accounting dimensions" such as "Business Partner". See "Detail" link. |
3. "estimated" landed cost higher than "invoiced" landed cost. "Is matching adjusted" = Yes
This last setup ("Is matching adjusted" = Yes) leads to creating a landed cost adjustment which takes the difference to the product cost (credit side of product accounting).
- In the case of a "product" landed cost type
Account | Debit | Credit |
Product Expense | "Estimated" Landed Cost Amount | |
Product Expense | "Invoiced" Landed Cost Amount (*)This ledger entry gets landed cost invoice "accounting dimensions" such as "Business Partner". See "Detail" link. | |
Product Asset | Difference (estimated>invoiced) Landed Cost Amount |
- In the case of an "account" landed cost type
Account | Debit | Credit |
G/L Item | "Estimated" Landed Cost Amount | |
G/L Item | "Invoiced" Landed Cost Amount (*)This ledger entry gets landed cost invoice "accounting dimensions" such as "Business Partner". See "Detail" link. | |
Product Asset | Difference (estimated>invoiced) Landed Cost Amount |
4. "estimated" landed cost smaller than "invoiced" landed cost. "Is matching adjusted" = Yes
This last setup ("Is matching adjusted" = Yes) leads to creating a landed cost adjustment which takes the difference to the product cost (debit side of product accounting).
- In the case of a "product" landed cost type
Account | Debit | Credit |
Product Asset | Difference (estimated<invoiced) Landed Cost Amount | |
Product Expense | Difference (estimated<invoiced) Landed Cost Amount | |
Product Expense | "Invoiced" Landed Cost Amount (*)This ledger entry gets landed cost invoice "accounting dimensions" such as "Business Partner". See "Detail" link. |
- In the case of an "account" landed cost type
Account | Debit | Credit |
Product Asset | Difference (estimated<invoiced) Landed Cost Amount | |
G/L Item | Difference (estimated<invoiced) Landed Cost Amount | |
G/L Item | "Invoiced" Landed Cost Amount (*)This ledger entry gets landed cost invoice "accounting dimensions" such as "Business Partner". See "Detail" link. |
Cancel Matching
A landed cost matched can be cancel by using header process button "Cancel Matching". Before that landed cost matching needs to be "Unpost".
Cancel matching action implies that:
- Current matched amounts are not removed from Matched Amount tab.
- A new matching needs to be executed in the corresponding landed cost purchase invoice(s)
- Correct matching amounts will then be updated in Matched Amount tab.