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

Debtors ageing Report

Hi experts,

I have a client that has configured the customers debtors outstanding report to appear together with the payments done. As r a Result the customer cannot see the debtors outstanding in the correct ageing baskets. Can any one tell me where i can modify the report to allow only the debtors values to appear in the report rather than the payment details to appear as well. The client is using SAP B1 2005 PL50

your valuable input will be much appreciated in this regard.

thanks

Asela

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 19, 2011 at 10:03 AM

    Hi,

    In the Aging selection criteria window, at the bottom there are three checkboxes. Please mark the one mentioning ' Include customers/vendors with zero balance' and leave the others unchecked and run the Aging Report to get the Open balance left for the outstanding invoices.

    Check if it helps.

    Kind Regards,

    Jitin

    SAP Business One Forum Team

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 19, 2011 at 10:09 AM

    Hi Asela......

    Are you talking about the modification of System Standard Report or you want to modify the user defined report that you prepared?

    Regards,

    Rahul

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Modify the standard system created Report. Currently its showing values within brackets which are payments done by the customers. I don't wont the customers payments to be displayed just wanted to show the debtors amounts in the correct ageing basket.

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.