Collapse AllExpand All

12.2.7. Sales Assignments

Sales assignments are used to identify the general ledger (G/L) accounts to be used when processing the following:

  • Sales orders

  • Invoices

  • Sales order credit memos

The account assignments are made using a combination of customer type, product category, and site designations. This means that transactions conforming to the defined combination will follow the assignments established for that combination. To access the Sales Account Assignments master list, go to Sales Assignments. The following screen will appear:

Sales Assignments master list

The Sales Assignments screen displays information on existing sales account assignments.

Note

Sales account assignments use a weighted calculation. The weight of each sales account assignment is calculated according to a point system and the highest weight is selected for use in any given situation. Here is how the points are calculated:

  • Matching sales type = 5 points

  • Matching shipping zone = 4 points

  • Matching product category = 3 points

  • Matching customer type = 2 points

  • Matching site = 1 point

When the same weight exists for more than one account assignment, the first sorted value in the following order is selected:

  1. Customer type

  2. Product category

  3. Sales type

  4. Shipping zone

12.2.7.1. Sales Assignment

To create a new sales assignment, select the NEW button. The following screen will appear:

Create new Sales Account Assignment

When creating a new sales assignment, you are presented with the following options:

Tip

The account numbers assigned to cost categories should not all be the inventory account. Instead, they should be individual accounts selected specifically for each cost-tracking purpose. This will increase your visibility into your inventory costs and valuation.

Site

Specify site to be associated with the account assignment.

Note

In the case of conflicts between sales assignments, the system by default selects specific assignments before all-inclusive ones. For example, if there were a choice between an assignment featuring WHSE-1 as the supplying site and another featuring ANY site, the more-specific WHSE-1 would be selected.

All Customer Types

Select to associate all customer types with the sales assignment.

Selected

Specify the customer type you want to associate with the sales assignment.

Pattern

Enter a customer type pattern to select a range of customer types. Refine your search using regular expressions.

All Product Categories

Select to associate all product categories with the sales assignment.

Selected

Specify the product category you want to associate with the sales assignment.

Pattern

Enter a product category pattern to select a range of product categories. Refine your search using regular expressions.

Shipping Zone

Select a shipping zone to associate with the sales assignment.

Sale Type

Select a sale type to associate with the sales assignment.

Inventory Sales Account

Identify a general ledger (G/L) account to assign as the default inventory sales account. This is a revenue account. It will be credited when invoices are posted.

Sales Credit Account

Identify a G/L account to assign as the default sales credit account. This is a revenue contra account. It will be debited when sales credits are posted.

Cost of Sales Account

Identify a G/L account to assign as the default cost of sales account. This is an expense account. It will be debited when sales order items are shipped. It will be credited when sales order items are returned to stock—either through shipping or the processing of a sales credit.

Returns Account

Identify a G/L account to assign as the default returns account. This is a contra revenue account. It will be debited when returns created by a return authorization are posted.

Cost of Returns Account

Identify a G/L account to assign as the default cost of returns account. This is a contra expense account. It will be credited when return authorization quantity is posted as received.

Cost of Warranty Account

Identify a G/L account to assign as the default warranty account. This is a contra expense account. It will be debited when warranty items are shipped and credited when warranty items are received.