Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to get a Report for a past date.

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

replied

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 :

Vendor Ageing & G/L account

Hope it helps.

Kind Regards,

Jitin Chawla

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question