Introduction

The Entry Type Code (ETP) is used in conjunction with the MAX table to determine where different sales, cost of sales, excise tax, discounts, freight, etc. post to the General Ledger. It is formed using 2 characters that represent different things in the system. It indicates “How did I sell or sample”?

Articles that Reference this Article

Entry Type Code Format

The first character

The first character is a letter that has defaults pre-loaded in the system however this can be changed and added to as needed. This letter is also defined in the Sales Type Table. Sales type is used on each transaction in the system (attached to OE orders and attached to PS TTX codes). The ETP table is where it gets the information to use in the mapping in the MAX table (Menu option INFMM MAX).

The system comes preloaded with these ETP codes (first letter of code):

D =No Charge Donations
F = No Charge Free Goods
P = No Charge Pours
S = No Charge Samples
Z = Standard Sales

It is recommended that you do not change, Z=Standard Sales. You may however add additional codes depending on what you are tracking in the G/L or for reporting purposes. You can have more than one Sales Type (SAT) point to the same General Ledger account (example W=No Charge Wine Writer).

The second character

The second character is a number that is hardcoded into the system and cannot be changed. The hard coded numbers represent the following:

1 = Gross Sales

2 = Discounts

4 = Cost of Sales – the actual cost of the wine

5 = Cost of Sales/Excise tax/used only if the Excise Tax $ Control (in part master) is set to IC or EC

8 = Freight account for system-generated shipping charges (or manually entered in OE).

When an order is placed the Sales Type (SAT) associated with the order references the ETP (Entry Type Code) in combination with the CFC* and PFC** and determines a mapping so the dollars related to the order hit a specific G/L Account.

*CFC (Customer Financial Codes) – “Who did I sell or sample to”?

*PFC (Part Financial Code) –“What did I sell or sample”?

A full example of an ETP code is: Z1- Gross Sales

Description

This is the description that will appear in the MAX table for you to know what portion of the sale you are mapping to the GL.

Set ID

One of the critical items on this screen is the Set ID, this Set ID refers to the Entry Code set in the MAX table (INFMM.MAX). When going into the MAX table you must specify what Set Id/ Entry code set to work with. This is a way to group your entry types to see all like types together in the MAX table. Note: You can only have 9 entry lines on a page in the MAX table.

The sample data that is preloaded in the system has Set Id’s of Z for Sales, N for No Charge. If you are using the second digit of 4 and/or 5 or if you have many of a certain group you may need to set up additional set ID’s. An example would be you have more than 5 different categories of No Charge. You may want to add a new Set ID of O (the letter immediately after N). This will all become clearer when entering the MAX table.

Note

If using profit analysis the suggestion would be to use P as the set ID. We would not recommend using P for additional No Charges just in case you do ever decide to use the Profit Analysis module.

Profit Analysis Group Code

Unless using the profit analysis module this would be NA. If using Profit Analysis this would come from central table PAG. *See Profit Analysis Overview and Setup for more information.

Options to Bypass Max Table Entries

The information in the green box that allows you to put in a GL account to bypass the max table was created for clients with A LOT of different brands. It is used so the customer does not have to fill in the MAX table for every brand. If you would like more information on this feature please contact an AMS representative for assistance.

ETP Set ID and its Relationship to the MAX Table

The Max Table uses customer (CFC) and part financial _(PFC) codes, embedded in each transaction, to map the dollars from each transaction to General Ledger accounts. In the MAX table the 'Entry Code set to Maintain' is defined on each ETP code. You use the Set Id in the ETP table to group your like codes together for ease of entering mappings in the MAX table.

Documentation

Entry Type Code (ETP)