How to sum some lines (in details section) of system layout of SAP B1 in crystal report 2011?

[former_member183402]

Hello,

I would kindly like to ask how to do a formula in a system layout to do Sum of all invoices(IN) and Incoming Payment(RC) in Customer Aging Report for all Customers. here's a screenshot I took please find it.

I want to sum amount of all RC 1 and to sum all IN documents, How can I do that in Customer Aging Report?

Thanks

Looking forward to your great help.

Best Regards,

[azizelmir · Accepted solution]

Hi Rurangwa,

Please check this solution.png

1- In section "details d" create this formula SUM_ALL_INandRC1 and make it invisible:

Shared numbervar total;
IF left({PLD__ITEMS.F_34},2) in ('IN';'RC 1') 
    then total:=total + If NumericText({@F_38}) then toNumber({@F_38}) else 0

2- In section "details g" create the second formula: Tot_IN_RC

shared numbervar total;

Hope this helps you.

Aziz

[former_member183402 · Accepted solution]

Thank you so much Aziz,

You solved many different issues for me