• Creating Sage X3 Alerts

    Hi team,

    I want to create a rule where Sage X3 will either be notifying or prohibit user from proceeding when they want to create a quotation for a supplier who has reached a certain credits amount (to be agreed) ie has several outstanding invoices which…

  • Stock journal not having values

    Hi team

    I need some assistance. I am facing a situation where I am having stock journals created but not having values. The process is triggered from a purchase> purchase receipt> and the purchased items were supposed to be received as stock but now,…

  • Error in returning stock - Line movements are pending, please adjust

    Hi team,

    I am facing a challenge in returning a stock where as I have deliveries and I was able to create credit notes among the steps in returning the stock but I am facing an error as in below screenshot as soon as I select the delivery number so as…

  • Delete/insert lines with SOAP web service


    I don't understand how to set up the parameters to insert and delete lines via web service; actually, I can't find much on those parameters in general (their definition, when should I use which, etc). A simple example would do the job as well, I can…

  • Record Print options greyed out

    After posting payment, the record print option is greyed out only the list button is active. I need help.

  • Any Easy way to exclude weekend from date calculation in 4GL?

    Is there any easy way to exclude the weekend from my date calculations in X3?

    For example, my delivery is suppose to arrive on Monday. It takes 3 business days to get to the customer. If I do Monday - 3, I would get ship date of Friday when I actually…

  • Workflow Rules message by Criteria

    In the message text area in workflow rules, I was wondering if we can display text in a email dynamically based on a criteria. 

    This is my attempt, but doesnt work:

    |[F:PSD1]ITMDES<> '',chr$(13)+chr$(10)+"Order Description :[F:PSD1]ITMDES|…

  • Bar Code - Multiple Suppliers

    My company is currently on V11, and about to upgrade to V12.  We have a hurdle that I am hoping someone has come across and found a solution for...

    We have multiple products that we source from multiple suppliers.  I am looking for a way to use multiple…

  • Sage X3 Implementation - Resistance to change

    We are a distribution/manufacturing company who implemented Sage X3 about 2 years ago and acquired another company early last year. We are facing quite the pushback from the acquisition from the employees and their resistance to change. Therefore, there…

  • 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



  • 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

  • blank report

    hello everybody ,

    i want to print a blank page when some users want to print a sale invoice thant contain line with GROPRI = 0.

    please anyone has a solution for that.

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

  • Adding Field to Screen

    Good morning Everyone and Happy Monday!

    I'm attempting to add PTHNUM to screen POH2, but I am receiving this error "Fields PTHNUM: Undefined parameter OBJZON ( Type VCR)." Does anyone know what I'm doing wrong and how to resolve this?…

  • Stock Labels- Change default quantity of labels to print?


    Sage prints directly to our label printer in our manufacturing plant. Sometimes the user printing stock labels will accidentally forget to change the 'quantity' of labels. 

    The Zebra label printer will then print thousands of labels if…

  • 4GL Subtracting Time


    How do you subtract time with the 4GL language?


  • Batch server difference between U9 and V11/V12


    I'm curious to know what is the main reason to change the batch server from the application server to the syracuse server level. 

    Any idea about the advantage or the improvement reason behind this major modification ?

    Can we always check by…

  • V11 Graphical Query Tool

    Is there a way to export or see the fields used on old Graphical Queries that are no longer visible. Will then use this to create new queries via the old graphical tool 

  • Turn off Delivery Contact

    Is there a way to turn off the requirement of a delivery contact on the sales order?

    We are running into an issue where the contact for the sales order gets removed from our system which leads to an error message that the delivery contact doesn't exist…

  • Delivery Locking after validating

    I trying to validate my deliveries using the  VALIDATION() subprogram in the TRTVENLIVV file. 

    Whenever, I successfully validate a delivery, the record is locked up. 

    I added the Unlock = "SDH"+delivery_number command, but the record is still locked up.…

  • Connect Existing DB Server to Brand New App Server

    Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might).

    I have some ideas, but I'd like to know how others…

  • Slow performance on CREATE invoice after upgrade to Sage x3 v11 patch 18

    We get more that 30 seconds to be able to CREATE an invoice.

    After create we can work/change/validate/print the invoice with no problem or delay.

    Any ideas or same problem\ solution ?

    Best Regards,

  • Outside Scope of VAT Tax rates

    We are on version 11 patch 12, but this is a question for any version and patch level.

    X3 allows you to set up Tax Rates, which isn't an issue. These then link through to the VAT Reporting, and in UK the BRI legislation. Using the MTD VAT Box setup, we…

  • Inter-Site Suggestion for multiple production sites

    We have an environment in V11 Patch 8 and need to have MRP trigger inter-site suggestions with multiple sites. The product is manufactured in both sites, but we need suggestions from the warehouses to drive the intersite movements. Here are the sites…

  • Which is the right Syracuse Hotfix for v11?

    There was a KB article #106630, which was for Syracuse, which was a hotfix for and addressed the & being replaced with &amp;.  But now that KB article no longer exists.  

    If you search the KB for Syracuse you'll find the original…