Statements in Crystal

[mahdvic]

I'm attempting to create a Statement using Crystal, i'm having a difficult time trying to show just the open items from the aropnfil. Does anyone know of a way I can tell what invoices have been completly paid.

Thanks

 

[MacolaHelp]

There is no flag in the ar open file to set a fully paid status as you can reapply documents at any time until they are purged. If amt 1 + amt 2 are applied equally to a document with an opposite sign such as CM or PMT, then the document doesn't show as open. If you really want to dig into the formulas, check the ICR for ARAGERPT. There are about 50 formulas in there you can borrow or maybe you can modify the ICR to do what you want.

 

[tpllc]

What are you trying to accomplish with the crystal report aging? You could also use the ICR statement. If you are looking for a form to print with the Progression statement there is a product called Check Factory and Transmit that will do that and also allow you to e-mail or fax directly from Progression to you customer.

Steve Henley
trianglepartners.com
Exact Software consulting, sales and implementations.