Skip to main content
Solved

What is the replacement of ItemCustSalesHist?

  • July 25, 2025
  • 3 replies
  • 114 views
  • Translate All

Forum|alt.badge.img+6

       Hello,  we previously were using ItemCustSalesHist table to run some reports. This table is very useful. It has the sum up data with Item and Customers by each period. So we don’t have to count from the ARTran to reduce perfermance issue.
 

    I don’t understand why this table is obsolete in 2024R2 or even earlier version .Is there a replacement for it?   I Know there is a ItemSalesHist table, but we need to group or exclude some customers.  So I need some data form like customer ,item ,sales qty (already counted) , period, something like this.
    Can anyone help?

Best answer by Naveen Boga

Hi ​@ray20 I just checked the code that both ItemCustSalesHist and INItemCustSalesHist marked with [PXHideen] attribute hence it will not show in the GIs.

 

 

 

 

 

View original

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20

Hi ​@ray20 Have you checked with INItemCustSalesHist ?

Translate

Forum|alt.badge.img+6
  • Author
  • Captain II
  • July 25, 2025

​@Naveen Boga  Hello, expert, yes, as the DAC relations(SM401000) show, it should be INItemCustSalesHist .

But strangely, I can NOT search this table out in Generic inquiry.  Why?   is there any place to set the access?

 

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20

Hi ​@ray20 I just checked the code that both ItemCustSalesHist and INItemCustSalesHist marked with [PXHideen] attribute hence it will not show in the GIs.

 

 

 

 

 

Translate