Grouping Production Schedules for Actual or Average Costing

Production schedules must be included in a schedule group in order to be costed for actual or average costing by the Transaction Costing process. This section discusses how to group production schedules.

A schedule group for costing can include one or more production schedules. In the organization, one job could include several production schedules across shifts and days. You can collect all the production schedules for one job together into one schedule group ID. When the schedule group ID is costed by the Transaction Costing process, the final costs are divided by the outputs across all the production schedules in the group.

Page Name

Definition Name

Usage

Auto Numbering Page

AUTO_NUM_PNL

Define a numbering scheme to create group schedule IDs. The numbering scheme is defined by SetID and the number type Schedule Group ID. You cannot create groups until you establish a numbering sequence.

Group Schedules Page

CE_GROUP_PID

Group one or more production schedules into a schedule group for costing actual and average costs make items.

Auto Group Schedules Page

CE_AUTOGRP_PID

Group one production schedule into one schedule group for costing actual and average cost make items.

Ungroup Schedules Page

CE_UNGROUP_PID

Remove production schedules from a schedule group. Production schedules cannot be removed after the Transaction Costing process (within the Cost Accounting Creation process) is run.

Use the Auto Numbering page (AUTO_NUM_PNL) to define a numbering scheme to create group schedule IDs.

The numbering scheme is defined by SetID and the number type Schedule Group ID. You cannot create groups until you establish a numbering sequence.

Navigation:

Set Up Financials/Supply Chain > Common Definitions > Codes and Auto Numbering > Auto Numbering > Automatic Numbering

This example illustrates the fields and controls on the Auto Numbering page. You can find definitions for the fields and controls later on this page.

Auto Numbering page

Field or Control

Description

Number Type

Enter Schedule Group ID to set up automatic numbering for schedule groups.

Field Name

Select the value CE_GRP_PID_ID for automatic numbering. This automatic numbering field is 10 characters long.

Start Seq (start sequence)

Enter a prefix using three characters. One or more prefixes can help identify the type of schedule group. For example, you may want to use a unique prefix of ALT for production schedules in the Atlanta plant and LDN for production schedules in the London plant.

Max Length (maximum length)

Enter maximum length of the schedule group ID. 10 or less characters can be entered.

Last Number Issued

Enter a numeric value to start the automatic numbering. The system starts by increasing in increments of one the last number that is issued.

Note: This field cannot be zero or blank. You must enter a value.

Default

If you create more than one numbering sequence for this number type, indicate the default sequence.

Use the Group Schedules page (CE_GROUP_PID) to group one or more production schedules into a schedule group for costing actual and average costs make items.

Navigation:

Cost Accounting > Item Costs > Update Costs > Group Schedules for Costing

This example illustrates the fields and controls on the Group Schedules page. You can find definitions for the fields and controls later on this page.

Group Schedules page

To cost make items using actual or average costing, you must place production schedules in a group. Use this page to add one or more production schedules to a new or existing schedule group ID. When you enter this page, the system displays all available production schedules based on the business unit, item ID, and production area. You can refine the search to include the due dates from and to production. The search results only display production schedules that are not currently attached to a group. Select the production schedules to add to the schedule group ID, enter a Description (required), and save the page.

Use the Auto Group Schedules page (CE_AUTOGRP_PID) to group one production schedule into one schedule group for costing actual and average cost make items.

Navigation:

Cost Accounting > Item Costs > Update Cost > Auto Group Schedules

This example illustrates the fields and controls on the Auto Group Schedules page. You can find definitions for the fields and controls later on this page.

Auto Group Schedules page

To cost make items using actual or average costing, you must place production schedules in a group. Use this page to add one production schedule to one schedule group ID. You can create multiple schedule groups at one time by selecting one or more production schedules. The system creates one group ID for each separate production schedule when you save this page.

Use the Ungroup Schedules page (CE_UNGROUP_PID) to remove production schedules from a schedule group.

Production schedules cannot be removed after the Transaction Costing process (within the Cost Accounting Creation process) is run.

Navigation:

Cost Accounting > Item Costs > Update Cost > Ungroup Schedules

This example illustrates the fields and controls on the Ungroup Schedules page. You can find definitions for the fields and controls later on this page.

Ungroup Schedules page

Use this page to remove production schedules from a schedule group ID. This can only be done before the Transaction Costing process (within the Cost Accounting Creation process) is run for this schedule group ID or any transaction included in this group.

Note: If a schedule group ID is created with certain production schedules and then later you remove all the production schedules from the group, then the schedule group ID cannot be used again for a different set of production schedules.