• 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 &.  But now that KB article no longer exists.  

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

  • OPPOR and OPPORCRM tables and their purposes.


    I hope someone can help me with this one. I’m trying to set up some analytics reporting for sales people around projects and forecasts etc.. They are just starting to use the CRM component of Sage X3 (V11).

    In the process, they alerted me…

  • error executing report

    Hi guys!

    I've made a new report for production labels, the new report is called YETIQPROD and I put the crystal file under my dossier\report\ITA

    when I launch the report from stock\labels I get this error

    where's the problem?

  • consultation does not refresh in homepage


    I'm a newbie with Sage Enterprise Management (v.11)

    I've made a consultation, and put it in a home page, but does not refresh when clicking the button.

    At the opening of the homepage, sometimes is filled with record, other not and I have…

  • How to turn off carrier price calculation?

    On the delivery screen, when I work with web services, when I save a record, it asks web service the following message and web services responds with a yes. 

    The carrier, shipping address, or weight/volume was modified:  Search for the carrier price?


  • Syracuse Release Notes

    Hello! I am looking for release notes for Syracuse updates but can't seem to find them anywhere. Can anyone tell me whether this  documentation is available anywhere? I am going from v11.14 to v11.22.

  • Limit on Screen Lines in BPA Activity Code?

    Has anyone found a limit to the number of Screen Lines you can have an the BPA Activity Code (Number of BP addresses)? We have a customer with over 16,000 locations and our Customer Service team has asked if we can import them all. Currently we are set…

  • No License Rights for Folders after Syracuse 11.22 Upgrade

    Hi Everyone, this is my first post on Sage City, deciding to branch out.

    Has anyone been receiving any Access issues to Non-Production Endpoint Folders Post Syracuse Patch 11.22 for security hotfix?  

    Two of our clients are receiving No License to access…

  • How to perform redirection to specific URL in Syracuse?

    Hi Guys,

    Did anyone ever tried to perform a URL redirection to a specific URL?

    By right, I have many users using accessing the SageX3 Web URL using http://IP:8124/auth/login/page , http://localhost:8124/auth/login/page and http://servername:8124/auth/login…

  • 4GL- Calling IMPORTSIL from grid contextual menu (GBOUT1) doesn't work

    Hi, I'm facing a weird behaviour.

    In my specific, I've developed a routine that uses IMPORTSIL to add a new line to an existing sales order.

    This routine is simple:

    1. Reads current SOH data and generates a text file
    2. Add a new text line from parameters…