Browse By Tags

  • 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…
  • A/R customer history

    Currently I can only see a few months worth of customer sales history. I need to see more than this. How can I go in and adjust the settings to allow me to see more than just the last few months? I need to at least see all of 2016 and right now I can…