• Importing new components to existing BOMs

    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…
  • Budget Calculation not calculating

    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…
  • Selection parameters in the query for movements by items

    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…
  • Sage X3 - Stock Accounting Task

    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…
  • Historical Data Conversion in X3

    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…
  • delete product site

    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…
  • Application Error on Stock Change Transaction Screen (GESSCS)

    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…
  • What is the purpose of the following: Substitution product "Field SBSITM / Screen ITS [ITS]" VS Alternate product "Field RPLITM / Screen ITM2 [ITM2]" in "Product"

    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…
  • Adding Total Deposit to Left List On Manual Remittance Screen (GESFRM)

    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…
  • Graphql Work Order Production Reporting

    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 } } }…
  • Menu item - type: query - "where" parameter operators

    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"…
  • Extend product info in Price list entry

    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…
  • Expiration Dates/Product on Hold

    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…
  • BIDBPENT and BIDPAYENT greyed out in the user parameter definition (Chapter TRS, group AUZ)

    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…
  • Patch creation - include inquiry screen

    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…
  • Code to query purchase pricing?

    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…
  • Does Sage X3 soap web service support the pagination results?

    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
  • Creation of New Non-Financial Site that should only be warehouse and have no financial impact on existing company or sites.

    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…
  • How to find out where the script is used?

    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…
  • Advice needed X3 compatible printers

    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,…
  • Trying to return a Using ASYRRESTCLI.EXEC_REST_WSCLB how do I get my RETVAL to bring back more than 250 Chars?

    Hi There I am trying to return a Using ASYRRESTCLI.EXEC_REST_WSCLB how do I get my RETVAL to bring back more than 250 Chars? Here is my code
  • Best way to import BP Contacts under Common Data > BPs > BP's > Contacts tab?

    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…
  • Object fields

    Can i declare more than 16 fields in an object ? If positive, how ?
  • FAQ: Custom columns in Web Scheduling

    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,…
  • Error reprorted when creating a new sale invoce

    Hello everyone,can someone guide me to sovle this issue Thank you!!!