Issue

 

When trying to reconcile Accounts Receivable (AR) cash receipts in Bank Reconciliation, ARCASH records ARCASH are not getting marked with a “Y” in the ARCASH.Apcode field; even though the records have been copied to the APRECO table. The following steps describe the problem:

1. In the AR module, enter a cash receipt.
2. Open Accounts Payable.

© Copyright Sage Software

1. Under the Maintain menu, point to Bank Reconciliation and click Reconcile Accounts.
2. In the Reconcile Accounts option grid, leave all settings as default and click Proceed.
3. In the next screen, select Current A/R Cash Receipts File.
4. Click Save.

At this point, the cash receipt records in ARCASH will be copied to APRECO. and the ARCASH.Apcode field should be marked with a “Y” to indicate that the records have been recorded. Instead, this field is not updated and the each time the steps above are performed, the AP Bank Reconciliation feature will record duplicate cash receipt transactions into the APRECO table.

Solution or Workaround

This issue may be caused by duplicate ARDIST.Tranno values.

The program code that marks the ARCASH.Apcode field with a “Y,” compares to see if the following condition is true:

ARCASH.Ctranno = =  ARDIST.Tranno

If true, the program gathers all the records in ARCASH that have a corresponding record in ARDIST and groups them together. These grouped records are then copied to APRECO and ARCASH.Apcode is marked with a “Y” so that these records will not be copied to APRECO a second time. However the duplicate ARDIST.Tranno values confuses the program and it does not know which corresponding ARCASH record to mark. Therefore the code fails to execute and no value is written to the ARCASH.Apcode field. As a result, the ARCASH records are continually copied to APRECO.

In one reported case, the ARCASH.Ctranno value was incorrectly reset and two range of numbers existed: 70,000 and 5,000. When the records were copied to ARDIST.Tranno, the 5,000 range was used and the range would reset to 70,000. The ARDIST.Tranno field would be populated by this range and ARCASH.Ctranno would reset back to the 5,000 range. As a result, there were duplicate ARDIST.Tranno values for each cash receipt records.

To resolve this issue, the Ctranno value in the SYSDATA.Int2 field should be updated to use a value greater than the largest ARDIST.Tranno value.