Hi,
We are starting to use Landed costs. I would like to make a GI that will show all inventory availability and the total cost (purchase receipt and landed cost (if there is a landed cost for the purchase receipt).
Similar to how the inventory lot/serial history works. it will show receipt cost, then if you check the box it will so the cost with landed cost included. I would like that cost with landed cost included.
Does anyone know the best way to get that total cost?
Best answer by livl
Hi!
I have a GI here that does calculate based on the purchase receipts. We use the acu-container add on that splits up the the tariffs and customs duty for us. we also use “COST” as an allocation variable for all of our landed cost codes so its relatively simple math to figure out the proportion of landed costs to apply to each item. the ONLY issue is finding the final landed cost since the way my tables are joined. I have to “SUM” all of the landed cost amounts. however i am using “min” to find the unit costs and the tariff amounts. since i cant sum and min at the same time,
If you are looking for something historical reference, i.e., what was the landed cost for an item for a specific purchase receipt, I don’t have anything and would love the same thing for our company.
The problem I run into when to use the landed cost amount vs the billed amount and the creating a system that “knows” how landed cost valuation method. Then, there is still the challenge of linking everything together.
hi
Hi
Hi
As someone working on a similar GI, I recommend starting with the following tables:
POLandedCostReceiptLine - this has the allocated LC amount
POReceiptLine - to bring the PO receipt details, like inventoryID etc.
InventoryItem - to bring any inventory ID details that aren’t available in the POReceiptLine table.
CurrencyInfo - to link the exchange rate of applicable transactions if you are purchasing in different currencies from your base currency.
I used formulas to calculate the unit cost column and grouped by POReceiptLine.InventoryID & POReceipt.ReceiptNbr so that the landed cost column would show a total of all LC allocated per InventoryID & PO Receipt. Other tables that you may find useful are INItemCost & POReceiptLandedCostDetail.
I hope this is helpful to you.
Hi
Hi
Hi!
I have a GI here that does calculate based on the purchase receipts. We use the acu-container add on that splits up the the tariffs and customs duty for us. we also use “COST” as an allocation variable for all of our landed cost codes so its relatively simple math to figure out the proportion of landed costs to apply to each item. the ONLY issue is finding the final landed cost since the way my tables are joined. I have to “SUM” all of the landed cost amounts. however i am using “min” to find the unit costs and the tariff amounts. since i cant sum and min at the same time,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
