I have been using Quik Reports for about 10 years, and have found it to be a very versatile product. However, I recently installed Invoice Sales History (an add-on product from Softline), and have had difficulty generating reports from this module. I have reinstalled both programs a few times -- and still cannot generate a report as follows:

The table for Invoice History (6.1C) is the table that I am using. There are three choices: Header / Detail / or Total section.

My problem is I am unable to generate date or print data from the detail area of the invoice history data files. For example, I wish to generate a report that will give me all the purchases made by a specific customer over the last 12 months. Therefore, I would choose from the following fields:

From the Header:

Customer Number
Invoice Date
Invoice Number

From the Detail section:

Item No.
Item Desc.
Item Category
Qty Shipped
Price

I am able to generate reports by pulling the info from the Header fields. The detail area, however, remains blank. I can't seem to be able to pull the item no. / desc. / qty shipped and price fields.

I do receive a message as follows, "Not all data in report is related".

What am I doing wrong? Do you have any advice?

The message that you are getting, 'Not all data related', is indeed important for the reason your report on Invoice History is not working as you were hoping. This issue has to do during installation when the table is compiled. Not only is the table copied into the \QRASP directory, but other files are updated to allow Quik Reports to know how these files relate to each other and with other Accpac data. This problem is that these 'linking' files are not updated correctly and Quik Reports can't find the correct relationship between the Header and Detail information. This is why a report using only the Header or Detail will work, but a report using 2 or more files will not.

As mentioned previously, the linking information is updated during installation of the product. Because Invoice Sales History is a '3rd party product' from Softline, ISH is what installs the tables and related information.

Here are a few things to look at:
1) Make sure the table named 'QRTIH61C.ld4' exists in the QRASP directory on the drive where your Accpac programs are. This is the table Quik Reports uses to report on Invoice Sales History data. The actual table tame may be QRTIH61B, if the data in version 6.1B has the same structure as 6.1C
2) Open Quik Reports and go to the Options menu and Install Data. Make sure that the table named 'Invoice History' is selected.
3) Close Quik Reports and open a DOS prompt. Go to the QRASP directory on your Accpac drive. From here, you can run a ulility that tells you if the table is set up correctly, called 'QRCARD'. To run, type at the DOS prompt:
QRCARD QRTIH61C.ld4 (or QRTIH61B.ld4 if that is the table you have).
This will create a text file with the same file name as the table, but a CRD file extension. You can edit this text file with Word, Wordpad, etc. There should be 2 sections in the file. The first section will list all of the fields that are available for using in Quik Reports. Some fields will have a single Capital letter next to them, indicating this field is available as a 'link field'. The second section will list all of the fields that are available for linking, and will be labelled with the same A, B, C, etc. If you do not have this second section, and there are no letters in the top section, then you can be sure the table did not set up as it should.

The usual solution to fix this is to reinstall the 3rd party application, in this case Invoice Sales History. You should not have to reinstall Quik Reports in this case. You are not doing anything wrong at all; some supporting files have not been updated as they should and this is preventing you from getting what you need for your report.

If it turns out the installation is the cause of this problem, please let the Webmaster know and we'll see what can be done. The solution may be to have you 'manually' install the table. Don't worry about that bridge until we need to go there...

Also make sure you are using the table called 'Invoice History'. There may be another table with a similar name 'Order History', but this is not the correct table to use.

Hope this helps out.
Regards,
Softrak Support

[This message has been edited by Webmaster (edited 11-29-2001).]

Thanks for the follow-up information.

If the data structure of Invoice Sales History 6.1D is not different than version 6.1C, then the table name being QRTIH61C won't be the problem. If the data is the same for two different versions of a program, then the same table will be able to read either version in the same way.

If you had to convert your data after installing ISH 6.1D, then this is a different matter, and a new table would have to be created and installed.

Compatibility with report writers such as Quik Reports works a little differently than compatibility between other programs. As long as a valid table exists and gets installed properly, Quik Reports can be compatible with virtually any version of Accpac Plus program.

Let's try this. In the QRASP directory, do you have a file QRTIH61C.TXT? This would be an uncompiled version of the table. Perhaps this file exists on your Invoice Sales History diskette? If so, copy it to the QRASP directory.
Now we can try and compile the table manually. Open a DOS prompt and go to QRASP, similar to what you did for QRCARD earlier. There will be two functions to run:

qrcomtab qrtih61c.txt
qrbuild qrtih61c.txt

The first compiles the table, and the second builds it and connects it to the rest of the programs. In QRBUILD, you may be asked to build a block that doesn't exist, and this is something you want to do. Say Yes each time this question is asked.

If it doesn't work the first time, sometimes you have to give is a second try.

Regards,
Softrak Support