cancel
Showing results for 
Search instead for 
Did you mean: 

How to get a Report for a past date.

Former Member
0 Kudos

Hi

Is there a way to get a report for a past date in SAP B1. For example I want to take a print out of Customer Receivables Aging Report for 30.06.2008 (Not the current Report.) without rolling back to that date from a backup.

Thank you very much

Sanjaya

Accepted Solutions (1)

Accepted Solutions (1)

jitin_chawla
Advisor
Advisor
0 Kudos

Hi Sanjaya,

You can get the past dated or the backdated aging report by taking the relevant dates in the Aging report selection criteria window.

For backdated aging report you can refer to Note No. 800294

Example:

Today is the 12.12.2007, I need to see the ageing report for open customer receivables on 30.11.2007. Between the 30.11.2007 and 12.12.2007 some of the then open invoices have been paid.

Reports => Financials -> Ageing -> Customer Receivables Ageing

Set 'Ageing Date' last date of the period, here 30.11.2007.

Set 'Posting Date' from '01.01.2007' (= Start of fiscal year) to

'30.11.2007'.

Bring tab 'By Journal Postings' into the foreground.

Tick boxes 'Display Customers with Zero Balance' and 'Consider

Reconciliation Date'.

Click on 'OK'.

This setting will generate an ageing report showing all AR invoices posted between 01.01.07 to 30.11.07 that are not reconciled on 30.11.2007.

You can refer to the following thread as well :

Hope it helps.

Kind Regards,

Jitin Chawla

Answers (0)