23 Product Costing Processing Options

This chapter contains these topics:

23.1 Item Cost Level Conversion (P41815)

Processing Option Processing Options Requiring Further Description
PROCESS CONTROL:  
1. Enter the cost level to update to.  
2. If updating to cost level '1', enter the branch to default the costs from.

If updating from a cost level '3', the costs will default from the primary location.

  
3. Enter a '1' to run in final mode and update files.

If blank, no file updates will occur.

  
4. Enter a '1' to print only exceptions on the edit report.

A blank will print all items.

  

23.2 Item Cost Revisions (P4105)

Processing Option Processing Options Requiring Further Description
DISPLAY CONTROL:  
1. Enter a '1' for Speed Cost Update.

If left blank, the screen will default to Item Cost Revisions.

  
DEFAULT VALUES:  
2. Enter the default cost method to display when the Speed Cost Update format is selected.  
PROCESS CONTROL:  
3. Enter a '1' to prevent the standard cost from being changed.  
4. Enter a '1' to write Subledger Information based on Item Number, into Journal Entries.

If left blank, no Subledger Information will be written in Journal Entries

  
5. Enter '1' to use 15 character lot, leave blank to default to 12 characters.  

23.3 Costing Exceptions (P30801)

Processing Option Processing Options Requiring Further Description
ERROR MESSAGES:  
1. Enter the minimum message level to appear on the report. Error messages are defined in the Vocabulary Overrides file (F0020).  
2. Enter the Cost Method to base costing errors on.

If left blank, '07' will be used.

  

23.4 Cost Simulation (P30820)

Processing Option Processing Options Requiring Further Description
DATE EFFECTIVITY:  
1. Enter the As Of Date.

If left blank, the system date will be used.

 This relates to the As Of date on the BOM and Routing. It can be utilized to simulate costs for items in the future.
COST ROLLUP MODE:  
2. Enter the Cost Method to use for the roll up.

If left blank, '07' will be used.

 This is the OUTPUT. This is the cost method you want simulated.
3. Enter a '1' to simulate only the items selected and not explode the bill of material. Works in conjunction with processing option 6 and 7.

If this is a blank, then 6 and 7 are input from F4105.

If this is a 1, then 6 and 7 are input from F30026.

Note: If this is a 1 for a single-level BOM roll, the system goes to a different input file (F30026) and when you run the cost update, the system will only revalue items that are in included in the data selection.
COST SIMULATION PRINT INFORMATION:  
4. Enter one of the following:

1 = Print all items

2 = Print changed items

If left blank, no report will be printed.

  
ROUTING CALCULATION INFORMATION:  
5. Enter one of the following:

1 = Clear and recalculate labor and overhead for manufactured items only

2 = Clear and recalculate labor and overhead for all items

3 = Clear Labor and Overhead for all items, but recalculate labor and overhead for manufactured items only

If left blank, labor and overhead will not be recalculated.

  
SUBCONTRACTED ITEMS:  
6. Enter the Cost Method to move from the Cost Ledger file (F4105) to the Cost Components file (F30026).

If left blank, no cost will be moved.

 The file read is dependent on the value in processing option 3.
PURCHASED ITEMS:  
7. Enter the Cost Method to move from the Cost Ledger file (F4105) to the Cost Components file (F30026).

If left blank, no cost will be moved.

 The file read is dependent on the value in processing option 3.
PROCESS MANUFACTURING:  
8. Enter a '1' to calculate costs of Co/By-Products.  
DEFAULT DISPLAY DECIMALS:  
9. Enter the number of decimals to use for display (0-4) in the Cost Simulation report (P30825).

If left blank, 4 decimals will be used.

  
CO/BY PRODUCT RECALCULATION:  
10. Enter a '1' to indicate that the costs of Co/By Products used as Ingredients/Components should not be cleared and recalculated.  

23.5 Item Cost Components (P30026)

Processing Option Processing Options Requiring Further Description
COST TYPES:  
1. Enter a '1' to allow input into the Calculated Cost Types for routings (B1-B4 and C1-C4). If you want to manually input these values then be sure processing option 5 is blank on the P30820 program.
SUBCONTRACT PURCHASE ORDERS:  
2. Enter the cost method to be used for subcontracted items *OPxx (i.e., 01, 02, 03).

If left blank, parent item's method will be used.

  
DEFAULT DECIMALS:  
3. Enter the number of decimals to use for display (0-4).

If left blank, 4 decimals will be used.

  
AS OF DATE:  
4. Enter the As of Date for which Operation sequences will be picked up from Routing (F3003) for Cost Type Calculations Detail Window.

If left blank, this will default to today's System Date.

  

23.6 Costed Bill of Material Inquiry (P30206)

Processing Option Processing Options Requiring Further Description
DEFAULT VALUES:  
1. Enter the number of decimals to use for display (0-4).

If left blank, 4 decimals will be used.

  
2. Enter a '1' to base fixed costs on the requested quantity.

If left blank, fixed costs will be based on the Accounting cost quantity.

  

23.7 Costed Routing Inquiry (P30208)

Processing Option Processing Options Requiring Further Description
SUBCONTRACT PURCHASE ORDERS:  
1. Enter the cost method to be used for subcontracted items.

If left blank, '01' will be used.

  
PURCHASED ITEMS:  
2. Enter the cost method to be used for purchased items.

If left blank, '07' will be used.

  
OPERATION SEQUENCE DISPLAY:  
3. Enter a '1' to display the costs up to and including the operation sequence entered in the 'Skip To' field.

If left blank, the costs will be displayed beginning with the entered operation's costs.

  
TOTALING OPTIONS:  
4. Enter a '1' to include cost buckets 1 and 2 in the total.

If left blank, the total will only include cost buckets 3-6.

  
COSTED RESOURCES/CO/BY-PRODUCTS:  
5. Enter the number of decimals to display (0-4) in the Costed Resources/Co/By-Products window.

If left blank, 4 decimals will be used.

  

23.8 Item Cost Update (P30835)

Processing Option Processing Options Requiring Further Description
PROCESSING CONTROL:  
1. Enter a '1' to update costs.

If left blank, Proof mode is assumed and costs will not be updated.

  
2. Enter the Cost Method to update in the Cost Components and Item Cost Ledger files.

If left blank, '07' will be used.

 This is the OUTPUT. This is the cost method that will be updated in final mode.
3. Enter a '1' to update only the items selected and not explode the bill of material.

Note: If revaluing configured item WIP, include all changing configured items and their changing components in the data selection (no standard BOM).

 If this is set to 1, only the items in the data selection will update. If blank, then all items on all levels of the Bill of material will be updated.
4. Enter a '1' to update the Work Center Rates in the Work Center Rates file.

If left blank, rates will not be updated.

  
PROCESS MANUFACTURING:  
5. Enter a '1' to update costs of Co/By-Products.  
ACCOUNT LEDGER INFORMATION:  
6. Enter one of the following:

1 = Write Detailed G/L transactions (by Item)

2 = Write Summarized G/L transactions (by Account).

If left blank, no G/L transactions will be written.

  
7. Enter the General Ledger Date.

If left blank, the system date will be used.

  
REPORT FORMAT:  
8. Enter one of the following:

1 = Print all items

2 = Print changed items

If left blank, all items will be printed.

  
WIP RE-VALUATION:  
9a. Enter a '1' to adjust WIP according to new costs.

9b. Enter a '1' to include configured items in WIP revaluation. If left blank, configured work orders will not be adjusted.

WARNING: If unexpected journal entries are written by WIP revaluation, the only recovery is to restore the F3102 (production cost file) from backup, so use of proof mode is recommended (see processing option 1).

  
10. Enter the document type.

If left blank, 'IB' will be used.

  
11. Enter one of the following:

1 = Write Detailed G/L transactions (by document)

2 = Write Summarized G/L transactions (by Account).

If left blank, no G/L transactions will be written.

  
12. Enter a '1' to move the Production Document Number into the Sub-Ledger field. This cannot be set to 1 if processing option 6 or 11 is set to 2.
DEFAULT DISPLAY DECIMALS:  
13. Enter the number of decimals to use for display (0-4) in the Item Cost Rollup Report(P30835).

If left blank, 4 decimals will be used.

  
FLEX ACCOUNTING:  
14. Enter '1' to use flex accounting.

If left blank, flex accounting will not be used.

  

23.9 Item Ledger - Costs (P4111)

Processing Option Processing Options Requiring Further Description
DISPLAY OPTIONS:  
1. Enter the format to be displayed:

1 = Running Quantity Balance format.

2 = Running Dollar Balance format.

3 = Cost Item Ledger format.

4 = Location Item Ledger format.

5 = Lot Status/Grade/Potency Item Ledger format.

If left blank, the Cost Item Ledger format will be displayed.

  
DEFAULT VALUES:  
2. Enter the default document type upon entering the video.

If left blank, a '*' will default for all document types.

  
3. Enter a '1' to display Item Ledger entries in ascending date and time order.

If left blank, the entries will be displayed in descending date and time order.

(This option does NOT apply to Running Balance formats.)

  
4. Enter a '1' to search by Original Document Type.

If left blank, the search will be done by G/L Document Type.

  
DREAM WRITER VERSIONS:

Enter a DREAM Writer Version for the following programs.

(ZJDE0001) is the default.

  
5. Load & Delivery Ledger Inq P49511  

23.10 Costed Bill (P30440)

Processing Option Processing Options Requiring Further Description
BILL EFFECTIVITY:  
1. Enter the As Of Date for the bill of material.

If left blank, the system date will be used.

  
COSTING OPTIONS:  
2. Enter the Cost Method to use.

If left blank, '07' will be used.

  
3. Enter the costs to be printed.

1 = Simulated

2 = Frozen

  
4. Enter the number of units to cost (e.g., 10000).  
5. Enter a '1' to base fixed costs on the requested quantity.

If left blank, fixed costs will be based on the Accounting cost quantity.

  
AMOUNT DECIMAL POSITIONS:  
6. Enter a '1' to display 2 decimal positions in the amount fields.

If left blank, 4 decimal positions will be displayed in the amount fields.

  

23.11 Multi-Level Costed Bill (P30445)

Processing Option Processing Options Requiring Further Description
BILL EFFECTIVITY:  
1. Enter the As Of Date for the bill of material.

If left blank, the system date will be used.

  
COSTING OPTIONS:  
2. Enter the Cost Method to use.

If left blank, '07' will be used.

  
3. Enter the costs to be printed.

1 = Simulated

2 = Frozen

  
4. Enter the number of units to cost (e.g., 10000).  
PRINT FORMAT:  
5. Enter a '1' to print an indented bill of material.  
6. Enter a '1' to print a Unit Cost line of detail.

If left blank, only one line of detail will be printed for each item.

  

23.12 Cost Components (P30026P)

Processing Option Processing Options Requiring Further Description
REPORT FORMAT:  
1. Enter the Cost to print:

1 - Simulated Cost

2 - Frozen Cost

  

23.13 Cost Component/Ledger Integrity (P30543)

Processing Option Processing Options Requiring Further Description
REPORT FORMAT:  
1. Enter a '1' to see report detail for all items processed.

If left blank, only items with cost discrepancies will be printed.

  

23.14 Comprehensive Cost Comparison-Cost Lvl 1 (P30550)

Processing Option Processing Options Requiring Further Description
PRINT VARIANCE OPTIONS:  
1. Enter a '1' to print items with a cost ledger unit cost (F4105) vs.

frozen cost (F30026) variance.

Enter a '2' to print items with a simulated cost vs. frozen cost (F30026) variance.

Enter a '3' to print items with either or both variances. Leave blank to print all items regardless of any variances.

Blank is the default.

  
STOCKING TYPES:  
2. Enter the Stocking Types of items to be selected to print on the report. Up to 5 stocking types may be entered. (for example: MPX) If left blank, all stocking types will be selected.  

23.15 Copy Component Cost Values (P30890)

Processing Option Processing Options Requiring Further Description
COPY FROM INFORMATION:  
1. Branch/Plant (Required)  
2. Cost Method (Required)  
3. Select the Costs to be copied:

1 = Simulated

2 = Frozen

  
COPY TO INFORMATION:  
4. Branch/Plant (Required)  
5. Cost Method (Required)  

23.16 Cost Simulation Reset (P30850)

Processing Option Processing Options Requiring Further Description
PROCESSING CONTROL:  
1. Enter the Branch/Plant to be processed or '*' to process all Branch/Plants.  
2. Enter a '1' to reset rates for Cost Centers for the selected Cost Method(s).  

23.17 Update Sales Cost, Price, or Exchange Rate (P42950)

Processing Option Processing Options Requiring Further Description
UPDATE OPTIONS:  
1. Enter '1' to update Sales Order with the most current unit cost.

If left blank, will not update cost.

  
2. Enter '1' to update the currency exchange rate. Please note that only the domestic amounts will be re-calculated, the foreign amounts will remain the same.

If left blank the currency exchange rate will remain the same.

  
3. Enter '1' to update the inter-company currency exchange rate. Foreign amounts will not be re-calculated.

If left blank, will not update the inter-company exchange rate.

  
UPDATE PRICE OPTIONS:  
4. Enter '1' to recalculate the unit price of the sales order.

If left blank, the unit price will remain the same.

  
5. Enter '1' to recalculate the Transfer Price for inter-branch sales. The pricing method specified when the order was entered will be used.  
6. Specify the date on which all base price and advanced price adjustment recalculations will be based:

' ' - Transaction/Order Date

'1' - Requested Ship Date

'2' - Promised Ship Date

'3' - Original Promised Date

'4' - Actual Ship Date

'5' - System Date

'6' - Invoice Date

'*' - Use System Constants value

'P' - Use Based-on Date Preference

NOTE: Processing options 7 thru 9 are supported only by the Advanced Price Adjustment Module (45).

  
7. Enter the Line Type of the new sales detail line item. This line item will contain the difference between the old sales price and the newly recalculated price.

If left blank, will update the new price directly to the item. This must be a non-inventory Line Type.

  
8. If you have specified in the last processing option to create a sales detail record to record the price difference, enter the override next status of the detail line.

If left blank, will use the original detail line's next status.

  
9. Enter '1' to base recalculation on the original order quantity.

If left blank, the system will recalculate based on the current quantities of the order.

  

23.18 Item Cost Revisions (P4105)

Processing Option Processing Options Requiring Further Description
DISPLAY CONTROL:  
1. Enter a '1' for Speed Cost Update.

If left blank, the screen will default to Item Cost Revisions.

  
DEFAULT VALUES:  
2. Enter the default cost method to display when the Speed Cost Update format is selected.  
PROCESS CONTROL:  
3. Enter a '1' to prevent the standard cost from being changed.  
4. Enter a '1' to write Subledger Information based on Item Number, into Journal Entries.

If left blank, no Subledger Information will be written in Journal Entries

  
5. Enter '1' to use 15 character lot, leave blank to default to 12 characters.