We have been using Dynalynk for Excel v.5 to extract the GL accounts from ACCPAC Plus for the presentation of financial statements until we have upgraded our Excel to v.7 recently. As Dynalynk does not support Excel v.7, our local dealer recommended QuikLink as the simplest solution.

By following the instructions given by the dealer, we managed to convert our existing financial statements from the Dynalynk format into QuikLink format without changing any Excel cell formulae. The reports seem fined for companies without GL department. However, for companies with departments, cell formulae which point to a single account number is correct but not for the cell formulae which refers to a range of account numbers. For the latter, the answer shows a cumulative total of all the departments instead of the particular department.

A sample of the cell formula pointing to a range of GL expenses accounts for a particular department is:
=ACCPAC("gldata.M",$A69&"-"&$D$8)
where A69 point to the account numbers (610000-619999) and D8 refers to the department code (OL1).

The dealer informed that the problem lies with QuikLink for Excel v.7 which does not recognize department codes which are alphanumeric. We then tested a sample data with numeric department code but the answer is still wrong as before.

Please advise.

Thank you