Overview
Sales Account Distribution tab manages the sub-ledger sales accounts for a Product, by giving the possibility to establish allocation percentages to a number of sub-ledger revenue accounts, which are when Sales Order Lines for said Product are created.
Application
When a Sales Order Line is added for a Product Master that has a Sales Account Distribution, the SO Line will inherit the Sales Account Distribution defined in this tab, and calculate the amounts for each of the accounts based on the allocated percentages. The values can be viewed Sales Order Line > Components button.
Furthermore, when SO Shippers for the Sales Order Line are Invoiced, the Sales Account Distribution is passed over to the Sales Invoice Line, where they can be modified before the Sales Invoice is Approved.
Setup
Product Master > Order Processing Tab
Allow Sales Acct. Distribution: When this field is checked (either at the Product Group level, or overridden directly on the Product), the 'Sales Account Distribution' tab will be displayed on the Product Master
Navigation
Product Master > Product Master Sales Account Distribution Tab
Processing
- Click on ‘New Sales Account Distribution’ link to create a new 'Sales Account Distribution' record linked to this Product Master.
- On this record, the user can define the Sales Account, Percentage, and Comments.
- When a Sales Order Line is created for this Product, the Sales Account Distribution will be created for the Sales Order Line mirroring the Product's setup.
- Additionally, any Remaining Percentage, that has not been distributed, will be assigned to the Product Master > Accounts tab > Sales Account field, when a Sales Order Line for this product is created.
NOTE The sum of all the Account Distributions for a given Product should not be greater than 100%.
NOTE If the Product Master has a different Sales Account Distribution on a Contract Master > Products for Purchases > Sales Account Distribution, when a Sales Order Line is added for a Sales Order Header that references this Contract, the Contract Sales Distribution will be used, instead of that defined on the Product Master > Sales Account Distribution tab.
Fields
Sales Account (primary): The “primary” Sales Account defined for the Product (or Product Group). When no other distributions exist, this value starts as 100%, which is subsequently reduced as each addition Sales Account distribution is added, reduced by the percent assigned to additional distributions.
Sequence: Auto-assigned sequence number, denoting the order in which additional Account Distribution records are added
Sales Account: The Sub-Ledger Sales Account for the given Account Distribution record
Percentage: The percentage (or portion) of the total Sales amount to be charged (distributed) to the given Sales Account
Comments: Optional user-defined comments regarding this Account Distribution record
SEE ALSO
