what file & field 1

[randva]

Macola 7.5.102e, Pervasive

I want to write a report to show all COD orders that have not been paid. (When we ship COD, it takes a week or so for the freight company to collect a check and forward it to us. Sometimes they forget to collect or lose the check).

The APOPNFIL looks like a good candidate. I can select by terms code and date. But how do I decide if there is a balance due? Is there an easy way to check?

Or am I looking in the wrong file?

Any suggestions are greatly appreciated.

 

[dgillz]

You are in the right place. You need to summarize by apply to number, and if the sum >0 there is a balance.


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown