Search results for query: *

A client recently had their ACCPAC 5.5 moved and upgraded to Sage 300 v2016. Now I'm getting an error on the last line: accSession.Init "", "AS", "AS1000", "60A" accSession.Open "ADMIN", "xxx", "CBCRA", Date, 0, "" MsgBox accSession.AppVersion Dim mDBLinkCmpRW As...

I've got a VBA script which inserts A/R invoices into ACCPAC 5.5. Works fine over the last four years for two databases (was tweaked as ACCPAC was updated). Now a third database has been set up and I get this error when inserting an invoice detail line: Tax class 0 is not in the range of 1...

ACCPAC 5.5 - Is there a field I can query or an API call I can make which will give me the balance (total charged - payments, write offs, etc) for every invoice?

One of my clients has upgraded to 5.5 and is complaining about how slow the Aged Trial Balances (among other reports) is to run. I've checked in SQL Server 2005 box and the processor barely hits 10% and there's plenty of spare RAM for caching. Their ACCPAC integrator states, "...Aged Trial...

One of our clients is upgrading from v5.3B to 5.5. Has the COMAPI changed in any way (specifically the functions used to insert A/R customers and invoices)?

For one of our clients we need to pull data out of their Pervasive ACCPAC db and into a SQL Server db on a different server (Windows 2003). What's the best way to do this? Do we need to install the entire ACCPAC client to get access to the ODBC driver?

This code has worked on two different clients' ACCPAC systems (with appropriate db/user/pw changes). Dim accSession As New AccpacCOMAPI.AccpacSession On Error GoTo ACCPACErrorHandler accSession.Init "", "AS", "AS1000", "53A" accSession.EnforceAppVersion = False...

Is there a API function that I can call that will give me the current A/R balance for a customer ID? If not, any suggestions as to how to get this info?

What's the proper syntax for opening a view with COMAPI and VBScript? This works in VBA: Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkCmpRW = accsession.OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE) Dim ARCUSTOMER1 As AccpacCOMAPI.AccpacView mDBLinkCmpRW.OpenView...

One of our clients wants us to integrate a custom application (SQL Server back end) with ACCPAC Advantage 5.2 (also a SQL Server back end). Basically we need to send customer info and invoices to ACCPAC and retrieve cash receipts info from ACCPAC. Doing straight SQL inserts is probably a bad...