Skip to main content
Solved

total cost on GI


Forum|alt.badge.img
  • Jr Varsity III
  • 65 replies

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, 

View original
Did this topic help you find an answer to your question?

13 replies

abrunner78
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 36 replies
  • May 2, 2023

@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.   


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 65 replies
  • May 2, 2023

hi @abrunner78 , thanks but we are using lots and looking to get the true cost per lot (PO receipt cost + landed cost). this shows on the inventory lot/serial history screen but looking to show in a GI instead.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2519 replies
  • June 20, 2023

Hi @mna10 were you able to find a solution? Thank you!


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 65 replies
  • June 20, 2023

Hi @Chris Hackett, unfortunately no. I wish there was an easy way to make a GI that shows this. I cannot figure it out.


  • Freshman I
  • 8 replies
  • June 29, 2023

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.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 65 replies
  • June 29, 2023

Hi @reneed, thanks for sharing. Are you able to attach your GI so I can look?


  • Freshman I
  • 8 replies
  • June 29, 2023

@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.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 65 replies
  • June 30, 2023

Hi @reneed Thanks! some of our items were done via receipts vs POreceipts being we were fixing valuation methods. These are the ones we are having an issue with for the landed costs.


  • Freshman I
  • 8 replies
  • June 30, 2023

@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
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2519 replies
  • July 13, 2023

Hi @reneed were you able to find a solution? Thank you!


  • Freshman I
  • 8 replies
  • July 14, 2023

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


Kevin CV
Freshman I
  • Freshman I
  • 7 replies
  • February 6, 2024

@reneed  - Have you been able to make any progress on this?  

 


  • Freshman II
  • 13 replies
  • Answer
  • August 27, 2024

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, 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings