ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> File for crystal reports
http://www.istechforum.com/YaBB.pl?num=1237846599

Message started by dashdown on 03/23/09 at 15:16:39

Title: File for crystal reports
Post by dashdown on 03/23/09 at 15:16:39

Is there a file that I could use for a crystal report that contains the invoice number and amount the customer has paid on that invoice? I don't think BKARINVT will work because the invoice number gets set to 0 when the invoice is paid. Any help would be appreciated. ::)

Title: Re: File for crystal reports
Post by cathyh on 03/23/09 at 15:21:06

I think you are looking for BKARHINV.

Title: Re: File for crystal reports
Post by dashdown on 03/24/09 at 05:52:17

Does BKARHINV have a field that contains the amount the customer has paid on that invoice and if so, which field is it?
Thanks

Title: Re: File for crystal reports
Post by GasGiant on 03/24/09 at 05:59:43

No, the amount paid on the invoice comes from BKARINVT. The amount remaining, if any, will be listed there.

Title: Re: File for crystal reports
Post by dashdown on 03/24/09 at 06:06:13

But doesn't the invoice number get set to 0 in BKARINVT when the invoice is paid?

Title: Re: File for crystal reports
Post by GasGiant on 03/24/09 at 08:26:08

Um, no. The payment record has an invoice number zero, but the invoice keeps its number. Payments reduce the BKAR.INVT.AMTRM field and get inserted just after the invoice. It is a very orderly table in raw form.

Title: Re: File for crystal reports
Post by dashdown on 03/24/09 at 08:51:07

OK, I got it. Thanks