Browse By Tags

When trying to create/duplicate a customer in the customers function in the homologation dossier. We found error on @X3.TRT/CONTOB looking for rd_tiv funcion wich not found. We're trying dossie valitation, but we're found the same error. Version 12.0…

Hi everyone, I get stuck in a problem due to not knowing how to return an array from a Funprog I mean, I'd like to know if it is possible how to return an array from a Funprog Something like: ########################################################################…

Normally, whenever you want to create any entry in sage X3, there are two ways, 1. either by clicking the "New Button" 2. "Modifying the existing entry", just need to remove the entry number, press TAB, and all of the attributes of the existing entry…

Hi, I am creating a simple SQL Requester which will pull back data from 2 tables - PREQUIS and ACLOB. I wish to use a SQL Function I have to convert the CLOB Text from RTF to 'readable' text. This works fine in SQL, but when I try in the SQL Requester…

In Report Writer, Sage 100 Contractor, is there a way to use the selection criteria "in list" with a variable like {variable[N]}? In this case, I am using {Job Number[N]} to select Job Number in SQL statement where job number is not in the Primary Table…

In Sage 50cloud Accounts you can configure the F12 function key to take you quickly to live Q&A help. Find out more >

Hello, I want to use the standard function of product-site creation. it will be like Call ... From TRTCREITF (Or something like that ). Is there any developper who used this function before ? I need also which parameters to pass to this function …

Hallo, i have created a report based on a view. The where clause of the view containts a fixed value. for ex : where QtyDays = 5 and ... Our customer wishes that the fixed value becomes variable and act like a parameter. My tought was to create…

HI All Hope anybody can help, Running Sage CRM 7.2d The Opportunity list was deleted by accident When I go to opportunities there is just a blank Screen When trying to recreate the views in Admin-> Customization Now When I add items to the…

Good Morning Community, I find myself in need of running a batch file from within a component. I have found the RunSQL command and know of the XP_CMDSHELL procedure in SQL, which runs a command line in command prompt. The command is to be used to run…

Hi, I have a problem with a left list. I want to add a field in a left list which consists of the BPADDRESS fields POSCOD and CITY. ([F:BPA]POSCOD-[F:BPA]CTY). Only the default address should be shown. In order to only shown the default address…

Is it possible to lock down this function for a period without have to disable the function on each profile. We need this to happen when we are finished with one site for a period. We do not want the users to book anymore entries.

Hi there VI fans; I have a field that contains an Invoice Number that I am trying to import into AP Invoice Header. Unfortunately the string also contains a lot of stuff that is not invoice numbers. For example, here are 3 of the values in that field…

Hi All, I want to setup a calculated field in explore that takes a package quantity UDF and divides the on-hand quantity by that to show the number of cases they have on hand. The hitch is that not all of the items have a pack size and some items have…

Hello, After I run a job it shows that all the inserts and updates were failed. Almost all the error message (which I could see in 'Transaction Errors') say that 'Input string was not in a correct format'. I want to know how can I get to know…

I'm importing invoice records from MS Sql server and one of the fields has line feed characters, but they get stripped out during the import. The sql field contains something like "Line one text" + char(13) + char(10) + "Line two text". In MS Access…