MAC-PAC Homecontact ussupport login 
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.