Working with Periodic Functions (WPER)

Periodic functions are jobs that you need to run periodically, usually on a daily, monthly, or yearly basis. Periodic functions include reports listing or summarizing activity in a particular area of your business, such as accounts payable disbursements, gift certificates issued, or refunds processed; reports providing current status information on your business, such as merchandise on-hand in a warehouse or carryover pick slips; periodic resets, such as clearing daily, weekly, monthly, or yearly total buckets; aging operations, such as evaluating orders for time-release holds or updating bill-to customer account age.

MICROS recommends you assign certain functions to your daily, monthly and yearly processing; a list of these functions appears in this chapter. You can define your own programs and queues as periodic functions as well.

You use Working with Periodic Processes (WPPR) to define a group of periodic functions to run together within a periodic process. You cannot run a periodic function by itself.

Note: Periodic functions and processes are not restricted by company; when you create a periodic function or process, it is defined across all companies.

In this topic:

Work with Periodic Functions Screen

Create Periodic Function Screen

Change Periodic Function Screen

Display Periodic Function Screen

Periodic Functions

Work with Periodic Functions Screen

How to display this screen: Enter WPER in the Fast path field at the top of any menu, or select Work with Periodic Functions from a menu.

MSR0166 DISPLAY Work with Periodic Function 5/17/96 11:55:33

Opt Function Description Applic C/P System

Type options, press Enter.

2=Change 4=Delete 5=Display

APDISB AP MONTH-END DISPB JOURNAL A/P P N

APLEDG AP LEDGER A/P P N

APPUR AP MONTH-END PURCHASES JOURNAL A/P P N

CBTAGE CUSTOMER BILL TO AGING A/R P N

CBTCYTD MOVE & CLEAR YTD BUCKETS A/R P N

CLR_DAY DAILY CLEAR PROCESS ALL P N

CLR_MTH MONTHLY CLEAR PROCESS ALL P N

CLR_WEK WEEKLY CLEAR PROCESS ALL P N

CLR_YR YEARLY CLEAR PROCESS ALL P N

DISB_GL MONTH END DISBURSEMENTS BY G/L ALL P N

DISB_VD M/E DISBURSEMENT JRN BY VENDOR ALL P N

DSPFD DISPLAY FILE DEFINITION A/P C N +

F3=Exit F6=Create F12=Cancel F21=Print list

Field

Description

Function

The name of the periodic function.

Alphanumeric, 7 positions; display-only.

Description

The description of the periodic function.

Alphanumeric, 30 positions; optional.

Applic (Application area code)

The area of CWDirect (for example, Customer Service) where this function belongs. Use application areas to categorize similar system control values, secured features, and menu options as well as periodic functions.

Alphanumeric, 3 positions; optional.

C/P (Command or program)

This value indicates the type of periodic function. Valid values are:

C - This periodic function is a command.

P - This periodic function is a program.

Alphanumeric, 1 position; optional.

System

This value indicates whether the periodic function is a system-level function, which was delivered with the software and cannot be changed or deleted. Valid values are:

Y - This is a system-level function.

N - This is not a system-level function

Alphanumeric, 1 position; optional.

Screen Option

Procedure

Change a periodic function

Enter 2 next to the function to advance to the Change Periodic Function Screen.

Delete a periodic function

Enter 4 next to a function to delete it.

Display a periodic function

Enter 5 next to a function to advance to the Display Periodic Function Screen.

Create a new periodic function

Press F6 to advance to the Create Periodic Function Screen.

Create Periodic Function Screen

Purpose: Use this screen to create a function to include in periodic processing.

How to display this screen: Press F6 at the Work with Periodic Functions Screen.

MSR0192 ENTER Create Periodic Function 5/17/96 13:03:11

Function . . . . .

Description . . . .

Company Parameter .

Appl Area . . . . .

Program Name . . .

OR

Command . .

F3=Exit F12=Cancel

Field

Description

Function

The name of the periodic function. You must define a function at this screen before you can assign it to a periodic process.

Alphanumeric, 7 positions.

Create screen: required.

Change screen: display-only.

Description

The description of the periodic function.

Alphanumeric, 30 positions; optional.

Company parameter

Enter Y in this field to indicate that a company parameter is required to execute the periodic process containing this periodic function. If you assign a function with this field set to Y to a periodic process, it updates the Company parameter field for the periodic process to Y, and you need to enter a company code at the First Execute Periodic Process Screen (Setting Parameters).

Note: In order to run a periodic function without errors, you must enter Y in the Company parameter, even if the periodic function is designed to run across companies.

Company codes are defined in and validated against the Company file.

Alphanumeric, 1 position; optional.

Applic (Application area code)

The area of CWDirect (for example, Customer Service) where this function belongs. Use application areas to categorize similar system control values, secured features, and menu options as well as periodic functions.

Alphanumeric, 3 positions; required.

Program name

The name of the program to be called by the periodic function.

Alphanumeric, 10 positions; required if no command is entered.

Command

The command you type at a command line to execute the periodic function. You can enter up to four command lines.

Alphanumeric, four lines, 63 positions each; required if no program name is entered.

Change Periodic Function Screen

To change: Enter 2 next to the function at the Work with Periodic Functions Screen to advance to the Change Periodic Function screen. You can change any information on this screen except the function name.

See Create Periodic Function Screen for field descriptions.

Display Periodic Function Screen

To display: Enter 5 next to the function at the Work with Periodic Functions Screen to advance to the Display Periodic Function screen. You cannot change any information on this screen.

See Create Periodic Function Screen for field descriptions.

Periodic Functions

Purpose: The tables below provide a list of the periodic functions you can use to schedule certain functions in CWDirect.

See Working with Periodic Processes (WPPR) for information on how to assign each function to a periodic process and how to schedule when the system executes the periodic process.

Accounts Payable (A/P) Periodic Functions

Accounts Receivable (A/R) Periodic Functions

General Usage (ALL) Periodic Functions

General Ledger (G/L) Periodic Functions

Customer Service (C/S) Periodic Functions

E-Commerce (EDC) Periodic Functions

Fulfillment (FUL) Periodic Functions

Interface (INT) Periodic Functions

Inventory (INV) Periodic Functions

Order Entry (O/E) Periodic Functions

Purchase Order (P/O) Periodic Functions

Accounts Payable (A/P) Periodic Functions

The table below lists the periodic functions associated with Accounts Payable processing. The Schedule column represents how often MICROS generally recommends you run the periodic function. Your business requirements may require a different schedule.

Accounts Payable Periodic Functions

Function

Program

Schedule

Description

APCLOSE

PFR0029

Monthly

Close A/P Accounting Period

Updates the Accounting Period file with a close date. Also, prevents back dating transactions, since you cannot post to a closed period.

Run A/P reports before executing this periodic function.

APJRDT

PFR0003

Monthly

Purchase Journal Summary by Date

See A/P Purchases Summary Report by Invoice Posted Date.

APJRGL

PFR0015

Monthly

Purchase Journal Summary by G/L Number

See Purchase Journal Summary Report by Vendor Number.

APJRVN

PFR0018

Monthly

Purchase Journal Summary by Vendor

See Purchase Journal Summary Report by Vendor Number.

APLEDG

PFR0035

Monthly

A/P Ledger for Held/Open Invoices

Generates the A/P Ledger.

DSJRDT

PFR0004

Monthly

Disbursement Journal Summary by Date

Generates the Disbursements Journal Summary Report by Check Printed Date.

DSJRGL

PFR0016

Monthly

Disbursement Journal Summary by G/L Number

Generates the Disbursements Journal Summary Report by Vendor Number.

DSJRVN

PFR0017

Monthly

Disbursement Journal Summary by Vendor

Generates the Disbursements Journal Summary Report by Vendor Number.

GIFTISS

PFR0010

Monthly

Issued Gift Certificates

Generates the Unredeemed Gift Certificate List, which lists all gift certificates that have not been fully redeemed (used as payment) on a shipped order. Recently redeemed gift certificates remain on this report until the orders where they are redeemed are billed.

See Print Unredeemed Gift Certificate Screen (PUGC) and Working with Gift Certificates.

APLEDGR

PFR0001

Monthly

A/P Ledger

Generates the A/P Ledger.

Accounts Receivable (A/R) Periodic Functions

The table below lists the periodic functions associated with Accounts Receivable processing. The Schedule column represents how often MICROS generally recommends you run the periodic function. Your business requirements may require a different schedule.

Accounts Receivable Periodic Functions

Function

Program

Schedule

Description

ARCLOSE

PFR0028

Monthly

Close A/R Accounting Period

Updates the Accounting Period file with a close date. Also, prevents back dating transactions, since you cannot post to a closed period.

Run A/R reports before executing this periodic function.

ARCNDAY

PFR0025

Daily

Daily A/R Control

Generates the A/R Control Report.

ARCNMON

PFR0026

Monthly

Monthly A/R Control

Generates the A/R Control Report.

AVGDPAY

ACR0108

Monthly

Average Days to Pay

Average days to pay; the number of days between the invoice date and the date payment for the invoice is posted to the customer’s A/R account.

Updates the CBT Average days to pay field in the Customer Bill To file.

See Using A/R Inquiry (DARI).

CBTAGE

ACR0121

Monthly

Customer Bill To Aging

Updates the CBT Aging field in the Customer Bill To file.

See the A/R Aging Summary Report.

CBTAGER

PFR0022

Monthly

A/R Aging Reports

Generates the Processed Refund Register.

CBTCYTD

ACR0123

Yearly

Move and Clear YTD Buckets

Clears any YTD (year-to-date) buckets

Files affected include Customer Bill To, Flash Report, Item Warehouse, and Location.

Note: In order to update YYD buckets correctly, run this periodic function only at year end and make sure the Accounting Values (B71, B72, B73) are correct.

CR_ME

PFR0002

Monthly

Month End Cash Receipts Journal

Generates the Monthly Cash Receipts Journal.

RSOORBT

OER0951

Monthly

Update On-Order in CBT

Updates the CBT $ on order field in the Customer Bill To file.

ARWO999

uses command

Daily

Automatic A/R Open Item Write-offs

Automatically posts a write-off for debit A/R open items that meet the automatic A/R open item write-off requirements. See Automatic A/R Open Item Write-off Process for more information.

General Usage (ALL) Periodic Functions

The table below lists the periodic functions associated with General Usage processing. The Schedule column represents how often MICROS generally recommends you run the periodic function. Your business requirements may require a different schedule.

General Usage Periodic Functions

Function

Program

Schedule

Description

ORDSUM

PFR0062

Daily

Order Summary

Updates all of the fields defined in the Order Control Summary file for the current transaction date. See Reviewing Operations Control Summary (FLSH).

Updates the actual value fields and Last updated fields defined in the Threshold Values file. See Working with Threshold Values (WTHR).

Generates the Operations Control Report.

This periodic function performs updates similar to the THRESHD periodic function.

BRKSTR

PFR0095

Daily

Starts the Broker Java jobs. See Order Broker Integration for background.

ENDBRK

PFR0096

Daily

Ends the Broker Java jobs. See Order Broker Integration for background.

CLRJRN

Reset/Clear Journals

Command: call cwmpgpl/

resemjrnu parm (T2)

This command resets journals. In order to retain existing information, save the journal and then delete.

ASYNCSD

Async Shutdown

MSR0954

Calls the Controlling Data Queue (CNTL_ASYNC) in Background Job Control and ends the background jobs; also ends the CDC ASYNC. This periodic function performs the same updates as typing 8 next to the controlling data queue to end the background jobs. See Ending the Background ASYNC Jobs for more information on the updates that are performed. See Warehousing WMS Background Jobs (WPBJ) for more information on the CDC ASYNC.

ASYNCST

Async Start-up

MSR0949

Calls the Controlling Data Queue (CNTL_ASYNC) in Background Job Control and starts the background jobs; also starts the CDC ASYNC. This periodic function performs the same updates as entering 7 next to the controlling data queue to start the background jobs. See Starting the Background ASYNC Jobs. See Warehousing WMS Background Jobs (WPBJ) for more information on the CDC ASYNC.

REORG

Reorganize Data Files

PFR0019

Removes deleted records from physical files in your database containing 25% or more deleted records. See Purging Active Procedures.

THRESHD

PFTHRESHMO

Daily

Threshold Monitor

Updates all of the fields defined in the Order Control Summary file for the current transaction date. See Reviewing Operations Control Summary (FLSH).

Updates the actual value fields and Last updated fields defined in the Threshold Values file.

Monitors the threshold values to determine if a threshold has been breached.

For each breached threshold that has an email address defined and whose Email interval is reached, generates a Threshold Monitor Breach email.

See Working with Threshold Values (WTHR).

Note: This periodic function performs updates similar to the ORDSUM periodic function.

BO_REAS

PFR0024

Daily

Evaluate Backorder Reasons without Backorder Warehouse

Tries to reserve order detail lines that have a backorder reason, but no backorder warehouse. If inventory is not available, this function assigns a backorder warehouse so that the order detail line will process through Evaluate Backorders.

See Working with the EBO_ASYNC Job.

CASHRP

ACR0273

Daily

Cash Receipts Journal

Prints the Daily Cash Receipts Journal.

The Multi Currency by Offer (E03) system control value must be unselected to execute this periodic function.

CLR_MTH

MSR0576

Monthly

Monthly Clear Process

Clears (updates the zero) the MTD (month-to-date) fields in all files.

Files affected include Picker Error History, Picker/Packer, Flash Report, Item Warehouse, Location, Picker Error History.

DBST

ACR0178

Daily

Daily Business Status Report

Generates the Daily Business Status report for the day, which provides a high-level summary of sales, cash, inventory, A/R and A/P aging, order activity and shipments.

See A/R Printing Functions.

DLYCLR

MSR0574

Daily

Clear Daily Journals

Clears (updates to 0) all daily buckets.

Clears (updates to 0) the TD (today) fields in all files.

Files affected include Flash Report, Division, Item Warehouse, Order Type/User, Picker/Packer, Ship Via.

You should run daily reports before executing this periodic function.

Add this function as the last one (or just before reorganizing data files) in a daily periodic process.

DSLJPAY

ACR0315

Daily

Daily Sales Journal by Pay Type

Generates the Daily Sales Journal by Pay Type.

See Order Status and Activity Reports.

DSLJRN

ACR0216

Daily

Daily Sales Journal

Generates the Daily Sales Journal.

See Order Status and Activity Reports.

DWCHG

DWR0068

Daily

Process Data Warehouse Changes

Builds records in each related DW Staging file based on the key in the DW Transaction file.

You can also submit this process on demand at the Process Data Warehouse Changes Window.

The Use Data Warehouse (G94) system control value must be selected.

See Working with the Data Warehouse Integration in CWDirect.

ECOMERR

ECR0295

Daily

Batch OM Transaction Error Listing

Generates the E-Commerce Order Maintenance Errors Report.

See Working with Batch Order Maintenance Transactions (WBOM).

ENDASYN

MSENDASYNC

Daily

End Asyncs

Calls the Controlling Data Queue (CNTL_ASYNC) in Background Job Control (MBJC) and ends the background jobs.

This periodic function performs the same updates as selecting End for the controlling data queue to end the background jobs. See Ending the Background ASYNC Jobs for more information on the updates that are performed.

FUTURE

FLR0246

Daily

Evaluate Future Orders

Evaluates and reserves orders. If the arrival date - lead days = today’s date, then the system reserves the stock and the Future order flag is set to N.

ONHAND

PFR0005

Monthly

On Hand by Warehouse

Generates the On Hand by Warehouse Report.

See Working with Interactive Reservation (MIRV).

PSJD

ACR0321

Daily

Print Sales Journal by Division

Generates the Sales Journal by Division.

See Printing the Sales Journal (PDSJ).

PURGECS

PFR0097

Daily

Purge Sold To Customers

Purges sold to customers that are older than the number of days defined in the Customer Purge Days property (PROP).

To be eligible for purge, the system verifies that:

• there are no open orders for the customer.

• there are no open refunds for the customer.

• there are no open returns for the customer.

• there is no open A/R for the customer.

• there are no open ticklers for the customer.

• there are no catalog requests for the customer.

• there are no open memberships for the customer.

See Purging Sold To Customers for background and for the list of tables that are purged.

PURGESP

PFR0098

Daily

Purge Spool Files

Purges spool files that are older than the number of days defined in the Spool File Purge Days property (PROP).

RESET

MSR0698

Run when a problem is detected

 

Note: Do not run this periodic function when the Billing Async is active.

Daily Inventory Reset

• Updates the ODT Quantity reserved in the Order Detail file, based on data for open orders in the Order Detail file and Reserved Order Line file.

• Resets the Reserved field in the Item Warehouse file, based on data in the Reserved Order Line file.

• Resets the S/H reserved quantity in the Item Warehouse file for open and held orders, based on data in the Reserved Order Line file.

• Updates the ITW Reserve transfer qty field in the Item Warehouse file, based on the ARD Actual quantity field in the Autostock Replenish Dtl file.

• Updates the Qty order direct ship field in the SKU file for drop ship open or held lines in the Order Detail file.

• Updates the SKU open qty field in the SKU file for non-drop ship open or held lines in the Order Detail file.

• Resets the SKU On hold qty field in the SKU file, based on data in the Order Header file.

RESET continued

 

 

• Reads through Order Detail records for future orders (ODT Future order is Y) and takes the quantity open or held, subtracts the quantity reserved, and updates the ITW B/O qty field in the Item Warehouse file.

• Deletes Pick Header and Pick Detail records for picks that have been billed.

• Deletes Pick Detail records if an associated Pick Header record cannot be found.

• Reads through Order Detail records for open lines and clears the ODT Date printed and ODT Qty printed.

• Clears ITL Printed qty out of Item Location.

• Clears fields in the Flash Report file.

• Resets ITL Printed qty for Item Location from Pick Location.

• Resets ODT Qty printed in Order Detail from Pick Location.

• Resets quantity printed and quantity remaining (unprinted) in Order Detail from Pick Control Detail.

• Deletes Reserved Order Line records if the associated Order Detail record is closed.

RESET continued

 

 

• Updates ODT date printed in Order Detail from Pick Control Detail.

• Updates Flash Report from Pick Control Detail.

• Updates ITL Printed qty in Item Location based on Pick Location.

• Resets ROL Qty printed and ROL Qty remaining on Reserved Order Line from Pick Location.

• Updates ITL Printed qty in Item Location from Autostock Replenish (printed quantity + transfer quantity = printed quantity).

• Updates Flash report for open and held records from Order Detail.

See Reset Reserve Quantity (MRQR).

RFRECON

PFR0008

Monthly

Refund Reconciliation and Purge

Purges refund checks once you have reconciled or voided the checks. Generates the Check Reconciliation List.

See Reconciling Checks (MREC).

RSLTME

CSR0557

Daily

Release Order on Time Hold

Releases prepaid orders from hold automatically when the number of days to hold the order (in the Hold days field in the Pay Type file) has passed, and releases orders held for credit card authorization.

See Releasing Orders from Time Hold.

SCVREV

PRF0077

Daily

Stored Value Card Reversal

Processes stored value card reversal trigger records (File type AHR) that are in a ready (R) status.

See Transmitting Stored Value Card Transactions (SSVC).

STRASYN

MSR0949

Daily

Start Asyncs

Calls the Controlling Data Queue (CNTL_ASYNC) in Background Job Control (MBJC) and starts the background jobs.

This periodic function performs the same updates as selecting Start for the controlling data queue to start the background jobs.

See Starting the Background ASYNC Jobs.

SUSPEND

OER0756

Daily

Suspended Orders List

Generates the Suspended Orders List report, which provides a listing of all orders in a suspended status.

See Placing Suspended Stock (SUSP).

SVCACT

PFR0076

Daily

Stored Value Card Activation

Processes stored value card activation trigger records (File type SVC) that are in a ready (R) status.

See Transmitting Stored Value Card Transactions (SSVC).

TAXRPT

PFR0012

Yearly

Tax Jurisdiction Report

Generates the Tax Jurisdiction Report.

See Working with Tax Jurisdiction (WTXJ) and Printing the Tax Jurisdiction Report (PTXJ).

URNCPN

PFR0021

Monthly

Unredeemed Coupon List

Generates the Outstanding Credits/Coupons Report, which lists all unredeemed records in the Coupon Redemption file, including gift certificates, coupons, merchandise credits, and bonus credits.

See Unredeemed Coupon Listing (PCPN).

WEEKCLR

MSR0575

Weekly

Weekly Clear

Clears week-to-date (WTD) fields in the SKU Offer Page file (INSKOP).

YEARCLR

MSR0577

Yearly

Clear Yearly Totals

Clears (zeros) yearly (YTD) buckets in files such as Flash Report file (FLFLSH).

TICKLER

PFR0072

Daily

Evaluate Create/Resolve Ticklers

Evaluates the:

OO tickler event to determine if any open orders qualify for an OO event rule. Also, determines if any existing OO ticklers can be resolved. See OO (Aged Open Orders) Event Processing.

UP tickler event to determine if any unconfirmed pick tickets qualify for a UP event rule. Also, determines if any existing UP ticklers can be resolved. See UP (Unconfirmed Pick Tickets) Event Processing.

AR tickler event to determine if any existing AR ticklers can be created or resolved. See AR (Accounts Receivable) Event Processing.

Next notification date for an existing open or in process tickler to determine if the system sends an email to the tickler supervisor notifying him of the aged tickler.

See Workflow Management Overview and Setup.

General Ledger (G/L) Periodic Functions

The table below lists the periodic functions associated with General Ledger processing. The Schedule column represents how often MICROS generally recommends you run the periodic function. Your business requirements may require a different schedule.

General Ledger Periodic Functions

Function

Program

Schedule

Description

GLEXTRA

GLR0078

Weekly

GL Extract

Populates a general ledger download file, based on records in the General Ledger Interface file (GLINTR) that:

• are earlier than or equal to the date you run the periodic function, and

• have a blank Date posted, and

• are not in the Division to Exclude from General Ledger Download File (F68).

• When the download is complete, the system updates the Date posted field in the General Ledger Interface file for each selected record.

The G/L Download Type (G03) system control value controls which general ledger download file the system populates.

See Generating the General Ledger Download File (GGLD).

Customer Service (C/S) Periodic Functions

The table below lists the periodic functions associated with Customer Service processing. The Schedule column represents how often MICROS generally recommends you run the periodic function. Your business requirements may require a different schedule.

Customer Service Periodic Functions

Function

Program

Schedule

Description

MEMBER

PFR0036

Daily

Generate Membership Orders

Generates orders for all standard customer memberships.

See Generating Membership Orders (EGMO).

NSLARN

CSR1398

Daily

SmartLabel Adv Notification

Populates the Return Notifications file, based on information in the SmartLabel ARN file, and then clears the SmartLabel ARN file.

See Importing Return Notifications.

OPENPP

PFR0006

Monthly

Open Prepaid Orders List

Generates the Open Prepaid Order List.

REFDUET

CSR0986

Monthly

Refund Due List by Type

Generates the Refund Due List by Type.

See Printing and Interpreting Refund Due Lists (MRDU).

REFPROC

CSR0533

Monthly

Refunds Processed

Generates the Processed Refund Register.

See Printing the Processed Refund Register (PPRR).

REFWRO

PFR0009

Monthly

Refunds Written Off

Writes off refunds and generates the Refund/Write Offs - Refund Checks report.

See Working with Refunds, Writeoffs and Balances Due (WREF).

SECRISK

PFR0084

Daily

Security Risk Purge

For a closed or cancelled order that uses any credit card pay type, including BML or stored value cards, the periodic function:

• Replaces the credit card number with asterisks (*)

• Removes the expiration date

• Deactivates the pay type

The above actions depend on whether the most recent date recorded in the order transaction history record for the order is the same or greater than the number of days set in the Credit Card Retention Days (K65) system control value.

UNACTSV

PFR0075

Daily

Unactivated Stored Value Cards

Generates the Unactivated Stored Value Card Report. You can use this report to review any stored value cards that require attention because:

• the stored value card was declined by the service bureau for activation

• the stored value card was billed at the manifest station without a number assignment

See Stored Value Card Purchase and Activation.

UNGIFT

PFR0007

Monthly

Unredeemed Gift Certificates

Generates the Unredeemed Gift Certificate List.

See Working with Gift Certificates.

PRSCLUB

OER1421

Monthly

President’s Club Expire Membership All

Searches for and updates expired President Club memberships so that the customer no longer receives President’s Club benefits once the expiration date has passed. Resets the customer’s Activity status to E (expired) and resets the Associate flag in the Customer Sold To file to N.

E-Commerce (EDC) Periodic Functions

The table below lists the periodic functions associated with Customer Service processing. The Schedule column represents how often MICROS generally recommends you run the periodic function. Your business requirements may require a different schedule.

E-Commerce Periodic Functions

Function

Program

Schedule

Description

ECAVAIL

ECR0144

Daily

Download E-Commerce Item Availability

Extracts the current available quantity for items and SKUs that you have previously downloaded to the e-commerce staging library.

The system downloads the current availability information for items only if you have used the Downloading E-Commerce Offer Files (EOFR) menu option to extract these items to the EC Item file (EXITEM).

When you use the Download E-Commerce Offer Files (EOFR) menu option, the system writes a record for all related offer, items, and SKUs in the E-Commerce Item Extract file (ECITEX) and the E-Commerce SKU Extract file (ECSKEX). When you run the ECAVAIL periodic function, the system checks these files to determine whether to include an item or SKU in the availability download.

See E-Commerce Item Availability Processing.

ECCSTEX

ECX0358

Monthly

Download CST Extended Changes

Extracts updated customer user fields to the EC Customer Extended (EXCSTE) staging file.

Selects customer records that are:

• active, based on the setting of the Inactive field for the customer

• newly created, if they include user information

• updated, if the update includes a change, addition, or deletion of any of the user fields

• deleted, if the deleted customer included user field information.

• Does not select customers whose Inactive field changes from inactive to active or from active to inactive.

See Extracting Customer Changes through a Periodic Function.

ECGFTC

ECR0142

Daily

Download Gift Certificates and Coupons

Extracts information on open, unredeemed coupons and gift certificates from the Coupon Redemption file (CSCPNR) to the EC Gift Certificate file (EXGFTC).

ECITMCH

ECX0178

Daily

Download Item Changes

Extracts item changes to the EC Item file and SKU changes to the EC Sku file for items and SKUs previously downloaded to e-commerce using the Downloading E-Commerce Offer Files (EOFR) menu option.

Additionally, extracts items whose item ship via overrides have been updated since the last time the item was downloaded to e-commerce to the EC Item Ship Via Override Download file.

ECOMINV

ECR0389

Daily

E-Commerce Item XRef All Items

Downloads all items that contain a long SKU style number to the EC SKU Retail XRef file and EComm SKU Extract file.

ECOMNEW

ECR0390

Daily

E-Commerce Item XRef New Items

Downloads new items that contain a long SKU style number to the EC SKU Retail XRef file and EComm SKU Extract file.

ECSHCNF

ECR0154

Daily

E-Commerce Ship Confirmations

Sends shipment confirmation emails.

See Sending Internet Order Ship Confirmation (ESCF).

ECGFTCH

ECR0302

Daily

Download Gift Certificates

Extracts information on open, unredeemed gift certificates from the Coupon Redemption file (CSCPNR) to the EC Gift Certificate file (EXGFTC).

ECSHCNF

ECR0154

Daily

Shipment Confirmation Emails

Sends shipment confirmation emails.

See Sending Internet Order Ship Confirmation (ESCF).

E-Commerce Periodic Functions

Function

Program

Schedule

Description

ECAVAIL

ECR0144

Daily

Download E-Commerce Item Availability

Extracts the current available quantity for items and SKUs that you have previously downloaded to the e-commerce staging library.

The system downloads the current availability information for items only if you have used the Downloading E-Commerce Offer Files (EOFR) menu option to extract these items to the EC Item file (EXITEM).

When you use the Download E-Commerce Offer Files (EOFR) menu option, the system writes a record for all related offer, items, and SKUs in the E-Commerce Item Extract file (ECITEX) and the E-Commerce SKU Extract file (ECSKEX). When you run the ECAVAIL periodic function, the system checks these files to determine whether to include an item or SKU in the availability download.

See E-Commerce Item Availability Processing.

ECCSTEX

ECX0358

Monthly

Download CST Extended Changes

Extracts updated customer user fields to the EC Customer Extended (EXCSTE) staging file.

Selects customer records that are:

• active, based on the setting of the Inactive field for the customer

• newly created, if they include user information

• updated, if the update includes a change, addition, or deletion of any of the user fields

• deleted, if the deleted customer included user field information.

• Does not select customers whose Inactive field changes from inactive to active or from active to inactive.

See Extracting Customer Changes through a Periodic Function.

ECGFTC

ECR0142

Daily

Download Gift Certificates and Coupons

Extracts information on open, unredeemed coupons and gift certificates from the Coupon Redemption file (CSCPNR) to the EC Gift Certificate file (EXGFTC).

ECITMCH

ECX0178

Daily

Download Item Changes

Extracts item changes to the EC Item file and SKU changes to the EC Sku file for items and SKUs previously downloaded to e-commerce using the Downloading E-Commerce Offer Files (EOFR) menu option.

Additionally, extracts items whose item ship via overrides have been updated since the last time the item was downloaded to e-commerce to the EC Item Ship Via Override Download file.

ECOMINV

ECR0389

Daily

E-Commerce Item XRef All Items

Downloads all items that contain a long SKU style number to the EC SKU Retail XRef file and EComm SKU Extract file.

ECOMNEW

ECR0390

Daily

E-Commerce Item XRef New Items

Downloads new items that contain a long SKU style number to the EC SKU Retail XRef file and EComm SKU Extract file.

ECSHCNF

ECR0154

Daily

E-Commerce Ship Confirmations

Sends shipment confirmation emails.

See Sending Internet Order Ship Confirmation (ESCF).

ECGFTCH

ECR0302

Daily

Download Gift Certificates

Extracts information on open, unredeemed gift certificates from the Coupon Redemption file (CSCPNR) to the EC Gift Certificate file (EXGFTC).

ECSHCNF

ECR0154

Daily

Shipment Confirmation Emails

Sends shipment confirmation emails.

See Sending Internet Order Ship Confirmation (ESCF).

Fulfillment (FUL) Periodic Functions

The table below lists the periodic functions associated with Fulfillment processing. The Schedule column represents how often MICROS generally recommends you run the periodic function. Your business requirements may require a different schedule.

Fulfillment Periodic Functions

Function

Program

Schedule

Description

CARRYOV

PFR0033

 

Carryover Report

Prints the Carryover Report.

See Printing the Carryover Report (PCOR).

LOBSTAT

PFR0034

Daily

Reset Line of Business Stats

Updates line of business order queue statistics.

See Updating the Line of Business Order Queue Statistics.

RESRVBO

FLR0804

Daily

Reserve Backorders

Evaluates backorders by searching for any item warehouse that has a backorder quantity greater than 1 and whose on-hand quantity - reserved quantity is greater than 0. Will try to reserve the order detail line (as long as a cancel date does not exist).

See Working with the EBO_ASYNC Job.

RESTPRI

FLR0234

 

Reset Quantity Printed

Interface (INT) Periodic Functions

The table below lists the periodic functions associated with Interface processing. The Schedule column represents how often MICROS generally recommends you run the periodic function. Your business requirements may require a different schedule.

Interface Periodic Functions

Function

Program

Schedule

Description

BROKER

PFR0083

 

Submit Backorders to Order Broker

Creates Order Broker triggers (File type OBR) for a backordered order line if:

• the Use Order Broker (K08) system control value is selected.

• the record matches the trigger rules for the BROKER_ORD process in Integration Layer Job Control (IJCT).

See Order Broker Integration.

INVDWNL

ILR0081

Weekly

Inventory Download

Creates inventory download triggers (File type ITW) for an item/SKU if:

• the Create Generic Inventory Download Trigger Records (I32) system control value is selected.

• the record matches the trigger rules for the INV_DOWNLD process in Integration Layer Job Control (IJCT).

• there is at least one Item Warehouse record that matches all criteria.

See Generic Inventory Download API.

ORBJEND

PFR0089

As needed

End Orbital Java Jobs

Ends all Java Message Handler jobs used by the Chase Paymentech Orbital Gateway Integration to send transactions between CWDirect and Orbital Gateway.

ORBJSTR

PFR0091

As needed

Start Orbital Java Jobs

Starts all Java Message Handler jobs used by the Chase Paymentech Orbital Gateway Integration to send transactions between CWDirect and Orbital Gateway.

PURGIJT

ILR0026

Weekly

Purge IJCT Trigger Records

• Purges IL Outbound Trigger records older than the number of days specified in the Outbound Interface Trigger File Purge Days (I14) system control value, using the following calculation: Last processed date is less than the current system date by the number of purge days and Status is X

• Purges store fulfillment records older than the number of days specified in the Store Pickup/Shipment Request Purge Days (I43) system control value.

RLTJAVA

PFR0090

As needed

End Relate Java Handler Jobs

Ends all Java Message Handler jobs used by the Relate Stored Value Card Integration to send transactions between CWDirect and Relate.

STPINVO

MSX1521

Daily

Stop Invoice Outbound IJCT Process

Stops the INVOIC_OUT integration layer job.

You can also stop the IJCT job from a command line:

call pgm(MSX1521) parm('' '' '' x'000f')

STRINVO

MSX1520

Daily

Start Invoice Outbound IJCT Process

Starts the INVOIC_OUT integration layer job.

You can also start the IJCT job from a command line:

call pgm(MSX1520) parm('' '' '' x'000f')

Inventory (INV) Periodic Functions

The table below lists the periodic functions associated with Inventory processing. The Schedule column represents how often MICROS generally recommends you run the periodic function. Your business requirements may require a different schedule.

Inventory Periodic Functions

Function

Program

Schedule

Description

FGUPDT

PHR0049

Monthly

 

Note: Do not run this periodic function when Asyncs are active.

Update Cost of Finished Goods

• Updates the cost of a finished good when the cost of one or more of its component items changes and generates the Finished Good Items Average or Standard Cost Updated Report. See Updating the Cost of a Finished Good.

• Updates the General Ledger Interface file with the change in inventory valuation.

• Creates an item download trigger. See Generic Item Download API.

Note: If a component item changes and you do not run this periodic function, the finished good item cost will not be accurate and reports will not be correct.

FIFORES

command, where 999 is the company code:

CALL PGM(INR1495) PARM(' ' X'999F')

Only if you use FIFO costing

FIFO Reset

Compares the Item Warehouse records to the associated open FIFO records to make sure that the totals match. If the totals do not match, adjusts the FIFO Cost records using the information for the Item Warehouse.

• If the Item Warehouse has more stock then the total of the FIFO layers, the system creates a FIFO layer for the difference. The system pulls the cost for this FIFO layer from the FIFO layers using the standard FIFO hierarchy (1. Oldest Open, 2. Most Recent Closed, 3. Last Purchase cost) using a quantity of 1. Also, creates an Item Transaction Cost Detail record with a G/L Transaction code of Y. Note: Make sure the Y transaction code has a positive (+) effect on inventory.

• If the Item Warehouse has less stock then the total of the FIFO layers, then the system reduces the FIFO layers for the amount of the difference, starting with the oldest open layer. Also, creates an Item Transaction Cost Detail record with a G/L Transaction code of X. Note: Make sure the X transaction code has a negative (-) effect on inventory.

PFR0063

PFR0063

Daily

Drop Ship On Hold Report

Generates the Drop Ship Integration Items on Hold from Vendor Report.

PFR0064

PFR0064

Daily

Drop Ship Revised Due Date Report

Generates the Drop Ship Integration Items Revised Due Date Report.

PFR0065

PFR0065

Daily

Drop Ship Pending Cancel Report

Generates the CWCollaborate Drop Ship Items Pending Cancellation report.

See Drop Ship Items Pending Cancellation.

RIITUPL

PFR0087

Daily

RI Item Upload

Runs the RI Item Upload Program to process records in the Retail Integration Item Upload File (RIIUPP).

See Working with Retail Integration Item Upload (RIIU) and Item Upload Processing for processing details.

UPD_STD

POR0461

Monthly

 

Note: Do not run this periodic function when Asyncs are active.

Update Standard Cost

Updates the cost of all items in the SKU file with the item’s landed cost. The system uses the price defined for the primary vendor plus any additional vendor/item charges to determine the landed cost.

The system only updates the standard cost for items with a primary vendor and a vendor item associated with the vendor.

The Costing Method (A25) system control value must be set to STANDARD in order to update the standard cost of all items.

See Updating Standard Cost (MSCC).

Order Entry (O/E) Periodic Functions

The table below lists the periodic functions associated with Order Entry processing. The Schedule column represents how often MICROS generally recommends you run the periodic function. Your business requirements may require a different schedule.

Order Entry Periodic Functions

Function

Program

Schedule

Description

SUMVIA

OEC1033

Daily

Update Ship Via/Item Summary

Runs a batch job to collect information on the current number of available order lines for each item/ship via combination in your company and populates the Ship Via Item Summary Header (OESVIH) file and Ship Via Item Summary Detail (OESVID) file. You can review the total open orders, shippable units, and oldest arrival dates for each item with a particular ship via assigned using the Ship Via/Item Inquiry (SVII) menu option.

WUDWNLD

PFR0043

Daily

Western Union Download

Downloads order information to the Western Union Download file. The system downloads any orders that contain the check interface pay type and have a blank check interface download date. The Western Union Download file allows you to send check information to an outside service for verification.

See Job Description for Business to Business Order Generation (G13).

Purchase Order (P/O) Periodic Functions

The table below lists the periodic functions associated with Purchase Order processing. The Schedule column represents how often MICROS generally recommends you run the periodic function. Your business requirements may require a different schedule.

Purchase Order Periodic Functions

Function

Program

Schedule

Description

RECURPO

PFR0031

Monthly

Process Recurring Purchase Orders

Generates recurring purchase orders. You can use the Recurring Purchase Order Screen to create a recurring PO template.

You can review the recurring POs generates at the Recurring Purchase Orders Generated Screen (Displaying).

The PO Allow Recurring (A50) system control value must be selected.

SO02_01 CWDirect 18.0.x 2018 OTN