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 the…

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

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…

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.

Best…

Hi

Sage V12 P28

I have a Bespoke Crystal report  (delivery note) that can print to a printer on my network, we also then print out a fedex label.

Added a new printer to the network, logged in as a standard user and get the attached.

However logging in…

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.

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

I made this report, all setup is good and link expression fine, put I didn't got any information from running this report, please help  

Hello,

I have integrated a patch of crystal report to my folder, the integration is completed successfully. However, when running the report, I go the error of missing parameters:

Job 3 - ERR 504 coming from the edition server : Error induced by the print…

Can some shed some light on how the table TMPBLA is populated to derive NA-TRLBAL?

Hi

I would like to seek advice on how to print a document direct to the local printer without downloading a document in SAGE X3

Regards

We will have the need to only allow 2 users access a few customized reports and nothing else.  No other functions but these crystal reports.

Is this possible?  I don't believe can use access code because then would require the access code to be on EVERY…

Hello,

I have a very peculiar problem that we have struggled with off and on since we upgraded to v12 in 2020.Some of our users report that SOME of the Crystal reports they print take a very long time to load. I have finally narrowed it down to functional…

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…

Hello,

I would like to know if it is possible to send a report (PDF) by email from sage X3 while allowing the user to personalize the email (subject, message, recipients...).

I made a script that automatically generates the invoice in pdf format to save…

Hello

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…

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…

Hello,

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 2.20.0.2. My goal is to use networked printers from central…

Hello,

I'm looking for the solution how to send a report directly to a network printer but i dont have an idea how to do that.

What i found so far, when im connected remotely to a server, where sage x3 configuration console is installed i can add…

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…

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

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

Even better if they can be separated Active vs Inactive.

Thanks!

Hello,

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…

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 ? 

Hello,

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…