Forum - Receipts and payments not reconciling

Receipts and payments not reconciling

Cozatec Global User

2-24-20

Standard ERP 2020-01-07
Version 85330525 for Windows

A client reports this issue to us, and it can be duplicated on the test system.
This issue is with Module > Nominal ledger > Reports > Bank Reconciliation
Reconciled receipts and payments reflect as outstanding in the report.

For example, in Demo data
1. Create invoice 20.01.2020
2. Create a receipt for that invoice on 02.02.2020
3. Reconcile that receipt: Module > Nominal ledger > register > account reconciliation
4. Run report: Module > Nominal ledger > Reports > Bank Reconciliation > the receipt made on the 02.02.2020 reflects on the report as outstanding.

Please assist.

Michael W.

2-26-20

Hi there

We are aware of this issue and it is in the process of being fixed.

As soon as we have a version or build with this fix, we will update this post.

Best regards,

HansaWorld Support

Michael W.

5-5-20

Hi there

Please see below for a description of how the logic Account reconciliation works:

From Standard ERP version 8.5 2019-11-04 and higher

Nominal Ledger >>Reports>>Account Reconciliation

On the Account Reconciliation report, If a transaction has been reconciled (has a reconciled date) during the period specified in the report specification window, then it will be reflected in the “Reconciled During this Period” section of the Account Recon report, regardless of its transaction date.

For example:
Transaction S/INV.10000001:
Transaction date: 05.01.2019
Reconciled Date: 02.03.2019

Scenario 1:
When running the account reconciliation report, the period is set as 01-01-2019:28-02-2019
Transaction S/INV.10000001 reconciliation date does not fall within the period specified. It will therefore appear as unreconciled on the report.

Scenario 2:
When running the account reconciliation report, the period is set as 01-01-2019:31-03-2019
Transaction S/INV.10000001 reconciliation date does fall within the period specified. It will therefore appear as reconciled on the report.

Back to the list

New Message
Open Questions My Questions