total cost on GI

@mna10 The Average Cost on Price/Cost tab of the Stock Item screen should have all of the calculations done and rolled into it.

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 @mna10 were you able to find a solution? Thank you!

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.

@mna10 Here you go. There are some extra tables, as I am still tweaking a few things. 😄 Please share any ideas you may have. We are moving to lot/serial number tracking soon, so any discoveries you make would be extremely helpful.

@mna10 Maybe you could try bringing in the INRegister table, since it contains the child DAC POReceipt. This way you could have the GI show both receipts and POreceipts. This might be effective for you, especially if the receipts contain the final item cost.

@Chris Hackett Unfortunately, I am still wrestling with this problem!