• Web service returning "Process[WS_NAME] - No return code (status[6]) "

    I'm getting the following message on some web services responses. Just in some times.

    "Process[ZWS_NAME] - No return code (status[6]) "

    The web services its a Subprogram web service.

    Has anyone known what is it? And how to fix it?

  • within generate porder from prequest

    Hello everybody

    i'm about generating purchase order from purchase request , the probleme that i want to pass a field value as params from request line or header to all line in the order

    thank you 

  • auto affect header field to all lines

    hello everybody!!

    in the purshase order i made the CCE field of PREQUIS mandatory ; now i want to affect this CCE to all lines in PRESUISD and after modification in the header all the line will be modified!!!!!

    thank you

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

  • Hey my report numbers have changed! Or have they?

    Have your colleagues come to you saying that their report / inquiry data is different than when they ran it before? Or that beginning balances seem to have changed? You review the data, and it appears to be fine now. They want to know why it changed.…

  • Customer Parent/Child relationship

    Hello Team,

    Could you clarify, is it possible to create the customer Parent/Child relationship in Sage X3?

    If yes, could you provide screenshots on how to do it?

  • What is the difference between Invoice Due date basis and Invoice Due date

    Hello Team,

    Could you help me with the following question?

    What is the difference between Invoice Due date basis and Invoice Due date?

  • Batch JE Function - reversals?

    Can you create reversing entries in the Batch JE function? If so where? 

    Financials > Journals > Batch Entry

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

  • How to upload a file to mark outstanding transactions?

    Hi there

    I have a bank reconciliation of 9,000 transactions, of which 750 of them are outstanding. I have already identified the outstanding transactions in an excel workpaper.  

    Do you know if there is any way to upload or mark the 750 outstanding transactions…

  • Adding current Date to an SEI Dashboard

    Hi Everyone, 

    I am trying to add a current date widget to an SEI dashboard. I have tried to add a KPI view with a calculated column containing @@CURDATE without success. 

    Best regards, 

    Tarik

  • Where can I find the received qty from a PO?

    As seen above, I am looking for received/delivered qty from a Purchase Order. Is it the Received STK or PUR in the PORDERQ table? so far I have been using received stk, but am unsure if that is correct

  • I need help verifying a variable on creation of Sales Invoice

    I there,

       I'm struggling to get a verification if a Variable is empty or not on creation of a sales order. 

       The Variable is in each line of the sales order, i need to emmit a warning and block te creation if one of the lines has the var empty 

       Here is…

  • How do suppliers work?

    How are suppliers set up? I see in the ITMBPS table, there is a flag for default supplier which makes me think that if it is not a default supplier, is it the last supplier that updates anytime an item is received from a new supplier? 

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

    Hello, 

    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…

  • STOCK ACCOUNTING INTERFACE ERROR.

    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=~

  • How can I go about joining the SINVOICED table to the STOJOU table?

    As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

  • Advanced selection filter: global checkbox not available

    Hello, 

    I am looking to set a default 'STD' filter. The checkbox to set the selection as global is not available. 

    I have Admin rights as my role. 

    Am I doing something wrong? 

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

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

  • error During the Closing year end fixed asset

    During the Closing  year end (fixed asset -> processing -> period / year end) an error message appears (no company to find). please help me to find the solution

  • Sage X3: New legislation regarding sales to Canadian customers

    Canada has recently implemented new sales tax legislation that may impact certain Sage Customers. Effective July 1, 2021, any non-Canadian company that sells $30,000 CAD, or more in products or services within a 12-month period to Canadian customers …

  • Improve Menu profile import function

    This function is very useful to translate Syracuse menus, as it reads translations already done in SQL db.
    But, some items on the navigation page are not translated.

    Example with Fixed assets/Inquiries menu. ‘All legislations’ and ‘Germany & Austria’ and…