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).]