Sales Accounts

This file stores the accounts needed to post to sales and Cost of Goods Sold for both stock and nonstock items. In addition, a target profit margin can be entered along with a hold code to apply if an order line fails to meet that target.

REFERENCED BY

WH20.2

WH20.7

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
OSA-COMPANY Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
OSA-PROCESS-LEVEL Element: Process Level	Alpha 5 The process level is the reporting hierarchy below company.
OSA-SALES-MAJCL Element: Major Class	Alpha 4 Sales major class code. Sales major/minor classes are first set up in the Inventory Control system. Every inventoried and nonstock item ordered in the Order Entry and Billing systems must belong to a sales class as that is how the system knows which general ledger accounts to debit and credit.
OSA-SALES-MINCL Element: Minor Class	Alpha 4 Sales minor class code within the major class. Sales major/minor classes are set up in the Inventory Control system. Every inventoried and nonstock item ordered in the Order Entry and Billing systems must belong to a sales class as that is how the system knows which general ledger accounts to debit and credit.
OSA-SLS-ACCT-UNIT Element: Acct Unit	Alpha 15 Default general ledger account unit to be credited for inventoried and nonstock type items ordered that belong to this sales major/minor class.
OSA-SLS-ACCOUNT Element: Account	Numeric 6 Default general ledger account number to be credited for inventoried and nonstock type items ordered that belong to this sales major/minor class.
OSA-SLS-SUB-ACCT Element: Sub Acct	Numeric 4 Default general ledger subaccount to be credited for inventoried and nonstock type items ordered that belong to this sales major/minor class.
OSA-EXP-ACCT-UNIT Element: Acct Unit	Alpha 15 This is the general ledger account unit to be credited as an offset to COGS when placing an order for nonstock items within the sales major/minor class.
OSA-EXP-ACCOUNT Element: Account	Numeric 6 This is the general ledger account number to be credited as an offset to COGS when placing an order for nonstock items within the sales class.
OSA-EXP-SUB-ACCT Element: Sub Acct	Numeric 4 This is the general ledger subaccount number to be credited as an offset to COGS when placing an order for nonstock items within the sales class.
OSA-CGS-ACCT-UNIT Element: Acct Unit	Alpha 15 This is the general ledger account unit that is debited for cost of goods sold when an order is placed for inventoried or nonstock items belonging to this sales major/minor class.
OSA-CGS-ACCOUNT Element: Account	Numeric 6 This is the general ledger account number that is debited for cost of goods sold when an order is placed for inventoried or nonstock items belonging to this sales major/minor class.
OSA-CGS-SUB-ACCT Element: Sub Acct	Numeric 4 This is the general ledger subaccount number that is debited for cost of goods sold when an order is placed for inventoried or nonstock items belonging to this sales major/minor class.
OSA-VAR-ACCT-UNIT Element: Acct Unit	Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
OSA-VAR-ACCOUNT Element: Account	Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
OSA-VAR-SUB-ACCT Element: Sub Acct	Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
OSA-PROF-MARGIN Element: Prof Margin	Percent 4.2 (Percent) Entering a profit margin percentage for a sales class will place the Profit Hold Code on order lines for items from this class when the order line's projected profit margin does not exceed this margin. Profit margin is calculated as: (unit net price * SPR UOM (sell unit of measure to price unit of measure conversion factor) - unit cost) / unit net price. This is the target profit margin that should be reached or exceeded by all orders placed using items belonging to this sales class.
OSA-PROF-HOLD-CD Element: Hold Code	Alpha 4 This is the default hold code that the system will place on the order line that does not reach the profit margin criteria. These hold codes are set up in the Accounts Receivable system.

OESLSACCT FILE INDEX

OESLSACCT FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.