Aged Received not Vouchered

[Bill Powell]

Does anyone out there have ideas on how to create an "aged" Received not
vouchered. We want to try to track our RNV by oldest first.

Greatly appreciate any assistance.

Bill Powell
IT Senior Business Analyst
Diagnostic Imaging, Inc.
Direct (904) 332 3246
Mobile (904) 537-7843




Bill Powell
IT Senior Business Analyst
Diagnostic Imaging, Inc.
Direct (904) 332 3246
Mobile (904) 537-7843

 

[Terry B]

Hi Bill

I'm assuming you're not concerned with "As Of" reporting, and just want receipts with outstanding Not Vouchered amounts (aka Open Receipts).

Join tables Purchase Receiver table F43121 and Order Detail F4311 by the following columns:
KCOO
DOCO
DCTO
SFXO
LNID

Select rows on the F43121 with Match Type (PRMATC) ='1', and where Open Amount (PRAOPN) is not equal to 0.
NB: You can also us the Open Quantity (PRUOPN) <> 0, but this is not so reliable. I use the Open Receipt amount as this should equal the balance on the GL RNV account.

Sort on column PDTRDJ, and this will sort by order date.
If you want to sort by the date of the original receipt, then just sort by column PRDGL and ignore the join to F4311.

I'm only doing this from memory so please excuse any mistakes. Please let me know if this helped.

Kind regards
Terry
PS: Our company specialises in RNV and Purchase Receiver software solutions.

OW XE SP14.2 ES=AS400 V4R5, DS=NT4.0 SP6.

Set up OW Security FAST. QSeries - For all your OW Security needs www.qsoftware.com/products/qseries/

 

[david_mallory]

Bill,

You can look at F43121 receipts, records with MATC = 1 (MATC = 2 =
vouchers), sort by DGJ GL date (date of receipt), look at AOPN $ not
received, and at UOPN units not received. MATC = 4 are receipt reversals,
which will also be needed in some groups of transactions to get the whole
"receipt picture". You can then look at (or join to) the F4311 order table
to get more info about a line (i.e. what item was ordered), although F43121
has a lot of information. The TRDJ order date field on F4311 can be
unreliable: we have seen it wander around for no known reason (weird). DGJ
seems to be stable.

The F43121 records with MATC=1 are the records that get created by the P4312
receiving program, and are matched to the invoice in the AP match process.
When AP goes to the "display receipts" exit in the voucher match program
P4314, the screen is a display of the records with AOPN > 0, for the
selected PO or vendor. Also, screen P43214 displays all receipts.

Dave Mallory Denver Water 7.332 SP 15.1 Oracle 8.1722 NT 4.0