Recent content by jjmbosslm

I have a report that prints multiple invoices. For invoices that span multiple pages, I want the table header to repeat on each page (includes address, invoice #, etc). If the last table footer is the only row left to print, the page breaks to the next page, but the table header does not...

Thanks for the udpate Right now, I don't think I want to go directly to the database. Our client is switching from prevasive to SQLServer and I also do not know what backend my future clients will be using. Why isn't the macro creating a script? Thanks

I'm sorry, I actually need the remaining balance of an invoice or list of invoices (if possible) The reason I need the remaining balance is because that is the value returned from the other accounting packages we interact with Thanks

I need to get invoice applied amounts back into my applications. I tried recording a macro from the customer activity screens, but the macro is always blank. Is this the correct location and/or method to find this information? Thanks

Thanks for your help. I am dealing with a client that is not too responsive to my requests. I now get Retrieving the COM class factory for component with CLSID {13898C04-C674-4B4E-B5C0-D78AF3E566CA} failed due to the following error: 80070005. I am working with AccPac. They think it is a...

Is it safe to uninstall it? I was trying to remember where they came from? The server I have my app on is not the AccPac server. Does this change the situation?

I am attempting to move my application onto a clients server. It references the AccPac.Advantage.dll, but it cannot find it on the server. Thinking they were part of the SDK, I installed the SDK on the server without any luck. How do I get these dlls? Can I just copy the dlls(from my dev...

Got it, thanks. I have been dealing with other priorities for awhile. Now I'm back to the remote connection. I used the database setup app to add a new SAMSYS and SAMINC connection on another server. When I attempt to login into Accpac to test connection I get the error that You cannot...

I need to post multiple invoices to a batch. Right now my code is creating a new batch for every invoice. I now in other Accounting packages we connect to we set the batch number on the invoice and they all get grouped together. Is there way to do that in AccPac or is it create the batch...

Thank you for your quick response

Great. Thanks again I have customer being created and updated. Now onto AR Invoices. I have my test invoice getting created. My question is, is using the account set the only way to set the AR recievables control?

I am now adding customer and ship to data. A couple of questions 1. This code below seems to work, but do you see anything wrong? 2. Is there a way for AccPac to auto assign customer ids and ship to loc ids? 3. If so what is the best way to retrieve this info after it has been inserted. 4...

I thought so too. This is what AccPac techincal help suggested. "You can just set the dblink objects to nil and the garbage collector will take care of the disposing it. There is no close method.

I don't see a close method on any of those objects.

Is there a close connection that I should be calling?