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!

  • Congratulations strongm 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. Relloc

    accpac macro

    You might be doing your development the wrong way around. Have your setup AR0032 in Budget and Info Management's Budget view type. This will be the first step to integrate the AR (A/R Invoice Batch Headers)and IM. You can also ask your Service Provider to contact Orchid on your behalf. They...
  2. Relloc

    Automate Day End Processing?

    Yes it was easy just record it. Problem however scheduling it when you do not have software to do it. I have converted the code to C# and compiled it into a Conlsole aplication and it works like a charm every Morning @ 1:00 AM The code can be optimized, I plan to ad paramters to the comand...
  3. Relloc

    sales forecast module for accpac 5.3

    The only Add-On I can think of is Orchid Budget and Info Management.
  4. Relloc

    is accpac ERP good?

    Thank you for your point Jay it really helped us with especially point 1. I am looking at Accpac from an End user / IT Manager perspective and not a dealers perspective. Accpac has an excellent foundation and we really enjoy working with the Object and Data Base in general. We have got 70...
  5. Relloc

    is accpac ERP good?

    Hope it is not too late. I am worrying if it's good or not? Have been working with Accpac now for 8 Years and my opinion is that there must be something better. It will however be a perfect fit if. 1. Accounting is your only concern. 2. You only purchase the GL, AP, AR and CRM. 3. Lots of...
  6. Relloc

    Batch import not working?

    Your BATCHID, BTCHENTRY in the Header is most likely not the same as the BATCHNBR, JOURNALID in the Journal_Details
  7. Relloc

    SQL EATING MY MEMORY

    It all depends on if you running CRM on your SQL box. http://www.sql-server-erformance.com/sql_server_configuration_settings.asp We had more or less the same problem and fixed it by setting the Maximum (MB) on MS-SQL Server
  8. Relloc

    Common Vendor Database to All Companies

    Hello Seisa I always the attached code to automate Export/Imports Sub MainSub() 'Declare variables here Dim bRet As Boolean Dim ReturnValue As Boolean ' opendb Dim OEImport As AccpacImportExport.ImportExport Dim result As String Dim Session As New...
  9. Relloc

    ACCPAC Modules question?

    Elaborate? In Short To quote ettienne (TechnicalUser) 13 Mar 06 14:24 Insights is an amazing product, but you must invest in some training to get the full benefit. It depend on your organizations IT background 1. You are running SQL sever and that means that you already can use Analysis...
  10. Relloc

    ACCPAC Modules question?

    Insight is Perfect for GL but for most other modules it is a Nightmare
  11. Relloc

    Aggregation Question

    Thejuan have jou found a sultuion I have the same problem with budgets that should be a month level but not on a DAY level
  12. Relloc

    ACCPAC EPOS question

    IF you R in South Africa I would recommend ISOPOS It integrated into PO, IC and OE It is a stable and easy to use POS that has a good reputation
  13. Relloc

    ACCPAC Union Query

    If you are running Pervasive 2000 load service pack 4 if you want any success. Or Try in MSDE linked server using MS SQL server instead. Regards Relloc
  14. Relloc

    Not able to create ODBC Connection to Pervasive 2000

    Your client installation would properly be in the following sub directory on your Pervasive server installation “C:\PVSW\Clients\Win\setup.exe” Just run and you should be fine Good luck RELLOC
  15. Relloc

    Database error (operation=REV-POST, error=2).

    Your problem might be related to a bad index on your Pervasive Database Above mentioned is normally solved by a rebuild on the affected module and if the afore mentioned does not work a dump and reload
  16. Relloc

    How to make macro call Crystal Reports?

    Hello David My notebook with my samples is going to be out of town for a week. In the meantime Have a look at the bas.avb macro. In the ACCPAC MACROS FOLDER You will find a 4.2 compatible finder and code to automatically update the xxRPT.INI so you don't have to do that during an install...
  17. Relloc

    GL Report Generator won't do "Performance Ratios"

    Dear Neil Since you u r a programmer why don’t you look @ the source data in the GLAFS It is usually quite easy to pick up where your data is going ‘wrong’. Accpac does have its own report writer using Excel and my impressions of it is more or les the same as yours. You do have 3 other...
  18. Relloc

    How to make macro call Crystal Reports?

    Dear David You can call your new Crystal report like any other ACCPAC report via VBA Provided that you have correctly made provision for the report in the relevant report ini file. If u use version 5 plus u can use the accpac fields to do lookups on date, customers etc If you want I can...
  19. Relloc

    Not able to create ODBC Connection to Pervasive 2000

    Hello ZABARVAN There are usually 3 X tricks to accomplish a client ODBC connection. 1. Do not install a pervasive engine it will slow down the workstation ! 2. Install at least Pervasive 2000 service pack 3 3. The target engine should be reverenced not by name but by IP address Good Luck RELLOC
  20. Relloc

    Getting unit price to match unit cost

    The only way I can think of is ... Create a Price list that is linked to the ICILOC via an Update Trigger on your Pervasive database unfortunately you will have to always run a day end to get the latest costs RELLOC

Part and Inventory Search

Back
Top