• Is it possible to have a restriction by group of sites on the user's profile ?


    Today we have severals sites in Sage and we need to have restrictions on it.

    We put some restrictions code on the user's profile with the row level permissions  but there is a lenght limit and we will have to add 10 sites.

    I know it's possible…

  • What is the column name for AvailableStock->TotalRequirements in sql?

    I am looking to get the sql column name for  total requirements qty located in available stock. If anyone could point me in the right direction, it would be greatly appreciated.

  • No Applicable Rate when posting purchase invoice


    I am getting an error message when i try to post my invoice that there is no applicable rate for one of the purchase invoice lines. 

    We create our purchase invoices based on the receipt number.

    We are on V11, Patch 14



  • Enter backdated shipment for product that has since expired

    We have a scenario as follows

    Sales Order was done on 18/11/2021

    The product to be delivered expires 20/11/2021

    Physical delivery to the client was done on 19/11/2021

    The delivery was only captured in Sage X3 on 22/11/2021 although we changed the delivery…

  • Default Customer Contact checkbox location

    On the customer screen, there is a default contact checkbox. 

    Which table is this stored on? I cannot find it on CONTACT or CONTACTCRM table. 

    On V11, Patch 14

  • 1) Mass delete BPS Invoices 2) DocLink/DocAlpha

    1) Is there a way to mass delete BPS Invoices? I have 1900 to delete.

    2) Duplicate and triplicate Invoices have imported into Sage X3v12 p17 from DocLink/DocAlpha.  This is the second or third time it has happened.  Does anyone have advice on what might…

  • Facing issue while choosing the endpoint of the imported folder v12.0.21 on a new servers of Sage X3 version 12.0.26

    I got an error while choosing the endpoint of the imported folder v12.0.21 on the X3 version 12.0.26. "Create session error : The folder version is different from the version of the root folder.", As shown in the screenshot below :

    Has anyone…

  • Anyone know how to setup an Export template so that it's output is split into multiple files?


    We are still using version 7. We have an export template we use to export invoices to be sent through EDI. Currently the export template creates a single text document with information from every invoice that needs to be sent. Is there a way to…

  • Trying to read the products of Magento from X3 using rest api integration and Node JS Error

    Hi All,

    We are trying to read the product of Magento from Sage X3 using integration methods such as Rest webservices, Node.Js for one of our client. The Magento API endpoints uses 'OAUTH1' type of authorization for authentication of the Rest API…

  • Sales Kits -Commercial BOM

    I am trying to set up a sales kit - it is a bundle of 6 bottle of wines. 

    I couldn't change the unit of component product. It is grey out. And the system default as "CA" - case.

    Is there any solution that i can change it to a different unit…

  • How to Allocate stock/create shortage against intervention

    Hi Guys,

    V12 PU 25.

    Wondering if there is a way to manage the following scenario involving service interventions.

    When creating an intervention typically we need to specify the parts required for the job. We can do this under the consumption, however…

  • BOL Number Grayed out

    Who knows why the BOL Number Trailer seal number are grayed out on X3V12P26??


    Hello All,

    Please i need help

    I ran Stock Accounting Interface and this error below came up,

    ACC (CIL) : Tax code mandatory (XSTK Line 22) stat=97 KEY1=HOF2108ISS00000751 KEY2=1000 KEY3=~ KEY4=~ KEY5=~

  • Signing workflow without login

    Hi all,

    Why Sage X3 opens login window when a user sign an SOH from an emailed workflow message. How could this be omitted.



    Hello All,

    Please i tried to import sales invoice into the system and i notice that the template doesn't have serial number included.

    Please help me

    how do i add the field to it because sales invoice table doesn't have serial number field.


  • Sage X3 How to modify window that shows up when i click selection icon?


    Im looking for a way to modify a numer of columns( i would like to add field from [BOM] table) in window that shows up after I click the selection icon(first screenshot). 

    Thanks for help

  • Looking for the sales FOB field in sage x3

    Good day everyone, I am looking for the sales FOB field in sage x3. If there is no field in x3, is there a column in sql? So far I have been unsuccessful in finding said field. Any guidance would be greatly appreciated. 
    Thank you in advance!


    Hi All,

    Please i want to make the stock transaction field on SALES INVOICE to be defaulted to "YES".

    Please help.

  • Dimension Codes Not Flowing From Supplier Record to Supplier Invoice

    Common Data >> Bps >> Supplier, Financial Tab, Analytical Dimensions

    Currently only codes listed in AX1 flow through to the supplier invoice (Supplier BP invoices).  How do I change the other dimensions to flow through to the supplier invoice…


    Hello All,

    Please i need a guard on how to increase Serial number field on purchase Receipt and Sales Invoice.

    The field can't take more than 20 characters.

    Thank you.

  • ADC location override

    So I have been presented with an interesting challenge.

    In our company we've set X3 to batch allocate all available stock to meet all demand in the system.

    We also heavily leverage X3's ADC functionality.
    Our warehouse users are able to override…

  • Mongodb service doesn't autostart after upgrade

    Hi there,

    I have made 3 different upgrades from Mongodb 3.4 to 4.2 and now when I restart Windows, the mongodb service doesn't autostart. I have to start it manually.

    The update path was the following:

    • Mongodb 3.4 -> 3.6
    • Mongodb 3.6 -> 4.0
  • Detail Shortage issue

    Hello All,

    I have 4 Detail shortage when i checked my stock from product site and i have 6 quantity available.

    How do i resolve the issue.

    Please help


    Hello All,

    Please i need help, i tried to close period and i got this error message below.

    Kindly find screenshot below.


  • Sales return - can't find delivery in Left List

    Trying to process a Customer Return, but the relevant delivery doesn't appear in my left list.  Have checked that I have selected the right customer account.

    Why would the required Sales Delivery not appear?