• Connexion between Sage X3 V5 and Sql Server

    I want to establish a connection between Sage X3 and SQL server but I can't do it. Can anyone help me or should I go another way?
  • import a new order line with a specified SOPLIN line number

    Hi, I am trying to add a new sales order line via import while specifying a SOPLIN number, but X3 ignores it and generate a new one. I want to insert new imported lignes between existing lines. I wonder if it is possible ? Thanks, Faris…
  • Purchase Order "Confirm To" field usability in sage x3 v12

    Hi, does anyone here know how can I find the "Confirm To" field in sage x3 v12? Is customization needed?
  • Statistical Parameters; Values; Forecast = Yes

    Hi Our V11 system has a standard Sage Statisical Parameter set up with code VEN05 which, when used on a landing page, allows us to show a real-time report showing invoiced value. One of the columns, the MTHT vairable, is the SINVOICED.AMTNOTLIN * SINVOICE…
  • Works Order Costs

    Can anyone advise how the costs/prices are calculated for the finished product when completing a works order? Also if you know what tables and fields contain this information that would be appreciated as well.
  • GAS Import template

    Hi, I have a tech/dev question please. Sage X3 V11 patch 11. Can we add any conditions to the GAS import template for accounting date to check if period is restricted or closed? We're using a csv file to import journals to X3 based on GAS template…
  • Sage X3 and UK Packaging Waste Regulations?

    Hi, Can anyone advise if there is any functionality for Sage X3 to calculate the information required for the UK packaging waste regulations? https://www.gov.uk/guidance/packaging-producer-responsibilities I know there isn't anything for the new…
  • SPE Actions Stock Change control

    Hello, I am very new to trying to develop on SAGE and my only resource is the French bits of vertical already in the system so I apologise in advance. Ultimately what I am trying to do is, put a control on the ITMREF field on the GESSCS (Stock Change…
  • Sage X3 - Prepayments

    Hi Guys I'm relatively new to Sage and need some help while trying go figure out how to automate my areas as much as possible. Can someone please advice if this possible to prepay PO invoice, I only found non po prepayment procedures. Would the recurring…
  • PJM Import template: Possible export?

    Hello, PJM project import template is now available in the new Sage X3 release 2022 R2. We noticed that the template uses temporary tables to import projects. The "export" check box has been ticked on the template, have anyone managed to export existing…
  • Sage X3 Add-on for Real Estate

    Hello community , Does anyone know of any Real Estate add-on for Sage X3? Thanks, Dragos
  • Sage X3 - Tracking Goods in Transit

    Hi all, Hopefully another quick question, how are companies tracking goods in transit in X3 - is there a feature / status for this, or do we need to go down the route of receipting goods into a goods in transit stock location and then stock transfer…
  • How we can read the link data before loading the screen (especially company)?

    Hi Folks, Can anyone please help me on below? In our customized process we prepare a suggested payment list (Bunch of “Invoice Authorised - Await Suggest” invoices) and send it to the user(External User) for approval through the Sage X3 application…
  • lunch FUNMDESA(TRTDESALLM) from script

    Good morning. I need to launch the FUNMDESA function from script, indicating the component itmref. I used the following syntax. SAVACT = GACTION PARBOUT(1) = GSITE PARBOUT(2) = date$+365 PARBOUT(3) = '2' #allocazione dettagliata PARBOUT(4) = ''…
  • BP's bank account number construction for UK?

    Hi all, I have the case of BRI implementation and they don't use any IBAN accounts, just sort code and bank account number. How the account number is constructed? Thank you.