This chapter provides overviews of user-defined codes (UDCs) for product costing and costing information setup and discusses how to:
Define accounting cost quantities for standard costing.
Define inventory cost levels.
Define cost methods and item costs.
Set up manufacturing constants.
Set up standard rate and factor codes.
Assign values to user-defined cost components.
Set up simulated rates for work centers.
Set up general ledger class codes.
Define manufacturing automatic accounting instructions (AAIs).
Many fields throughout the JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting systems require UDCs. UDCs enable you to establish and maintain valid codes for various types of information to meet the needs of the organization. Codes are categorized by system and code type.
This table lists the UDCs that are used by the JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting systems:
UDC |
Description |
Use cost components to identify and track each type of cost for an item. The letter A at the beginning of a cost component is used for material costs, B for labor and machine hours, and C for labor and machine-based overhead. Cost components that begin with A, B, or C are hard-coded and cannot be changed or used for other cost component types. You can define an unlimited number of additional cost components to account for extra costs for an item, such as electricity or research and development. You can assign separate cost components by categories that are applicable to the business. The UDCs for extra cost components can begin with any letter except A, B, or C. Although you might attempt to set up extra cost components that begin with these letters, the Cost Simulation program (R30812) actually deletes these cost components. Note. The letter D is used for outside operations in demo data, but any code other than A, B, or C with a special handling code of 1 can be used. When you set up cost components, define a separate UDC value for all the possible cost components that might be used in the cost rollup for an item. Complete the following fields with the information indicated:
|
|
Use cost buckets to group similar cost components for inquiry and reporting purposes. When you set up cost buckets, complete the following fields with the information indicated:
|
|
Use operation bucket codes to combine component costs in each step in the routing. That is, you can group operation costs into totals that appear on review programs and reports for costed routings. For example, you might track labor costs by separate cost components that represent setup, run, and overhead labor for an item. When you assign the same sequence number to each cost component, you can combine these cost components into one total cost for labor on the review program for costed routings or report for the item. When you set up operation bucket codes, complete the following fields with the information indicated:
|
|
Set up the error messages that appear on the Costing Exceptions report (R30801) when any item contains any of the errors that are included in this table. You can change the severity level of an error to one that is appropriate for the company. The severity level is defined in Description 2. The error messages are hard-coded. You cannot add or delete messages. If you change the name of an existing message, you should not change its meaning, but merely adapt the definition to one that is more clearly understood by the company. |
|
If you want the weighted average cost (cost method 02) to be updated automatically by the system, use this UDC table to enter the program numbers for each of the programs that you want the system to update. Add Work Order Completions (P31114) and Variance Journal Entries (R31804) for actual costing. |
|
Define the cost methods that are used to calculate costs for all items. Codes 01 through 09 are hard-coded and cannot be altered. Codes 10 through 19 are reserved for use by the JD Edwards EnterpriseOne system from Oracle. Codes 02, 07, and 09 are the only cost methods that are supported by manufacturing. |
Example: Setting Up Cost Bucket Codes for Costed Bills of Material
You can group similar cost components for review and reporting purposes. For example, you can define A1 and A2 cost components as Purchasing. You do this by assigning them the same sequence number in the Description 2 field. The sequence number also determines in which order the groups appear on costed bill inquiries and reports. You can then use the costed bill inquiries and reports to review the total costs for the group Purchase.
Each cost bucket can contain several defined cost components.
This example illustrates how you might define the buckets and UDCs:
Bucket Number |
Description |
Bucket 1 |
Purchase: Includes cost components A1 (material), A2 (scrap), and D1 (outside operations). |
Bucket 2 |
Labor: Includes cost components B1 (direct labor), B2 (setup), and B4 (labor efficiency). |
Bucket 3 |
Machine: Includes cost component B3 (machine run). |
Bucket 4 |
Overhead: Includes cost components C1 (machine variable) and C2 (machine fixed). |
Bucket 5 |
Extras: Includes cost components X1 (taxes) and X2 (electricity). |
This example of UDC 30/CB illustrates how you might define the UDCs in the software:
Codes |
Description 01 |
Description 02 |
Hard-Coded |
A1 |
Purchase |
1 |
Y |
A2 |
Purchase |
1 |
Y |
B1 |
Labor |
2 |
Y |
B2 |
Labor |
2 |
Y |
B3 |
Machine |
3 |
Y |
B4 |
Labor |
2 |
Y |
C1 |
Overhead |
4 |
Y |
C2 |
Overhead |
4 |
Y |
C3 |
Overhead |
4 |
Y |
C4 |
Overhead |
4 |
Y |
You can set up JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting to meet specific manufacturing environment needs. The system uses the values that you define to determine the costs of the items that you manufacture.
The system uses accounting cost quantities to determine the allocation of fixed costs for an item. Accounting cost quantities represent the standard quantity of a work order or rate schedule for this item. During cost rollup, the system divides the fixed costs by the accounting cost quantity that you specify to determine a per unit fixed cost.
You use the Item Branch/Plant program (P41026) to define accounting cost quantities for standard costing.
Note. If you use either of the actual cost methods (02 or 09) for an item, you do not need to complete this task.
Form Name |
FormID |
Navigation |
Usage |
W41026D |
Item Revisions (G4112), Item Branch/Plant Manufacturing Data Retrieve an item number, select a record, and then select Addl System Info (additional system information) from the Row menu. |
Define accounting cost quantities for standard costing. |
Access the Additional System Info form.
Accounting Cost Qty (accounting cost quantity) |
Enter the amount that the system uses in cost rollup to determine the allocation of setup costs. The system totals the setup costs and divides the sum by this quantity to determine setup costs per unit. The default value is 1. |
This section provides an overview of inventory cost levels and discusses how to define inventory cost levels.
The cost level that you assign to an item indicates the level at which the system maintains costs. You determine whether the system maintains one overall cost for an item (cost level 1) or a different cost for the item in each branch/plant (cost level 2). The system can also maintain a different cost for each location and lot within a branch/plant (cost level 3).
You should assign cost level 3 if you use actual costing. For configured items, you must assign cost level 3. However, the system does not support cost level 3 for standard costing.
After you have initially assigned an inventory cost level to an item in the Item Master program (P4101), you should not change the cost level manually on the Item Master Revisions form. Instead, use the Item Cost Level Conversion program (R41815) to change the cost level for an item.
Form Name |
FormID |
Navigation |
Usage |
W4101A |
Inventory Master/Transactions (G4111), Item Master Retrieve an item on the Work With Item Master Browse form. Select the record and click Select. |
Define inventory cost levels. |
Access the Item Master Revisions form.
Inventory Cost Level |
Enter the level at which you want the system to maintain inventory costs. The system stores inventory costs with the inventory cost level in the Item Cost table (F4105). Values are: 1: Item level 2: Item/Branch level 3: Item/Branch/Location level |
Lot Process Type |
If you use actual costing and selected cost level 3, complete this field. The lot process type is a code that indicates whether lot or serial number is assigned. Lot and serial number processes use the Lot Master table (F4108). Values are: 0: Lot assignment is optional. You can assign numbers manually. Quantity can be greater than one. (Default) 1: Lot assignment is required. The system assigns numbers using the system date in YYMMDD format. Quantity can be greater than one. 2: Lot assignment is required. The system assigns numbers in ascending order using Next Numbers. Quantity can be greater than one. 3: Lot assignment is required. You must assign numbers manually. Quantity can be greater than one. 4: Serial number assignment is optional except during shipment confirmation. Quantity must not exceed one. 5: Serial number assignment is required. The system assigns numbers using the system date in YYMMDD format. Quantity must not exceed one. |
This section provides an overview of cost methods and item costs, lists a prerequisite, and discusses how to:
Set processing options for Cost Revisions (P4105).
Define cost methods and item costs.
You must provide cost information for each item that you use so that the system can track inventory costs. When you define an item with cost level 2 or 3, you specify the cost method that the system uses to determine the cost of an item for sales transactions, inventory transactions, and purchase orders in the Branch/Plant Constants program (P41001). You can override the values that you defined in the branch/plant constants for a particular item at the item branch/plant level. For example, you can specify that the system use the weighted average cost method to determine the inventory cost for an item and use the last-in cost method to determine the item's unit cost for purchase orders.
You can set up the JD Edwards EnterpriseOne Manufacturing Accounting system for these costing types:
Costing Type |
Description |
Use cost method 07 (Standard). This method is useful for items that are manufactured in volume with low variety and have stable costs. When you use cost method 07 for the parent item, the system uses only method 07 for all components, outside operations, and so forth. |
|
Use either cost method 02 (Weighted Average) or cost method 09 (Manufacturing Last Cost). When you assign either cost method 02 or 09 to the parent item, the system uses this value to update the Ledger field (LEDG) in the Work Order Master Tag table (F4801T) when work orders are generated. Therefore, the components on the parts list for the parent item can have any valid cost method (UDC 40/CM). The actual costing methods apply to discrete items only. Cost method 02 is useful for costs that change often. Use this method when you do not want to revalue on-hand inventory when the work orders are completed, but at a different time. Cost method 09 is useful for items that are engineered or manufactured to order and have costs that change often and significantly. Use this method when you want to revalue the inventory each time that you run the work order completion programs. Important! Because JD Edwards EnterpriseOne software does not support actual costing for process and configured items, the system issues an error message if you attempt to define an actual cost method for a process item (stocking type R) or a configured item (stocking type C). |
For every cost method that you assign to an item, you must specify an item cost. For actual costing methods you can either enter an initial cost or let the system update it with the last manufactured cost.
Note. You can remove a cost method for an item if it is no longer applicable. If you try to remove the sales and inventory or purchasing cost method, the system displays a warning message. The system does not delete the cost method, but updates it to a cost of zero.
To define cost methods and costs for items, you must first set up the Cost Method UDC table (40/CM).
Form Name |
FormID |
Navigation |
Usage |
W4105A |
Product Costing (G3014), Enter/Change Item Costs On the Work With Item Cost form, enter a valid combination of branch/plant and item number and click Add. |
Define cost methods and item costs. |
These processing options control default processing for the Cost Revisions program.
Process
This processing option controls whether you can change standard costs.
Process |
Enter 1 to prevent the standard cost from being changed. |
Interop
This processing option controls whether interoperability is enabled.
Transaction type |
Specify the transaction type for the interoperability transaction. If you leave this processing option blank, outbound interoperability processing is not used. |
Flex Acct
This processing option controls whether flex accounting is enabled.
Flex Accounting |
Specify whether to enable flex accounting. If you leave this processing option blank, the system does not use flex accounting. Note. To use this processing option, you must first enable flex accounting for AAIs 4134 and 4136. |
Access the Cost Revisions form.
Sales/Inventory |
Enter a value from UDC table 40/CM that indicates the cost method that the system uses for the inventory value and to calculate the cost of goods sold (COGS) for the item. Cost methods 01 through 19 are reserved for JD Edwards EnterpriseOne system use. If you maintain costs at the item level, the system retrieves the default value for this field from the data dictionary. If you maintain costs at the item and branch/plant levels, the system retrieves the default value from branch/plant constants. |
Purchasing |
Enter a value from UDC table 40/CM that indicates the cost method that the system uses for the inventory value and to calculate the cost of goods that are sold for the item. Cost methods 01 through 19 are reserved for JD Edwards EnterpriseOne system use. If you maintain costs at the item level, the system retrieves the default value for this field from the data dictionary. If you maintain costs at the item and branch/plant level, the system retrieves the default value from branch/plant constants. |
Cost Method |
Enter a value from UDC table 40/CM that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for use by the JD Edwards EnterpriseOne system. |
Unit Cost |
Enter the cost for one unit of this item in the primary unit of measure, based on the corresponding cost method. You can change the monetary amount for any cost method at any time except for cost method 07 (standard). You can prevent standard costs from being changed by setting the processing option. Best practice for changing standard costs is running the Frozen Update program (R30835). If you change the amount for the cost method that you use to value inventory and to track costs of goods sold, the system applies the new amount to the on-hand quantity of the item and creates journal entries to account for the difference between the old and the new amounts. Certain programs update the monetary amount for some cost methods. Examples include:
|
Note. If you enter a cost method for sales and inventory or purchasing and do not set up a cost amount for that method, a warning message appears. If you do not enter a cost amount for the cost method, the system assigns a cost of zero.
This section provides an overview of manufacturing constants and discusses how to set up manufacturing constants for product costing and manufacturing accounting.
You must define product costing and manufacturing accounting information that is unique to the branch/plant.
You use the Manufacturing Constants program (P3009) to specify this cost calculation information:
Whether to maintain costs at the work center level or the cost component level.
Which overhead costs to calculate.
Whether the program considers work center efficiency when calculating direct labor and overhead.
Whether overhead costs are entered as percentages or rates.
If you use actual costing, you can specify the sources for labor and machine rates that the system uses to calculate labor and machine costs.
Costing by Work Center
You can also use the manufacturing constants to specify the level of detail that you want to use for costing. You can cost items by cost component or you can set up the branch/plant to perform costing separately for each work center.
Form Name |
FormID |
Navigation |
Usage |
W3009B |
Product Costing Setup (G3042), Manufacturing Constants Select a branch/plant on the Work with Manufacturing Constants form, and click Select. |
Set up manufacturing constants for product costing and manufacturing accounting. |
Access the Manufacturing Constants Revision form.
Select the Costing Options tab.
Cost by Work Center |
Select to indicate that the system tracks cost variances for discrete and process items on a summarized level in the Item Cost Component Add-Ons table (F30026) or on a detailed level by cost component and work center in the Item Cost Component Detail table (F300261). |
Modify cost by Work Center Efficiency |
Select to indicate that the cost rollup creates cost component B4 (for labor efficiency) based on the direct labor value (cost component B1) and the Work Center Efficiency percentage from the Work Center Master table (F30006). |
Include Work Center Eff. in Overhead (include work center efficiency in overhead) |
Select to indicate that the cost rollup includes work center efficiency when you calculate overhead values if you specified that you want to modify costs by work center efficiency. |
Include Var. Labor Overhead in cost (include variable labor overhead in cost) |
Select to indicate that the cost rollup creates cost type component C3 (for variable labor overhead) in the Item Cost Component Add-Ons table (F30026). |
Calculate Var. on Setup Labor (calculate variable on setup labor) |
Select to indicate that the cost rollup includes setup labor expenses (cost component B2) in the total that is used to calculate variable setup overhead (cost component C3). |
Calculate Var. on Direct Labor (calculate variable on direct labor) |
Select to indicate that the cost rollup includes direct labor expenses (cost component B1) in the total that is used to calculate variable labor overhead (cost component C3). |
Include Fixed Labor Overhead in cost |
Select to indicate that the cost rollup creates cost component C4 (for fixed labor overhead) in the Item Cost Component Add-Ons table. |
Calculate Fixed on Setup Labor |
Select to indicate that the cost rollup includes setup labor expenses (cost component B2) in the total that is used to calculate fixed setup overhead (cost component C4). |
Calculate Fixed on Direct Labor |
Select to indicate that the cost rollup includes direct labor expenses (cost component B1) in the total that is used to calculate fixed labor overhead (cost component C4). |
Include Var. Machine Overhead in cost (include variable machine overhead in cost) |
Select to indicate that the cost rollup creates cost component C1 (for variable machine overhead) in the Cost Components table (F30026). |
Include Fixed Machine Overhead in cost |
Select to indicate that the cost rollup creates cost component C2 (for fixed machine overhead) in the Item Cost Component Add-Ons table. |
Machine Rate Source |
Enter a value that specifies the source for machine rates when the system calculates routing costs in the Production Cost table (F3102). Values are: 1: Work Center Rates table (F30008) 2: Equipment Rates table (F1301) |
Labor Rate Source |
Enter a value that specifies the source for labor rates when the system calculates the routing costs in the Production Cost table (F3102). Values are: 1: Work Center Rates table (F30008) 2: Employee Labor Rates table (F00191) |
Overheads |
Specify whether values for overhead fields (cost components C1 through C4) in the Work Center Rates table are expressed as percentages or rates. To specify whether the system expresses the overhead fields as percentages or rates, click either Percentages or Rates under the Overheads heading. |
See Also
Setting Up Manufacturing Constants
This section provides an overview of standard rate and factor codes and discusses how to set up standard rate and factor codes.
Standard rate and factor codes represent overhead costs or other indirect costs that you cannot assign directly to a certain production process or operation, but that must be accounted for in the costs of an item. These types of costs include utilities, insurance, research and development costs, rent or lease payments, and other types of operating costs.
Note. Rate and factor codes are user-defined, but you do not use the User Defined Codes program to enter and maintain rate and factor codes. Instead, you use the Generic Message/Rates Records program (P00191) to enter and revise rate and factor codes.
The Cost Simulation program (R30812) uses the rates and factors that you define to calculate the extra costs that appear in the Cost Components program (P30026).
Form Name |
FormID |
Navigation |
Usage |
W00191D |
|
Set up standard rate and factor codes. |
Access the Enter Generic Message/Rates form.
Code |
Place the cursor in the first blank line and enter a code that the Cost Components program uses in conjunction with the factor code to calculate extra costs. |
Description |
Enter a description of the code. |
Rate |
Enter a code that is used to define rate information in the General Rate/Message Records table (F00191). The system uses the rate that you set up with up to four decimal places to calculate the extra costs for this code. |
This section provides an overview of user-defined cost component values, lists prerequisites, and discusses how to:
Assign values to user-defined cost components.
Assign values to cost components by work center.
Review simulated and frozen costs and rates.
Review costs by work center.
Review calculation basis for unit costs at routing operations.
After you set up cost components and standard rate and factor codes, you must assign a monetary value to each. The system adds these values to the net amount of each item that you set up. You can assign a net-added value manually, or you can assign a predefined value.
You can also assign a calculated value based on the total value of another cost component. In this case, the system calculates the net-added value based on the total for an existing cost component. In addition, you can assign a calculated value based on the net-added value of another cost component. The system calculates the net-added value based on the net-added value for an existing cost component. In both circumstances, the system calculates this value when you enter information in the Cost Components program. The costs are then rolled up into the cost of the item when you run the Cost Simulation program.
For extra costs, the system can calculate the net-added value by multiplying a rate and factor. If you enter both amounts, the system multiplies the two numbers to calculate the net-added cost for the cost component for that item.
Cost Components by Work Center
To enable you to track variances not only on the cost-component level, but also on the work-center level, you can enter different cost component values for different work centers. This method enables you to track cost variations in each work center even if other inputs to the manufacturing process, for example items, routing, bill of material, work center rates, shop floor transactions, total costs, and total variance are the same.
To identify variances by cost center, you define different values for cost components in the work centers that you use on a routing. You can track and analyze material and labor costs by work center. The system enables you to review the net-added unit cost at each routing operation step on the Work With Work Center Cost form for the cost component that you select. For labor-related costs, you can access the Work With Cost Calculation form to display the calculations that the system uses to derive the net-added unit cost at each routing step; however, this information is not available for material costs.
Before assigning values to user-defined cost components, you must:
Set up standard rate and factor codes.
Set up work centers and select the Cost by Work Center option in the manufacturing constants if you want to track cost information by work center.
Form Name |
FormID |
Navigation |
Usage |
W30026B |
Product Costing (G3014), Enter/Change Cost Components On the Work With Cost Components form, enter a combination of branch/plant and item number, click Find, and then click Select. |
Assign values to user-defined cost components. |
|
W30026D |
On the Work With Cost Components form, enter a combination of branch/plant and item number, click Find, and then select Costs by Workcenter from the Form menu. |
Assign values to cost components by work center. |
|
W30026F |
On the Enter Cost Components form, select a record and then select Cost Detail from the Row menu |
Review simulated and frozen costs and rates. |
|
W30026A |
On the Enter Cost Component form, select a record and select Cost Calc (cost calculation) from the Row menu. |
Review costs by work center. |
|
W30026E |
On the Work With Work Center Cost form, select Cost Calc (cost calculation) from the Row menu. |
Review calculation basis for unit costs at routing operations. |
Access the Enter Cost Components form.
Cost Type |
Enter a code that designates each element of cost for an item. Examples of cost component types are: A1: Purchased raw material. B1: Direct labor routing rollup. B2: Setup labor routing rollup. C1: Variable burden routing rollup. C2: Fixed burden routing rollup. Dx: Outside operation routing rollup. Xx: Extra add-ons, such as electricity and water. The optional add-on computations usually operate with the type Xx extra add-ons. This cost structure enables you to use an unlimited number of cost components to calculate alternative cost rollups. The system then associates these cost components with one of six user-defined summary cost buckets. |
Simulated Net Added and Frozen Net Added |
If you want to assign a net-added value manually, enter the appropriate value for the cost component. The system uses this value to calculate costs during the simulation process. This is the cost to build this item at its level in the bill of material. This cost does not include materials (lower-level components). The program displays costs that you manually enter in the Simulated Total field. If you have run the Item Cost Component - Frozen Update program (R30835), the system displays frozen net-added costs. |
Simulated Total and Frozen Total |
Enter the sum of the net added cost at this level plus the sum of the total costs of the direct components of the item (which includes lower-level component costs of those items.) The heading above the Net Added and Total columns indicates whether the costs are simulated or frozen values. The system uses this value to calculate the cost of all the lower levels during the simulation process for the designated cost method. If you have run the Item Cost Component - Frozen Update program, the system displays frozen total costs. |
Sim Fac Code (simulated factor code) |
To assign a predefined value to a cost component for extra costs, select one of the values that you defined for the factor code (30/CF) in the Generic Message/Rates table (F00191). The system multiplies the value in this field by the value in the Simulated Rate field. Note. To review the valid factor codes, use the Search button or select Factors from the Form menu. To assign a value to a cost component based on the total value of another cost component, select a cost component type and type & followed by the cost component code in the Sim Fac Code (simulated factor code ) field. Because of the way in which the system rolls up the costs, the cost component that you reference must come before the cost component that you are defining. For example, to define cost component X2, you can reference cost component X1 by entering &X1 in this field, but you cannot define cost component X1 by referencing cost component X2. To assign a calculated value based on the net added value of another cost component, you must enter specific information in this field: * followed by the based on cost-component code. Because of the way in which the system rolls up the costs, the cost component that you reference must come before the cost component that you are defining. For example, to define cost component X2, you can reference cost component X1 by entering *X1 in this field, but you cannot define cost component X1 by referencing cost component X2. The system retrieves the total value or net-added value for the based on cost component and multiplies it by the value in the Simulated Rate Code field or the Simulated Rate field. |
Simulated Rate Code |
To assign a predefined value to a cost component for extra costs, select one of the values that you defined for the rate code (30/CR) in the Generic Message/Rates table (F00191). The system multiplies the value in this field with the value in the Sim Fac Code field. Note. To review the valid rate codes, use the Search button or select Rates from the Form menu. |
Frozen Net Added |
For standard costing, this field displays the net added costs after you run the frozen cost update process. If you use actual costing (cost method 02 or 09), you enter the actual costs directly into this field. |
Access the Enter Cost Components by Work Center form.
Enter cost component information for each work center to which you want to assign separate costs.
Access the Cost Component Detail form.
Review cost component detail information for the selected cost component. If you have set up costing by work center, the system displays the work center to which the simulated and frozen costs and rates for the cost component apply.
Access the Work With Work Center Cost form.
Review the net-added unit costs by cost component at each routing operation step.
Access the Work With Cost Calculation form.
Review the calculations that the system uses to derive the net-added unit costs at each routing step for the selected cost component.
Note. You cannot review the calculation basis for material costs.
This section provides an overview of simulated rates, lists a prerequisite, and discusses how to create simulated rates for work centers.
You can effectively manage changes to a work center by tracking rates for labor and machine costs. You can update simulated rates for machine and labor hours by work center and cost method. The system uses these values in other manufacturing calculations that are used in costed routings, labor rate variance reports, and direct labor efficiency reports.
If you use standard costing, you must set up the simulated rates for work centers.
If you use actual costing, you can use work center rates for machine and labor costs. You set up the source for machine and labor rates in the manufacturing constants.
You can set up the work center rates even if you have decided to use labor or machine rates. The system uses the work center rate as the default rate if no other rates have been selected.
Before you set up simulated rates for work centers, you must set up work centers.
Form Name |
FormID |
Navigation |
Usage |
W3006C |
Product Costing (G3014), Enter/Change Work Center Rate On the Work With Work Center Rates form, enter a combination of branch/plant and work center, click Find, and then click Select. |
Create simulated rates for work centers. Create or change work center rates for labor and machine costs. |
Access the Work Center Rate Revisions form.
Work Center |
Review the number that identifies a branch, plant, work center, or business unit. |
Direct Labor |
Enter a rate, in cost per person per hour, that the system uses, together with the run labor hours of the associated routing, to calculate the standard run labor cost. |
Setup Labor |
Enter a rate that the system uses together with the setup labor hours of the associated routing to calculate the standard setup labor cost. |
Labor Variable O/H (labor variable overhead) |
Enter a rate or percentage, as determined in the manufacturing constants, that the system uses to calculate the standard cost for variable labor overhead. If this field contains a rate, it is the cost per hour. If this field contains a percentage, it is the percentage of direct labor. Enter percentages as whole numbers. For example, enter five percent as 5.00. |
Labor Fixed O/H (labor fixed overhead) |
Enter a rate or percentage, as determined in the manufacturing constants, that the system uses to calculate the standard cost for fixed labor overhead. If this field contains a rate, it is the cost per hour. If this field contains a percentage, it is the percentage of direct labor. Enter percentages as whole numbers. For example, enter five percent as 5.00. |
Machine Run |
Enter a rate that the system uses, together with the run machine hours of the associated routing, to calculate the standard machine labor cost. |
Machine Variable O/H (machine variable overhead) |
Enter a rate or percentage, as determined in the manufacturing constants, that the system uses to calculate the future standard cost for machine overhead. If this field contains a rate, it is the cost per hour. If this field contains a percentage, it is the percentage of machine run. Enter percentages as whole numbers. For example, enter five percent as 5.00. |
Machine Fixed O/H (machine fixed overhead) |
Enter a rate or percentage, as determined in the manufacturing constants, that the system uses to calculate the standard cost for fixed machine overhead. If this field contains a rate, it is the cost per hour. If this field contains a percentage, it is the percentage of machine run. Enter percentages as whole numbers. For example, enter five percent as 5.00. |
See Also
Entering Costing and Accounting Information for Work Centers
This section provides an overview of general ledger class codes and lists the forms used to set up general ledger class codes.
General ledger (GL) class codes are used by the AAIs to determine which accounts the system posts transactions to for specific items.
You set up the GL class code in the Item Master and the Branch/Plant program (P41026). When you associate the item with the item location, the system copies that value to the Item Location table (F41021). You can revise the GL class code for an item using the Location Revisions program. The AAIs retrieve the appropriate GL class code from the Item Location table.
Because the system generates journal entries based on GL class codes and AAIs, you should set up the class codes carefully and in collaboration with the accounting department.
See Also
Form Name |
FormID |
Navigation |
Usage |
W41026A |
Inventory Master/Transactions (G4111), Item Branch/Plant On the Work With Item Branch form, search for an item and branch combination, select the record, and click Select. |
Set up general ledger class codes. |
|
W41024A |
On the Work With Item Branch form, select Location Revisions from the Row menu. On the Work With Item Locations form, select a location and click Select. |
Make location revisions, such as changing the class code. |
This section provides an overview of manufacturing AAIs and discusses how to:
Set processing options for Automatic Accounting Instructions (P40950).
Define manufacturing AAIs.
Each transaction for which the system creates journal entries requires AAIs that instruct the program to post amounts to specific accounts in the general ledger. User-defined AAIs connect manufacturing accounting, the chart of accounts, and financial reporting. You should create AAIs for each unique combination of company, transaction, document type, general ledger class, and cost component.
AAIs use these five keys to retrieve the object account number to use to create general ledger entries for work order transactions:
Company number.
Document type of the transaction (except for AAIs 3120 and 3401)
If no transaction is associated with the activity, for example, in AAI 3120 (Work in Process), the AAI does not specify a document type for the transaction
General ledger class code.
Document type.
Cost component.
To retrieve an AAI, the system searches first for an exact match between company and the general ledger class code. If the system does not find a match, it searches for the default company and the general ledger class code for the item. If it does not find a match, it searches for the company and uses **** (four asterisks) for the general ledger class code.
Each AAI or record type points to a specific object account in the general ledger. Business unit and a subsidiary can also be supplied in the AAI table or supplied by default from other sources.
Manufacturing AAIs are defined at the 3000 level, as illustrated in this table:
AAI |
Description |
3110 Inventory/Raw Materials |
This AAI specifies which balance sheet accounts in the general ledger the system uses when it issues raw materials or parts from inventory to work in process (transaction document type IM). You also use this AAI to issue completed subassemblies from inventory back into work in process. The system uses this AAI when you run the Manufacturing Accounting Journal Entries program (R31802A). |
3120 Work in Process |
For debit transactions, this AAI increases the value of work in process by issuing raw materials and parts to work orders or rate schedules (document type IM) and recording labor, machine, and overhead costs from the routing (document type IH). For credit transactions, during completion (document type IC), this AAI records the transfer of costs for a work order or a rate schedule from work in process to subassemblies and finished goods inventory. The system uses this AAI when you run the Manufacturing Accounting Journal Entries program. |
3130 Sub-Assembly/Finished Goods |
This AAI specifies which balance sheet accounts in the general ledger the system uses when it receives subassemblies or finished goods from work in process into inventory (document type IC) or scrap (document type IS). The system uses this AAI when you run the Manufacturing Accounting Journal Entries program (R31802A). |
3210 Clear Work in Process |
For actual costing, this AAI posts any additional cost of goods sold that were not included when completions were entered. The system uses this AAI when you run the Variance Journal Entries program (R31804). |
3220 Labor |
Use this AAI when the actual hours are different from the planned hours that are associated with shop floor activities on document type IV. This is applicable to all cost components except A1 and A2. Variances are posted as positive or negative, depending on whether they are favorable or unfavorable. The system uses this AAI when you run the Variance Journal Entries program. |
3240 Material |
Use this AAI when the actual costs are different from the planned costs for cost components A1 and A2. The variance results from either over-issues or under-issues. Variances are posted as debits or credits, depending on whether they are favorable or unfavorable. The system uses this AAI when you run the Variance Journal Entries program. |
3260 Planned |
Use this AAI when the planned costs are different from the current costs that are associated with shop floor activities on document type IV. This variance results from either of the items listed:
Variances are posted as positive or negative, depending on whether they are favorable or unfavorable. The system uses this AAI when you run the Variance Journal Entries program. |
3270 Engineered |
Use this AAI when the current costs are different from the standard (frozen) costs that are associated with shop floor activities on document type IV. This variance results from a change to the standard bill of material or the standard routing. Variances are posted as positive or negative, depending on whether they are favorable or unfavorable. The system uses this AAI when you run the Variance Journal Entries program. |
3280 Other |
Use this AAI when the completed cost is different from the standard cost that is associated with shop floor activities on document type IV. This variance results when a cost rollup is performed in the middle of the cycle, or it is generated when the quantity completed plus the quantity scrapped does not equal the work or rate schedule quantity. The variance might also be rounding. Variances are posted as positive or negative, depending on whether they are favorable or unfavorable. The system uses this AAI when you run the Variance Journal Entries program. |
3401 Accruals |
This AAI specifies the profit-and-loss accounts that offset work-in-process labor, machine, and overhead transactions to work orders or rate schedules (document type IH). The system uses this AAI when you run the Manufacturing Accounting Journal Entries program. |
Form Name |
FormID |
Navigation |
Usage |
W40950D |
Shop Floor Management Setup (G3141), Automatic Acctg Instructions On the Work With AAIs form, complete the Skip to AAI field, select a record, and then select Details from the Row menu. |
Define manufacturing AAIs. |
These processing options control default processing for the Automatic Accounting Instructions program.
Defaults
These processing options control default settings for entering and retrieving AAI information.
AAI Table Number |
Specify the default value for the Skip to AAI field on the Work With AAIs form. |
Cost Type |
Specify whether to define cost types. If you selected the Use Product Cost Detail option in the Branch/Plant Constants program, enter 1 to define cost types for these distribution AAIs: 4122 4124 4134 4136 4220 4240 4310 |
Access the Account Revisions form.
Co (company) |
Specify the company. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note. You can use company 00000 for default values such as dates and AAIs. You cannot use company 00000 for transaction entries. |
Do Ty (document type) |
Specify the transaction document type. You select a document type from the Document Type UDC table (00/DT) that identifies the origin and purpose of the transaction. The system reserves several prefixes for document types, such as vouchers, invoices, receipts, and timesheets. The reserved document type prefixes for codes are: P: Accounts payable documents R: Accounts receivable documents T: Time and Pay documents I: Inventory documents O: Purchase order documents S: Sales order documents Manufacturing transactions use these values: IM: Material issue IH: Routing transactions IC: Completions IS: Parent scrap IV: Variance |
Or Ty (order type) |
Specify the document type for the work order. Enter a value from the Document Type UDC table that identifies the type of document. This code also indicates the origin of the transaction. |
Cost Type |
Specify a code that designates each element of cost for an item. Examples of the cost object types are: A1: Purchased raw material. B1: Direct labor. B2: Setup labor. B3: Machine run. C1: Machine variable overhead. Dx: Outside operation routing rollup. Xx: Extra add-ons, such as electricity and water. This cost structure enables you to use an unlimited number of cost components to calculate alternative cost rollups. The system then associates these cost components with one of six user-defined summary cost buckets. |
Obj Acct (object account) |
Specify an object account number. The AAI table is the only place where the object account portion of the general ledger account number is defined. Note. If you use a flexible chart of accounts and the object account is set to six digits, you should use all six digits. For example, entering 000456 is not the same as entering 456 because if you enter 456, the system enters three blank spaces to fill a six-digit object. |
Sub (subsidiary) |
Enter a code that indicates a subsidiary account, which is a subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. Note. If you are using a flexible chart of accounts and the object account is set to six digits, you must use all six digits. For example, entering 000456 is not the same as entering 456 because, if you enter 456, the system enters three blank spaces to fill a six-digit object. If you leave this field blank, the system uses the value that you entered on the work order in the Cost Code field. |