How to check a invoice is paid or not paid in qlikview

[tripatiqv]

Hi,

We are using SAP as erp  and we are getting amount from customer and it is stored in ACDOCA table 

and invoice to customer stored in vbrk table.

now our requirement is there any way to find the invoices which are not paid

for exemple

now first 3rs  1pen is sold to customer and invoice generated

then first 5rs  1pen is sold to customer and invoice generated

then first 8rs  1pen is sold to customer and invoice generated

suppose we recieved the 10rs from customer and 2 bill is generated for 3rs and 5rs 

now our requirement is how to track the inovice which is not billed in qlikview.

here  our result should be 8rs invoice.

Regards

Tiru

[chrismarlow]

Hi,

Do you mean allocate cash recieved to invoices on a FIFO basis (by customer), so you can show outstanding accounts recievable balance, or do you mean use QlikView to actually generate an invoice for outstanding customer debt (which seems unlikley)?

There are a number of threads on running balances in scripts that cover the former.

Cheers,

Chris.

[tripatiqv]

Hi,

Thanks for reply

For easy to understand

I have attached excel

which is having amount received from 2 customer   and invoices  done for customer.

our requirement is   we need yellow highlighted invoice as output.

these are all the invoices which are not paid. 

Thanks