Documentation > MAC-PAC Reference and Help > Reference File Categories > ACCOUNT NUMBER ASSGMNT

Function Select

RF202S01 - Function Select

 

The  Accounts Payable Account Number  Assignment category defines the account numbers that are to be assigned to the system-generated transactions for the entity's category type.  The following account types are allowed:

Accounts payable                                     Freight

On account                                                  Duty

Cash (bank account)                                Other invoice charges

Discounts taken                                         Exchange gain

Discounts lost                                            Exchange loss

Taxes paid                                                   Declarable VAT

Drafts payable account                           Intermediate VAT

Intercompany receivable                        Postponed VAT

Intercompany payable                            Intermediate Postponed

1099 Withholding                                     VAT

If you set-up your system for management reporting, the reporting class for each account/center must match the reporting class defined for Accounts Payable on Reference File category 026, Subsystem Reporting Class.  This is a required category.

CATEGORY TYPE

Required.  Used to define the type of transaction for which an account number will be assigned.  Type 17 is not used if VAT processing is implemented.  Valid entries are:

01 - Accounts payable account

02 - On-Account

05 - Bank account (cash)

10 - Discounts taken account

15 - Discounts lost account (net system only)

17 - Tax account

20 - Drafts payable account

25 - Intercompany receivables account

30 - Intercompany payables account

40 - Freight account

45 - Duty account

50 - Other charges account

60 - Exchange gain account

61 - Exchange loss account

65 - VAT declarable account

67 - VAT intermediate account

69 - Postponed VAT account

68 - Intermediate postponed VAT account

99 - 1099 withholding account

COMPANY

Required. This field contains the "on the books of" company identification code for all subcategory types.  The company must exist on Reference File category 002, Entity Name.  This is either the invoice or payment company, depending on the type:  01, 30, 65, 67, 68, 69 - Invoice company.  All other types - Payment company.

LOCATION

Required. This field contains the "on the books of" location identification code for all subcategory types.  The company-location combination must exist on Reference File category 002, Entity Name.  This is either the invoice location or payment location, depending on the type: 01, 30, 65, 67, 68, 69 - Invoice location.  All other types - Payment location.

ORIGINATING COMPANY

Optional.  This field contains the "intercompany to/from" company identification code for subcategory types 25 and 30. The company must exist on Reference File category 002, Entity Name.  For type 25, this is the invoice company.  For type 30, this is the payment company.

ORIGINATING LOCATION

Optional. This field contains the "intercompany to/from" location identification code for subcategory types 25 and 30. The company/location combination must exist on Reference File category 002, Entity Name.  For type 25, this is the invoice location.  For type 30, this is the payment location.

CODE NUMBER ONE

Required for subcategory types 01, 05, 17, 20, 65, 67, 69 and 99.  Contains the user code used to identify each account for an entity within each subcategory type.  The following codes are valid:

Type 01, 02, 20                           Accounts payable code

Type 05                                         Bank code

Type 17                                         Tax code

Type 65, 67, 68, 69                     Value Added Tax code

The field must be a valid code on the Reference File.  If you enter a type of 99 (1099 tax code), then the CODE1 field must be a valid withholding code on Reference File category 234 and must be entered.

CODE NUMBER TWO

Optional for subcategory type 05.  Contains the user code used to further identify an account.  If entered, must be defined on the Bank Account Payment Type File (CFBPTP).

The following field combinations are valid:

TYPE             CO          LOC       CO          LOC       CD1                                       CD2

01                   R             R             -               -               A/P Code (R)                      -

02                   R             R             -               -               A/P Code (O)                     -

05                   R             R             -               -               Bank Code (R)                    Paymt Type (O)

10                   R             R             -               -               -                                               -

15                   R             R             -               -               -                                               -

17                   R             R             -               -               Tax Code (R)                       -

20                   R             R             -               -               A/P Code (R)                      -

25                   R             R             R             R             -                                               -

30                   R             R             R             R             -                                               -

40                   R             R             -               -               -                                               -

45                   R             R             -               -               -                                               -

50                   R             R             -               -               -                                               -

60                   -               R             R             -               -                                               -

61                   R             R             -               -               -                                               -

65                   R             R             -               -               VAT Code                            -

67                   R             R             -               -               VAT Code                            -

68                   R             R             -               -               VAT Code                            -

69                   R             R             -               -               VAT Code                            -

99                   R             R             -               -               Withholding Code (R)     -

R = Required

O = Optional

- = Must be blank

Detail

RF202S02 - Detail

 

This screen is used to assign account/centers for Accounts Payable transactions.

If you set-up your system for management reporting, the reporting class of the account/center must be the same as the reporting class of Accounts Payable as defined on Reference File category 026, Subsystem Reporting Class.

The account/center combination must exist on the General Ledger Account Master File.

ACCOUNT NUMBER

Required.  The number of the account that you are maintaining.

CENTER NUMBER

Optional.  The number of the center associated with the account being maintained.

ACCOUNT DESCRIPTION

Optional.  This description will be passed to the General Ledger module to help identify the type of transaction posted.