Skip to Content
avatar image
Former Member

monthly outstanding statements

HI all,

When printing customers' monthly outstanding statements, how do I avoid printing customers with a credit balance?

Thanks.

Chloe

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 09, 2008 at 12:42 AM

    Hi Gordon,

    I am new to SAP. Can you be a little more specific about where I can find credit balance field in the PLD?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 03:44 AM

    Hi Chloe,

    You can modify your PLD and set the credit balance field invisible based on the sigh of the balance amount.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 05:51 AM

    The Report Selection parameters do not have an option to filter Credit Memo's out from the Report.

    One way to control them would be to use Forumula's in your PLD and associate all the fields on the row to not print when the Values is ➖ negative . Or when the DocType = 'CN'

    Suda

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2008 at 06:11 AM

    Hi Chloe,

    You can also use filters in the Aging report to see the Business partners with values greater than zero before printing.

    Regards,

    Preety Goel

    SAP Business One Forums Team

    Add comment
    10|10000 characters needed characters exceeded