Reconciled amounts appears in customer aging report

[Former Member]

Dear all,

When we take aging report for reconciled transactions,reconciled amounts appears in

aging days ,the invoices which are reconciled still showing in Aging report (Suppose we have ar invoice in 0-30 days and its payments (journal entry ) made in 30-60 days it's

already reconciled)

Why it is showing in reconciled aging report ?

I am using B1 2007 Pl 17

Regards

Saurav Gupta

[K_Pauquet]

Hi Saurav Gupta,

the ageing report allows you to pinpoint open transactions at a particular date.

Consider this:

System Date (Today) : 08.08.2011

Ageing date 01.08.2011

Invoice Posting date: 20.07.2011, due date : 31.07.2011

Payment Date for invoice 02.08.2011

You allow documents to be considered up to the ageing date.

-> The invoice above, although fully paid, will be shown as overdue since you are ignoring all transactions after the ageing date. As far as the report is concerned, the payment hasn't happened yet.

With these options, the invoice will be shown as well:

System Date (Today) : 08.08.2011

Ageing date 01.08.2011

Invoice Posting date: 20.07.2011, due date : 31.07.2011

Payment Date for invoice 02.08.2011

You allow documents to be considered up to the system date & choose to display reconciled transactions.

-> all documents up to today will be taken into consideration, meaning that both the invoice & the payment are shown in the report.

To see the true open documents today, choose these parameters:

System Date (Today) : 08.08.2011

Ageing date 08.08.2011

You allow documents to be considered up to the system date & have all tickboxes unchecked.

Also, please upgrade your system at the earliest convenience, you are using a very old version.

All the best,

Kerstin

[Former Member]

hii all,

thanks for the answer.....I will try upgrade the system ASAP.

Regards

Saurav Gupta

[Former Member]

Hi Saurav.........

Please check the proper parameter for the Reconciled Amount to be displayed in Aging report is selected or not........

Regards,

Rahul

[jitin_chawla]

Hi,

Please check the following :

1) In the Aging Report selection creteria window, please confirm whether you have selected the checkbox 'Display Reconcilied transactions'? Run the report without selecting the checkbox.

2) Please check whether the status of the Invoice is closed or open. You can check the same by right click on Invoice and 'Applied Transaction'

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi Saurav Gupta,

It might be by bug. You may try in test environment to reproduce it.

Better option is to upgrade your system. 2007 version support will be ending soon.

Thanks,

Gordon

[Former Member]

hii gordon ,

If it is a bug then how can we can rectify it .In my case if i Reconciled the invoices with INcoming payment then it get cleared ...

and if I reconciled through je then it is showing both invoice amt as well as Je amount (-ve ) in aging report

This happens from the start of this fiscal year (1/4/11) ...before this period ...when we reconciled the invoice it always get cleared .

Regards

Saurav Gupta

[Former Member]

If it is due to bug, you can do nothing other than upgrade. However, if your previous year no problem, check your current year settings.

[Former Member]

What selection criteria are you using in your aging report?