Recent content by robhob

G'day! I've got an unusual situation. We backup our MySQL databases every night. The backup is done by copying the folders containing the database files (MyISAM on a Windows 2000 server) to a temp folder. They are then zipped and FTP'd to a server at our offices. If I then unzip the database...

When I try AR0055 I get the following error "Invalid object name 'AR0055'

Thanks Ettienne. I thought as much. I'm trying to programatically calculate the 30/60/90 values per debtor. Any tips?

Hello I've read a number of posts where people refer to an "AR Aging Report". Where do I find this report in v5.4A? Thanks Rob PS. Excuse my ignorance - I'm not an ACCPAC guru or an accountant.

Hi tuba2007 Thanks again for your expert help! Greatly appreciated. Have a good one. Rob

Hello I'm having an issue importing data into ACCPAC 5.4A SP3. I'm working with code created by someone else and I'm not too sure what the layout of the CSV file is supposed to be. The file seems okay but when I try and import it I get the following error: Invoice total amount [910.02] does not...

Oops - I should have done a more thorough search of this forum. I found the solution: ettienne (TechnicalUser) 14 Jan 09 10:32 Install the system manager service pack and run REGACC. Thanks Ettienne Cheers Rob

G'day all. I've got a problem logging on to ACCPAC 5.4a. After entering my password and pressing enter I get the following error: System error. Cannot connect to Sage Accpac Signon Manager. Any ideas? Cheers Rob

Unbelievable! You're a star!!! I've only recently been asked to help with ACCPAC support... I don't have any ACCPAC background so I'm learning on the fly. This forum has been a great help. Thanks ettienne

Hello I'm able to do everything except it seems like I can only add one entry to the "Assign UI Profiles" screen. Any ideas? Thanks Rob

Hi DjangMan I tried it but it didn't work. The report wouldn't even run in ACCPAC! It worked in Crystal Reports. Thanks for the tip though - great minds!

Hello I've figured out that the easiest solution to my problem is to copy the report and modify the command on each copy to begin with the sql statement USE dbname. This way I don't have to redesign the report each time modify the ODBC connection. So at the end of the day, each report uses the...

Thanks tiba2007 I just create a copy of the report for each company. Have a good one. Rob

Thanks tuba2007 I tried your suggestion but unfortunately it didn't work. The ODBC on the subreport doesn't get updated... Anyway, thanks for all your time and trouble. If I find a solution I'll post it here. Rob

Okay! I've just done a simple experiment. I created a report in Crystal that pulls data from the ARCUS database using an ODBC connection. I ran it from two different companies and it worked! It gave me distinct data for each company. It worked with AND without the CMPNAME parameter. The problem...