Sage X3

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…

When trying to add comments in the "Delivery Comment" box of the "Delivery" tab on the Order Management screen, I encounter the error message in the attached screenshots. This seems to occur when trying to add several comments. I'm trying to shorten the…

Hi All, On a customized field we are triggering a creation action of a current transaction. For which we are able to create transaction but in the next step we need to refresh the screen. To achieve this, we have tried various ways such as calling actions…

Hi, Anyone knows how to set up a table control rule to require a value in some especific box from a multi dimension field, such as Analitycal dimensions or Statistical groups from Customers, for example? Thanxs

Hopefully this will make sense: Our company is trying to figure out how to code, or whatever, our Supplier BP invoices to show that we were not taxed and should have been so we can run a report to decided what we owe for sales tax. OR if we can somehow…

Hello I would like to dynamically hide a column in a table (in the SOH4 screen). I manage to do it for a single field of the screen with the Chgfmt command, but not for a complete column. Is there another command or another syntax?! For info I am…

Hello, We are trying to implement the new EDI module for new tables and objects we developed on a vertical project for Ports & Shipping Business. Apart from the documentation we can find through the how to option in the online manual, does anyone have…

How do create and update allergen? I want to create a new allergen with two letters and update some.

Hi everybody. Any Knows if exists function to read Barcode 128? to pickup all the inforormation? Thanks!

Is there a way to update the credit status field of a sales order on creation? I have tried setting the value on in APRES_CRE "[M:SOH1]CDTSTA = 4" without any luck. I have also tried using the entry point TRTVENCDT > CALCREDIT also without any luck. …

I tried with all possible keys, but I still have a problem with the connections in between the table. Please, can anyone help me? I intend to create a query that presents all shipments and all production follow-ups made on a date and the respective accumulated…

I've set up a custom field in the ITMBPC table to denote that a particular customer product needs to have a special dispatch label printed. It's a simple yes/no, so I have linked it to Local menu 1. How do I get it to display in the ITU screen so that…

Hi, In the sales order signature workflow, I want to update a field in the ORDER table when the user validates the order. I tried to add the action AWRKUPDFLD in the action tab of SOHSIG workflow, but I couldn't because the grid is already full of standard…

Hello I would like to add a field on BPCUSTOMER to return if customer has at least one active Quote : not closed It works. But I do not manage the fix the value in the Table. I don't want to go on each Customer and Save. I would like to the value…

We have had a few situations where crystal reports formatting was getting messed up by rtf from ACLOBs. We were able resolve this issue by updating the formatting being stored for the comments fields on the ACLOB screen. Edit screen ACLOB Select…

I've started doing some very basic scripts in house but I've run into a wall recently. I'm trying to emulate the same behavior that is seen with MANHLDREL tied with the manual hold button on the SO screen. That is, when the action is triggered, a window…

Hi all, I am trying to create new SOH records using Soap Web service protocol but I notice that my specific object actions are not executed. I insert my Specific code as usual at SPESOH. When I create a new Sales order with a web interface,…

i have a problem with the number of decimals. The COE type ( coefficient) has 6 decimal precision but the quantity has only 5 . I deliver quantities in units but sometimes I find 0.9 because of the difference between the precision number between the…

On the purchase orders screen, I have created a new checkbox field. When I create a new order record, if I type in the order lines block first and then after I try to uncheck the checkbox, the checkbox gets checked again the first time. If I uncheck…

Hello, I would like to have a calculated field in SOH4. SUM QTY of all the lines in SORDERQ which has the same PJTNUM (opportunity). Not only the lines on the screen. I would like to Sum all the lines from all the Sales Orders. I need to do same…

Hello X3 Folk, Anyone has idea to get parameter value which has been sent through email and external user is using the same to login X3. 10.10.10.10/.../main.html Above link will open payment approval screen and I want to get company name…

I was trying to add internal notes to the purchase orders at a line level and was thought I would share a how to. If you have a better way, please share. Add column to PORDERQ; YLINTEX2, Type TXC Save and validate table This is where the ID…