OESLSACCT FILE
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 Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
OSA-PROCESS-LEVEL Alpha 5
Process Level The process level is the reporting
hierarchy below company.
OSA-SALES-MAJCL Alpha 4
Sales Major Class 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 Alpha 4
Sales Minor Class 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 Alpha 15
Sales Accounting Default general ledger account unit to
Unit be credited for inventoried and nonstock
type items ordered that belong to this
sales major/minor class.
OSA-SLS-ACCOUNT Numeric 6
Sales Account 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 Numeric 4
Sales Subaccount 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 Alpha 15
Expense Accounting This is the general ledger account unit
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 Numeric 6
Expense Account 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 Numeric 4
Depr Expense This is the general ledger subaccount
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 Alpha 15
Cost Of Goods Sold This is the general ledger account unit
Acct 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 Numeric 6
Cost Of Goods Sold This is the general ledger account
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 Numeric 4
Cost Of Goods Sold This is the general ledger subaccount
Sub 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-VAR-ACCT-UNIT Alpha 15
Cost Variance The variance account accounting unit.
Accounting Unit
OSA-VAR-ACCOUNT Numeric 6
Cost Variance The variance account account number.
Account Number
OSA-VAR-SUB-ACCT Numeric 4
Cost Variance The variance account subaccount number.
Subaccount
OSA-PROF-MARGIN Percent 5.2 (Percent)
Profit Margin 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 Alpha 4
Prof Hold Cd 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
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OSASET1 COMPANY WH20.2 WH20.7
PROCESS-LEVEL
SALES-MAJCL
SALES-MINCL
OESLSACCT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
OSA-COMPANY -> ACO-COMPANY
Cogs GLMASTER Required
When OSA-CGS-ACCT-UNIT != Spaces
Or OSA-CGS-ACCOUNT != Zeroes
Or OSA-CGS-SUB-ACCT != Zeroes
OSA-COMPANY -> GLM-COMPANY
OSA-CGS-ACCT-UNIT -> GLM-ACCT-UNIT
OSA-CGS-ACCOUNT -> GLM-ACCOUNT
OSA-CGS-SUB-ACCT -> GLM-SUB-ACCOUNT
Expenses GLMASTER Required
When ((OSA-EXP-ACCT-UNIT != Spaces )
Or (OSA-EXP-ACCOUNT != Zeroes )
Or (OSA-EXP-SUB-ACCT != Zeroes ))
OSA-COMPANY -> GLM-COMPANY
OSA-EXP-ACCT-UNIT -> GLM-ACCT-UNIT
OSA-EXP-ACCOUNT -> GLM-ACCOUNT
OSA-EXP-SUB-ACCT -> GLM-SUB-ACCOUNT
Holdcode HOLDCODES Required
When OSA-PROF-HOLD-CD != Spaces
ACO-CUST-GROUP -> HDD-CUST-GROUP
OSA-PROF-HOLD-CD -> HDD-HOLD-CODE
Holdcodes HOLDCODES Required
When OSA-PROF-HOLD-CD != Spaces
ACO-CUST-GROUP -> HDD-CUST-GROUP
OSA-PROF-HOLD-CD -> HDD-HOLD-CODE
Iccompany ICCOMPANY Required
OSA-COMPANY -> ICC-COMPANY
Majorcl MAJORCL Required
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
"S" -> MAJ-CLASS-TYPE
OSA-SALES-MAJCL -> MAJ-MAJOR-CLASS
Minorcl MINORCL Required
When OSA-SALES-MINCL != Spaces
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"S" -> MIN-CLASS-TYPE
OSA-SALES-MAJCL -> MIN-MAJOR-CLASS
OSA-SALES-MINCL -> MIN-MINOR-CLASS
Oecompany OECOMPANY Required
OSA-COMPANY -> OEC-COMPANY
Oeproclev OEPROCLEV Required
OSA-COMPANY -> OEP-COMPANY
OSA-PROCESS-LEVEL -> OEP-PROCESS-LEVEL
Sales GLMASTER Required
When OSA-SLS-ACCT-UNIT != Spaces
Or OSA-SLS-ACCOUNT != Zeroes
Or OSA-SLS-SUB-ACCT != Zeroes
OSA-COMPANY -> GLM-COMPANY
OSA-SLS-ACCT-UNIT -> GLM-ACCT-UNIT
OSA-SLS-ACCOUNT -> GLM-ACCOUNT
OSA-SLS-SUB-ACCT -> GLM-SUB-ACCOUNT
Variance GLMASTER Not Required
Valid When OSA-VAR-ACCT-UNIT != Spaces
Or OSA-VAR-ACCOUNT != Zeroes
Or OSA-VAR-SUB-ACCT != Zeroes
OSA-COMPANY -> GLM-COMPANY
OSA-VAR-ACCT-UNIT -> GLM-ACCT-UNIT
OSA-VAR-ACCOUNT -> GLM-ACCOUNT
OSA-VAR-SUB-ACCT -> GLM-SUB-ACCOUNT
|
