• How can i get dimension on financials with FDE?

    On the print selection grid in FDE there is a selection to include dimensions in the financials.    I have tried it on two system and it does not appear to cause the dimension values to print.

    I found an article in the kbase that says "Can Dimensions…

  • Rename report previews


    I would like a report to have a specific name when it is previewed by a user. Is this possible?
    Currently the PDF has the name as  the report.

    I know it's possible to save the file in a folder with a specific name thanks to script, but I want to…

  • stock valuation report with version management

    We are having issues with the stock valuation report for a client on V12.

    The client uses version management.

    Everything else works and respect the versions but it looks like the standard stock valuation report does not respect the actual version of the…

  • Print Server service not starting when configured on gMSA account


    I have taken over infrastructure with misconfigured - but running - Sage x3 v12 installation. I am trrying to run PrintServer on the same machine Sage app is installed. Service app version is My goal is to use networked printers from central…

  • Negative stock balance and amount in Stock Valuation Report

    Hello Guys,

    I have a question regarding the processing of the Stock Valuation Report.

    When I take a Warehouse-wise Stock Report upon entering a back date on the Stock Valuation Report, the Quantity and Amount is displayed as a Negative Value. But in reality…

  • Statistical Groups

    What are the key differenced analytics wise between Statistical Groups and Dimensions?  What kind of reporting can you do using one vs. the other?  

  • Supplier Lists - Active vs Inactive

    How would I get a list (preferably exported to Excel) of BP Suppliers?

    Even better if they can be separated Active vs Inactive.


  • Rename batch task output


    I'm using X3 V12 and I'm trying to create a batch recurring task in order to print every night all the invoices of the day.

    However, right now the task only creates a pdf file with the same name as the report.

    How can I dynamically change…

  • What date in X3 will tell me when a shipment was validated?

    I assumed that the STOJOU table will be the best place to look, and I'm currently looking at the CREMVTDAT field, but I just wanted to see if that is correct, or should I be using something else ? 

  • Automatically print a report in a network directory


    I would like to be able to automatically generate invoice in PDF format in a specific directory right after validating it.

    I was thinking of using "Call ETAT(ZINVOICE,PDF) From AIMP3" and EXEBOUT in my invoice script (SPESIH)

    Where ZINVOICE…

  • ZPL List "cuting" my file


    I need help, i'm creating a PAT file using openo and wrseq with some ZPL code, that file is then called by a Report wich has been created using a ZPL list.

    The PAT file is created without any problem, but when i call the report the .DATA is generated…

  • How do I print a list of the invoices paid by a specific check?

    I just want a way to reprint the remittance. I can't find a report or screen to show me all the invoice numbers on a check, just a listing of the PINs that I can drill back to. Any suggestions?

  • Reports printing with smaller font in PDF


    When i try to print a report via PDF, the font is smaller than if i do it directly to a printer.

    I don't know why this happens, the report is the same for the 2 options. Shouldn't the final document be the same for the 2 options?


  • AP / AR Aging Report Shows Fully Applied Invoices


    When i run the aged trial balance it shows fully applied invoices and payments. It is matched already and customer wants to see only outstanding documents. Are there any way to remove all applied documents from aging reports.


  • Purchase Order Report

    Good morning All, 

    I was asked to take a look in the system and determine if there was a purchase order report that would only show those that have had a revision.  I didn't see anything in the queries that would allow me to start with 'all' purchase orders…

  • Unpriced Purchase Orders

    Hello All, 

    I am wondering if/how I would go about printing an unpriced purchased order?  I have seen it in many of the other ERP systems (generally as a radio button or checkbox) I have used in the past but have not found the option in X3.


  • Sage X3 V12P26 Print Server error when printing reports created from Crystal Reports for Enterprise when testing for future QR code purpose

    Hi all,

    I have a client purchased a Crystal Server 2020 license due to its support of QR code generation over the normal Crystal Reports 2020 which required third-party additions which the client is uncomfortable about purchasing additional third-party…

  • Purchasing Invoice Elements Description

    I have run into an interesting issue.  When I change the description on a Purchasing Invoice Element it does not change on the Purchase Order, the old description changes.  If I add a new element the description is blank.  I have looked into the record …

  • Record Print options greyed out

    After posting payment, the record print option is greyed out only the list button is active. I need help.

  • Phone formatting in Crystal Reports

    Does anyone have a suggestion on how to format the phone numbers based on the country's phone number format?

    Since the table doesn't show the formatted entry (which really makes no sense), I need to create a formula in Crystal, but isn't there an…

  • How to remove line number from the graphical report created using SQL query

    Dear Sagians,

    I have graphical report created using view and sql  query, but the problem here after adding this into dashboard is instead of date, line number is coming[Below screenshot] Any ideas to display the date here.

    Note: When running the report…

  • Reporting

    Good morning, 

    Without going into customized reports (I'm guessing that's where I need to be), does anyone know if there is a standard open purchase order report that would also show the consumed requisition and/or who submitted said REQ?


  • Blank report

    Someone long time ago showed me the way to check the rpt results and why is failing, it was on one of the X3 folders, anybody knows???

  • Trial Balance

    We are on V11- is there an out of the box trial balance report that can be run by date?   We have a customized one that was taken from a V3 version.  While I'm asking is there a TB report that can provide a comparison of month range?   Would like to know…

  • Sales Invoice report stuck when printing for some users


    Since this past Friday Dec 17 2021 we have started to experience a weird behaviour where for some users the SBONFACP Report generated via printing on (Sales >> Sales Invoice) does not print out to PDF, it remains showing the progress bar moving and…