Recent content by NeilN

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...

Entering an invoice manually works.

Ok, a new tax group was created. I went into ACCPAC, pulled up the customer record, changed the tax group, saved, reverted back to the original tax group, and saved again. Still get same error. I then changed the tax group for the customer and did not change it back. Same issue. Any other...

Customers are created using the API. I've read enough posts on here to firmly realize that directly updating the database is Not a Good Idea :-) Regarding tax group, I know but there are procedures... ARCUSTOMER1Fields("IDCUST").Value = "W" + CStr(rsClients.Fields.Item(0).Value)...

The customers *are* being created through automation. I'm waiting for the accounting group to create a new tax group so I can test etienne's suggestion. The strange thing is, the other two databases also have automated customer creation and invoice creation works fine in them. If etienne's...

I apologize if I'm misunderstanding you. I went to the A/R Customers module, pulled up the customer and went to the invoicing tab. The Tax Group is GPST. I cannot change or delete this as there is only one Tax Group set up. I reselected it and saved the record. The same error occurs.

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...

AR. Thanks very much!

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?

Thanks. I will see if we can move the ACCPAC client to a box in the datacenter.

The SQL Server box is offsite. Users connect from the office via a dedicated VPN tunnel.

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...

Thanks ettienne and tuba2007. The upgrade was fairly painless.

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?