Documentation >
MAC-PAC Reference and Help >
Reference File Categories >
ACCT NO ASSNMNT - INVENT
Function Select
RF452S01 - Function Select
WILLIAMS COMMON FEATURES 2/04/92
DSP01 REFERENCE FILE CATEGORY 452 FUNCTION SELECT
Category Name ACCT NO ASSNMNT - INVENT
TP CO LOC WH C1 C2 DT OC CC
Category Key 01001001DW101
XXXXXXXXXXXXXXXXXXXXXXXXXXX
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-Inventory category defines the account and center numbers that are to be assigned to system generated journal entries which are inventory related. The following classes are allowed:
Inventory
Standard Cost Change-Classified Items
Inventory-Direct Shipments
Inventory-Non-Stocked Items
Inventory Adjustment
Standard Cost Change-Purchase Order Receipts
Reference Item Expense
Standard Cost Change-Open Orders
Cost of Reference Item
Cost of Goods Sold
Quantity Variance - Invoice Matching
Purchase Price Variance - Invoice Matching
Exchange Gain - Invoice Matching
Exchange Loss - Invoice Matching
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). For types 50, 55, 60, and 61, the reporting class must match the reporting class for Accounts Payable defined on category 026.
TYPE
Required. Used to define the type of account which an account number will be assigned. Valid entries are:
01 - Inventory
05 - Inventory-Direct Shipments
06 - Inventory-Non-Stocked Items
10 - Inventory Adjustment
20 - Standard Cost Change-Open Orders
25 - Standard Cost Change-Classified Items
35 - Standard Cost Change-Purchase Order Receipts
40 - Reference Item Expense
41 - Cost of Reference Item
45 - Cost of Goods Sold
50 - Quantity Variance - Invoice Matching
55 - Purchase Price Variance - Invoice Matching
60 - Exchange Gain - Invoice Matching
61 - Exchange Loss - Invoice Matching
COMPANY
Required. The company must exist on Reference File category 002. If the subcategory type is 20, the company must be the manufacturing company.
LOCATION
Required. The company/location combination must exist on Reference File category 002. If the subcategory type is 20, the location must be the location in which the manufacturing warehouse exists.
WAREHOUSE
Required (if the subcategory type is not 05). The warehouse must exist on the Warehouse Description file. Account assignment records should be added for all warehouses in each company/location. If the subcategory type is 20, the warehouse must be the manufacturing warehouse.
CODE 1
Required (If subcategory type is 01, 10, 40, 41, 45). Optional (If subcategory type is 06, 50, 55, 60, 61). The user code is used to classify account numbers. If the subcategory type is 01, 06, 40, or 41, the user code will be a two position accounting code that must exist on Reference File category 433. If the subcategory type is 10, the user code will be a two position adjustment code that must exist on Reference File category 432. If the subcategory is 45, the user code will be a two-position product class code that must exist on Reference File category 426. If the subcategory type is 50, 55, 60, or 61, the user code will be a two-position purchasing group code that must exist on Reference File category 482.
CODE 2
Required (if subcategory type is 45). A two-character adjustment code that must exist on Reference File category 432.
DEPARTMENT
Optional (If subcategory type is 41). Must be a valid department on Reference File category 470 if one blank department has already been entered. A blank department must be entered before any other department codes are valid. Department code must be blank for all other subcategory types.
ORDER CLASS
Optional (if subcategory type is 45). A three-position order class code, which must exist on Reference File category D36. This field must be blank for other subcategory types.
CUSTOMER TYPE
Optional (if subcategory type is 45). A two-position customer type code, which must exist on Reference File category 311. This field must be blank for other subcategory types. Note that a customer type cannot be entered unless an order class is also entered.
The following table shows all valid account number combinations that may be entered:
TYPE CO LOC WHSE C1 C2 DEPT ORDER CL CUST
01 R R R R(2) - - - -
05 R R - - - - - -
06 R R R O(2) - - - -
10 R R R R(3) - - - -
15 R R R - - - - -
20 R(1) R(1) R(7) - - - - -
25 R R R - - - - -
30 R R R - - - -
35 R R R - - - - -
40 R R R R(2) - - - -
41 R R R R(2) - O - -
45 R R R R(4) R(3) - O(5) O(6)
50 R R R O(8) - - - -
55 R R R O(8) - - - -
60 R R R O(8) - - - -
61 R R R O(8) - - - -
R = Required
O = Optional
- = Blank
(1) = Must be a manufacturing company/location.
(2) = Must be a two position accounting code.
(3) = Must be a two position adjustment code.
(4) = Must be a two position product class code
(5) = Must be a three position order class code.
(6) = Must be a two position customer type code.
(7) = Must be a manufacturing warehouse.
(8) = Must be a two position purchasing group code.
Detail
RF452S02 - Detail
WILLIAMS COMMON FEATURES 2/04/92
DSP01 REFERENCE FILE CATEGORY 452 INQUIRE
Category Name ACCT NO ASSNMNT - INVENT
TP CO LOC WH C1 C2 DT OC CC
Category Key 01001001DW101
ACCOUNT CENTER
Data 1050011 1004
XXXXXXXXXX XXXXXXXXXX
Data
Data
F2=Command F3=Exit F9=Inquiry F10=Function Select
This screen is used to define the account and center to which system generated journal entries, that relate to inventory 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: If Accounts Payable and Inventory Accounting have different reporting classes and the Match flag on Reference File category 200 is set to 'IA,' then the reporting class for types 50, 55, 60, and 61 must match the reporting class for Inventory Accounting as defined on category 026. Otherwise, if the Match flag on Reference File category 200 is set to 'AP,' then the reporting class for types 50, 55, 60, and 61 must match the reporting class for Accounts Payable as defined on category 026.
ACCOUNT
Required. Used to define the account number to which a transaction is to be distributed. If G/L is installed or if the type is 50, 55, 60, or 61 (which require AP to be installed), the account and center must be defined on the G/L Account Master File. Otherwise, the account must be defined on Reference File category 113.
CENTER
Optional. 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 50, 55, 60, or 61 (which require AP to be 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.