Sage X3

I want to mass update all the existing products with their respective locations. However, when I am trying to export default locations along with the types, i don't know how to export multiple types. Upon exporting only receipt is getting exported. See…

Hi All, I am trying to export data of supplier using xml in Http Request in .Net with direct credentials not SSO One On calling the below xml i am getting response of Cannot read property 'GRP' of undefined Can anyone kindly guide how to get…

We're working on a remittance import template for our client and are looking for a way to link the PAYFRM and PAYMENTH tables. Currently when adding FRMNUM to the link column, we encounter a warning stating that the link does not appear coherent. The…

Hi Have any Business Partners in Australia been able to successfully setup and import using the Advanced Bank Statement Import function in V12. I can not seem to get any assistance on this as Sage mainly deal with the MT940 files. Do clients actually…

I am trying to import/export BPs from one endpoint to another. However, when I import the file the BP numbers are chronologically assigned instead of keeping the same BP numbers from the exported file. Where do I go to adjust this?

Hello, I'm trying to build an import template that allows me to create ITMMASTER and ITMFACILIT records at the same time. These are the fields I have listed below. When I attempt to import based on this template, the Product in ITMMASTER is created…

I was able to update BOMD with a line detail thru Usage>Import and the report indicated that the record was modified. However, the Production BOM detail was not updated even though the properties showing that the record was modified?

Is there a definitive list for what is considered a special character?

We have been investigating an odd issue at a customer site where we are unable to upload files as attachments or if we are doing an import. When doing the import, we select client & attempt to select the file and receive the message: file not found…

Please excuse my ignorance, but I'm trying to read some scripts in X3 and I'm wondering what the '!' before a function or command means. Also, can anyone confirm if the : is an end of line notation? I'm looking for 4gl language references that might…

Hi Sagians, We have around 5000 locations to create. I have checked the default import template but couldn't find any. I have created my own template but it is not working. Below is my template. If Any one have idea please share..

Have any Business Partners in Australia been able to successfully setup and import using the Advanced Bank Statement Import function in V12. Every demo I goto the users all say that simple products like Xero have import from australian banks and I am…

Can sage send data to a webhook? If so, could you elaborate on the process for this? Thanks, Chris

From experience, doing a data extract (to SVG) while users are in the system works, but users report that X3 performs very poorly or not at all for the duration of the SVG. The 'spinning wheel' shows on screens when attempting to open / save records.…

Hello guys, Someone can tell me please if it's possible to invoke an external webservice (soap) using 4GL ? I don't find any information here about this subject. Thanks

We are on version 11 patch 9 I created a table and a custom import template: The first record is always created (after I RTZ the table) but instead of creating all of the other records it insists on updating them instead. Here is the error received…

Hi I have to import a file but as soon as I go over a certain number of lines, I get an error Maximum number of lines exceeded. I have changed the activity code to increase the lines and also the number of records on the GACCENTRY,GACCENTRYD and GACCENTRYA…

Good Morning Sage City - Upgrading my companies V5 to V11 and trying to move over Cost records.. I've been mostly successful until the Overhead / ITCNAT table came into play. I keep getting an error message that reads "The total of natures of expense…

Hi, I'm trying to create projects (GESOPP) through REST Webservice.. I can create into OPPOR table but when I try to create for OPPORCRM (needed to be visible in GESOPP function) get the error message: "A Pre-sales or After-sales step must be…

Hi , We are using Standard SIHFL (Sales Invoice Full) template but still we are facing issue which is showing error message as ITMREF(1) mandatory field. We have only 1 line in the Invoice which we import. We tried with same template using exporting…