• Trying to create a report in SQL that pulls all costs for an item.

    I am trying to create a report that pulls all OE sales by month and includes standard cost, average cost, most recent cost, last cost, alt cost 1 and alt cost 2. I can't seem to find which table or view has all of these costs. It looks like they are…
  • oerpt.ini in Sage 2016 PU1

    Trying to change the form in Sage 2016 so that it uses a ODBC report instead of a datapipe report. The client is on Sage 2016 PU1. Changed the oerpt.ini file by commenting the sections on OEINV01 that points to datapipe, however when trying to run…
  • national account sales report

    How do you create a report to show the sales for a national account if the customer numbers are not contiguous?
  • Aged PO & PO Action Report

    Hello, I run Po aged report & PO action report, however there are some po not finished yet missing in the action report but includes in aged report. very weird! and my aged report includes tax while the action report not. could somebody indicate the possible…