Browse By Tags

Hi, I know SequenceNo counts up if a duplicate record is generated on the same day but I am not sure what fields exactly need to be used. Is it just SalesOrderNo, WTNumber, WTStep, RecordType, and TransactionDate? Or is it the rest of the fields as…

Hello All, So I'm trying to setup a BoM for a process driven product formula which would look similar to this: Phase 1 Instructions (Component type: Text, Type: Active) Input 1 Weight (Component: Normal, Type: Physical) Input 2 Weight (Component: Normal…

Backgound on the challenge I am facing: A vendor sends us an import file that combines three customer data fields into one, separated by a ‘/’. (These are Unit No / Account No / Order Reference) This combined field is imported into our Sage Line…

I created a custom screen where I am displaying images related to drivers. I am using a datatype of ABB, Graphic object of Photo.I have an issue on how to store those images. I know that it is stored in the CBLOB table. In the screen ITM1 there is the…

I created a custom screen where I am displaying images related to a driver. I am using a datatype of ABB, input of Display, and Graphic object of Photo.I have an issue on how to store those images. I know that it is stored in the CBLOB table. In the screen…

Hi, I don't understand how to set up the parameters to insert and delete lines via web service; actually, I can't find much on those parameters in general (their definition, when should I use which, etc). A simple example would do the job as well, I…

Good Day, We have consolidated some of our branches and we need to provide the effected employees with a small transport allowance monthly (not reimburse, upfront - to pay the additional taxi fair to the new branch) How must this be declared on…

Hi, We want to post Purchase Invoices from code after it has been saved, we have done a similar customization for the Suppliers and it works perfectly. However, for the Purchase Invoices, it does not execute. Here is the code snippet we use. It…

Hi all, I would like to read a value from a field (TEXT) and If the user entered a value different than only numbers the system will replace all non number characters to blank. something like : replaceAll( ' [^0-9] ' , ' ' ) is it possible? …

We have our own product no & also need the supplier product no - can we put this on Sage 50 Accounts and if we can how. Also if it can be done how do we show both numbers on our Purchase orders?

Good afternoon. I have a few software support agreements, some of which I'm charged VAT on, others not. The ones that do not contain VAT... which tax code should I use? It think t2 and t9 are the most confusing codes!

Hi, I want to create new products code for all the existing ones with better alpha numeric and logical product codes however i will like to have the old product code data on it like last purchase, re order level ,re order quantity and purchase info…

We set a lot of nominal code for individual events, but now we used project, so we want to hide those unused NC. Who knows Sage will introduce the new function of hiding unused NC?

Hi, In Sage 50 Accounts Professional, is there any way I can change the field type of an Analysis Code on Sales Orders from free text to numeric/integer. Alternatively - can I make a predefined list of allowed values? Thanks

Hello, I'm based in the Republic of Ireland. What is the VAT Code for purchase of goods not for re-sale at the Standard Rate within the EU? Is it T18.? Thanks, DANIEL SMITH

Hi everyone, I'm using "Call OUVRE_BOITE From GESECRAN" to show a popup window with a progress bar while doing some stuffs. How can I show the same popup window but with 2 bars, the first for the main task and the second for the sub tasks? Thank you…

Many Windows 10 users are experiencing an Error code 20, this is caused by a Windows 10 update where the option Beta: Use Unicode UTF-8 for worldwide language support is enabled. Please follow the attached links to resolve the error: Error Code 20…

Hi, We have a string returned into an XML format the we store as Local Clbfile variable. What is the best way to get a string out of this variable? Kind Regards

Hi, How do I add multi-line text in classes and representations? I used to do this in the screen field (graphic object multi-line) Best Regards

Hi, How do I use IMPORTSIL in V7 classes and representations style coding? "Call IMPORTSIL("YBPP", WNOMFIC) From GIMPOBJ" doesnt work anymore. Best Regards

Hello, We are trying to add a customization to the Production BOM screen (BOD1), which adds the average cost from ITV onto the mask for the screen BOD1. I have written the following code: $ACTION Case ACTION When "OUVRE" : Gosub OUVRE When "LIENS…

Hello, First of all I have to say that I am a beginner on SAGE X3 environment, so it is possible I ask very easy question......sorry for that I have to read the content of an ascii delimiter file to generate accountancy entries on X3 V9 To do…

I have a stored procedure I would like to call to populate a work table as a preprocessor to an SQL client requester. Syntax would be helpful. Thanks SQL stored procedure call from X3