Documentation >
MAC-PAC Reference and Help >
Reference File Categories >
ACCT NO ASSNMNT-PROCESS
Function Select
RF451S01 - Function Select
WILLIAMS COMMON FEATURES 2/04/92
DSP01 REFERENCE FILE CATEGORY 451 FUNCTION SELECT
Category Name ACCT NO ASSNMNT-PROCESS
TYP-CO-LOC-WH-CD-ADJ-RC
Category Key 01001001MFG01
XXXXXXXXXXXXXXXXXXX
Request Code 4
1 - Add
2 - Change
3 - Delete
4 - Inquire
F2=Command F3=Exit F7=End Category F8=Display List
F9=Inquiry
The Account Number Assignment-Process category defines the account and center numbers that are to be assigned to the system generated journal entries. The following account classes are allowed:
Work in Process Labor Closure Variance
Accrued Purchase Receipts Manning Closure Variance
Labor Accrual Overhead Closure Variance
Overhead Accrual Purchase Price Variance
Misc. Cost Accrual Labor Efficiency Variance
Non-Acquisition Costs Manning Efficiency Variance
Total Material Variance Overhead Efficiency Variance
Scrap Expense
If you set-up your system for management reporting, the reporting class for each account/center must match the reporting class defined for Inventory Accounting on Reference File category 026, Subsystem Reporting Class.
TYPE
Required. Used to define the type of account for which an account number will be assigned. Valid entries are:
01 - Work in Process.
08 - Accrued Purchase Receipts - type 08 is used as the account/center for Accrued Purchase Receipts in Accounts Payable if the System Management Reporting option in Accounts Payable and Inventory Accounting are different (found in Reference File category 026), and if the Match flag on Reference File category 200 is set to 'IA'. Otherwise, use a subtype of 09 or 10 for the Accrued Purchase Receipts account.
09 - Accrued Purchase Receipts - type 09 is used as the account/center for Accrued Purchase Receipts in Accounts Payable if the System Management Reporting option in Accounts Payable and Inventory Accounting are different (found in Reference File category 026), and if the Match flag on Reference File category 200 is set to 'AP'. Otherwise, use a subtype of 08 or 10 for the Accrued Purchase Receipts account.
10 - Accrued Purchase Receipts - type 10 is always used by Inventory Accounting. It is used by Accounts Payable if the System Management Reporting option in Accounts Payable and Inventory Accounting are the same (found in Reference File category 026), or if management accounting is not used.
11 - Labor Accrual.
12 - Overhead Accrual.
13 - Miscellaneous Cost Accrual.
14 - Non-Acquisition Costs.
20 - Total Material Variance.
21 - Labor Closure Variance.
22 - Manning Closure Variance.
23 - Overhead Closure Variance.
24 - Miscellaneous Cost Variance.
25 - Purchase Price Variance.
26 - Labor Efficiency Variance (as-incurred).
27 - Manning Efficiency Variance (as-incurred).
28 - Overhead Efficiency Variance (as-incurred).
30 - Scrap Expense
Note: Types 26-28 should only be used for MRP parts. Because variances for JIT parts are calculated differently, types 26-28 are not used for them.
COMPANY
Required. The company must exist on Reference File category 002 (Entity Name). If the subcategory type is 01, 11, 12, 13, 20, 21, 22, 23, or 24 the company must be a manufacturing company.
LOCATION
Required. The company/location combination must exist on Reference File category 002 (Entity Name). If the subcategory type is 01, 11, 12, 13, 20, 21, 22, 23, or 24, the location must be a manufacturing location.
WAREHOUSE
Required. The warehouse must exist on the warehouse description file. If the subcategory type is 01, 11 12, 13, 20, 21, 22, 23, 24, 26, 27, 28, or 30, the warehouse must be a manufacturing warehouse.
CODE
Required (If PO, SF, or JIT is installed). The User Code is used to classify account numbers. This code is required if the subcategory type is a 10, 11, 12, 13, 14, 26, 27, 28, or 30. The code is optional if the subcategory type is 01 or 25. For subcategories 20, 21, 22, 23, or 24, this field must be blank. The user code must be blank for all other subcategory types.
o If the subcategory type is 01 (WIP), the user code should be entered only for parent parts. It should be a two-digit accounting code. The code must be defined on Reference File category 433.
o If the subcategory type is 10, the user code will be two position Accounts Payable code. The AP code must exist on Reference File category 208 if Purchasing is installed.
o If the subcategory type is 11 and Just-in-Time is installed, the user code will be a three position department number. The department number must exist on the Department Master File.
o If the subcategory type is 11, 12, or 13 and Shop Floor is installed, the user code will be a three position department number. The department number must exist on the Department Master File.
o If the subcategory type is 14, the user code will be a three position cost element code. The cost element code must exist on Reference File category C17.
o If the subcategory type is 25 and the user code is entered, it will be a two position purchasing group code, which must exist on Reference File category 482.
o If the subcategory type is 26, 27, 28, or 30, the code is a three-position department number and a one position production type. The department number must be defined on the Department File. The production type must be defined on Reference File category C01.
Note: Current processing does not support as-incurred variances for JIT parts. For types 26, 27, and 28, the only production type that will be used is 1 - MRP.
ADJUSTMENT CODE
Optional. (Subcategory type is 10). Used to classify an adjustment for Accrued Purchase Receipts. If entered, it must exist on Reference File category 497.
o For subcategories 12, 13, 14, and 25 this field must be blank.
o If the subcategory type is 20-24, 26-28, or 30, the code, if entered, will be a one-position production type, which must exist on Reference File category C01.
RATE CODE
Optional. (Subcategory type is 11 or 12.) Used to classify labor and overhead accrual by cost element. If the Shop Floor module is not installed, the rate code field must be left blank.
The following table shows all valid account numbers-process combinations:
TYPE CO LOC WHS CODE ADJUST RT CD
01 R(1) R(1) R(6) O(8) -
09 R R R R O
10 R R R R(3) O -
11 R(1) R(1) R(6) R(4) - O(5)
12 R(1) R(1) R(6) R(4) - O(5)
13 R(1) R(1) R(6) R(4) - -
14 R R R R(5) - -
20 R(1) R(1) R(6) - O(9) -
21 R(1) R(1) R(6) - O(9) -
22 R(1) R(1) R(6) - O(9) -
23 R(1) R(1) R(6) - O(9) -
24 R(1) R(1) R(6) - O(9) -
25 R R R O(7) - -
26 R(1) R(1) R(6) O(10) O(9) -
27 R(1) R(1) R(6) O(10) O(9) -
28 R(1) R(1) R(6) O(10) O(9) -
30 R(1) R(1) R(6) O(10) O(9) -
R = Required.
O = Optional.
- = Must be blank.
(1) = Must be the manufacturing company/location.
(3) = Must be a two position Accounts Payable code from Reference File category 208.
(4) = If Shop Floor Control is installed, must be a three position department number.
(5) = Must be a three position Cost Element code from Reference File category C17.
(6) = Must be the manufacturing warehouse.
(7) = Must be a valid Purchasing Group from Reference File category 482.
(8) = Must be a valid Accounting Code from Reference File category 433.
(9) = Must be a valid Production Type from Reference File category C01.
(10)= Must be a three-position department code or production center family.
Detail
RF451S02 - Detail
WILLIAMS COMMON FEATURES 2/04/92
DSP01 REFERENCE FILE CATEGORY 451 INQUIRE
Category Name ACCT NO ASSNMNT-PROCESS
TYP-CO-LOC-WH-CD-ADJ-RC
Category Key 01001001MFG01
ACCOUNT CENTER
Data 1050012 TST1
XXXXXXXXXX XXXXXXXXXX
Data
Data
F2=Command F3=Exit F9=Inquiry F10=Function Select
This screen defines the account/center to which process related transactions will be booked.
If you set up your system for management reporting, the reporting class for each account/center must match the reporting class defined for Inventory Accounting on Reference File category 026 (Subsystem Reporting Class).
NOTE: For Accrued Purchase Receipts, either type 08 or type 09 is used. The type 09 account/center is used as the Accrued Purchase Receipts account/center in Accounts Payable when management accounting is used and the Match flag on Reference File category 200 is set to 'AP'. Therefore, the account/center associated with this type must match the reporting class defined for Accounts Payable on Reference File category 026. Type 10 is used for Accounts Payable only if your system is set up for management reporting and the reporting class defined for Accounts Payable and Inventory Accounting are different.
ACCOUNT
Required. The account number in the general ledger to which the transaction is to be distributed. If G/L is installed or if the type is 09 or 10 and AP is installed, the account and center must exist on the G/L Account Master file. Otherwise, the account must be defined on Reference File category 113.
CENTER
Optional. The center number is used to define the center (within a company/location) to which the account is assigned. If G/L is installed or if the type is 09 or 10 and AP is installed, the account and center must exist on the G/L Account Master File. Otherwise, the center must be defined on Reference File category 112.