Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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