Sage X3

I was wondering how is the location changing on adc material picking screen? Is there a stock change transaction happening?

Hello, When I do detailed allocation and look into the STOALL table, the lot, location, and status aren't being recorded in the STOALL table. Is there a way to get this data captured into the STOALL table/create its own stock record on the stock table…

How would I write 4Gl code that will create a new record in the stock table? Thanks, Chris

When calling a Subprog from a button action on a Window, it executes a number of data validations, one of these validations does select in in SQL. When I execute the query in SQL, it returns the correct results. For example: When testing the same…

Has anybody created an API call for an ADC function? More specifically, I am looking at the ADC Material picking screen and looking for information on how to write a write api call for this. Thanks, Chris

Hello, I try to make some development in PJM module V11. we have OPPORPJM class there which have Property TAS linked with class PJMTSK During Task planning I Have prepared 3 Phases If I look at Value in Instance GZINSPJM I can see: GZINSPJM…

Hi, I added GPE=1 to a OUVRE action, but it is still reading the standard script. Does GPE=1 not work on the action OUVRE? I am doing this for the SUBENTL script. I created a ouvre in the SPEENTL script.

Good day people, have been trying to change the tab title for a windows and have been having a bit of a challenge. Have used the standard Windows Management to make the name change on the tab but when I preview, one of the names doesn't change while others…

Please any help will be appreciated. I am trying to clone a functionality from Customer BP Invoices under the AP/AR Accounting. In the Distribution field in Lines where you can perform analytical distribution I am trying to clone same functionality for…

Good day everyone, I am going to be grateful if I get a reply to one of my challenges. I am trying to create two tabs with the table screen type. I am successfully making on the tab save data to the database but the other tab cant save data into the database…

What 4GL command would I use if I want to start reading a string from the right. I kind of want it to work how left$ works. Right$ is not what I am looking for since you have a define the number of characters starting from the left. Thanks.

Hi, How do I write this 4gl statement for a Date Datatype? Subprog C_DAT(VALEUR) Variable Date VALEUR If VALEUR = "" mkstat=2 GMESSAGE = "Date is Mandatory" Endif End This is throwing an incompatibility error because I think you cant write…

Hi All, In Administration > Administration > Users > Groups , is there a way (in code or otherwise) to get hold of the Role, users linked to group and Endpoints? I've tried to get into the representation but it is not listed in the dictionaries. I…

Hi, Is there a way to convert an integer to represent days in 4GL? For example, I have an integer that says 40. How can I make it so it represents 40 days? Thanks!

Can somebody tell me if the SPESTOALL is actually the SPE script for the STOALL screen? I have been writing code in it and I have not been receiving a response back from the screen.

Hi, There is something wrong with my code and I am not sure what is wrong with it. The E represents the standard button, save, code for the screen. Thanks! ########################################################## $AVANT_E If [M:ALL]STA(nolign…

Where do I find the logic for all of these options (see picture)? I looked in the standard script for this screen and it is not there. The screen is ITM0 and it is located on Common Data -> Products -> Products. Using Sage x3 version 11 patch 2. …

Hey, I need to make a modification to a script called SUBSMXA. The standard script is SUBSMX, and it is linking the SUBSMXA via gosub. What I am trying to do is make a modification (adding something, not removing anything) to one of the actions in…

Hey I created a field to a table and applied the field to a screen. When I press save, the inputted data from the new field is not being saved to the database. Can somebody tell me the process of creating a brand new field and how to make whatever people…

Hey, I am having a bit trouble adding a column to the Manufacturing> Inquiries > Products. Screen code: CONSMKI2. I am trying to add the field REFPER from the table STOLOT. In the script I have added the following code: ##############################…

Hi, I am trying to change the font size for some of the text. This is a specific text that is located under the fields. Can somebody tell me the process to changing the text for this field. I guess what I am having trouble with is that I can not find…

I'm trying to read a .csv text file. I am setting adxifs to ',' and adxirs to chr$(10) (line feed). For some reason, it doesn't parse the columns. if I change the delimeter to '|' (pipe), it works fine. Does anybody know what I'm doing wrong? Here are…

Hi All, am hoping someone can give me some advice on where I'm going wrong... I have a bespoke field on the PIH1 screen that reads and writes to the db as required. What I want to happen is when I open the screen that if this field is populated…

I there, I'm new in Sage X3 V8 My Company has large Item descriptions with more than 30 chars lenght so we need to use both description fields, description 1 and description 2, but this 30 chars limit start to make a lot of troubles for the user becaus…

Hello, I am trying to set up a SPE for the client to have an info box message pop-up if the invoice price (being NETPRI from PINVOICED table) is different than the price listed on the price list (PRI from PPRICLIST table). The problem with these 2 tables…