Skip to Content
author's profile photo Former Member
Former Member

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 22, 2008 at 12:33 AM

    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--gl-account

    Hope it helps.

    Kind Regards,

    Jitin Chawla

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.