• Print Engine Error in Sage X3

    Job 2 - ERR 504 coming from the edition server : Error induced by the print engine Crystal .NET. YPO_QrTest.rpt - - Message 1/3 : Error running the report: c:\Sage\SafeX3\PRTSRV\Data\SEED_WIN-AHQG645R547_20100\ENG\Report\YPO_QrTest_CrDll_SEED.rpt - Message…
  • Change file name when printing list

    Hello, Is it possible to change the name of the file when printing using output type preview? I tried with AIMP3 entry point, with GPOINT PARAM but nothing works. JOBID didn't update the name ExportFile parameter neither thanks for you…
  • Work Order Costing with Sales Costing

    I'm trying to create a Crystal Report that will show the costing of work orders, but of course, they had to add in a twist. I need to be able to show the sales cost along with it. It would kind of be like the sales invoice line inquiry where it shows…
  • v12- where is the stock valuation report?

    i see a few questions regarding this report however in V12 I do not see the report to run. Can someone advise? I saw someone post an issue with STOCK12G report however do not have on V12 nor do I see in the SEED Sage folder. I'm looking for an inventory…
  • sales order form- suppress headers/ footers on crystal report

    Hi- I'm hoping someone can help me as in a pickle trying to resolve this issue. I have to add Terms and conditions to the sales order form but it is about 3 pages long. I'm having issues suppressing the header on the section where the terms are displayed…
  • Stock Valuation Report extraction

    I have being trying to extract a stock valuation report but it has being grouping the products based on category, is there a way i can extract it with grouping it by the product category ?
  • Multi-level BOM report with costs

    I need to produce a Multi-level BOM report with costing details and totals. The "Print BOMs" report under common data gives the correct BOM structure, but I'd like this with Material, Labour, Overhead costs - and totals... Does anyone know of such…
  • V12- Is there no trial balance or like report at all?

    I'm having issues with my customized trial balance report however would like to compare with a standard version. So question is: in V12 is there no trial balance report (including balances by dimensions?) I know the NA-TRLBAL has been depreciated but…
  • Printing image attachment from Products to the Job Ticket

    I'm very new to Sage X3. Does anyone know if it's possible to have an image that is attached to a product print on the Job Ticket report maybe as a subreport? I have tried everything I can think of in Crystal Reports but I'm not getting anywhere. Thanks…
  • SAGE X3 - USA Legislation

    Hi everyone, When we make a new installation with the USA Legislation in the Sage X3, which reports the system brings for us? For example: Is there a USA Sales Order report? Is there a USA Purchase Order report? Please is Urgent. I need your help…
  • detail of stock valuation appearing in trial balance

    Hi Experts, How to look for detail of stock value appearing in Sage X3 trial balance. I am looking for product wise stock qty and value information. thanks,
  • Error when printing crystal reports - fail to retrieve data from data base

    Dear all, I patch the customized crystal report from Source folder, then integrate it into another folder which is not on the same server with the source folder. We got the below issue when executing report printing - fail to retrieve data from data…
  • [v12p32] Need help on how to send a Report to email directly to user through Reports (AIMP) when email is set on Administration > Notification Server only.

    Hi, How to email a report without a SERMES entry? Tried to email to myself a report without a local SERMES entry. Report is: LISREL However, I receive nothing. Spam also no new email. Assume no local IIS6 SMTP Relay Server is available for…
  • connect ETIMEDOUT when printing report

    Reference: https://www.sagecity.com/za/sage-x3/f/general-discussion/155387/error-cannot-connect-to-server-xx-server-local-1807-error-connect-etimedout---error-code-500 If Print Server was already set in stone for a long time (ref link assumed connectivity…
  • ADC Production reporting

    ADC Production reporting when the produced quantity exceeds 100%, ADC PR does not backflush the additional material. The production tracking entry transaction controls this? Are there circumstances this setting would not work? We do have it set to consume…
  • Access to Demand Forecast Data

    I am trying to create a Crystal Report which compares actual quantity sold to forecasted quantity sold and calculates the Forecast accuracy by SKU and in total. Where can I find the Demand Forecast Data table in Sage X3 V11. Anthony
  • Credit Hold Report

    Is there a report which displays what orders are on credit hold? We have a need to know this before creating shipment and seeing that there is a hold. I haven't found one but not sure there even is one. Or is there an inquiry? Any help is appreciated…
  • bank details not correct on payment proposal report

    we've added banking details on the supplier and when print the payment proposal the bank info is not displaying what is entered on the supplier. It is displaying different details. I've checked the table and it incorrectly displayed in table as well.…
  • 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…
  • Record Locking Report

    Hi Guys, We have a requirement which I am hoping that someone might have seen before and have a solution. In essence, we need to be able to produce a report that shows which sales orders are locked by which user and which delivery route. Currently…
  • Work Order- what batches were consumed?

    Is there a report or query to find out what batches were consumed for a work order? I cannot seem to find an easy way to obtain this information. thanks Christine
  • Purchase payment

    Hello, Please should be informed that I have a script on a décisionnel tool which by it I can retrieve order receipt information my purpose is : is it possible to get invoice informations and the bank check details which are associated to the order…
  • Availability - Inventory aging report on sage x3

    Hi all, Could you kindly let know how to run a inventory aging report on sage X3 ? The option in which it can be accessed or kindly let know if its not available and a customised report has to be developed. Much appreciate and thanks in advance…
  • Stock internal documents and labeling print Reports [Released, Rejected]

    Hi, How can edit these reports for internal documents we are using this labels in quality control SageX3 v12 there are some screens for more information Please Help.
  • Report Results

    I run this report it shows just 100 record and I have more record how can I show more than 100 record, please help.