Sage 300

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); …

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…

how to retrieve vendor number values ​​on the PO Order screen using macros Thanks,

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…

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…

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…

Hello, I am trying to reduce the number of decimal places shown in the Unit Price field on my invoice template generated in Crystal Reports (a custom made OEINV.rpt) The field is currently showing six decimal places on items related to labour (i.e…

Hello, I am trying to reduce the number of decimal places shown in the Quantity ordered, quantity shipped, and quantity backordered fields on my invoice template generated in Crystal Reports (a custom made OEINV.rpt) Each field is currently showing…

i have the below Exception please any help ????