Skip to Content
0
Former Member
Apr 13, 2009 at 06:32 AM

Table & Fields for Collection Amount

62 Views

Hi,

I want to create an ABAP report for invoice Vs. Collection. But getting stuck in 1 scenario.

Case: I have raised 2 invoices for a same client.

Inv No. Date. Amount

10000001 23.03.2009 100.00

10000011 15.04.2009 300.00

But I got a single collection cheque of Rs. 400/-

So I need to clear the 2 invoices against the collected cheque & pass a single entry in F-28.

After that my report show the values as

Inv No. Date. Amount Chq No. Chq Date. Chq Amt. Outstanding.

10000001 23.03.2009 100.00 1021 25.04.2009 400.00 -300.00

10000011 15.04.2009 300.00 1021 25.04.2009 400.00 -300.00

Which shows all total a wrong information.

For collection amount I am choosing BSAD Table with WRBTR Field.

Please suggest how to resolve this issue, where can I find the field in which table, which can tell me the bifurcation of collection.

Thanks,

Bidhu