Sage X3

Hello everyone, I have a few custom fields on the SIH0 screen. If these fields are not set by the user I would like to add a message box (Yes / No) when they post the invoice. Basically to inform the user that they are empty and if they continue to…

Hello everyone, I have a custom field on the SINVOICEV table. I've added this field to the SIH0 screen and put a default to "2" (it is a yes/no). If I create an invoice directly from the SIH0 screen the default works fine. When I generate an invoice…

Hi Everyone, I have 3 custom fields on the sales header ( SORDER) and sales lines ( SORDERP). I also have the same fields on the invoice tables. When the order is invoiced I would like to transfer the values of these fields from the order to the corresponding…

Good afternoon I am trying to move data from one field to another. Basically we have a free text field that we used to use and now we are using one linked to AUTILIS and I want those user codes we were using to now populate my new field. I believe…

Hi Everyone, I was just wondering if anyone else has experienced this issue. Basically, I've created three custom UDF fields on the sales header (SORDER) and detail (SORDERP). I've included those fields on both the header and details of the import template…

Good morning I have added a field to SORDER, and then added that to SOH0. I am then receiving a heap error, but not sure what to do next. Anyone have any advice?

Hi, I want to add a new field value to SDELIVERY to store the value of a field from BPCUSTOMER table. We have a field on BPCUSTOMER - YDROPSHIP table ( datatype M, chapter =1 ). We set the field value when we create the customer record. I want to…

Hello, i want to add a field in my MGB screen that contain avaible stock , so i added a field type QTY but i have no idea how to write function in spe script that calculate availble stock !!!!! please help!! i'm under X3 V11

I'm wondering if anyone out there may have a solution or possibly the same issue. Currently we are using pack codes for inventory so we can retain the number of units per weight however now we want to begin using price lists but based on the products…

Good day We receive an XML string from a client but it is not the correct format for Sage X3. Is it possible to write the data from this string into its own separate columns in SQL? Regards Chris

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

I'm a relatively new user at sagecity, so my apologies if I violated any rules in my post. i'm Trying to check if a custom field in the lines of a document has value but i'm not achiving what i want... here's what i tried: Case ACTION When …

HELLO , i'm trying to add a custom field in SNL0 screen using an entry point (SNL0_CUD)to save the value Of the field in CUNLISDET (stock count ) , it saved well in the table but once i click on SAVE button the field appear empty on the screen ? any help…

I have been trying to add a field to CONSCPP and I can see the field in the screen, however, it does not populate any data. Its already added in Setup>General Parameters>Inquiry Screens, also on Screen CONSCPP2 and WMCPPSTD. Not sure where else I…

BOMs I am trying to add a custom long description field to our Manufacturing BOM screen (BOH0) and receiving this error - I've added a "Before Field" Action to the ITMREF field and added this as the script. Subprog AV_ITMREF(VALEUR) Variable…

I am trying to do a simple calculation where I need to multiply two fields and the total is displayed in another field. I believe this can be easily done through 4GL programming, but have some questions. My thinking is I would add an action to the screen…

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!

Is there a function to modify the BPSNUM field on STOLOT ? Cannot use Lot modification function as I'm not changing the Lot number but I want to add a value to the STOLOT.BPSNUM field. I'm thinking I need to go directly in the table. (ugh) thanks …

I have a need to set the format of fields on a screen to "Display" when a certain value is detected in a field. I know how I could suppress it conditionally, but that's not what I want to do. Basically... if I were writing the suppress for it I would…

When I execute a routine that modifies fields in a budget line after a After_modif action in a header field, if I don't position myself in the lines the changes are lost when I register the budget. I need some action in code that simulates as if I click…

I have a custom field in the STOALL table that I would like to transfer to the STOJOU table when the transaction is validated/posted. I've been looking for an entry point to do this, but I can't seem to find it. Does anybody know if there is an entry…

To narrow down my issue, I have added a customised field into the Sales invoice (Controls tab) screen SIH1 and at the same time into a new screen called ZSIH1, both held in the OSIH window. I have validated screens/ windows globally and created a new…

Hi all, We have done a customization where an auto WO is created on another site, once created on original site. In a WO Scheduling when we click the ‘Schedule’ button the following data is populated usually: Can you clarify which tables in specific…

Hi Team, I need help. I want to add the DUNS custom field at the Customer level (the Identity tab) First of all, I added the DUNS custom field to the BPCUSTOMERS table. But, I cannot understand in which screens I should add the custom field so that to…

I have a very strange issue. I have a custom sequence definition defined in X3. In my 4GL, I am calling NUMERO to get the next sequence number. This worked in our test environment, but it just hangs indefinitely in our pilot environment. I have confirmed…