• How can I add more intervals to Aged Balance Report (BALAGEGRP)

    Hello There, I need help in Sage x3 Aged Balance report (BALAGEGRP), which I need to add more intervals in it. The report already shows the following intervals: 0-30 Days 31-60 Days 61-90 Days +91 Days What I need to do is add 2 more intervals…
  • to be able to amend the default time zone for the credat and updatim

    We have an issue where when you run queries from within a landing page and go to the "Show Advanced Fields" to get the date and time the query refreshed, this is only correct for 6 months of the year in the UK. The other 6 months it shows an hour behind…
  • Transaction Log Files

    X3 generates a log file of every transaction in X3. This log can be found under Reports and Log Reading. The issue is that you cannot find the log number of a specific transaction from the actual transaction and the log list doesn't always give transaction…
  • Adding a Sage Enterprise Intelligence (SEI) worksheet to X3

    Did you know you can add an SEI worksheet to open from within X3? There are two ways to accommodate this functionality, either by embedding it into a landing/home page or adding it within the menu modules as a menu item. These two knowledge base articles…
  • Free Professional Invoices For Sage X3

    Tired of your current boring Invoice templates and wish you could spruce them up a little bit? Well, now you can. Download these crystal reports and make sure the last impression you leave is a lasting one. Download Now These set of templates have…
  • Crystal Reports with SQL Commands

    Hi all, I'm a Crystal Reports developer working for a company that uses X3 V6.5 patch 26 and I'm having troubles with a report that uses a SQL command. It doesn't seem that X3 sets the connection details properly on the command object when it runs the…