Search results for query: *

Looks like my salesperson id on the rm20201 file is not populated, that's why the query never finished, it was doing a table scan. ANyway, is there another file I can link to to get the salesperson id and match it to the rm20201 and rm20101 files?

My updated query looks like below but it takes forever to process(I have to cancel it before it finishes), is there a limit on btrieve as far as the number of tables you can include on a select? SELECT RM20101."CUSTNMBR", RM20101."DOCNUMBR", RM20101."POSTDATE", RM20101."ORTRXAMT"...

Thanks for the posting , I will try that.

Looks like they never ran that "paid transaction removal" program, is it possible to get all the data I need from the op[en file instead(rm20101)? I just need the amount paid, invoice number, customer number and salesperson id to link it to the salesperson master and get their name. Ideally the...

quick question, whn you create the odbc dsn as a system dsn on the remote clients, are you able to succesfully connect to the database?

thanks for the reply, strangely emough the file in my system is RM20201, RM30201 is empty. Maybe we have different versions or different implenentations. Anyway, for the crystal report it needs to have a link to the salesperson file as well as to the invoice master(names are my own) so the query...

No, I don;t think it does have Smarlist. In the meantime, I found a posting which makes reference to rm30200 which has records marked with a 1 in the doctyp filed, indicating they are invoices and a docnumber field which contains the invoice number. I'll try that and post my results here in case...

Is there a table containing payment history data along with the invoice number in Great Plains 5.5 using bTrieve? This is so we can pay commisions based on what's actually received intead of what's sold. I've seen a few candidates using the Report Writer but nothing I can use yet. Any help would...

Looks like there;s plenty of useful advice here, that's why I decided to post my question. I'm trying to run a Crystal Report 7.0 on a GP Dynamics v5.x with Btrieve as the DB. There is an ODBC user DSN but I don't know the password to run the report. As a GP newbee, just started working for...