• SORDER.SHIDAT_0 & SDELIVERYD.SHIDAT_0 not matching

    Hi, This may not be an error as much as a question as the internal workings of Sage X3. I've been setting up reports for our Sales department, but they weren't lining up wtih our Actuals. I realized that I was utilizing SORDER.SHIDAT_0 instead of SDELIVERYD…
  • Sum a number of days in a Date

    Hello, I need sum a number of days in a Date in 4GL. Anywhere now a simple formule to make this? For exemple: Field: Actualy day -> 24/09/2018 Number: 10 I need the new date will be 04/10/2018 Thank you for your help.
  • Date Format v7/PU8 for Reports

    Changing the Locale setting's Regional Preferences from en-US to en-GB for example correctly displays the UK date format online - but reports still display the date in en-US format. Question: how to have UK user's reports print using the en-GB (d/m…