monthly outstanding statements

[Former Member]

HI all,

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

Thanks.

Chloe

[Former Member · Accepted solution]

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?

[Former Member · Accepted solution]

You can check this thread to have more info regarding the condition setup in PLD:

If you still have question, keep posting.

Thanks,

Gordon

[preety_goel]

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

[former_member583013]

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

[Former Member]

Hi Suda,

Can you guild me as to how to write that formula?

Thanks.

Chloe

[Former Member]

Hi Chloe,

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

Thanks,

Gordon