Need help with new custom field formula. I create custom field "Net Available Stock"
I have added the custom field to below screens, functions. now I need the field to work accordingly. I create a custom script for net availability and still having…
Does anyone have a sample C# example of how to insert a customer into the AR Customers section of Sage 2017 ?
I have the Visual Basic macro sample, but it looks so complicated, don't know where to start.
Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement.
mDBLinkCmpRW.OpenView("CS0120", out csQry);
sSQL = "Select Name, Description from MYDB.dbo.Table";
csQry.RecordClear();
csQry.Browse(sSQL, true);
…
BOMs
I am trying to add a custom long description field to our Manufacturing BOM screen (BOH0) and receiving this error -
I've added a "Before Field" Action to the ITMREF field and added this as the script.
Subprog AV_ITMREF(VALEUR) Variable…
Hi, I encounter this odd behavior while creating a macro to do an OE Invoice Entry. I did not even set the "HDRDISC" value but this error 1144
" Invoice Detail
Attempt to change read-only field 'Header Discount'. "
keep popping up and I am not able…
Hi everyone:
I have a macro that prints invoices to preview destination ; in past versions I was selecting what invoices are printed by changing the @Selection_criteria parameter and was able to print a particular invoice, group of invoices not in a…
Hello all,
Is there any possible way to automate the Sage 300 item number change process? I know there's a way to automate the database dump (using OrchidSystems Process Scheduler) prior to running it, but having the ability to schedule the item number…
Hi,
I would like to know if there is a way to increase the number of buttons showing on the screen header. As example:
On Suppliers, I added 2 new buttons, Test 1 and Test 2, but on the header there are only 3 buttons
----------------------…
The requirement is to print the company name, address, and contact details of the party responsible for paying for duties/taxes on a delivery. This may be different than the BPC listed on the delivery record.
I am trying to add a BP number and related…
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…
Good day everyone,
I am Manuel a rookie in the use of Sage X3. Fortunately over time have gotten myself familiar with the Interface and workings of the ERP system but on the development part have been stuck with a few challenge and hoping get it it…
i want to know the status of my 3rd period in 2014 is locked or not
i had tried using code below
Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE)
Dim mDBLinkSysRW As AccpacCOMAPI…
I'm trying to insert a new block into the SOH1 screen, but no matter how I set the positions they are not interpreted the same way the function help describes (using the "grill").
Given these 3 blocks:
BP, Position 1.1, line 1, col 2, sequence 5…
Hi,
The requirement is to to be able to run the Crystal Report on a preset day and email it out - without manual intervention. The report is not parameterized. I have hard coded the dates.
Is this possible using Windows Task Scheduler or is there…
Does anyone know how to do the above? I've been asked to update the column names on the invoice screen to reflect what our users actually call it but can't seem to find a way to do that. I've tried updating the title, abbreviated title and the long title…
