Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. robhob

    Damaged Database

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

    AR Aging Report

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

    AR Aging Report

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

    AR Aging Report

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

    Invoice Entry Import Error

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

    Invoice Entry Import Error

    ...1,1,1,D0019,***NEW***,LABOUR CHARGES,,,W/END 17/08/2008,1,20080817,20080817,COD,VAT,VAT,798.26,798.26,111.75,798.26,910.01,910.01,20080817,910.01,910.01,AR 2,1,1,20,PP_HRS,TEMP POSITION: 2500,HRS,40.5,0,19.71,798.26,0,111.75,798.26,2,14,MKJEA HW - Normal Hours,1...
  7. robhob

    System error. Cannot connect to Sage ACCPAC Signon Manager

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

    System error. Cannot connect to Sage ACCPAC Signon Manager

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

    how to disable the "finder" beside the Customer No textbox on OE scree

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

    how to disable the "finder" beside the Customer No textbox on OE scree

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

    Crystal Report in ACCPAC

    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!
  12. robhob

    Crystal Report in ACCPAC

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

    Crystal Report in ACCPAC

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

    Crystal Report in ACCPAC

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

    Reporting: ACCPAC 5.4A + Crystal Reports 10

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

    Crystal Report in ACCPAC

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

    Crystal Report in ACCPAC

    Hi muhaidib As to your previous post, I also have the same problem. Crystal displays the information from the DNS! I've seen this CMPNAME thing on a couple of different forums but knowbody explains it properly. Hmmm... looks like we'll have to create a report for each company.
  18. robhob

    Crystal Report in ACCPAC

    Hi muhaidib I'm still trying to figure this one out myself. From what I understand you add a parmeter to your report in Crystal. The parameter doesn't get used in Crystal but ACCPAC populates it automatically when the report is run. I don't understand how or what Crystal is supposed to do with...
  19. robhob

    Reporting: ACCPAC 5.4A + Crystal Reports 10

    Surely if ACCPAC changes the ODBC connection on the fly it doesn't matter what or how the data is queried. Once Crystal has the ODBC source it gets whatever it's told to.
  20. robhob

    Reporting: ACCPAC 5.4A + Crystal Reports 10

    So basically I'll have to create a new report for each company if I use a custom query. Is that right? I've tried using the CMPNAME thing and it didn't work. I'm using a command to retrieve the data.

Part and Inventory Search

Back
Top