Browse By Tags

  • Ops Inquiry IC Item Inquiry tab sorting options

    Hello, Is there a way to change how a tab displays information in Ops Inquiry IC Item Inquiry? For example, Cust.Hist.Det. tab, I would like to sort by date descending so I can see most recent sales first. Is it possible to add a customer name to the…
  • Historical Item Sales by customer - using SQL

    Good morning, I am using the below SQL statement to get a sales per item number from my Sales History tables ( OESHHD and OESHDT ) as well as item cost in my Sales Posting Journal tables ( OEAUDH and OEAUDD ). However, when I compare my sql output my…