Skip to main content
Answer

What is the replacement of ItemCustSalesHist?

  • July 25, 2025
  • 3 replies
  • 53 views

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.

 

 

 

 

 

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • July 25, 2025

Hi ​@ray20 Have you checked with INItemCustSalesHist ?


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?

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • July 25, 2025

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