|
xTuple ERP Reference Guide |
|
|
xTuple ERP Reference Guide |
| 12.2.7. Sales Assignments | ||
|---|---|---|
 | 12.2. Accounting Mappings |  |
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 . The following screen will appear:
The Sales Assignments screen displays information on existing sales account assignments.
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:
Customer type
Product category
Sales type
Shipping zone
To create a new sales assignment, select the button. The following screen will appear:
When creating a new sales assignment, you are presented with the following options:
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.
Specify site to be associated with the account assignment.
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.
Select to associate all customer types with the sales assignment.
Specify the customer type you want to associate with the sales assignment.
Enter a customer type pattern to select a range of customer types. Refine your search using regular expressions.
Select to associate all product categories with the sales assignment.
Specify the product category you want to associate with the sales assignment.
Enter a product category pattern to select a range of product categories. Refine your search using regular expressions.
Select a shipping zone to associate with the sales assignment.
Select a sale type to associate with the sales assignment.
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.
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.
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.
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.
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.
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.
| |  | |
| 12.2.6. Expense Categories |  | 12.2.8. Sales Categories |