Sage X3

What SQL command need to be used in order to extract 3 text lines without the prefixed "encoded" data from the TEXTE_0 field?

What does this adonix format mean?

The insert image button is greyed out in the rich text file. Can somebody tell me how to make this enabled so I can insert an image to the rich text file? Thanks!

Hello All, Thank you all in advance for any and all help you might be able to give me. I am trying to add a field (column) to a query grid for "Line Text Entry" from the "TEXCLOB" table. The Line Text Entry field is from sales order > lines tab. I am…

I will need to create a new table index in order to for me to link a table. What effects will creating a new table index have on the system?

What does sage alphanumeric limits? Is it only for alphabet and numbers? Or will I be able to add special characters such as .

Is there a way to get Lot to accept decimals?

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…

How can I display the Payment due date for a sales invoice in crystal reports I can see the invoice date but not the due date , we are on V8 any help would be great. I have the Payment terms on the invoice and the invoice date but am at a loss to…

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…

I am seeking assistance in creating a formula with the formula wizard that will make this certain criteria true: If the product starts with an R, then this field is mandatory.

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: ##############################…

So we have a company name field that is displaying in order line inquiry (screen: CONSCSP2). The weird part is that this field isn't being called any where on the screen, but the column is appearing. I even went to setup -> general parameters ->inquiry…

Hey, I am having trouble linking multiple tables in 4GL. These are the fields and tables that I want to link. Name Field Name Table Reference Work Order Number MFGNUM MFGITM Product Label YPRODLBL…

I am trying to export data from sage to a text file on our server. So far, I got this in my code: --------------------------------------------------------------------------------------------------------- If clalev([F:SOH])=0 Local File SORDER [SOH…

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…