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

Function Select

 

RF302S01 - Function Select

 

The Accounts Receivable 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 selected account number's class code must be the same code assigned in category 340 to that account class for the specific subcategory type.  This is a required category.  The following account classes are allowed:

Accounts receivable                                                                 City tax

Accrued receivable                                                                                   Unapplied cash

Cash                                                                                                              Debit/credit memo clearing

Discounts                                                                                                    Intercompany receivable

Allowance for doubtful accounts                                                         Intercompany payable accounts

Exch gain/loss-unrealized                                                                    Other expenses

Exchange gain/loss                                                                                 Sales

Value added tax                                                                                        State tax

Intermediate VAT                                                                                     County tax

Other income                                                                                              Consol invc gain/loss

Drafts Receivable/Payments Awaiting Remittance                      Drafts in Transit

Unpaid/Claimed Back Drafts                                                              Draft Risk

Unpaid/Claimed Back Draft Expenses

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

SUBCATEGORY TYPE

Required.  Used to define the type of transaction for which an account number will be assigned.  Valid entries are:

02 - Accounts receivable account

03 - Accrued receivable account

06 - Cash account

07 - Drafts receivable/Payments awaiting remittance

08 - Drafts In-transit

09 - Draft Risk

11 - Discounts account

12 - Allowance for doubtful accounts/chargebacks

16 - Sales account

17 - State tax account

18 - County tax account

19 - City tax account

21 - On account (contra receivables account)

22 - Debit/credit memo clearing account

25 - Intercompany receivable account

30 - Intercompany payable account

40 - Unpaid/Claimed Back Draft

41 - Unpaid/Claimed Back Draft Expenses

60 - Exchange gain account

61 - Exchange loss account

62 - Consolidated Invoice Gain

63 - Consolidated Invoice Loss

65 - Value added tax account

67 - Intermediate Value added tax account

70 - Finance charge

COMPANY

Required.  Contains the "on the books of" company identification code for all subcategory types.  The company must exist on the Entity Name record defined in Reference File category 002.

LOCATION

Required.  Contains the "on the books of" location identification code for all subcategory types.  The company/location combination must exist on the Entity Name record found on Reference File category 002.

COMPANY

Optional.  Contains the "intercompany to/from" company identification code for subcategory types 25 and 30.  The company must exist on the Entity Name record found on Reference File category 002.

LOCATION

Optional.  Contains the "intercompany to/from" location identification code for subcategory types 25 and 30.  The company-location combination must exist on the Entity Name record found on Reference File category 002.

CODE

Required.  A code or codes used to identify an entity within each subcategory type.  Different codes are entered depending on the subcategory type.  In cases where a single two character code is entered, it must be entered in the first two positions.  The following chart shows what information should be entered for each subcategory type.  Each code must be defined on the indicated Reference File category.

02 - Accounts Receivable code (required, category 333)

03 - Accounts Receivable code (required, category 333)

06 - Bank code and payment type code (The bank code is required, and it must be defined on the Bank Master File, CFBAMP.  A payment type must be specified for any account that will be used in payment application.  A payment type should not be entered for any account used to record cash sales in order entry.  Payment types are defined on category 240.)

07 - Payment type code (required, category 344) and customer accounts receivable code (optional, category 333).

08 - Bank code (required) and payment code (optional) Bank code must exist on the Bank Master File (CFBAMP) and payment type must exist in category 344.

09 - Remittance type (required, category F48)

12 - Write-off/Chargeback reason code (optional; if entered, it must be a valid reason code on Reference File category 350 or a valid direct write-off payment type on Reference File category 240).

16 - Product class code and adjustment code (optional, categories 426 and 432).

17 - State tax code (required, category 304)

18 - County tax code (required, category 305)

19 - City tax code (required, category 306)

21 - Customer Accounts Receivable Code (optional, category 333)

40 - Unpaid/Claimed back transaction type code (optional, category F31) and Accounts receivable code (optional, category 333)

41 - Bank code (optional)

65 - VAT code (required, category 308)

67 - VAT code (required, category 308)

USER CODE (OC)

Optional.  The characters 19-21 are used only for category types 08, 16, 65, and 67,as specified below:

08 - Remittance type (optional) Must be right-justified in this three character field.  Must exist in Reference File category F49 in combination with the payment type.

16 - Sales account (defined on category D36) Allows for more detailed reporting of sales and cost of goods expenses in the GL.

65 - Country code (defined on category 007) Allows VAT to be reported by country.

67 - Country code (defined on category 007) Allows intermediate VAT to be reported by country.

CUSTOMER TYPE (CC)

Optional.  The characters 22-23 contain a valid customer type as defined on reference category 311.  The customer type field allows for more detailed reporting of sales and cost of goods expenses in the GL.  This field can only be entered for Subcategory Type 16 - Sales Account.

TYP                CO          LOC       CO          LOC       CD                                                          OC          CC

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

03                   R             R             -               -               A/R Code(R)                                      -               -

06                   R             R             -               -               Bnk Cd(R), Pmt typ(O-)                   -               -

07                   R             R             -               -               Pmnt Type(R), A/R Code (O)

08                   R             R             -               -               Bk Cd(R), Py Ty(O), Rmt Ty(O)

09                   R             R             -               -               Remit Type(R)                                    -               -

11                   R             R             -               -               -                                                               -               -

12                   R             R             -               -               WO/CB Reason Code (O)               -               -

16                   R             R             -               -               Prod Class(O) & Adj Cd(O)OO     -               -

17                   R             R             -               -               State Tax Code(R)                              -               -

18                   R             R             -               -               County Tax Code(R)                         -               -

19                   R             R             -               -               City Tax Code(R)                               -               -

21                   R             R             -               -               A/R Code (O)                                     -               -

22                   R             R             -               -               -                                                               -               -

25                   R             R             R             R             -                                                               -               -

30                   R             R             R             R             -                                                               -               -

40                   R             R             -               -               Unpd/Clm Cd(O), A/R Cd(O)     -               -

41                   R             R             -               -               Bank Code(O)                                     -               -

60                   R             R             -               -               -                                                               -               -

61                   R             R             -               -               -                                                               -               -

62                   R             R             -               -               -                                                               -               -

63                   R             R             -               -               -                                                               -               -

65                   R             R             -               -               VAT Code(R)                                      O            

67                   R             R             -               -               VAT Code(R)                                      O             -

70                   R             R             -               -               -                                                               -               -

R  = Required

O  = Optional

-  = Must be blank. 

0  = Optional (for AR) or must be blank (for OP post billing cash sale account).

Detail

RF302S02 - Detail

 

ACCOUNT NUMBER/CENTER NUMBER

Account Number is required.  Center Number is optional.  The account/center combination must exist on the Account Master File (CFBAMP).

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