Skip to main content
Question

How to get the acurate unit cost of a item based on the Lot/Serial through a GI?

  • June 25, 2025
  • 4 replies
  • 62 views
M
Jr Varsity II
Forum|alt.badge.img

Hi,

We have a requirement to see the exact unit cost of the items which has been recorded in the Sales Orders. These items are either lot or serial tracked. So we have used the “INLotSerialCostStatusByCostLayerType” table to get the correct unit cost based on the lot number. However, we have observed that for some lines, the unit cost column shows “0” even though the item has a unit cost. 

Is there any table we can use to get the exact unit cost for lot/serial tracked item?

 

Thanks!

Michelle

4 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • nhatnghetinh
  • Captain II
  • June 25, 2025

Hi ​@MWijesuriya43 

Try using the INTranSplit table (PX.Objects.IN.INTranSplit)

 

Best Regards,

NNT

I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
Chris Hackett
DipakNilkanth
Pro III
Forum|alt.badge.img+13

Hi ​@MWijesuriya43,
I believe you can use the INTran table to fetch the unit cost for Lot/Serial-tracked items.

Hope, it helps!

Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Chris Hackett
M
Jr Varsity II
Forum|alt.badge.img
  • MWijesuriya43
  • Author
  • Jr Varsity II
  • June 25, 2025

Hi ​@Nilkanth Dipak , ​@nhatnghetinh ,

Thanks.My requirement is to see the unit cost of the items which has been booked in theshipment (Confirmed shipment) status and the both Intran and Intransplit tables are updated only after the issue is completed. Hence, the required information will not be there.

Regards!

 

Chris Hackett
DipakNilkanth
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • September 23, 2025

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved