ISTech Support Forum - File for crystal reports

Welcome, Guest. Please Login.

	06/07/25 at 05:01:16 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Accounting

‹ Previous topic | Next topic ›

Pages: 1

Send Topic

Print

File for crystal reports (Read 773 times)

dashdown Full Member Be alert. The world needs more lerts. Posts: 189 Gender:	File for crystal reports 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.
Back to top	IP Logged

cathyh Active Member I used to be indecisive; now I'm not so sure...... Posts: 1210 Gender:	Re: File for crystal reports Reply #1 - 03/23/09 at 15:21:06 I think you are looking for BKARHINV.
Back to top	Cathy Hamilton Wing Inflatables, Inc. EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09) Windows 2008 Server/client Pervasive V10.1 IP Logged

dashdown Full Member Be alert. The world needs more lerts. Posts: 189 Gender:	Re: File for crystal reports Reply #2 - 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
Back to top	IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: File for crystal reports Reply #3 - 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.
Back to top	IP Logged

dashdown Full Member Be alert. The world needs more lerts. Posts: 189 Gender:	Re: File for crystal reports Reply #4 - 03/24/09 at 06:06:13 But doesn't the invoice number get set to 0 in BKARINVT when the invoice is paid?
Back to top	IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: File for crystal reports Reply #5 - 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.
Back to top	IP Logged

dashdown Full Member Be alert. The world needs more lerts. Posts: 189 Gender:	Re: File for crystal reports Reply #6 - 03/24/09 at 08:51:07 OK, I got it. Thanks
Back to top	IP Logged

Pages: 1

Send Topic

Print

ISTech Support Forum › Evo-ERP and DBA Classic › Accounting

‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge