Unpaid Invoice in ERDK table

[Former Member]

Hi,

I've to find the unpaid invoices for a business partner in ISU. Can anyone please help me to determine if an invoice is paid or not. I was looking at table ERDK but not sure whether it has a field which indicates this.

Thanks,

Gauri

[former_member587072]

Hey Gauri   ... ERDK will not have the paid status.   To determine if the customer has any unpaid invoices you'd select against DFKKOP for that BP and account checkng for open main txns 0100 (periodic), 0200 (final) and 0300 (manual billing).  

Joe

[Former Member · Accepted solution]

Hi Gauri,

Use DFKKOP table and field Augst = " " blank for unpaid items.

thanks

Prasad

[Former Member]

Thanks Joe and Prasad.

I guess this will work.