Skip to main content
Question

INItemSalesHist vs. INItemCostHist

  • March 13, 2026
  • 3 replies
  • 26 views
J
Freshman I
Forum|alt.badge.img

Hi all,

I’m building a report to track beg inv and end inv. so far so good. Now, I’m looping in sales and margin data. 

I see that INItemCostHist and INItemSalesHist both have FinPtdSales and FinPtdCOGS. 

any difference between these two fields? the INItemCostHist matches our sales reports, but want to make sure.

thanks

Joseph

3 replies

rkenna
Captain II
Forum|alt.badge.img+3
  • rkenna
  • Captain II
  • March 13, 2026

Hi ​@JHuang, did you take a look at the DAC and the Source Data behind the DAC?

jhalling52
Jr Varsity I
Forum|alt.badge.img
  • jhalling52
  • Jr Varsity I
  • March 13, 2026

Hi ​@JHuang,

 

I think in theory, they should be the same, but there could be several factors that could cause discrepancies.  If there were IN Adjustments, Inventory History Rebuilt, difference in timing with releasing IN Documents, ect. 

To test, you can build a simple GI and join the two tables as shown:  

In the results grid, add a formula to show the records that are different for the Sales and COGS:

 

This will help you narrow down which records have differences.

Joe Halling, Strategies Group
    J
    Freshman I
    Forum|alt.badge.img
    • JHuang
    • Author
    • Freshman I
    • March 13, 2026

    Thanks all, I did check the DAC, but both fields only showed “Sales”. ​@jhalling52 I’ll try your idea as that’s a great trick I didn’t think of. 

    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