Chapter 34: Working with File Sets (WFST) Contents SCVsSearchGlossary Reports XML Index Order Billing History Consolidation Report

Chapter 35: Consolidating Order Billing History (MOBH)

Purpose: Use the Consolidate Order Billing History menu option to consolidate records in the Order Billing History file up to a given date, to save space and eliminate unneeded information. You can "roll up" or consolidate records into summary records by indicating which key fields you would like to retain, and which you would like to blank out.

Example: You want to retain separate records by sold-to customer, but not ship-to customer. The total units and quantities of the ship-to customer records for each sold-to customer will be added or netted together, and then the individual ship-to customer records will be deleted. The resulting consolidated sold-to records will have the ship-to number fields set to zero.

The system flags each consolidated record in the file. You can consolidate any records only once.

When to run consolidation: You should run the consolidation at night, when there will not be any other activity that might update the Order Billing History file.

Reviewing consolidated records: When you review customer history through Work with Customers (fast path = WCST), any consolidated records are indicated as follows:

• Consolidated items are flagged at the Customer Sold To Item History Screen (available by selecting F18 at a Create/Change/Display Customer screen, or entering 18 next to a customer at a selection screen)

• The range of dates included in a consolidated record is indicated at the Display Customer Order History Screen (available by selecting F19 at a Create/Change/Display Customer screen, or entering 19 next to a customer at a selection screen)

• The range of dates included in a consolidated record is indicated at the Order Billing History Detail Screen (available by entering 5 next to an item at the Customer Sold To Item History screen or the Customer Sold To Order History screen)

Additional information:

• House list: Working with Drops (WHLS) ignores consolidated records.

• Merge/purge: Working with Merge/Purge Sold-to Names (MMCS) ignores consolidated records that do not include the sold-to customer number.

In this chapter:

• Consolidate Order Billing History Screen

• Order Billing History Consolidation Report

Consolidate Order Billing History Screen

Each flagged option on this screen represents a key field in the Order Billing History file. In order to save separate order billing history records by a field, you must flag it with a Y. For example, set the Customer flag to Y to save separate order billing history for each sold-to customers; otherwise, the history will be consolidated across all sold-to customers in your company.

You must set at least one field to Y.

How to display this screen: Enter MOBH in the Fast path field at the top of any menu or select Consolidate Order Billing History from a menu.

CSR1009 ENTER Consolidate Order Billing History 5/10/99 11:08:04

EZK Mail Order

Consolidate transactions up to . . . . . 60198

End journaling first . . . . . . . . . . . . . N (Y/N)

Consolidate by Customer . . . . . . . Y (Y/N)

Ship To . . . . . . . . Y (Y/N)

Item . . . . . . . . . Y (Y/N)

SKU . . . . . . . . . . N (Y/N)

Ship Via . . . . . . . N (Y/N)

Source . . . . . . . . N (Y/N)

Offer . . . . . . . . . Y (Y/N)

Salesman . . . . . . . N (Y/N)

Item Class . . . . . . Y (Y/N)

Long SKU Department . . N (Y/N)

Long SKU Class . . . . N (Y/N)

Order# . . . . . . . . N (Y/N)

Transaction Code . . . Y (Y/N)

Placer . . . . . . . . N (Y/N)

Originator . . . . . . N (Y/N)

Entity . . . . . . . . Y (Y/N)

F3=Exit F9=Submit F12=Cancel

Note: The system stores your entries on this screen in the Default Options file, to save data entry if you run the consolidation program periodically. The first time you use this screen, each yes/no flag will default to N, and the date field will be blank.

Field

Description

Consolidate transactions up to date

Enter the last date for which order billing history should be consolidated. All order billing history records from this date or earlier that meet the selection criteria will be consolidated.

Numeric, 6 positions (MMDDYY format); required.

End journaling first

This field indicates whether you should turn off journaling while you are processing the consolidation job in order to save system resources. Valid values are:

Y = End journaling before processing the consolidation.

N = Continue to write journal records during the consolidation.

Alphanumeric, 1 position; required.

Consolidate by:

Customer

This field indicates whether to consolidate order billing history by number of the sold-to customer on the order. Valid values are:

Y = Retain separate order billing history for each sold-to customer.

N = Consolidate customer sold-to order billing history.

See Creating and Updating Sold-to Customers (WCST).

Alphanumeric, 1 position; required.

Ship to

This field indicates whether to consolidate order billing history by customer ship-to number. Valid values are:

Y = Retain separate order billing history for each ship-to customer. You must also set the Customer field, above, to Y.

N = Consolidate customer ship-to order billing history.

See Customer Service Chapter 29: Creating and Updating Ship-to Customers (WCST).

Alphanumeric, 1 position; required.

Item

This field indicates whether to consolidate order billing history by item. Valid values are:

Y = Retain separate order billing history for each item.

N = Consolidate customer order billing history for all items.

See Merchandising Chapter 24: Performing Initial Item Entry (MITM).

Alphanumeric, 1 position; required.

SKU

This field indicates whether to consolidate order billing history by SKU. Valid values are:

Y = Retain separate order billing history for each SKU. You must also set the Item field, above, to Y.

N = Consolidate customer order billing history for SKUs.

See Merchandising Chapter 24: Performing Initial Item Entry (MITM).

Alphanumeric, 1 position; required.

Ship via

This field indicates whether to consolidate order billing history by ship via. Valid values are:

Y = Retain separate order billing history for each ship via.

N = Consolidate customer order billing history for all ship vias.

See Fulfillment Chapter 30: Working with Ship Via Codes (WVIA).

Alphanumeric, 1 position; required.

Source

This field indicates whether to consolidate order billing history by source code. Valid values are:

Y = Retain separate order billing history for each source code.

N = Consolidate customer order billing history for all items.

See Marketing Chapter 6: Working with Source Codes (WSRC).

Alphanumeric, 1 position; required.

Offer

This field indicates whether to consolidate order billing history by item. Valid values are:

Y = Retain separate order billing history for each offer.

N = Consolidate customer order billing history for all offers.

See Marketing Chapter 2: Working with Offers (WOFR).

Alphanumeric, 1 position; required.

Salesman

This field indicates whether to consolidate order billing history by salesman. Valid values are:

Y = Retain separate order billing history for each salesman.

N = Consolidate customer order billing history for all salesmen.

See Accounts Payable Chapter 11: Working with Sales Representatives (WSLS).

Alphanumeric, 1 position; required.

Item class

This field indicates whether to consolidate order billing history by item class. Valid values are:

Y = Retain separate order billing history for each item class.

N = Consolidate customer order billing history for all item classes.

See Merchandising Chapter 5: Working with Item Classes (WICL).

Alphanumeric, 1 position; required.

Long SKU department

This field indicates whether to consolidate order billing history by long SKU department. Valid values are:

Y = Retain separate order billing history for each long SKU department.

N = Consolidate customer order billing history for all long SKU departments.

See Merchandising Chapter 9: Working with Long SKU Departments (WLSD).

Alphanumeric, 1 position; required.

Order#

This field indicates whether to consolidate order billing history by order number. Valid values are:

Y = Retain separate order billing history for each order.

N = Consolidate customer order billing history for all orders.

Alphanumeric, 1 position; required.

Transaction code

This field indicates whether to consolidate order billing history by transaction code. Valid values are:

Y = Retain separate order billing history for each transaction code.

N = Consolidate customer order billing history for all transaction codes.

Transaction codes for order billing history are:

• E = entry

• M = maintenance

• B = billing

See Customer Service Chapter 34: Reviewing Customer History.

Alphanumeric, 1 position; required.

Placer

This field indicates whether to consolidate order billing history by the individual who placed the order. Valid values are:

Y = Retain separate order billing history for each placer.

N = Consolidate customer order billing history for all placers.

See Customer Service Chapter 38: Creating and Updating Individuals.

Alphanumeric, 1 position; required.

Originator

This field indicates whether to consolidate order billing history by the individual who originated the order. Valid values are:

Y = Retain separate order billing history for each originator.

N = Consolidate customer order billing history for all originators.

See Customer Service Chapter 38: Creating and Updating Individuals.

Alphanumeric, 1 position; required.

Entity

This field indicates whether to consolidate order billing history by entity. Valid values are:

Y = Retain separate order billing history for each entity.

N = Consolidate customer order billing history for all entities.

See Accounts Payable Chapter 1: Working with Entities (WENT).

Alphanumeric, 1 position; required.

Step-by-step instructions:

1. Complete the Consolidate transactions up to date field and reset the flag for each selection option you would like to override.

2. Press F9. The system submits the job CONSOL_OBH in held status. You must release this job to consolidate order billing history. Once released, the batch job consolidates order billing history based on your selection criteria, and produces the Order Billing History Consolidation Report.

Chapter 34: Working with File Sets (WFST) Contents SCVsSearchGlossary Reports XML Index Order Billing History Consolidation Report

SO03_08 CWDirect 18.0 August 2015 OTN