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.
Hi! I have searched multiple blogs and sites for this answer (along with the online help center) and can't find a clear document that states which characters are restricted in Imports/Exports per table. I've been told by Consultants that certain characters…
Hello community,
I am trying to add some description data to a customer facing crystal report and noticed I am only pulling the ID/ Code of the certain fields but need to show the full description of what that id/code is. Trying to add the descriptions…
What I am trying to do is write a query that will list all SEI processes and the Folders they are located in. I can't seem to find any table in the SEI database that contains the folder structure. Is what I'm trying to do possible? My organization is…
Hello,
Some customers want to restrict the access of the function "Bank transaction management". Indeed, in multi-company cases, they want to display only bank statement for the company that the user is responsible.
There is no way to setup this access…
Dear Fellows,
As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…
I am looking to a add new field at the product Level. The field should have the option to hold options the user can pick from.
Does anyone have steps on how I can do that.
What would be the safest way to mass update the pricing for all the product in the system. On the product site- Under the cost tab I want to update Standard cost for all the products.
When trying to create a delivery for a sales order I got the following error:
On the sales order, line item number one is has order quantity of 14784.
On the stock by site inquiry; The product shows on sales order 14784 and available stock at…
I'm trying to create a new query so that my user can have a list of new prep lists on their landing page. using table STOPRELIS, I was able to create a query but there is a line per product, when I only want the prep list, pick ticket, and so number.…
How can I have the lot number that appear on the delivery, also appear on the invoices. This will help the warehouse pick the product more accurately. Currently on the invoice screen, the LOT number columns shows up but the Lot Number information is not…
Good day all.
Is it possible to do a mass update of opening and closing periods using the mass processing or batch updates?
I know that it can be used to do mass updates of standard fields, but when it comes to running validation rules I am not exactly…
Is there any documentation outlining what needs to be backed up for Disaster Recovery? SQL backups are done, but what happens if the server is lost? What steps can one follow to recover a system having only the SQL backups?