MAC-PAC Homecontact ussupport login 
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

 

Conversation

CL Program

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.