We are working with Accpac Plus and QuikCheck Plus for Windows 6.1B. We have entered the cheques for one month in a batch in QuikCheck and we are having problems transferring the batch to Accpac. We want the batch to transfer to Accpac in one Accpac entry and with only one transaction entry to the bank acount. We also want the entry to transfer in cheque number order (the same as we had entered in Quikcheck).

When we do the transfer, it comes across in one batch, but with many Accpac entries. The description for most items is "consolidated posing" which is not acceptable and the sort order is not by cheque number.

We have tried sorting the G/L transaction report different ways but cannot get the transfer to appear in the correct format.

Please advise what can be done to have the transfer complete in the format we require.

Hi John,

If you want all the GL entries to the bank account to be consolidated into one entry, you can do this in either Quik Check for Windows or Adagio Checks. To do this, go to the Company Profile and on the Interfaces screen, select the option 'Consolidate Bank Account'. This will consolidate the bank account entry when you post check batches, and maintain the detail for the other transactions. Note that this setting will not influence checks that have already been posted, but only for checks that will be posted in the future.

What you may have done is printed the GL Transaction Report and consolidated the detail to some degree, changing the structure of the GL information. Once this is done, the detail cannot be restored. This is how all Accpac Plus sub-ledger programs work.

Because your GL is likely version 6.1A or higher, the GL transaction report will contain details for every posted check. You may be used to something different for levels of GL 6.0 or earlier, such as what Quik Check for DOS did. The GL6.0 style of GL detail cannot be replicated with multiple vendors/dates in a single entry.

Also, as with all other Accpac Plus programs at 6.1A or later, the GL transaction report from the sub-ledger program can be sorted by Account, Entry, or Date. There is no provision to sort by Check Number (or reference). The closest you can get is sorting by Entry, which will match as long as you post your batches in the same order as the checks are numbered. Check number order does not matter once the subledger is retrieved into GL.

Regards,
Softrak Support