• Lack of data in Data Model and Views

    Hello, After verification, I found in a worksheet of Data Model and View, it lacks the data of one day from Sage X3. The specific is: In a purchasing worksheet in SEI, it only displays the data of February 1, 5, 13 and 27 from Sage X3. However,…
  • Conversion failed when converting date and/or time from character string.

    I'm building a report in Excel w/ SEI add-in where product lines are the columns, and days of the month (dates) are the rows to report on daily sales. Using the Invoices process as the basis for the data. When using the formula wizard, I get the above…
  • What does ZTABCHANGE do and should stored procedure ZREFCNVRATES run on a job?

    Recently I ran into an issue where the our newly created fiscal year was not showing up in the GL Transaction Detail with Year-End Simulation. After some digging it was determined that the GL Transaction Detail with Year-End Simulation process had the…