• 1099 report within Sage

    Is there is a 1099 report within Sage? That is, some sort of report that shows vendor payments for a certain date range
  • 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…
  • Purchase Metrics

    Trying to get a handle on purchase cost over time for our Raw Materials. I cannot find a report or dashboard for this type of information. What am I missing. How are others solving this issue? Noel
  • What is the BOMPRN Print code?

    Hi, I want to make two versions of the BOMPRN printouts available to users via Production BOMs. However I can't find the print code to do so. The original BOMPRN report isn't listed in Paramters>Destinations>Print Codes. Any ideas? Thanks
  • How to print multiple Report

    Hi, i need to print two report in just one click transaction. I have created two separately reports that take the same parameters. How can i to print one after another? As shown in the preview image I added a row in "Crystal Report" section in Dictionary…
  • Graphical Query Tables Linking

    How can I link the following tables together, I tired to link every possible key but keep running into an issue. Please advise.
  • Webservice to return file or blob

    Hi, I need create one webservice to return the result of one Crystal Report (PDF for example). So, I use function ETAT to generate the result of report (PDF format) to specific location,after that I need return this file to Web, any idea how I can…
  • 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…
  • RE: How to add an 'or' for criteria (SQL)

    Hi Israel, Sorry to bother you again, but I have yet another question. I'm trying to do as you've shown me for search criteria, but I seem to be running into a small issue. I have 2 fields that are joined. I have the following query: SELECT F.ITMREF_0…
  • Report Attachment in Email

    When we are attaching a report(PDF) in email, the attachment takes a name like 'jobrpt_ReportCode_UserCode_Number'. Is it possible to change the default naming style to change a name which could be meaningful. E.g. If Purchase Order, attachment should…
  • RE: Crystal Reports with SQL Commands

    Hi Ben: Could you please provide some more details on what do you mean by "SQL command" Standard reports in X3 have parameters in them that allow the report to connect properly when launched within Sage ERP X3. For example if you open Tabcountry…
  • 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…
  • Component Product Report

    Hi All, I've been using X3 for about 2 months now, so I know a little with a lot to learn. Currently I am trying to run a report/inquiry to determine how much RAW materials we are using. By running the PRODBINV report I get a high level report of…