MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Reference > Common Features > Key Concepts and Procedures > Sample BPM Extract Programs > Overdue Purchase Orders (CF900E, CF900CLP)

Overdue Purchase Orders (CF900E, CF900CLP)

 

 

This program extracts open or released purchase order release lines which have a non-zero balance due quantity and a dock date less than or equal to today’s date.  Phantom purchase orders are not included. 

Before extracting new event information, this program checks if the information has already been extracted.  It does this by checking the detail event information for each overdue purchase order.  If this data matches the 40-character event detail information for a previously extracted event, the record is not extracted.

On the Event Maintenance Detail screen for this event type, the replace flag should be set to Y.

Route Based On Information

      Receiving company, receiving warehouse

Event Detail Information (40-character user-defined field)

      Purchase order number, purchase order line number, buyer code, part number, and dock date

Control Value Information

      Balance due quantity

Action Codes and Fast Path Information

 

Conversation

CL Program

Fast Path Information

1.  Purchase Order Inquiry

PO880CLP

(po #/po line #)

2.  Purchase Order Maintenance

PO180CLP

(co/whs/po #/po line #)

3.  Vendor Inquiry

CF810CLP

(vendor #)

4.  Item/Vendor Relationship Inquiry

PO840CLP

(co/whs/vendor #/item)

5.  PO Receipt Administration

PO210CLP

(co/whs)

6.  Receipt Quantity Control

PO220CLP

(co/whs)

7.  Multi-Line Receipt Maintenance

PO270CLP

(co/whs)

 

 

WILLIAMS                 BUSINESS PROCESS MANAGER                     4/20/95

 DSP01                         EVENT MAINTENANCE                   EVENT DETAIL

                                                                               

 Type    PO1  Desc         OVERDUE PURCHASE ORDERS                             

 Extract Name  CF900CLP                 Extr Type     PGM  RPG PROGRAM         

 Replace       Y                        Extr Freq Cd  DLY DAILY                

 Extr Day Nbr                           Extr Freq Mn                           

 Last Extract   4/17/95 15:00:53        Next Extract   4/18/95  0:00:01        

                                                                               

 Action Code 1 007 PO INQUIRY           Action Code 2  006 PO MAINTENANCE      

 Action Code 3 011 VENDOR MASTER INQUIR Action Code 4  012 ITEM/VENDOR ANALYSIS

 Action Code 5 008 PO RECEIPT ADMINISTR Action Code 6  009 PO RECEIPT QUANTITY 

 Action Code 7 015 RECEIPT MULT-LINE QT Action Code 8                          

 Action Code 9                          Action Code 10                         

                                                                               

 Auto Action                            Immed Delete                           

 Sort Sequence DSC DESCENDING                                                  

 Control Value Description           Balance Due Qty                           

 Route Based on Description          Receiving Co/Wh                           

 Headings                            PO #    Ln  B   Item #          Dock Dt   

                                                                               

 F3=Exit             F4=Prompt           F10=Function Select F12=Comments      

 F15=Rekey Data                                                                

Event Maintenance Detail Screen for the Overdue Purchase Orders Event.