Chapter 32: Uploading PO Information (POUL)

Purpose: Use this menu option to upload purchase order information to the mainframe computer from the iSeries. You can create a menu option and add this program to a periodic process that runs nightly.

In this chapter:

• Purchase Orders Interface Upload Screen

• Creating the Purchase Order File

• Purchase Order Information File

Purchase Orders Interface Upload Screen

How to display this screen: Enter POUL in the Fast path field at the top of any menu screen or select the Upload PO Information to Interface File option from the menu.

POR0426 ENTER Purchase Orders Interface Upload 8/22/95 11:49:51 Mail Order Company Submit Batch Job to Upload Purchase Orders to Interface File. Press Enter to Confirm. F3=Exit F12=Cancel

Instructions: Press Enter at this screen to create a file that contains updated purchase order information, and includes purchase orders that have been approved (authorized/released), purchase orders that have been revised (canceled, date changes, etc.), and new purchase orders.

Drop ship purchase orders are not included in this file.

Creating the Purchase Order File

Purpose: Select the Upload PO Information to Interface File option and press Enter. This option builds a file containing all approved purchase orders that have been added, revised, or canceled since the last upload.

The file POUPWK (PO Upload Workfile), which contains a list of purchase orders and the last upload date and revision number, is checked to see whether the purchase order information should be sent. If there is no entry in this file for a purchase order and it is a new approved purchase order, it will be included automatically. This information is uploaded to the mainframe computer from the iSeries.

When you select this option, the existing PO information file is cleared immediately from disk. Then, the POFIL_LOAD job is submitted and program POR0425 runs when you use this option. This program creates the file PORCVI on disk in library CWMPDTA and copies it to library NDM15LIB.

On-demand: Follow these steps to create a menu option for this program, if needed. This allows you to create the purchase order upload file on-demand.

1. Select the Work with Menu Options option (WOPT).

2. Press F6.

3. Enter POUL in the Option field, Upload PO Information to Interface File in the Description field, P (program) in the Type field, POR0426 in the Program name field, N in the Authority parameter field, Y in the Company parameter field, P/O in the Appl area field, and POL in the Appl group field.

During periodic process: Follow these steps to add this program to a periodic process that runs nightly.

1. Select Working with Periodic Functions (WPER).

2. Press F6 to create a periodic function.

3. Enter PO_UPLD (or any descriptive name) in the Function field, Upload PO Information in the Description field, Y in the Company parameter field, All in the Appl area field, and POR0426 in the Program name field.

4. Select Working with Periodic Processes (WPPR).

5. Enter 7 next to the periodic process you want to add this job to, such as a daily periodic process.

6. Enter the sequence number (which specifies when you want this job to run during the periodic process) in the Seq# field, enter the name of the periodic function (specified in Step #3) in the Function field, and enter Y in the Select field (so that the job runs each time the periodic process runs).

Purchase Order Information File

CWDirect Fieldname	Field name in PO Information File	Field attributes	Valid values
Purchase order number	PO-ORDER-NBR	Numeric, 7 positions
	PO-DEPT-NBR	Numeric, 3 positions	Hardcoded to 509
PO Status	PO-ORDER-STAT-CODE	Alphanumeric, 1 position	Valid values include: A = Open B = Complete C = Cancel
	PO-TYPE-STAT-CODE	Alphanumeric, 1 position	Hardcoded to N
	PO-APPRV-CODE	Alphanumeric, 1 position	Hardcoded to Y
PO approval date	PO-APPR-GRP-DATE	Numeric, 6 positions (YYMMDD format)
	PO-APPRV-BY-OP-ID-CODE	Alphanumeric, 6 positions	Hardcoded to FOLIO
PO due date	PO-DELIV-GRP-DATE	Alphanumeric, 6 positions (YYMMDD format)	Promise date on purchase order header
PO cancel date	PO-CNCL-GRP-DATE	Alphanumeric, 6 positions (YYMMDD format)	Cancel date on purchase order header
PO cancel date	PO-VENDOR-CNCL-GRP-DATE	Alphanumeric, 6 positions (YYMMDD format)	Cancel date on purchase order header
	PO-ORDER-BULK-FLAG	Alphanumeric, 1 position	Hardcoded to N
Vendor file country code	PO-ORDER-FORGN-CODE	Alphanumeric, 1 position	D = Domestic: loads a D if Cntry (Country) field in Vendor file is ' ' or equal to the value in the Default Country for Customer Address (B17) field in the System Control file. F = Foreign
Vendor number	PO-VENDOR-NBR	Numeric, 6 positions
	PO-CNSGN-FLAG	Alphanumeric, 1 position	Hardcoded to N
	PO-ORDER-LOT-FLAG	Alphanumeric, 1 position	Hardcoded to N
	PO-PRI-TCKT-FLAG	Alphanumeric, 1 position	Hardcoded to N
	PO-OTB-SCHED-PCT1	Numeric, 3 positions	Hardcoded to 100
	PO-OTB-SCHED-DATE1	Numeric, 4 positions (YYMM)	Fiscal year and month, using the accounting period associated with the promise date
	PO-OTB-SCHED-PCT2	Numeric, 2 positions	Hardcoded to 00
	PO-OTB-SCHED-DATE2	Numeric, 4 positions (YYMM)	Fiscal year and month, using the accounting period associated with the promise date, increased by 1 month1
	PO-OTB-SCHED-PCT3	Numeric, 2 positions	Hardcoded to 00
	PO-OTB-SCHED-DATE3	Numeric, 4 positions (YYMM)	Fiscal year and month, using the accounting period associated with the promise date, increased by 2 months1
	PO-OTB-SCHED-PCT4	Numeric, 2 positions	Hardcoded to 00
	PO-OTB-SCHED-DATE4	Numeric, 4 positions (YYMM)	Fiscal year and month, using the accounting period associated with the promise date, increased by 3 months1
	PO-OTB-SCHED-PCT5	Numeric, 2 positions	Hardcoded to 00
	PO-OTB-SCHED-DATE5	Numeric, 4 positions (YYMM)	Fiscal year and month, using the accounting period associated with the promise date, increased by 4 months1
	PO-OTB-SCHED-PCT6	Numeric, 2 positions	Hardcoded to 00
	PO-OTB-SCHED-DATE6	Numeric, 4 positions (YYMM)	Fiscal year and month, using the accounting period associated with the promise date, increased by 5 months1
PO entry date	PO-ORDER-GRP-DATE	Numeric, 6 positions (YYMMDD)
	PO-ORDER-DESI	Numeric, 25 positions	Hardcoded to FOLIO ORDER
Example: If the promise date is August 31, 1995, this translates to accounting period 9508 (YYMM); each successive field increments by 1 accounting period, so that PO-OTB-SCHED-DATE2 would be 9509, PO-OTB-SCHED-DATE3 would be 9510, etc. This date is based on whatever accounting period this date falls between, as defined in the Accounting Periods file in CWDirect.