Documentation >
MAC-PAC Reference Library >
Reference >
Common Features >
Key Concepts and Procedures >
Sample BPM Extract Programs >
Matched Accounts Payable Invoices with Quantity Variances (CF925E, CF925CL2)
Matched Accounts Payable Invoices with Quantity Variances (CF925E, CF925CL2)
This program extracts records from the Joined Logical Invoice/Receipt Match and Invoice Line file (APIVDL1) which have a status of matched and a non-zero quantity variance and are new or changed since the last extract.
This event should be defined as a daily, weekly, or monthly event depending on how often you wish to analyze invoices with receipt quantity variances.
Note: Because the Invoice/Receipt Match file is never cleared, matched AP invoices with quantity variances will continue to appear in your mailbox even after they have been resolved. To prevent this, set the Replace flag to N and delete the event notification records from your BPM mailbox manually when you have resolved or taken action for them.
Route Based On Information
Company, location
Event Detail Information (40-character user-defined field)
Vendor number, invoice number, part number
Control Value Information
Quantity variance percentage
Action Codes and Fast Path Information
|
|
|
1. Accounts Payable Invoice Inquiry
|
AP800C
|
(vendor #)
|
2. Accounts Payable Invoice Entry
|
AP100C1
|
(vendor #)
|
3. Purchase Order Inquiry
|
PO880CLP
|
(purchase order #)
|
4. Receipt Inquiry
|
PO890CLP
|
(recpt #/recpt ln #/co/whs)
|
WILLIAMS BUSINESS PROCESS MANAGER 4/20/95
DSP01 EVENT MAINTENANCE EVENT DETAIL
Type AP2 Desc MATCHED INVOICE RECEIPTS WITH QUANTITY VARIANCE
Extract Name CF925CL2 Extr Type PGM RPG PROGRAM
Replace N Extr Freq Cd DLY DAILY
Extr Day Nbr Extr Freq Mn 1
Last Extract 4/20/95 3:50:02 Next Extract 4/20/95 3:51:00
Action Code 1 029 AP INVOICE INQUIRY Action Code 2 030 AP INVOICE ENTRY
Action Code 3 007 PO INQUIRY Action Code 4 031 RECEIPT INQUIRY
Action Code 5 Action Code 6
Action Code 7 Action Code 8
Action Code 9 Action Code 10
Auto Action Immed Delete
Sort Sequence ADS ABSOLUTE DESCEN
Control Value Description % Qty Variance
Route Based on Description Co/Loc
Headings Vendor Inv# Ln Rcpt# Ln PO#
F3=Exit F4=Prompt F10=Function Select F12=Comments
F15=Rekey Data
Event Maintenance Detail Screen for the Matched AP Invoices with Quantity Variances Event.
|