Maintain Financial-Code to G/L Account # ref (INFMM MAX)

Owned by Danielle Chamberlain
Last updated: Apr 29, 2022

Introduction

This table is used to map the Wholesale sales to the General Ledger accounts. It uses the ETP, PFC, and CFC tables codes as described above. The Cost of Sales Journal (GLAJM CSR) uses the mappings in this table to post the costs of sales for Wholesale sales from the Order Entry module.

Table of Contents

Articles Referenced in this Article

Articles that Reference this Article

Central Table References



Where Is It Found

Maintain Financial-code to G/L - Account - # xref



Fiscal Year

Use ** in this field so you can retain use year after year instead of setting this up again each year. If for some reason you need to have an entry post to different accounts based on the year, this will allow that.

Entry Code set to Maintain

This is the set ID determined on each ETP table entry. This groups similar entries for ease of data entry. The ETP codes with the same set ID (up to 9) will all appear on the next screen. More information on Entry code Set can be found here: Entry Type Code (ETP).

Available Entry Code Sets:

This tells you what set IDs you have created on ETP code entries.

MAX Table Entries for Sales

Customer Financial Code (CFC)

Fill in the customer financial code that you wish to map to the GL

Part Financial Code (PFC)

Fill in the customer financial code that you wish to map to the GL in combination with the previously listed Customer Financial Code.

Note: For each customer financial code/part financial code combination that you will use in transactions a mapping needs to be done to point the dollars to general ledger accounts. If a transaction has a CFC/PFC combination that is not mapped when you post your journal you will receive an error message.

Select enter to open the G/L account field.

Note: You can also use the copy from feature to copy mappings from one CFC/PFC combination to another combination. This saves time on the initial setup.


For each entry code (ETP) fill in the GL account that it should post to.

Note: You do not have to have every account filled in. If you do not and a transaction is posted that has an unmapped CFC/PFC combo the system will let you know with an error when your journal is posted.

Select Enter to save and continue on to the next CFC/PFC combo or use the copy feature.

Max Table Entries for No Charge

For this example, our entry code set is N (for no charge). Hit enter to access the entry screen.

Customer Financial Code (CFC)

Fill in the customer financial code that you wish to map to the GL

Part Financial Code (PFC)

Fill in the customer financial code that you wish to map to the GL in combination with the previously listed Customer Financial Code

Note: For each customer financial code/part financial code combination that you will use in transactions a mapping needs to be done to point the dollars to general ledger accounts. If a transaction has a CFC/PFC combination that is not mapped when you post your journal you will receive an error message.

Select enter to open the G/L account field.

Note: You can also use the copy from feature to copy mappings from one CFC/PFC combination to another combination. This saves time on the initial setup. For No charge transactions, you would not need ETP codes with 1’s or 2’s as the second digit as there is no revenue and no discounts.

Fill in the General Ledger accounts that you would like Cost of Sales for each no charge type to post to. The example is set up for Donations, Free Goods, Pours, and Samples.

Hit Enter to Save and Continue.


NOTE: You will need to map for each entry code set and for each customer/part financial code combination needed within the entry code set. If you post at the end of the month and see errors in your journals they should tell you exactly what is not mapped for you to be able to map it.