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 would like to add additional costing components to existing product BOMs in Sage X3 (v11). When using the import template BOMPD, it requires a field for the BOM component sequence (BOMSEQ), however, each BOM has a different number of existing components…
Does anyone know how to setup the Budget Calculation function correctly. I'd like to create a new year budget (by period or annualized) from the prior year actual ledger account/dimension balances. The function appears to be straight forward, however…
Hello, I am trying to put a "location" field in the query for stock movements by items so that it can filter the movements it shows. I have modified the screen and added the field
then in criteria I created a formula to get the ones that matched…
Hi
Sage X3 V 12 pu 24 Patch.
We have recently had a SQL corruption that was repaired on the client. Long story short restoring to a valid backup was not an option.
Not ideal and measures have been taken to avoid this in the future.
The SQL is…
What is the best way to convert history from a legacy system to X3. Import templates are excellent for AP, AR, GL, SO, PO, etc. However, these are open balances. What is required to import several years of transactional history?
Gosh, this is a good…
I want to delete product-site records that they do not have transactions in that site.
when I use transaction mass update, it dose not check it has transaction or not and delete it directly and it is wrong because I want to delete the same record from…
We get the following error when selecting stock change transactions from the left list (not attempting to make any changes to the selected transaction) and when entering the stock change screen. Has anyone else encountered this error or have any idea…
Hello All, Can someone explain the reason for these two fields listed in the subject in "Products" screen. I've read the basic break down's from "F1" help, but we are looking for more real world examples and purposes of these two fields. Could either…
I'm trying to add the total deposit on the left list on the Manual Remittance Screen. This value is a summation from the PAYMENTH table on the field AMTCUR and is present on the screen as "Company Total." I'm struggling with how to go about this because…
Hi,
I have SAGEX3 release/12.17.0 build 33 and i'm trying to run the following graphql query:
{
xtremX3Manufacturing {
workOrderProductionReporting{
query{
edges{
node{
workOrderProductionReportingLines{
query{
edges{
node{
lot
}
}
}…
Good morning,
I'd like to filter a query for a landing page on my X3 v11. I see on X3 online help that you can add a "where" parameter to a menu item and add sdata conditions, but the help says:
Only simple conditions using "le", "ge", "eq", "lt"…
Good morning fellows!
Today I am looking for a way to extend product info on function "Price list entry". A customer wishes to be able to see field information "Description 2" in addition to the already displayed field "Description 1" within the grid…
Sage X3 is currently not looking at expiration dates for us in MRP, it will allocate items that are expired to the order. Is there a way to set up the system so that it will not use expired ingredients in the MRP? Also, looking for insight on how to place…
Hi all,
I want to limit the possibility of changing the bank account number on the BP and the payment proposal, using BIDBPENT and BIDPAYENT parameters on the user level. However in my customer's V12.0.31 it is not possible. Can you please help me how…
Hi togehter,
we successfully modified an inquiry screen (added columns, changed order of the cloumns...). Now we want to share that inquiry screen with another X3 system.
Unfortunately we cannot choose inquiry screens as an object in the patch creation…
We have a scenario where we direct ship product from a supplier to a customer. Because of this and because we want to see accurate sales margins on the sales order, we have a need to change the cost of goods on our sales order entry screen so that it…
Hi there, We tried to get all the products via the Soap Web Service, but if the listSize is over 30000, the api returns "NULL", does Sage X3 soap web service support the pagination results? Thanks
We need to create a warehouse site (Non-Financial Site), that should not have any link to the company's financials and inventory once the delivery is done. on the other hand, the site should only receive the items, and send the partial deliveries upon…
Hi,
Is there a way for me to identify where a script is being used other than identify from script name and description itself (unreliable since sometimes there's no description and badly named name).
In specific, I would like to know where this script…
Hello, everyone!
We are in the process of selecting barcode printers compatible with the X3 for our shop floor.
We have 2 options so far:
ZEBRA ZD421, DIRECT THERMAL, 203 DPI, USB, USB HOST, ETHERNET, BTLE5, EZPL
TSC TX210, LCD, WIFI READY,…
Hi I'd like to import email contacts under this contact function for about 1000 BP's. I have my list of BP's and the email address. I will flag them all with code being their BPCNUM followed by _STA. All fields will be the same such as language, country…
FAQ
I've seen multiple requests on how to add custom columns to Web Scheduling and thought a quick guide to this case and Brickscould help everyone:
Log in to the scheduler and select the Wrench -> Advance Configuration .
Automatically,…