Re: A/R receipts

Dan
 
OPENAR will only carry the invoice activity for unpaid AR invoices.  When the 
AR close is run the paid items are purged to ARHIST.  If you are looking for 
cash receipts after the AR month has been closed for a given period you will 
have to query over OPENAR and ARHIST.  In addition to that, you will need to 
qualify your record selection to caputer record codes 'RO' and tranaction types 
= 2.
 
The STATMT file is a good source, but it is cleared at the end of each month.
 
I hope this helps.....
 
Sincerely,


Dan Bale <dbale@xxxxxxxxxxxxx> wrote:
Looking for all receipts occurring in a given month. The month will
typically be the previous month before it is closed. So, today, I need all
of the receipts for June.

Found OPENAR & STATMT files, but the numbers are not what we are expecting.
Can anyone please advise?

Mapics/DB Rel4

TIA, db

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.




Sincerely, 

Richard T. Molder
President
Moldrich Solutions

Have a nice day unless you have made other plans.
                
---------------------------------
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!