Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
I have a serious challenge in determining the best approach to this issue.
A group called T has 3 sub groups called I,S,H respectively and they are into 3 different types of business.(advertising,security and digital board sales).
Sub group I has…
Hello. I have the following formular expression in crystal report whilePrintingRecords; stringVar X3TEX ;= "TABMODELIV~SHOAXX~"+ {TABMODELIV.MDL_O}+"~~"; X3TranslatedText({?X3DOS}, {BPARTNER.LAN_0},X3TEX) Could someone help in interpreting it. Cant get…
I got a problem regarding the sales order report printing , it keeps on loading but it never print . I'm just asking why was this happen . It only happen with this particular SO number.
Some fields in our X3 db were renamed.
SEI process currently refers to old field names.
Is it possible to remap field references in process?
I was hoping to be able to update references in the relevant process files in CentralPoint. But this hasn…
I created another field in the table SINVOICE. Prior to this time i can browse all fields from the explorer, but with the new field added i can not browse that particular field. I do want to should i create a new connection to the database.
When we have created a Works Order, we need to print a set of reports. We have created the reports on the Entry Transactions and they list on the File>>Print Menu. We have to then print the set of reports one by one. I would like to find out how can I…
Does anyone have details notes on how to add a new crystal report to show up in SAGEX3. The report has been developed on crystal but I want it to show up as an option under printer in PO. It is a copy of BONCDE report with a little modification but I…
I have a report I built from scratch. Pretty simple, only 4 tables and one parameter to fill.
I added it to the directory, then thereport dictionary, then set up the default values and then the print code.
The report is visible after I hit "Record…
Hello Guys,
I am just a newbie here in this forum and hoping to get along with you all.
Moreover, I am about to support a newly implemented ERP system in-house through a post implementation phase and am just wondering what are the proper steps and…
How can I pull a report that will show the customer BP invoice. We have the sales invoice by lines report. But we want to connect information from the Customer BP Invoice.
We want all the information under this:
The inquiry does not output the…
We currently have customer that accept Back orders. On the sales order the user is able to input items that are on back order. However, if a product is on back order the invoice form drops that product.
The sales order:
This is the invoice: The…
I did the following to the YSBONFAC Report.
When I print the report, the report does not break. But it does not out put the lot number either. Any recommendation. The lot number is on the delivery.
I have a Crystal report that runs a script to generate a table which is then used to create the report. I have edited the script to alter the data in the report but the changes I made are not showing up in the report or in the table that the script builds…
When users print that Available stock screen using the PRTSCN report the dates don't line up with the columns they represent. Is there a way to modify the PRTSCN report? It's not listed in the Reports > Reports section. Not sure if the picture below will…
I have a recurring task set up to run a shipping availability report for our warehouse. The report parameters include a date which needs to be the current date plus 14 days. Is there a way to set the report parameters to accomplish this?
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…
Hi there,
I am reading the XML file by using RDSEQ, but the problem here is its not reading line by line, instead its reading no. line at time.
Please advise !