Sage 300

I really want to get away from mailing printed checks. I have found a service provided by deluxe that allows emailed checks. Batches can be imported to their system using csv. I am looking for advice on the best practice work flow to make this happen…

I have a VBA Macro that runs via a VBA Script file triggered by Windows Scheduler daily. It, and three other similar daily Macros, run an their own Virtual Machine away from any pesky users. Every two or three months, the scripts stop running and I see…

I need to late bind an application because a number of users do not have Sage 300 on their desktop and I want to use COMAPI to communicate with Sage 300. I am stumped how to late bind AccpacCOMAPI.AccpacView. . If I try to Declare it as an object I…

I am looking at what options are available to eliminate the step of importing multiple batches into AR invoice Batches and AR REceipt batches. Currently we generate a import file from the Non Sage 300 product and the client imports the batch. Invoice…

Hello, Any recommendations for this add on other than Orchid? Ty.

Hi all, I would like to know if it is possible to create my own WEB API to get/post data with "GET/POST" method. I am trying to do something like this: - create a new table with roto ID using Orchid Extender - create my own API using Sage Web SDK…

Hi All, I have a custom table/view that I create using Orchid Extender module Table name: VIOEDEL View ID: VI0704 Is is possible to add view composition to custom view linking them by ORDNUMBER. I want to add OE0520 (ORDDH). The reason is…

Hello I Want to get the opened company id on my custom program, which argument can i use? i'm using Sage 300 2012

Using only the Sage 300 APIs which API call can I use to retrieve 'reversed' transactions? (Bank Reversals) In Sage I can see the reversals with a transaction type of 'Returned' on the AR Customer Inquery page but when I try retrieving the transactions…

I am receiving this memory error on both application servers when printing orders. Started with one user and now is affecting almost everybody who is printing orders. All servers and PrinBoss have latest updates. Reinstalled PrinBoss too and no luck…

I create a user in ACCPAC. But i can't execute my macro syntax. But if i change the user to Admin, its working fine. Can anyone help me? How to configure the new user, so i can execute the syntax

i want login using macro. but using windows authentication and specific domain can anyone can help me?

i have some code PORCP1header.Order = 0 PORCP1headerFields.FieldByName("RCPHSEQ").PutWithoutVerification("0") ' Receipt Sequence Key PORCP1header.Init() PORCP1header.Order = 1 temp = PORCP1detail1.Exists PORCP1detail1.RecordClear() PORCP1detail3…

I want to get value from PORCP1detail1Fields.FieldByName("ITEMDESC"). the condition that i have set if PORCP1header.Read how to get the previous data from that field and set into a variable in vb Example: Dim vItemDesc As String = "" vItemDesc…

I have Sage 300 ERP 2017 running on Windows Server 2016, and I am trying to communicate with the COM API with PHP. It works perfectly fine when run directly on the server where Sage 300 is installed. But when I try with any other computer, I am unable…

Hi, Is it possible that I could deploy the customized program (in desktop version, I just right click new >> program..) in Web UI? Thanks. Cinny

I've got a custom website that allows me to access various parts of Sage 300. I have moved it to a new server with a new version of Sage 300 and I cannot get it to work. I have a trial licence installed on Sage 300 and no module has an expired licence…

Good morning, i am looking for a process manufacturing add on for Sage 300. we need it to control mainly formulas and BOMs for a chemical production operation. Any suggestions will be appreciated.

Transaction not active when trying to update a view. Probably opened the database as read-only.

I have a C# application that connects to Sage 300. In versions 2012, 2014, and 2016. I just simply reference the correct versioned DLL files that come with the 300 install. When I try to reference the same DLL's for 2017, it does not work. I get a error…

Dear Team, Currently i have my own custom applications from Macro Records, and I have problem when i do Sage upgrade to latest version of Sage 300 i need to open my cording program and re-add the DLL files of Accpac.Advavantage.dll, Is there any better…

Does Sage 300 have a Work Order module? If not, could someone please recommend an Add On? Thanks

We currently use Sage 300 ERP for financials. Our MRP (Seradex OrderStream) will export daily AR/AP information and we import it into Sage via the appropriate forms Import. Our China facility is also using Sage 300 ERP for financials but they currently…

A client sends trucks out to locations to service HVAC equipment. They need software to schedule these visits as well as provide routing for each truck. Anyone know of any software that may (or may not)integrate with Sage 300?

I wish to create a AP aging dashboard in the Intelligence Reporting module. The issue is the table "APAGED" is only populated when the A/P aging report is run for all vendors. Hence if the report was run for one vendor that is what you will get when…