|
|
BL00.1 - Company
Use this form to add a company to the Billing system. Before you can define
the company in Billing, however, you must define the company in the General
Ledger, Accounts Receivable, and Inventory Control systems. See the Billing
Procedures Manual for more information.
Each company in the Lawson system has a unique company number that identifies
the name, address, and various parameters of the company. Company default
parameters, many of which can be overridden at various sublevels, are
initially defined at the company level. For example, the company remit-to
address is defined at the company level but is overridden by the remit-to
address at the process level.
Updated Files
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CKPOINT - Not used.
OECOMPANY - This is the primary file maintained by this program. It
contains valid Billing companies and their parameters.
OEPRCBOOK - When deleting a Billing company, all price book records for
the company are also deleted.
OEREASON - A reason code record is created when the default cancellation
reason code entered for the Billing company does not exist.
TXCOMPANY - Stores company information and which tax system the company
uses. Also includes general ledger accounts if they are defined
at the company level.
Referenced Files
APACCRCODE - Used to link a general ledger invoice accrual account to an
invoice.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTGRP - Used to display the Accounts Receivable customer group name
for the company.
CUSTORDER - Used to validate that no orders exist in the Order Entry
system prior to deleting the Billing company.
GLADDRESS - Used in the General Ledger company edit routine.
GLCHART - Used in the General Ledger account verification routine.
GLSYSTEM - Used in the General Ledger company edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
INSTCTRYCD - Validates the Intrastat country code.
INSTREGN - Validates the Intrastat region code.
ITEMGROUP - Used to validate the item group associated with the Inventory
Control company.
OEBASE - Used to validate that no price base records exist in the
Billing system prior to deleting the Billing company.
OEDISCOUNT - Used to validate that no discount records exist in the Billing
system prior to deleting the Billing company.
OEINVOICE - Used to verify that no invoice records exist in the Billing
system when changing the Company Invoice Option flag.
OEPRCLIST - Used to verify that no price list records exist in the Billing
system prior to deleting the Billing company.
OEPROCLEV - Used to verify that no process level records exist in the
Billing system prior to deleting the Billing company.
OEWKSHEET - Used to verify that no pricing worksheets exist in the Billing
system prior to deleting the Billing company.
TXTAXCODE - Used to validate tax codes. Also provides general ledger
account for sales tax postings.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
IFCC
BL01.1 - Process Level
Use this form to define a process level for a company. A process level is a
user-defined breakdown within a company, such as a department, division, or
sales office. It represents the level at which you track sales, and is used as
a reporting break on reports within the system. You can assign various
defaults, including location, ship days (to calculate default expected ship
date on an order), and reason code to a process level.
In addition, you can control invoicing at the process level instead of at the
company level. If invoicing parameters were not entered at the company level,
you can enter them at the process level on this form. If you do set up
invoicing at the process level, you will be responsible for specifying your
process level when you create invoices using BL122 (Invoice and Register
Print).
Process levels affect general ledger accounts. Unique general ledger accounts
are needed for each process level. The system uses these accounts to determine
the Accounts Receivable general ledger account to be debited for invoices and
all the default accounts to be debited and credited for special item orders.
Updated Files
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CKPOINT - Not used.
HOLDCODES - Used to validate the process level default hold codes.
OEPROCLEV - This is the primary file maintained by this program. It
contains valid Billing process levels and their parameters.
OEREASON - A reason code record is created when the default cancel reason
code entered for the Billing process level does not exist.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
Referenced Files
APACCRCODE - Used in the vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ICLOCATION - Used to validate the default inventory location.
OECOMPANY - Used to validate the Billing company.
OEINVOICE - Used to edit for existing invoices. Company cannot be deleted
if invoices exist.
ORDERTYPE - Used to validate the default order type.
TXTAXCODE - Used to validate tax codes.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL02.1 - Ship To
Use this form to define multiple ship-to addresses for any customer set up
for Order Entry/Billing and Accounts Receivable processing.
You can define a default ship-to for each customer, which will cause the
system to default the ship-to ID onto every order placed using the customer's
bill-to number. The documents created by the system will have this ship-to
name and address printed on them if a ship-to location is specified. If left
blank, the customer address is also used as the ship-to address.
Updated Files
ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
routines.
ARCUSTOMER - Used to validate the Accounts Receivable customer. Updated
with the customer default ship-to number.
ARLOCKBOX - Used in the Accounts Receivable customer edit and update
routines.
CBBANKINST - Used to validate the payment code.
CRANALYST - Used in the Accounts Receivable customer update routine.
CUSTDEFLTS - Used in the Accounts Receivable customer update routine.
CUSTDESC - Used to display Accounts Receivable customer information.
HOLDCODES - Used to validate hold codes. If this is the first time the
hold code is
referenced, the used flag is set.
MAJCUSTCL - Used in the Accounts Receivable customer update routine.
MINCUSTCL - Used in the Accounts Receivable customer update routine.
NATACCT - Used in the Accounts Receivable customer edit and update
routines.
NATBALANCE - Used in the Accounts Receivable customer edit and update
routines.
OECUST - Used in the Accounts Receivable customer edit routine.
OEFRTCODE - Used to validate freight codes.
OEMETHOD - Used to validate shipping methods.
SALESREP - Used to validate sales representatives. If this the first
time the sales representative is referenced, the used flag is
set.
SHIPTO - This is the primary file maintained by this programs. It
contains valid ship-to information.
SHIPTOCMNT - Stores order comments for ship to. These comments are copied
to any orders or
invoices for this ship to.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Also includes general ledger accounts if they are defined
at the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
APACCRCODE - Used in the vendor edit routine.
APCOMPANY - Used in the Accounts Payable vendor edit routine.
APCPYVND - Used in the Accounts Payable vendor edit routine.
APHLDINV - Used in the Accounts Payable vendor edit routine.
APVENCLASS - Used in the Accounts Payable vendor edit routine.
APVENGROUP - Used in the Accounts Payable vendor edit routine.
APVENMAST - Used in the Accounts Payable vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARCYCLE - Used in the Accounts Receivable customer update routine.
ARPAYMENT - Used in the Accounts Receivable customer edit and update
routines.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
GLINTCO - Used in the General Ledger company edit routine.
GLSYSTEM - Used in the General Ledger company edit routine.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Validates the Intrastat country code.
INSTREGN - Validates the Intrastat region code.
OECOMPANY - Used to validate the Billing company.
OEPRCLIST - Used to validate the Billing price list.
STATICCUST - Used in the Accounts Receivable customer edit routine.
TXTAXRATE - Used in the tax code edit routine.
WFSETUP -
BL02.2 - Ship To Comments
Use this form to add comments for a ship-to location. The system attaches
these comments to each order entered for the ship-to location.
Updated Files
SHIPTO - This file is maintained by this program. It contains valid
ship to information.
SHIPTOCMNT - This file is maintained by this program. It contains comments
for the ship to customers.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used by the Accounts Receivable customer edit routine.
CUSTDESC - Used to display Accounts Receivable customer information.
INSTCTRYCD - Validates the Intrastat country code.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
STATICCUST - Used in the Accounts Receivable customer edit routine.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
IFCC
BL03.1 - Standard Comments
Use this form to define standard comments that appear repeatedly on invoices
and orders and assign them to codes. You can add these standard comments to
invoice or order headers and lines during processing. When defining the
comments, identify if the comments should print on the invoice, pick list, or
both.
You can create multiple language versions of the same standard comments code.
When printing the standard comments associated with a comment code on an
invoice or pick list, the Billing system uses the language version
corresponding to the customer's preferred language as defined on AR10.1
(Customer).
Updated Files
CKPOINT - Not used.
OECOMMHDR - This file is maintained by this program. It contains standard
comment codes and descriptions.
OESTDCOMM - This file is maintained by this program. It contains the
actual comment lines for the standard comment codes.
Referenced Files
OECOMPANY - Used to validate the Billing company.
BL04.1 - Customer Item Cross Reference
Use this form to cross-reference your item number with your customer's number
for that item. When your item numbers are cross-referenced with your
customer's item numbers, both numbers appear on invoices. This makes reporting
easier for your customers.
Note: To define a cross-reference item that is shared by all customers, leave
the Customer field blank when running BL04.1 (Customer Item Cross-Reference).
Updated Files
CKPOINT - Not used.
OECUSTITEM - This is the primary file maintained by this program. It
contains valid customer items, their descriptions and the
Inventory Control item numbers they refer to.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
CUSTDESC - Used to display Accounts Receivable customer information.
ICCOMPANY - Used to validate the Inventory Control company.
INSTCTRYCD - Validates the Intrastat country code.
ITEMMAST - Used to validate the Inventory Control item.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL05.1 - Sales Class Accounts
Use this form to assign general ledger accounts to process levels and sales
class combinations. General ledger accounts for sales and cost of goods sold
are controlled at the sales class level. The accounts defined on this form are
used to post sales of inventory and nonstock items. Default accounts for
special order items will default from the process level.
Before you can use sales classes in the Billing system, you must define and
assign them to items in the Inventory Control system. You can assign a target
profit margin and a hold code to place on lines when this profit margin has
not been met for the sales class.
Updated Files
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CKPOINT - Not used.
HOLDCODES - Used to validate hold codes. If this is the first time the
hold code is
referenced, the used flag is set.
OESLSACCT - This is the primary file maintained by this program. It
contains valid process level/sales classes and related
information.
Referenced Files
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
MAJORCL - Used to validate the Inventory Control major sales class.
MINORCL - Used to validate the Inventory Control minor sales class.
OECOMPANY - Used to validate the Billing company.
OEPROCLEV - Used to validate the Billing process level.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL06.1 - Invoice Types
Use this form to define invoice types for a company. Invoice types are
user-defined codes that identify types of invoices. Invoice types can be debit
or credit records, and can indicate whether credit memos are created or goods
are returned to stock. Manual invoices require invoice types.
You can add invoice types directly on the invoice or specify them as an order
type default on OE51.1 (Order Type). The system uses invoice types as editing
criteria when adding an invoice or order to the system. The invoice types are
then passed to the Sales Analysis system for use in analyzing billings.
The Svc Fmt field on this form offers the option to print invoices in service
format. If you use service format, your invoices will be printed on plain
paper in a letter format. The service format also offers the option to print a
summary page and add top and bottom standard comments to the invoice.
Updated Files
CKPOINT - Not used.
OEINVCTYPE - This is the primary file maintained by this program. It
contains all valid invoice types.
Referenced Files
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
BL07.1 - Reason Codes
Use this form to enter reason codes for canceling orders or entering credit
memos. You can print a report listing all canceled orders by reason code. When
creating reason codes, you can specify whether or not order amounts are
subtracted from bookings at cancellation time.
When adding a company, you must specify a default reason code. Once the
default reason code is assigned to a company, it can be changed but not
removed; the system uses the reason code when an order is canceled or deleted
during processing.
Updated Files
CKPOINT - Not used.
OEREASON - Primary file maintained by this program. It contains all
valid reason codes.
Referenced Files
OECOMPANY - Used to validate the Billing company.
BL08.1 - Location Tax Option
Use this form to define third-party taxing options at the inventory location
level. If the company is using a third-party tax system, you assign a
geographic code to each location from which items will be shipped. See your
third-party tax system's literature for more information.
Updated Files
CKPOINT - Not used.
ICLOCATION - Primary file maintained by this program. Updates the
geographic code on the Inventory Control system item location.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
Referenced Files
APACCRCODE - Used in the vendor edit routine.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used to validate currency relationships.
GLSYSTEM - Used in the General Ledger company edit routines.
ICCOMPANY - Used to validate the Inventory Control company.
TXTAXRATE - Used in the tax code edit routine.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL09.1 - Add-On Charges
Use this form to add predefined charges that can be used on orders, invoices,
order lines, or invoice lines. These add-on charges are additional, intangible
charges to be included with an order or invoice associated with the processing
of a line item. The charges print on invoices and can be assigned a sales
major and/or minor class and passed to the Sales Analysis system for reporting
purposes.
Updated Files
CKPOINT - Not used.
OEMISC - This is the primary file maintained by this program. It
contains valid add-on charge codes and their parameters.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
Referenced Files
APACCRCODE - Used in the vendor edit routine.
CUCONV - Used in converting money amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
GLSYSTEM - Used in the General Ledger company edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
MAJORCL - Used to validate the Inventory Control sales major class.
MINORCL - Used to validate the Inventory Control sales minor class.
OECOMPANY - Used to validate the Billing company.
POAOCMAST - Used to validate the purchase order add-on cost code.
TXTAXRATE - Used in the tax code edit routine.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
IFCC
BL10.1 - Item Add Ons
Use this form to attach add-on charges to items. When add-on charges are
assigned to items, the system automatically applies the add-on charge each
time you order the item.
You can identify a state for which the add-on charges are valid. In this
case, when the item is ordered and the customer's ship-to or bill-to address
(whichever address is used on the order) is in the state identified for an
add-on charge, the charge is assessed automatically. To access the add-on
charge each time the item is ordered, leave the state field blank, regardless
of what state the customer resides in. These same rules apply when entering a
credit or debit memo.
Updated Files
CKPOINT - Not used.
ITEMADDON - This is the primary file maintained by this program. It
contains item add-on charge codes.
Referenced Files
ICCOMPANY - Used to validate the Inventory Control company.
ITEMMAST - Used to validate Inventory Control item numbers.
OECOMPANY - Used to validate the Billing company.
OEMISC - Used to validate the Billing add-on charge code.
BL12.1 - Freight Codes
Use this form to define the freight codes that can be used on orders in the
Order Entry and Billing systems. Freight codes are user-defined, alphanumeric
two-character values that identify general ledger freight accounts to be
credited, as well as some other processing options.
When defining freight codes, you can specify whether the freight code and
charge are to interface into the Purchase Order system for dropship orders. If
a code is placed on the freight code, an add-on cost record will be created
for the purchase order. When the carrier's invoice is entered, that value is
passed from the purchase order back to the customer order and billed to the
customer.
Updated Files
CKPOINT - Not used.
OEFRTCODE - Primary file maintained by this program.
Referenced Files
OECOMPANY - Used to validate the Billing company.
POAOCMAST - Used to validate the purchase order add-on cost code.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL13.1 - Credit Card Types
Use this form to define the different kinds of credit cards that customers
will be using to pay for their orders. You can place a credit card type and
number on the customer master account and the system assumes the customer is
paying via credit card. In this case, the invoice prints but interfaces into
the Accounts Receivable system as a closed, historical invoice.
Updated Files
ARCODE - Used to validate Accounts Receivable codes. If this is the
first time the Accounts Receivable code is
referenced, the used flag is set.
CKPOINT - Not used.
OECREDCARD - Primary file maintained by this program. It contains all
valid credit card types.
Referenced Files
OECOMPANY - Used to validate the Billing company.
BL14.1 - Customer Codes
Use this form to define customer codes. You can assign these codes to
customers on the customer master form. Customer codes are required for all
customers whose orders are placed in the Order Entry system. Customers having
the same customer code will be grouped together for sales reporting purposes
in the Sales Analysis system.
Updated Files
CKPOINT - Not used.
OECUSTCODE - This is the primary file maintained by this program. It
contains valid Billing customer codes.
Referenced Files
OECOMPANY - Used to validate the Billing company.
BL15.1 - Recurring Invoice User
Use this form to assign responsibility for entering the quantity
to be billed each period for those items that reset to zero
after each billing period. You cannot limit entry here if you selected No in
the Control Recurring Charge Entry field when defining the company.
Updated Files
BILLOPER - Primary file maintained by this program. It contains the
items and add-on charge codes that each operator is responsible
for.
CKPOINT - Not used.
Referenced Files
ICCOMPANY - Used to validate the Inventory Control company.
ITEMMAST - Used to validate Inventory Control item numbers.
OECOMPANY - Used to validate the Billing company.
BL16.1 - Recurring Invoice User Add-on Charge
Use this form to limit users so they can only enter specific add-on charges
on recurring invoices. You cannot limit entry here if you selected No in the
Control Recurring Charge Entry field when defining the company.
Updated Files
BILLOPER - Primary file maintained by this program. It stores the items
and add-on charge
codes that an operator is responsible for.
CKPOINT - Not used.
Referenced Files
ICCOMPANY - Used to validate the Inventory Control company.
OECOMPANY - Used to validate the Billing company.
OEMISC - Used to validate the Billing add-on charge code.
BL20.1 - Invoice Entry
Shipment-related invoices are created within the Order Entry system by running
OE129 (Daily Shipment Journal) for orders that have been shipped to the
customer.
Use this form to manually enter and update invoices, billing adjustments, and
credit memos. To correct an invoice from a shipment, use this form to change
information such as price, comments, or freight charges. If there are fields
on the shipment related invoice that cannot be changed, you can delete the
invoice and update the order in the Order Entry system to reflect the correct
information. After you correct the order, you can create corrected invoices
the next time you run OE129.
After you define the invoice, use the buttons on this form, BL20.1 (Invoice
Entry), to define additional information, as follows:
If you want to add details to help with the processing of the invoice, you can
choose the Invoice Opts Button.
If you must invoice at more than one process level or want to create copies of
unreleased invoices or credit memos with other changed header information, you
can choose the Copy button. For example, to create a new invoice for a
different process level, you can inquire on an unreleased invoice or credit
memo, choose the Copy button, and change the process level.
Updated Files
ACCOMMIT - Stores commitments not yet posted to the general ledger and
keeps commitment balances.
ACCOMMITX - Stores commitments not yet posted to the general ledgers and
keeps commitment detail.
ARCODE - Used to validate Accounts Receivable codes. If this is the
first time the Accounts Receivable code is referenced, the used
flag is set.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CBBANKINST - Used to validate the payment code.
HOLDCODES - Used to validate the hold code.
OECOMPANY - Used to validate the Billing company.
OECUSTCODE - Used to validate customer codes.
OEINVCCOMM - Used to store comments associated with an invoice or its line
items.
OEINVCDTL - Used to store lot/serial information for an invoice line for
subsequent printing
OEINVCLINE - Used to store all information for an invoice line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
OEINVCTAX - Used to store tax amounts calculated when the invoice is
released.
OEINVCTYPE - Used to validate invoice type.
OEINVCUOM - Used to store invoice line pricing information when the line
has been priced
via multiple units of measure.
OEINVHDR - Invoice Batch Header file. Created when an invoice is added,
if it does not
already exist. Batch totals are updated as invoices are added
for the batch.
OEINVOICE - Stores all information for an invoice.
OEINVSGBLK - Stores user analysis values for processing through the
Strategic Ledger system.
OEMISC - Used to validate the Billing add-on charge code.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate reason codes.
SALESREP - Used to validate sales representatives.
TERITORY - Used to validate territories.
TERMS - Used to validate Accounts Receivable terms.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCAL - Used in the Activity Management edit routines.
ACCALX - Used in the Activity Management edit routines.
AGINGCODE - Used in the customer edit routine.
APACCRCODE - Used in the vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the customer edit routine.
ARLOCKBOX - Used in the customer edit routine.
AROIHDR - Used in the customer edit routine.
ARPAYMENT - Used in the customer edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
COLINE - Used to verify customer order line information.
COLINEUOM - Used to verify order line multiple pricing units of
measure.
COMISC - Used to verify order and order line add-on
charges.
CUCONV - Used for currency editing.
CURELAT - Used to validate currency relationships.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
CUSTORDER - Used to validate customer orders.
GLCODES - Used in the General Ledger edit routines.
GLSYSTEM - Used in the General Ledger edit routines.
ICCATEGORY - Used to validate inventory control general ledger categories.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the inventory control location.
INSTCTRYCD - Used to validate the Intrastat country code.
INSTREGN - Used to validate the Intrastat region code.
ITEMADDON - Used in the order line edit routine. Automatically adds
add-on charges to an order when an item is ordered.
ITEMLOC - Used to validate the Inventory Control item location.
ITEMMAST - Used to validate the inventory control item.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEFRTCODE - Used to validate freight codes.
OEORDCMNT - Used to store order comments related to customer order(s) or
customer order line(s).
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
OPERATOR -
ORDERTYPE - Used to validate order types.
SHIPTO - Used to validate ship-to numbers.
STATICCUST - Used in the Accounts Receivable customer edit routine.
SYSTEMCODE - Used by the General Ledger system edit routine.
TXTAXRATE - Used in the tax code edit routine.
WHSHIPLINE - Used to store shipline information including feedback
quantity.
WHSHIPMENT - Used to store shipment header information.
BL20.3 - Invoice Add On Charges
Use this subform to attach add-on charges to an invoice. Define add-on
charges using BL09.1 (Add-on Charges).
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ARCODE - Used to validate Accounts Receivable codes.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CBBANKINST - Used to validate the payment code.
HOLDCODES - Used to validate the hold code.
OECOMPANY - Used to validate the Billing company.
OECUSTCODE - Used to validate customer codes.
OEINVCCOMM - Used to store comments associated with an invoice or its line
items.
OEINVCDTL - Used to store lot/serial information for an invoice line for
subsequent printing
OEINVCLINE - Used to store all information for an invoice line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
OEINVCTAX - Used to store tax amounts calculated when the invoice is
released.
OEINVCTYPE - Used to validate invoice type.
OEINVCUOM - Used to store invoice line pricing information when the line
has been priced
via multiple units of measure.
OEINVHDR - Invoice Batch Header file. Created when an invoice is added,
if it does not
already exist. Batch totals are updated as invoices are added
for the batch.
OEINVOICE - Stores all information for an invoice.
OEINVSGBLK - Stores user analysis values processed through the Strategic
Ledger system.
OEMISC - Used to validate the Billing add-on charge code.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate reason codes.
SALESREP - Used to validate sales representatives.
TERITORY - Used to validate territories.
TERMS - Used to validate Accounts Receivable terms.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCAL - Used in the Activity Management edit routines.
ACCALX - Used in the Activity Management edit routines.
AGINGCODE - Used in the customer edit routine.
APACCRCODE - Used in the vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the customer edit routine.
ARLOCKBOX - Used in the customer edit routine.
AROIHDR - Used in the customer edit routine.
ARPAYMENT - Used in the customer edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
COLINE - Used to verify customer order line information.
COLINEUOM - Used to verify order line multiple pricing units of
measure.
COMISC - Used to verify order and order line add-on
charges.
CUCONV - Used for currency editing.
CURELAT - Used to validate currency relationships.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
CUSTORDER - Used to validate customer orders.
GLCODES - Used in the General Ledger edit routines.
GLSYSTEM - Used in the General Ledger edit routines.
ICCATEGORY - Used to validate inventory control general ledger categories.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the inventory control location.
INSTCTRYCD - Validates the Intrastat country code.
INSTREGN - Validates Intrastat region code.
ITEMADDON - Used in the order line edit routine. Automatically adds
add-on charges to an order when an item is ordered.
ITEMLOC - Used to validate the Inventory Control item location.
ITEMMAST - Used to validate the inventory control item.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEFRTCODE - Used to validate freight codes.
OEORDCMNT - Used to store order comments related to customer order(s) or
customer order line(s).
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
OPERATOR -
ORDERTYPE - Used to validate order types.
SHIPTO - Used to validate ship-to numbers.
STATICCUST - Used in the Accounts Receivable customer edit routine.
SYSTEMCODE - Used by the General Ledger system edit routine.
TXTAXRATE - Used in the tax code edit routine.
WHSHIPLINE - Used to store shipline information including feedback
quantity.
WHSHIPMENT - Used to store shipment header information.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
IFOB
IFRS
SLSS
BL21.2 - Invoice Copy
Use this subform to copy a previously defined invoice and create a new
invoice.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ARCODE - Used to validate Accounts Receivable codes.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CBBANKINST - Used to validate the payment code.
HOLDCODES - Used to validate the hold code.
OECOMPANY - Used to validate the Billing company.
OECUSTCODE - Used to validate customer codes.
OEINVCCOMM - Used to store comments associated with an invoice or its line
items.
OEINVCDTL - Used to store lot/serial information for an invoice line for
subsequent printing
OEINVCLINE - Used to store all information for an invoice line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
OEINVCTAX - Used to store tax amounts calculated when the invoice is
released.
OEINVCTYPE - Used to validate invoice type.
OEINVCUOM - Used to store invoice line pricing information when the line
has been priced
via multiple units of measure.
OEINVHDR - Invoice Batch Header file. Created when an invoice is added,
if it does not
already exist. Batch totals are updated as invoices are added
for the batch.
OEINVOICE - Stores all information for an invoice.
OEINVSGBLK - Stores user analysis values processed through the Strategic
Ledger system.
OEMISC - Used to validate the Billing add-on charge code.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate reason codes.
SALESREP - Used to validate sales representatives.
TERITORY - Used to validate territories.
TERMS - Used to validate Accounts Receivable terms.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCAL - Used in the Activity Management edit routines.
ACCALX - Used in the Activity Management edit routines.
AGINGCODE - Used in the customer edit routine.
APACCRCODE - Used in the vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the customer edit routine.
ARLOCKBOX - Used in the customer edit routine.
AROIHDR - Used in the customer edit routine.
ARPAYMENT - Used in the customer edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
COLINE - Used to verify customer order line information.
COLINEUOM - Used to verify order line multiple pricing units of
measure.
COMISC - Used to verify order and order line add-on
charges.
CUCONV - Used for currency editing.
CURELAT - Used to validate currency relationships.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
CUSTORDER - Used to validate customer orders.
GLCODES - Used in the General Ledger edit routines.
GLSYSTEM - Used in the General Ledger edit routines.
ICCATEGORY - Used to validate inventory control general ledger categories.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the inventory control location.
INSTCTRYCD - Validates the Intrastat country code.
INSTREGN - Validates the Intrastat region code.
ITEMADDON - Used in the order line edit routine. Automatically adds
add-on charges to an order when an item is ordered.
ITEMLOC - Used to validate the Inventory Control item location.
ITEMMAST - Used to validate the inventory control item.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEFRTCODE - Used to validate freight codes.
OEORDCMNT - Used to store order comments related to customer order(s) or
customer order line(s).
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
OPERATOR -
ORDERTYPE - Used to validate order types.
SHIPTO - Used to validate ship-to numbers.
STATICCUST - Used in the Accounts Receivable customer edit routine.
SYSTEMCODE - Used by the General Ledger system edit routine.
TXTAXRATE - Used in the tax code edit routine.
WHSHIPLINE - Used to store shipline information including feedback
quantity.
WHSHIPMENT - Used to store shipment header information.
BL21.3 - Invoice Comments
Use this subform to assign comments to invoices in the customer's preferred
language.
Updated Files
OEINVCCOMM - Used to store comments associated with an invoice or its line
items.
OEINVOICE - Stores all information for an invoice.
Referenced Files
ARCUSTOMER - Used to validate the Accounts Receivable customer.
BL21.4 - Invoice Line Comments
Use this subform to assign comments to invoice lines.
Updated Files
OEINVCCOMM - Used to store comments associated with an invoice or its line
items.
OEINVCLINE - Used to store all information for an invoice line.
Referenced Files
ARCUSTOMER - Used to validate the Accounts Receivable customer.
OEINVOICE - This is a primary file maintained by this program. It
contains all information for an invoice.
BL21.5 - Line Add On Charges
Use this subform to attach add-on charges to an invoice line. You define
add-on charges using BL09.1 (Add-on Charges).
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ARCODE - Used to validate Accounts Receivable codes.
ARPROCLEVL - Used to edit the Accounts Receivable process
level.
CBBANKINST - Used to validate the payment code.
HOLDCODES - Used to validate the hold code.
OECOMPANY - Used to validate the Billing company.
OECUSTCODE - Used to validate customer codes.
OEINVCCOMM - This is the primary file maintained by this program. Comments
for an invoice can be added, changed or deleted.
OEINVCDTL - Used to store lot/serial information for an invoice line for
subsequent printing
OEINVCLINE - Used to store all information for an invoice line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
OEINVCTAX - Used to store tax amounts calculated when the invoice is
released.
OEINVCTYPE - Used to validate invoice type.
OEINVCUOM - Used to store invoice line pricing information when the line
has been priced
via multiple units of measure.
OEINVHDR - Invoice Batch Header file. Created when an invoice is added,
if it does not
already exist. Batch totals are updated as invoices are added
for the batch.
OEINVOICE - Top and bottom comment sequence numbers are updated when
comments are added to or deleted from an invoice.
OEINVSGBLK - Stores user analysis values processed through the Strategic
Ledger system.
OEMISC - Used to validate the Billing add-on charge code.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate reason codes.
SALESREP - Used to validate sales representatives.
TERITORY - Used to validate territories.
TERMS - Used to validate Accounts Receivable terms.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCAL - Used in the Activity Management edit routines.
ACCALX - Used in the Activity Management edit routines.
AGINGCODE - Used in the customer edit routine.
APACCRCODE - Used in the vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the customer edit routine.
ARLOCKBOX - Used in the customer edit routine.
AROIHDR - Used in the customer edit routine.
ARPAYMENT - Used in the customer edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
COLINE - Used to verify customer order line information.
COLINEUOM - Used to verify order line multiple pricing units of
measure.
COMISC - Used to verify order and order line add-on
charges.
CUCONV - Used for currency editing.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
CUSTORDER - Used to validate customer orders.
GLCODES - Used in the General Ledger edit routines.
GLSYSTEM - Used in the General Ledger edit routines.
ICCATEGORY - Used to validate inventory control general ledger categories.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Validates the Intrastat country code.
INSTREGN - Validates the Intrastat region code.
ITEMADDON - Used in the order line edit routine. Automatically adds
add-on charges to an order when an item is ordered.
ITEMLOC - Used to validate the Inventory Control item location.
ITEMMAST - Used to validate the inventory control item.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEFRTCODE - Used to validate freight codes.
OEORDCMNT - Used to store order comments related to customer order(s) or
customer order line(s).
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
OPERATOR -
ORDERTYPE - Used to validate order types.
SHIPTO - Used to validate ship-to numbers.
STATICCUST - Used in the Accounts Receivable customer edit routine.
SYSTEMCODE - Used by the General Ledger system edit routine.
TXTAXRATE - Used in the tax code edit routine.
WHSHIPLINE - Used to store shipline information including feedback
quantity.
WHSHIPMENT - Used to store shipment header information.
BL21.6 - Copy Standard Comments
Use this subform to copy standard comments to an invoice line.
Updated Files
OEINVCCOMM - This is the primary file maintained by this program. Comments
for an invoice line can be added, changed or deleted.
OEINVCLINE - Comment sequence number is updated when comments are added to
or deleted from an invoice line.
OEINVOICE - Stores all information for an invoice.
Referenced Files
OECOMMHDR - Used to validate standard comment codes.
OESTDCOMM - Used to retrieve standard comments.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
IFOB
IFRS
SLSS
BL22.1 - Copy Standard Comments
You can use this subform to copy standard comments to an invoice.
Updated Files
OEINVCCOMM - Used to store comments associated with an invoice or its line
items.
OEINVCLINE - Invoice line comments are auto-sequenced based on a field on
the invoice
line.
OEINVOICE - Invoice comments are auto-sequenced based on a field on the
invoice file.
Referenced Files
OECOMMHDR - Used to validate standard comment codes.
OESTDCOMM - Source for comments being copied.
BL29.1 - Batch Control
Use this form to view, change, and release unreleased batches of invoices and
credit memos. The system assigns the batch number when invoices and credit
memos are added on BL20.1 (Invoice Entry). If you selected the batch control
totals option on the Company form, you must enter control totals and they must
equal the detail added to the batch before releasing the batch.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ARCODE - Used to validate Accounts Receivable codes. If this is the
first time the Accounts Receivable code is
referenced, the used flag is set.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CBBANKINST - Used to validate payment codes.
HOLDCODES - Used to validate hold codes. If this is the first time the
hold code is
referenced, the used flag is set.
OECOMPANY - Used to validate the Billing company.
OECUSTCODE - Used to validate customer codes. If this is the first time
the customer code is
used, the used flag is set on.
OEINVCCOMM - Used to store comments associated with an invoice or its line
items.
OEINVCDTL - Used to store lot/serial information for an invoice line for
subsequent printing
on the invoice form.
OEINVCLINE - Used to store all information for an invoice line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
OEINVCTAX - Used to store tax amounts calculated when the invoice is
released.
OEINVCTYPE - Used to validate invoice types. If this is the first time the
invoice type is
referenced, the used flag is set.
OEINVCUOM - Used to store invoice line pricing information when the line
has been priced
via multiple units of measure.
OEINVHDR - Invoice Batch Header file. Created when an invoice is added,
if it does not
already exist. Batch totals are updated as invoices are added
for the batch.
OEINVOICE - Stores all information for an invoice.
OEINVSGBLK - Stores user analysis values processed through the Strategic
Ledger system.
OEMISC - Used to validate the Billing add-on charge code.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate reason codes. If this is the first time the
reason code is
referenced, the used flag is set.
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCAL - Used in the Activity Management edit routines.
ACCALX - Used in the Activity Management edit routines.
AGINGCODE - Used in the Accounts Receivable customer edit routine.
APACCRCODE - Used in the vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
AROIHDR - Used in the customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
COLINE - Used when creating invoice/invoice lines by copying a customer
order.
COLINEUOM - Used when creating invoice/invoice lines by copying a customer
order.
COMISC - Used when creating invoice/invoice Lines by copying a customer
order.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used to display Accounts Receivable customer information.
CUSTORDER - Used when creating invoice/invoice lines by copying a customer
order.
GLCODES - Used in the General Ledger account verification routine.
GLSYSTEM - Used in the General Ledger account verification routine.
ICCATEGORY - Used to validate inventory control general ledger categories.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Validates the Intrastat country code.
INSTREGN - Validates the Intrastate region code.
ITEMADDON - Used to trigger automatic creation of add-on charges for
specific items when
sold in specified states (or all states). The add-on charge
is created at
the invoice line level.
ITEMLOC - Used to validate the Inventory Control item location.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEFRTCODE - Used to validate freight codes.
OEORDCMNT - Used when creating invoice/invoice lines by copying a customer
order.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
OPERATOR -
ORDERTYPE - Used to validate order types.
SHIPTO - Used to validate ship-to numbers.
STATICCUST - Used in the Accounts Receivable customer edit routine.
SYSTEMCODE - Used by the General Ledger system edit routine.
TXTAXRATE - Used when calculating sales tax for an invoice line.
WHSHIPLINE - Used to store shipline information including feedback
quantity.
WHSHIPMENT - Used to store shipment header information.
BL29.2 - Invoice Batch
Use this subform to delete a batch of invoices. Remember that if you delete
an invoice batch, all invoices within the batch are deleted.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ARCODE - Used to validate Accounts Receivable codes. If this is the
first time the Accounts Receivable code is
referenced, the used flag is set.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CBBANKINST - Used to validate payment codes.
HOLDCODES - Used to validate hold codes. If this is the first time the
hold code is
referenced, the used flag is set.
OECOMPANY - Used to validate the Billing company.
OECUSTCODE - Used to validate customer codes. If this is the first time
the customer code is
used, the used flag is set on.
OEINVCCOMM - Used to store comments associated with an invoice or its line
items.
OEINVCDTL - Used to store lot/serial information for an invoice line for
subsequent printing
on the invoice form.
OEINVCLINE - Used to store all information for an invoice line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
OEINVCTAX - Used to store tax amounts calculated when the invoice is
released.
OEINVCTYPE - Used to validate invoice types. If this is the first time the
invoice type is
referenced, the used flag is set.
OEINVCUOM - Used to store invoice line pricing information when the line
has been priced
via multiple units of measure.
OEINVHDR - Invoice Batch Header file. Created when an invoice is added,
if it does not
already exist. Batch totals are updated as invoices are added
for the batch.
OEINVOICE - Stores all information for an invoice.
OEINVSGBLK - Stores user analysis values.
OEMISC - Used to validate the Billing add-on charge code.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate reason codes. If this is the first time the
reason code is
referenced, the used flag is set.
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCAL - Used in the Activity Management edit routines.
ACCALX - Used in the Activity Management edit routines.
AGINGCODE - Used in the Accounts Receivable customer edit routine.
APACCRCODE - Used in the vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
AROIHDR - Used in the customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
COLINE - Used when creating invoice/invoice lines by copying a customer
order.
COLINEUOM - Used when creating invoice/invoice lines by copying a customer
order.
COMISC - Used when creating invoice/invoice lines by copying a customer
order.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used to display Accounts Receivable customer information.
CUSTORDER - Used to validate customer orders.
GLCODES - Used in the General Ledger account verification routine.
GLSYSTEM - Used in the General Ledger account verification routine.
ICCATEGORY - Used to validate inventory control general ledger categories.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Validates the Intrastat country code.
INSTREGN - Validates the Intrastat region code.
ITEMADDON - Used to trigger automatic creation of add-on charges for
specific items when
sold in specified states (or all states). The add-on charge
is created at
the invoice line level.
ITEMLOC - Used to validate the Inventory Control item location.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEFRTCODE - Used to validate freight codes.
OEORDCMNT - Used when creating invoice/invoice lines by copying a customer
order.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
OPERATOR -
ORDERTYPE - Used to validate order types.
SHIPTO - Used to validate ship-to numbers.
STATICCUST - Used in the Accounts Receivable customer edit routine.
SYSTEMCODE - Used by the General Ledger system edit routine.
TXTAXRATE - Used when calculating sales tax for an invoice line.
WHSHIPLINE - Used to store shipline information including feedback
quantity.
WHSHIPMENT - Used to store shipment header information.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
IFOB
IFRS
SLSS
BL30.1 - Recurring Invoice
Use this form to create a recurring invoice. You create recurring invoices
for a service or set of services that you sell repeatedly, such as a leasing
service or a membership fee. You can later assign items to a recurring invoice
and assign it to a specific customer.
A recurring invoice acts as a template for a customer recurring invoice. The
system does not let you delete a recurring invoice if any customer recurring
invoice exists for the recurring invoice.
You can either enter a start and stop date for the recurring invoice or the
total number of invoices that can be created with this recurring invoice. For
example, enter 12 as the total number of invoices for monthly billing for a
one-year contract.
Recurring invoices are meant only for debit memos, not credit memos.
Updated Files
BLRIMAST - Primary file maintained by this program. Stores information
and control parameters to control creation of customer
recurring invoices and the subsequent invoices created from
those customer recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Primary file maintained by this program. Stores information
and control parameters to control creation of customer
recurring invoice line items and the subsequent invoices
created from those customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
OEINVCTYPE - Used to validate invoice types. If this is the first time the
invoice type is
referenced, the used flag is set.
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
Referenced Files
BLRICUST - Used to edit that no customer recurring invoices exist. A
recurring invoice
cannot be deleted when there are any attached customer
recurring invoices.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
GLSYSTEM - Used in the GL Company Edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OEPROCLEV - Used to validate the Billing process level.
BL30.2 - Recurring Add On Charges
Use this subform to assign add-on charges to a recurring invoice at the
header level. The recurring invoice must already exist before you can attach
an add-on charge to it. You can enter the charge as a flat amount, not as a
percentage or a unit price.
Updated Files
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Stores information and control parameters to control creation
of customer
recurring invoice line items and the subsequent invoices
created from those
customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those
customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
OEINVCTYPE - Used to validate invoice type.
SALESREP - Used to validate sales representatives.
TERITORY - Used to validate territories.
TERMS - Used to validate Accounts Receivable terms.
Referenced Files
BLRICMISC - Stores information and control parameters to control creation
of invoices
for an add-on charge.
BLRICUST - Used to edit that no customer recurring invoices exist. A
recurring invoice
cannot be deleted when there are any attached customer
recurring invoices.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used to validate currency relationships.
GLSYSTEM - Used in the General Ledger company edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the inventory control location.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OEMISC - Used to validate the Billing add-on charge code.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OEPROCLEV - Used to validate the Billing process level.
BL30.3 - Recurring Items
With this form, you can assign items to a recurring invoice line. You must
have already defined the recurring invoice before assigning items to it.
Updated Files
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Stores information and control parameters to control creation
of customer
recurring invoice line items and the subsequent invoices
created from those
customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
OEINVCTYPE - Used to validate invoice type.
SALESREP - Used to validate sales representatives.
TERITORY - Used to validate territories.
TERMS - Used to validate Accounts Receivable terms.
Referenced Files
BLRICLINE - Used to edit that no customer recurring invoice lines exist.
A recurring
invoice line cannot be deleted when there are any attached
customer recurring
invoice lines.
BLRICUST - Used to edit that no customer recurring invoices exist. A
recurring invoice
cannot be deleted when there are any attached customer
recurring invoices.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used to validate currency relationships.
GLSYSTEM - Used in the General Ledger company edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the inventory control location.
ITEMMAST - Used to validate the inventory control item.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OEPROCLEV - Used to validate the Billing process level.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
BL30.5 - Recurring Line Add On Charges
With this subform, you can assign add-on charges to recurring invoice lines.
The recurring invoice line must already exist before you can assign an add-on
charge to it. The add-on charge can be any type (flat amount, unit price, or
percentage). However, the zero-after option is valid only for flat amount
add-on charges.
Updated Files
BLRIMAST - Primary file maintained by this program. Stores information
and control parameters to control creation of customer
recurring invoices and the subsequent invoices created from
those customer recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Primary file maintained by this program. Stores information
and control parameters to control creation of customer
recurring invoice line items and the subsequent invoices
created from those customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
OEINVCTYPE - Used to validate invoice types. If this is the first time the
invoice type is
referenced, the used flag is set.
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
Referenced Files
BLRICLINE - Used to edit that no customer recurring invoice lines exist.
A recurring
invoice line cannot be deleted when there are any attached
customer recurring
invoice lines.
BLRICMISC - Stores information and control parameters to control creation
of invoices
for an add-on charge.
BLRICUST - Used to edit that no customer recurring invoices exist. A
recurring invoice
cannot be deleted when there are any attached customer
recurring invoices.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
GLSYSTEM - Used in the GL Company Edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
ITEMMAST - Used to validate Inventory Control item numbers.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OEMISC - Used to validate the Billing add-on charge code.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OEPROCLEV - Used to validate the Billing process level.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
INVOKED Programs
ACAC
IFCR
IFSG
IFCU
IFCC
SLSE
SLSU
IFAC
IFAU
SLSS
BL31.1 - Customer Recurring Invoice
Use this form to assign a recurring invoice to a specific customer. You must
have already defined the recurring invoice before you can assign one to a
customer. You can override the default information from BL30.1 (Recurring
Invoice) that appears here.
Recurring invoices are meant only for debit memos, not credit memos.
Updated Files
BLRICCOMM - Stores comments attached to either a customer recurring
invoice header or a
recurring invoice line comments.
BLRICLINE - Primary file maintained by this program. Stores information
and control parameters to control creation of invoices for an
item.
BLRICMISC - Primary file maintained by this program. Stores information
and control parameters to control creation of invoices for an
add-on charge.
BLRICSGBLK - Stores header information for customer recurring invoices.
BLRICUST - Primary file maintained by this program. Stores information
and parameters used to control invoice creation for a customer
recurring invoice.
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Stores information and control parameters to control creation
of customer
recurring invoice line items and the subsequent invoices
created from those
customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
HOLDCODES - Used to validate hold codes. If this is the first time the
hold code is
referenced, the used flag is set.
OEINVCTYPE - Used to validate invoice types. If this is the first time the
invoice type is
referenced, the used flag is set.
OEMISC - Used to validate the Billing add-on charge code.
SALESREP - Used to validate sales representative. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and Update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BILLOPER - Used to validate operator authority to enter item or add-on
charge.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used to display the Accounts Receivable customer information.
GLSYSTEM - Used in the General Ledger company edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OEPROCLEV - Used to validate the Billing process level.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL31.2 - Customer Recurring Invoice AOCs
Use this subform to assign add-on charges to a customer recurring invoice.
You must have already defined the customer recurring invoice before assigning
add-on charges to it.
Updated Files
BLRICCOMM - Stores comments attached to either a customer recurring
invoice header or a
recurring invoice line comments.
BLRICLINE - Used to edit that no customer recurring invoice lines exist.
A recurring
invoice line cannot be deleted when there are any attached
customer recurring
invoice lines.
BLRICMISC - Stores information and control parameters to control creation
of invoices
for an add-on charge.
BLRICSGBLK - Stores header information for customer recurring invoices.
BLRICUST - Used to edit that no customer recurring invoices exist. A
recurring invoice
cannot be deleted when there are any attached customer
recurring invoices.
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Stores information and control parameters to control creation
of customer
recurring invoice line items and the subsequent invoices
created from those
customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
HOLDCODES - Used to validate the hold code.
OEINVCTYPE - Used to validate invoice type.
OEMISC - Used to validate the Billing add-on charge code.
SALESREP - Used to validate sales representatives.
TERITORY - Used to validate territories.
TERMS - Used to validate Accounts Receivable terms.
Referenced Files
AGINGCODE - Used in the customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the customer edit routine.
ARLOCKBOX - Used in the customer edit routine.
ARPAYMENT - Used in the customer edit routine.
BILLOPER - Used to validate operator authority to enter item or add-on
charge.
CUCONV - Used for currency editing.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
GLSYSTEM - Used in the General Ledger edit routines.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the inventory control location.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMMAST - Used to validate the inventory control item.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OEPROCLEV - Used to validate the Billing process level.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL31.3 - Customer Recurring Invoice Items
Use this form to assign items to customer recurring invoice lines. Both the
customer recurring invoice and the invoice line must exist before you can
assign items to an invoice line.
Updated Files
BLRICCOMM - Stores comments attached to either a customer recurring
invoice header or a
recurring invoice line comments.
BLRICLINE - Used to edit that no customer recurring invoice lines exist.
A recurring
invoice line cannot be deleted when there are any attached
customer recurring
invoice lines.
BLRICMISC - Stores information and control parameters to control creation
of invoices
for an add-on charge.
BLRICSGBLK - Stores header information for customer recurring invoices.
BLRICUST - Used to edit that no customer recurring invoices exist. A
recurring invoice
cannot be deleted when there are any attached customer
recurring invoices.
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Stores information and control parameters to control creation
of customer
recurring invoice line items and the subsequent invoices
created from those
customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
HOLDCODES - Used to validate the hold code.
OEINVCTYPE - Used to validate invoice type.
OEMISC - Used to validate the Billing add-on charge code.
SALESREP - Used to validate sales representatives.
TERITORY - Used to validate territories.
TERMS - Used to validate Accounts Receivable terms.
Referenced Files
AGINGCODE - Used in the customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the customer edit routine.
ARLOCKBOX - Used in the customer edit routine.
ARPAYMENT - Used in the customer edit routine.
BILLOPER - Used to validate operator authority to enter item or add-on
charge.
CUCONV - Used for currency editing.
CURELAT - Used to validate currency relationships.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
GLSYSTEM - Used in the General Ledger edit routines.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the inventory control location.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMMAST - Used to validate the inventory control item.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OEPROCLEV - Used to validate the Billing process level.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL31.5 - Customer Recurring Invc Line AOCs
Use this subform to assign add-on charges to a customer recurring invoice
line. You can enter add-on charges as a flat amount, unit price, or as a
percentage. However, if you selected the zero-after option, you can only
enter the add-on charge as a flat amount.
Updated Files
BLRICCOMM - Stores comments attached to either a customer recurring
invoice header or a
recurring invoice line comments.
BLRICLINE - Primary file maintained by this program. Stores information
and control parameters to control creation of invoices for an
item.
BLRICMISC - Primary file maintained by this program. Stores information
and control parameters to control creation of invoices for
add-on charge.
BLRICSGBLK - Stores header information for customer recurring invoices.
BLRICUST - Primary file maintained by this program. Stores information
and parameters used to control invoice creation for a customer
recurring invoice.
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Stores information and control parameters to control creation
of customer
recurring invoice line items and the subsequent invoices
created from those
customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
HOLDCODES - Used to validate hold codes. If this is the first time the
hold code is
referenced, the used flag is set.
OEINVCTYPE - Used to validate invoice types. If this is the first time the
invoice type is
referenced, the used flag is set.
OEMISC - Used to validate the Billing add-on charge code.
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and Update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BILLOPER - Used to validate operator authority to enter item or add-on
charge.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used to display the Accounts Receivable customer information.
GLSYSTEM - Used in the General Ledger company edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OEPROCLEV - Used to validate the Billing process level.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL31.7 - Recurring Customer Mass Create
With this form, you can create one customer recurring invoice for up to 10
customers at once. The recurring invoice must already be defined before you
can mass create a customer recurring invoice for several customers.
Updated Files
BLRICCOMM - Stores comments attached to either a customer recurring
invoice header or a
recurring invoice line comments.
BLRICLINE - Primary file maintained by this program. Stores information
and control parameters to control creation of invoices for an
item.
BLRICMISC - Primary file maintained by this program. Stores information
and control parameters to control creation of invoices for
add-on charge.
BLRICSGBLK - Stores header information for customer recurring invoices.
BLRICUST - Primary file maintained by this program. Stores information
and parameters used to control invoice creation for a customer
recurring invoice.
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Stores information and control parameters to control creation
of customer
recurring invoice line items and the subsequent invoices
created from those
customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those
customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
HOLDCODES - Used to validate hold codes. If this is the first time the
hold code is
referenced, the used flag is set.
OEINVCTYPE - Used to validate invoice types If this is the first time the
invoice type is
referenced, the used flag is set.
OEMISC - Used to validate the Billing add-on charge code.
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and Update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BILLOPER - Used to validate operator authority to enter an item or add-on
charge.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used to display Accounts Receivable customer information.
GLSYSTEM - Used in the General Ledger company edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OEPROCLEV - Used to validate the Billing process level.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
STATICCUST - Used in the Accounts Receivable customer edit routine.
INVOKED Programs
ACAC
IFCR
IFSG
IFCU
IFAC
IFAU
SLSE
SLSU
IFCC
SLSS
BL32.1 - Recurring Invoice Comments
With this subform, you can add comments to recurring invoices at the header
level. Before adding comments however, you must create the recurring invoice
itself. Define standard comments using BL03.1 (Standard Comments).
Updated Files
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Stores information and control parameters to control creation
of customer
recurring invoice line items and the subsequent invoices
created from those
customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
OEINVCTYPE - Used to validate invoice types. If this is the first time the
invoice type is
referenced, the used flag is set.
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
Referenced Files
BLRICUST - Used to validate the customer recurring invoice.
CUCONV - Used to validate currency conversion rates.
CURELAT - Used in converting monetary amounts between currencies.
GLSYSTEM - Used in the GL Company Edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OEPROCLEV - Used to validate the Billing process level.
BL32.2 - Recurring Line Comments
With this subform, you can add comments to a recurring invoice line.
Updated Files
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Stores information and control parameters to control creation
of customer
recurring invoice line items and the subsequent invoices
created from those
customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
OEINVCTYPE - Used to validate invoice types. If this is the first time the
invoice type is
referenced, the used flag is set.
SALESREP - Used to validate the sales representative. If this is the
first time the sales representative is referenced, the used
flag is set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
Referenced Files
BLRICLINE - Stores information and control parameters to control creation
of invoices
for an item.
BLRICUST - Used to validate customer recurring invoice numbers.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
GLSYSTEM - Used in the GL Company Edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
ITEMMAST - Used to validate Inventory Control item numbers.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OEPROCLEV - Used to validate the Billing process level.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
BL32.3 - Customer Recurring Invoice Comments
Use this subform to add comment text and standard comments to a customer
recurring invoice in the customer's preferred language. You must have already
defined the customer recurring invoice before assigning comments to it.
Updated Files
BLRICCOMM - Stores comments attached to either a customer recurring
invoice header or a
recurring invoice line comments.
BLRICLINE - Primary file maintained by this program. Stores information
and control parameters to control creation of invoices for an
item.
BLRICMISC - Primary file maintained by this program. Stores information
and control parameters to control creation of invoices for
add-on charge.
BLRICSGBLK - Stores header information for customer recurring invoices.
BLRICUST - Used to validate customer recurring invoice numbers.
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Stores information and control parameters to control creation
of customer
recurring invoice line items and the subsequent invoices
created from those
customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those
customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
HOLDCODES - Used to validate Hold Codes. If this is the first time the
Hold Code is
referenced, the used flag is set.
OEINVCTYPE - Used to validate invoice types If this is the first time the
invoice type is
referenced, the used flag is set.
OEMISC - Used to validate the Billing add-on charge code.
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and Update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BILLOPER - Used to validate operator authority to enter item or add-on
charge.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used to display Accounts Receivable customer information.
GLSYSTEM - Used in the General Ledger company edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OEPROCLEV - Used to validate the Billing process level.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL32.4 - Customer Recurring Line Comments
With this subform, you can add standard comments codes and comment text to a
customer recurring invoice line in the customer's preferred language. The
customer recurring invoice and invoice line must already exist before you can
assign comments to the invoice line.
Updated Files
BLRICCOMM - Stores comments attached to either a customer recurring
invoice header or a
recurring invoice line comments.
BLRICLINE - Primary file maintained by this program. Stores information
and control parameters to control creation of invoices for an
item.
BLRICMISC - Primary file maintained by this program. Stores information
and control parameters to control creation of invoices for an
add-on charge.
BLRICSGBLK - Stores header information for customer recurring invoices.
BLRICUST - Used to validate customer recurring invoice numbers.
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Stores information and control parameters to control creation
of customer
recurring invoice line items and the subsequent invoices
created from those
customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
HOLDCODES - Used to validate Hold Codes. If this is the first time the
Hold Code is
referenced, the used flag is set.
OEINVCTYPE - Used to validate invoice types. If this is the first time the
invoice type is
referenced, the used flag is set.
OEMISC - Used to validate the Billing add-on charge code.
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and Update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BILLOPER - Used to validate operator authority to enter item or add-on
charge.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used to display Accounts Receivable customer information.
GLSYSTEM - Used in the General Ledger company edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OEPROCLEV - Used to validate the Billing process level.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
STATICCUST - Used in the Accounts Receivable customer edit routine.
INVOKED Programs
ACAC
IFCR
IFSG
IFCU
IFCC
SLSE
SLSU
IFAC
IFAU
SLSS
BL33.1 - Recurring Item Quantity Entry
Use this form to set the quantity for an item for each recurring invoice.
Only items with the zero-after option set on the master recurring invoice line
will appear here.
Updated Files
BLRICLINE - Stores information and control parameters to control creation
of invoices
for an item.
CKPOINT - Used for batch recovery.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and Update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BILLOPER - Used to validate operator authority to enter item or add-on
charge.
BLRICUST - Used to validate customer recurring invoice numbers.
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
CUSTDESC - Used to display the Accounts Receivable customer information.
ICCOMPANY - Used to validate the Inventory Control company.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL34.1 - Recurring Add-on Charge Entry
Use this form to enter add-on charges for recurring invoices. This feature is
only valid if you selected the zero-after use flag. You can only enter add-on
charges as a flat amount, not as a unit price or a percentage.
Updated Files
BLRICMISC - Primary file maintained by this program. Stores information
and control parameters to control creation of invoices for an
add-on charge.
CKPOINT - Not used.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and Update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate an Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BILLOPER - Used to validate operator authority to enter an item or add-on
charge.
BLRICLINE - Primary file maintained by this program. Stores information
and control parameters to control creation of invoices for an
item.
BLRICUST - Used to validate customer recurring invoice numbers.
BLRIMAST - Stores information and control parameters to control creation
of customer recurring invoices and the subsequent invoices
created from those customer recurring invoices.
CUSTDESC - Used to display the Accounts Receivable customer information.
INSTCTRYCD - Used to validate the Intrastat country code.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEMISC - Used to validate the Billing add-on charge code.
STATICCUST - Used in the Accounts Receivable customer edit routine.
INVOKED Programs
IFCR
IFSG
BL40.1 - Price Base
Use this form to add a price base and assign items to that base, which is
required for the system to perform default pricing.
Item pricing takes place when you enter an item on an invoice or order. Both
the price base and price list are referenced to arrive at item prices. Simply
stated, a price base represents the dollar (or English Pound, or French Franc,
and so on) amount an item's price is based on. Examples of a price base are
list price, suggested retail price, or vendor cost. A price list (which is
assigned to a customer) specifies a percentage, amount per unit, or override
price that is used to modify the price base.
Pricing offers many additional options, including quantity break pricing,
discounting, contracts, and promotions. See the Billing Procedures Manual for
more information on pricing.
Updated Files
OEBASE - This is the primary file maintained by this program. It
contains price bases and item price by unit of measure.
OEBPAUDIT - This file is updated by this program when the Billing company
requires price auditing. An audit record will be written when
a base price is added or changed.
Referenced Files
CUCODES - Used to validate base currency.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location when the
Billing company is using location-based pricing.
ITEMMAST - Used to validate the Inventory Control item numbers.
OECOMPANY - Used to validate the Billing company.
BL40.2 - Multiple UOM Price Base
Use this form to add price bases for each unit of measure in which an item is
sold. An item can be sold in up to six different units of measure, each of
which can be defined for both current and future price bases. If an item has
multiple pricing units of measure, you must use this form to enter a price for
each pricing unit of measure.
Updated Files
OEBASE - This is the primary file maintained by this program. It
contains price bases and item price by unit of measure.
OEBPAUDIT - This file is updated by this program when the Billing company
requires price auditing. An audit record will be written when
a price base is added or changed.
Referenced Files
CUCODES - Used to validate the currency code.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
ITEMMAST - Used to validate the Inventory Control item numbers.
OECOMPANY - Used to validate the Billing company.
BL40.3 - Base List Maintenance
Use this form to update all the price bases for a specific item. This form is
especially useful when you need to modify the pricing for an item across all
price bases.
Updated Files
OEBASE - This is the primary file maintained by this program. It
contains the price bases and item price by unit of measure.
OEBPAUDIT - This file is updated by this program when the Billing company
requires price auditing. An audit record will be written when
a price base is added or changed.
Referenced Files
CUCODES - Used to validate the currency code.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
ITEMMAST - Used to validate Inventory Control item numbers.
OECOMPANY - Used to validate the Billing company.
BL41.1 - Worksheet
Use this form to define worksheets. Worksheets let you precalculate and
massage price bases before you actually update them. Price bases are created
from worksheet prices by using an existing item price source: issue cost, last
received cost, or another base's current base.
In the worksheet pricing procedure, you select which items will be affected
by a specific worksheet (for example, which items will be selected for price
base manipulation). You can use selection criteria to choose items from a
certain vendor, items from certain sales classes, or specific item numbers.
Note: A single worksheet can include parameters from only the first form, the
second form, or both. The selection is inclusive and the most restrictive
multiplier will be used. That is, if an item range multiplier applies, it will
be used. If no item range applies, the system uses the sales class range
multiplier. If no sales class multiplier is used, the vendor multiplier will
be used.
See the Billing Procedures Manual for more information on the worksheet
process.
Updated Files
CKPOINT - Not used.
OEWKSHEET - Primary file updated by this program.
Referenced Files
APCOMPANY - Used in the Accounts Payable vendor edit routine.
APCPYVND - Used in the vendor edit routine.
APHLDINV - Used in the vendor edit routine.
APVENCLASS - Used in the vendor edit routine.
APVENGROUP - Used in the vendor edit routine.
APVENMAST - Used in the vendor edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
MAJORCL - Used to validate major sales class.
OEBASE - Used to validate the price base name.
OECOMPANY - Used to validate the Billing company.
OEWKPRICE - Used in delete edit. Worksheets with existing work prices may
not be deleted.
INVOKED Programs
IFCC
BL42.1 - Worksheet Items
Use this form to update worksheet price bases for items. The worksheet
process provides a mechanism to precalculate and massage worksheet price bases
prior to updating the actual price bases file. This form also allows you to
assign a next price base for each item.
Note: Worksheets can be updated by this program whether released for
processing or not. Once BL141 has processed, the worksheet is no longer
maintainable. Use BL340 (Base List Worksheet Purge) to remove unwanted
worksheets.
See the Billing Procedures Manual for more information on the worksheet
process.
Updated Files
OEWKPRICE - Used in delete edit. Worksheets with existing work prices may
not be deleted.
OEWKSHEET - Primary file updated by this program.
Referenced Files
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
ITEMMAST - Used to validate Inventory Control item numbers.
OECOMPANY - Used to validate the Billing company.
BL42.2 - Worksheet Item UOM
Use this form to update price bases for items with multiple pricing units of
measure. The worksheet process provides a mechanism to precalculate and
massage worksheet price bases prior to being updated by BL141 (Base List
Worksheet Update).
This form lets you define separate worksheet price bases, depending on the
quantity of an item ordered. See the Billing Procedures Manual for more
information on the worksheet process.
Updated Files
OEWKPRICE - Primary file maintained by this program.
OEWKSHEET - Release function changes status on the Worksheet file.
Referenced Files
ICCOMPANY - Used to validate the Inventory Control company.
ITEMMAST - Used to validate Inventory Control item numbers.
OECOMPANY - Used to validate the Billing company.
INVOKED Programs
IFCC
BL43.1 - Worksheet Release
Use this form to selectively release worksheets. You can select worksheets
using BL41.1 (Worksheet) and BL42.1 (Worksheet Items). After release,
worksheet data is updated to the permanent basis files when BL141 (Base List
Worksheet Update) is run. After BL141 is run, you can no longer update
released worksheets.
Updated Files
CKPOINT - Not used.
OEWKSHEET - Primary file updated by this program. Release function
changes the status on
the pricing worksheet.
Referenced Files
OECOMPANY - Used to validate the Billing company.
BL44.1 - Discount Code
Use this form to define and update discount codes. Discount codes, which you
can assign to price lists, contracts, and promotions, specify how an item
price is discounted. Each discount code can specify up to three separate
discount percentages. These percentages can apply to an item gross price or to
an item price less any discount percentages already applied.
The discount percentages assigned to a discount code print on the pricing
reports: Discount Code Listing (BL244), Price List Listing (BL245), and
Promotion Listing (BL247).
For posting purposes, each discount percentage can be assigned to a separate
general ledger account number.
See the Billing Procedures Manual for more information on pricing.
Updated Files
CKPOINT - Not used.
OEDISCOUNT - Primary file maintained by this program.
Referenced Files
OECOMPANY - Used to validate the Billing company.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL45.1 - Price List
Use this form to create a price list and update its overall defaults. Enter
the price base to use, a default percentage to apply, and the discount code,
if any. When pricing an item, if no price lists exist at the sales class or
item level, the system multiplies the price base by the default percentage
defined in the Default Percent field to calculate a price. You must assign a
price list to each customer for which orders will be placed.
Updated Files
OEDISCOUNT - Used to validate discount codes. If this is the first time
the discount code
is referenced, the used flag is set.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract. Secondary file maintained by this
program. If a Price List is deleted all price list sales class
records are also deleted.
OEPLITEM - Secondary file maintained by this program. If a Price List is
deleted, all
price list item records are also deleted.
OEPRCLIST - Primary file maintained by this program.
Used to store default pricing parameters for price list,
promotion, and contract.
Referenced Files
OECOMPANY - Used to validate the Billing company.
OEMISC - Used to validate add-on charges.
BL45.2 - Price List Sales Class
Use this form to assign a price list and optionally a discount to items
within a specific sales class. Separate percentages can be applied to quantity
breaks within a sales class. In addition, the amalgamated pricing flag is
updated here. Select amalgamated pricing if the quantity breaks are to be
applied based on the total order quantity of all lines with items in this
sales class.
Updated Files
OEDISCOUNT - Used to validate discount codes. If this is the first time
the discount code
is referenced, the used flag is set.
OEPLCLASS - Primary file maintained by this screen.
Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
Referenced Files
ICCOMPANY - Used to validate the Inventory Control company.
MAJORCL - Used to validate the major sales class.
MINORCL - Used to validate minor sales class.
OECOMPANY - Used to validate the Billing company.
BL45.3 - Price List Item
Use this form to manipulate the price base at the item level in one of three
ways:
1) apply a percentage
2) add or subtract a fixed amount per unit sold
3) override the price with the price entered here
You can also assign these options based on quantity breaks. A discount code
can also be assigned at this level.
Updated Files
OEDISCOUNT - Used to validate discount codes.
OEPLITEM - Primary file maintained by this screen.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
Referenced Files
ICCOMPANY - Used to validate the Inventory Control company.
ITEMMAST - Used to validate Inventory Control item numbers.
OEBASE - Used to validate the price base name.
OECOMPANY - Used to validate the Billing company.
BL46.1 - Contract
Use this form to define contracts and tie them to a customer. Contracts are
date-sensitive agreements established with a customer on a one-to-one basis
that determines pricing arrangements. Think of a contract as a price list
assigned to a specific customer for a specific time period. The same options
that are available on a price list are available for a contract. Using this
form, you can update the default information for a contract, including the
price base, the default percentage, the effective date range, and the default
discount code.
Note: Due to the defaulting hierarchy, you cannot add a new contract that has
an overlapping date range with an existing contract unless both contracts have
a blank default percentage.
See the Billing Procedures Manual for more information on contracts.
Updated Files
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and Update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
CUSTDESC - Used to display the Accounts Receivable customer information.
INSTCTRYCD - Used to validate the Intrastat country code.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate price base name.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEMISC - Used to validate the Billing add-on charge code.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL46.2 - Contract Sales Class
Use this form to define contract pricing that will affect items of a specific
sales class. You can also apply different contract pricing percentages to the
same sales class, depending on the item quantities ordered. Discounts can also
be assigned to a contract price at the sales class level. Set the Amalgamated
Pricing flag to Yes if the quantity the price is based on is the total order
quantity for all items in this sales class.
See the Billing Procedures Manual for information on item pricing.
Updated Files
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and Update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
CUSTDESC - Used to display the Accounts Receivable customer information.
ICCOMPANY - Used to validate the Inventory Control company.
INSTCTRYCD - Used to validate the Intrastat country code.
MAJORCL - Used to validate the major sales class.
MINORCL - Used to validate the minor sales class.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL46.3 - Contract Item
Use this form to assign a contract and optionally a discount on an item by
item basis. You can also define separate contract pricing percentages, based
on item quantities ordered.
See the Billing Procedures Manual for more information on pricing.
Updated Files
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
Referenced Files
ICCOMPANY - Used to validate the Inventory Control company.
ITEMMAST - Used to validate Inventory Control item numbers.
OEBASE - Used to validate the price base name.
OECOMPANY - Used to validate the Billing company.
INVOKED Programs
IFCC
BL47.1 - Promotion
Use this form to update the default parameters for a promotion, including the
price base, the default percentage to apply, and a discount code. Promotion
pricing can override price lists, and the same parameters that are available
for price lists are available for promotions. You assign a promotion to a
price list and specify an effective date range. Due to the default hierarchy,
you cannot add a new promotion that has a date range overlapping that of an
existing promotion.
Updated Files
ARPROCLEVL - Used to validate the Accounts Receivable process level.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
Referenced Files
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
OEBASE - Used to validate the price base name.
OECOMPANY - Used to validate the Billing company.
OEMISC - Used to validate the Billing add-on charge code.
BL47.2 - Promotion Sales Class
Use this form to assign a promotion, and optionally, a discount to items
within a specific sales class. You can define separate promotion pricing
percentages based on item quantities ordered.
See the Billing Procedures Manual for a description of item pricing.
Updated Files
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
Referenced Files
ICCOMPANY - Used to validate the Inventory Control company.
MAJORCL - Used to validate the major sales class.
MINORCL - Used to validate the minor sales class.
OECOMPANY - Used to validate the Billing company.
BL47.3 - Promotion Item
Use this form to assign a promotion and optionally a discount on an item by
item basis. Separate promotion pricing percentages can be defined based on
item quantities ordered.
See the Billing Procedures Manual for a full description of item pricing.
Updated Files
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
Referenced Files
ICCOMPANY - Used to validate the Inventory Control company.
ITEMMAST - Used to validate Inventory Control item numbers.
OEBASE - Used to validate the price base name.
OECOMPANY - Used to validate the Billing company.
BL48.1 - Price Book
Use this form to create a price book. A price book is a list of prices by
price base. Define the parameters controlling this listing by using BL48.1
(Price Book), BL48.2 (Price Book Sales Class), and BL48.3 (Price Book Item).
To create a price book, specify the base price and up to three separate price
lists to retrieve item prices from. The prices from each price list print on
the price book in the column specified, along with any comments that you
enter.
Updated Files
OEPBCLASS - Secondary file maintained by this screen. If a Price Book is
deleted, all
price book sales class records for that price book are also
deleted.
OEPBITEM - Secondary file maintained by this program. If a price book is
deleted, all
price book item records for that price book are also deleted.
OEPRCBOOK - Primary file maintained by this program.
Referenced Files
ICLOCATION - Used to validate the Inventory Control location.
OEBASE - Used to validate the price base name.
OECOMPANY - Used to validate the Billing company.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
BL48.2 - Price Book Sales Class
Use this form to assign comments for a specific sales class. These comments
print at the beginning of the items in this sales class.
Updated Files
OEPBCLASS - Primary file maintained by this program.
Referenced Files
ICCOMPANY - Used to validate the Inventory Control company.
MAJORCL - Used to validate the major sales class.
MINORCL - Used to validate the minor sales class.
OECOMPANY - Used to validate the Billing company.
OEPRCBOOK - Used to validate the price book.
BL48.3 - Price Book Item
Use this form to assign item comments to a price book. These comments print
on the price book report prior to printing the pricing information for that
item.
Updated Files
OEPBITEM - Primary file maintained by this program.
Referenced Files
ICCOMPANY - Used to validate the Inventory Control company.
ITEMMAST - Used to validate Inventory Control item numbers.
OECOMPANY - Used to validate the Billing company.
OEPRCBOOK - Used to validate the price book.
INVOKED Programs
IFCC
BL80.1 - Invoice Inquiry
Use this form to inquire on, print, or start to fax an invoice or credit memo.
You can view an invoice line in more detail by choosing the Invoice Lines
form tab, selecting the desired line, and transferring to BL81.1 (Invoice Line
Inquiry).
Before you can start to fax an invoice or credit memo from this form, ensure
that LAWSON INSIGHT E-Fax Agent and WinFax PRO software are installed and
active. (WinFax PRO is a trademark of Symantec Corporation and its
subsidiaries. Symantec, the Symantec logo, and WinFax are US registered
trademarks of Symantec Corporation and its subsidiaries.)
In addition, before you can start to fax an invoice or credit memo, display
BL80.4 (Billing Fax) to type specific transmission and optional cover
information. To display BL80.4, choose the Fax button on this form (BL80.1
(Invoice Inquiry)).
The invoices and credit memos you inquire on here come from the following
systems or forms:
- the Order Entry system including OE30.1 (Returns) if the Create Credit Memo
flag is set;
- a non-Lawson system or the Activity Management system, imported using BL520
(Billing Interface);
- BL20.1 (Invoice Entry) and related forms;
- BL31.1 (Customer Recurring Invoice) and related forms; and
- BL130 (Create Recurring Invoices).
For details of interfacing the Billing system with other systems, see the
Supply Chain Technical Guide.
After you use BL80.1 to start a fax, the BL80.1 program places the resulting
fax file in the $LAWDIR//interface directory, where the file
remains until the E-Fax Agent sends the file through the WinFax PRO software.
For information on the E-Fax Agent, see the Desktop Installation Guide and
the E-Fax Agent online help.
Updated Files
ARCODE - Used to validate Accounts Receivable codes. If this is the
first time the Accounts Receivable code is referenced, the used
flag is set.
OEINVSGBLK - Stores user analysis values for processing through the
Strategic Ledger system.
SALESREP - Used to validate sales representatives.
TERMS - Used to validate Accounts Receivable terms.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
Referenced Files
AGINGCODE - Used in the customer edit routine.
APACCRCODE - Used in the vendor edit routine.
APCOMPANY - Used in the Accounts Payable vendor edit routine.
APVENGROUP - Used in the vendor edit routine.
APVENMAST - Used in the vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the customer edit routine.
ARLOCKBOX - Used in the customer edit routine.
ARPAYMENT - Used in the customer edit routine.
BILLTO - Used to validate the customer bill to
information.
COLINE - Used to verify customer order line information.
CUCONV - Used for currency editing.
CURELAT - Used to validate currency relationships.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
CUSTORDER - Used to validate customer orders.
GLSYSTEM - Used in the General Ledger company edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
INSTCTRYCD - Validates the Intrastat country code.
INSTREGN - Validates the Intrastat region code.
ITCOMMENT - Used to print item comments.
ITEMGROUP - Used in the Item edit routine.
ITEMLOC - Used to validate the Inventory Control item location.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the Accounts Receivable customer edit routine.
OECUSTITEM - Used to store customer item numbers for Inventory Control item
numbers.
OEFRTCODE - Used to validate freight codes.
OEINVCCOMM - Used to print invoice/invoice line comments.
OEINVCDTL - Used to store lot/serial information for an invoice line for
subsequent printing on the invoice form.
OEINVCLINE - Used to store all information for an invoice line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
OEINVCTAX - Used to store tax amounts calculated when the invoice is
released.
OEINVCTYPE - Used to validate invoice type. If this is the first time the
invoice type is
referenced, the used flag is set.
OEINVCUOM - Used to store invoice line pricing information when the line
has been priced
via multiple units of measure.
OEINVOICE - Stores all information for an invoice.
OEMETHOD - Used to print Order Entry shipping method information.
OEMISC - Used to print add-on charges information.
OEPROCLEV - Used to validate the Billing process level.
OESTDCOMM - Used to obtain comments for standard comment codes.
SHIPTO - Used to validate Ship To number.
STATICCUST - Used in the Accounts Receivable customer edit routine.
TXTAXCODE - Used to validate tax codes.
TXTAXRATE - Used in the tax code edit routine.
TXTAXTABLE - Used in the tax code edit routine.
WHSHIPMENT - Used to store shipment header information.
BL80.2 - Invoices By Invoice Number
Use this form to view a list of company invoices sorted by invoice number.
This form offers several inquiry features. With the Display Sequence option,
you can choose to view these invoices either by lowest invoice number first
or by highest invoice number first. In addition, to view more detail about an
invoice, you can select the line containing the desired invoice number and
then transfer to BL80.1 (Invoice Inquiry).
Updated Files
None.
Referenced Files
OECOMPANY - Used to validate the Billing company.
OEINVOICE - Stores all information for an invoice.
BL80.3 - Invoices By Customer
Use this form to view a list of customer invoices sorted by invoice number.
With the Display Sequence option, you can choose to view these invoices either
by lowest invoice number first or by highest invoice number first. In
addition, to view more detail about an invoice, you can select the line
containing the desired invoice number and then transfer to BL80.1 (Invoice
Inquiry).
Updated Files
None.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used by the Accounts Receivable customer edit routine.
CUSTDESC - Used to display Accounts Receivable customer information.
INSTCTRYCD - Used to validate the Intrastat country code.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEINVOICE - Stores all information for an invoice.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL80.5 - Unreleased Invoices By Batch
Use this form to view a list of unreleased invoices by invoice batch number.
To view more detail on a specific invoice, select the invoice in the Line
Action (SC) field next to the invoice and then transfer to BL80.1 (Invoice
Inquiry).
Updated Files
None.
Referenced Files
OECOMPANY - Used to validate the Billing company.
OEINVHDR -
OEINVOICE - Stores all information for an invoice.
INVOKED Programs
ACAC
IFCR
IFSG
IFCU
IFAC
IFAU
SLSE
SLSU
IFCC
BL81.1 - Invoice Line Inquiry
Use this form to inquire on invoice lines. You can find specificc invoice
line information in the Detail, Base Currency Totals, Tax, and Accounts tabs.
You can view additional information about the entire invoice in BL80.1
(Invoice Inquiry).
Updated Files
CKPOINT - Used for batch recovery.
ICCOMPANY - Used to validate the Inventory Control company.
OEINVSGBLK - Stores user analysis values for processing through the
Strategic Ledger system.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and Update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate an Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
CUSTDESC - Validates the customer description.
INSTCTRYCD - Validates the Intrastat country code.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEINVCLINE - Used to store all information for an invoice line.
OEINVCTAX - Used to store tax amounts calculated when the invoice is
released.
OEINVOICE - Stores all information for an invoice.
STATICCUST - Used in the Accounts Receivable customer edit routine.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL85.1 - Sea Inquiry
Updated Files
ARPROCLEVL - Stores Accounts Receivable process level.
ICCOMPANY - Used to validate the Inventory Control company.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
routines.
ARCUSTGRP - Used to display the Accounts Receivable customer group name
for the company.
ARCUSTOMER - Used to validate the Accounts Receivable customer. Updated
with the customer default ship-to number.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit and update
routines.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used to display Accounts Receivable customer information.
GLSYSTEM - Used in the General Ledger company edit routine.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMLOC - Used to print Inventory Control Location information.
ITEMMAST - Used to validate Inventory Control item numbers.
KITITEM - Used to validate kit items.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL85.2 - Sea Inquiry
This program allows the SEA Customer Service Center to inquire on items a
customer can order by conducting a search either by description or by major
and minor class.
Updated Files
ARPROCLEVL -
ICCOMPANY - Used to validate the Inventory Control company.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
routines.
ARCUSTGRP - Used to display the Accounts Receivable customer group name
for the company.
ARCUSTOMER - Used to validate the Accounts Receivable customer. Updated
with the customer default ship-to number.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit and update
routines.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used to display Accounts Receivable customer information.
GLSYSTEM - Used in the General Ledger company edit routine.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMLOC - Used to print Inventory Control Location information.
ITEMMAST - Used to validate Inventory Control item numbers.
KITITEM - Used to validate kit items.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL85.3 - Sea Inquiry
This program is part of the Order by Catalog section of the SEA Customer
Service Center. This form displays major sales classes for a company and the
minor sales classes associated with them.
Note: Major sales classes are displayed as catalog categories on the web.
Updated Files
ARPROCLEVL -
Referenced Files
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTGRP - Used to display the Accounts Receivable customer group name
for the company.
ICCOMPANY - Used to validate the Inventory Control company.
MAJORCL - Used in inventory update routines if the invoice line is
deleted.
MINORCL - Used in inventory update routines if the invoice line is
deleted.
OECOMPANY - Used to validate the Billing company.
INVOKED Programs
IFCC
IFCR
IFSG
BL90.1 - Pricing Inquiry
Use this form to view default pricing information for an item and quantity.
You can enter an item and a quantity and see how the item would be priced (and
discounted) using normal default pricing logic. You can override the default
pricing parameters (base price, price list, promotion, and contract) on this
form to display "what if" pricing.
Updated Files
ARPROCLEVL - Used to validate the Accounts Receivable process level. If
this is the first
time the process level is referenced, the used flag is set.
CKPOINT - Not used.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable customer edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
COMPONENT - Used to validate the kit item cost.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
GLSYSTEM - Used in the General Ledger account edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Stores the Intrastat country code.
ITEMLOC - Used to validate the Inventory Control item location.
ITEMMAST - Used to validate Inventory Control item numbers.
KITITEM - Used to validate kit items.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
SHIPTO - Used to validate ship-to numbers.
STATICCUST - Used in the Accounts Receivable customer edit routine.
INVOKED Programs
IFCC
IFCR
IFSG
BL91.1 - Invoices On Hold
Use this form to display released and unreleased invoices on hold and delete
hold codes from invoices. (Released invoices can also have hold codes removed
with BL92.1 (Released Invoice).)
Updated Files
CKPOINT - Not used.
HOLDCODES - Used to validate hold codes. If this is the first time the
hold code is
referenced, the used flag is set.
OEINVOICE - Primary file maintained by this program. Invoices are put on
or taken off
hold by this program.
TERMS - Used to validate terms code. If this is the first time the
terms code is
referenced, the used flag is set.
Referenced Files
ARCOMP - Used to validate the Accounts Receivable company.
CUCONV - Used in currency conversion routine.
CURELAT - Used in currency conversion routine.
CUSTORDER - Used to validate the customer order.
GLSYSTEM - Used in GL Account edit routine.
OECOMPANY - Used to validate the Billing company.
OEPROCLEV - Used to validate the Billing process level.
BL92.1 - Released Invoice
Use this form to display released invoices that are or are not on hold. This
form functions as a type of Drill Around from BL91.1 (Invoices On Hold).
This form can also be used to delete shipment-related invoices. You can
delete invoices created manually using BL20.1 (Invoice Entry) or BL29.1
(Unreleased Batches). When an invoice is created with OE129 (Daily Shipment
Journal), it is created in unreleased or released status. You can change
invoices except for shipment-specific items. When the changes are complete,
OE129 (Daily Shipment Journal) should be run again to produce a new invoice.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ARCODE - Used to validate Accounts Receivable codes. If this is the
first time the
Accounts Receivable code is referenced, the used flag is set.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CBBANKINST - Used to validate the payment code.
CKPOINT - Not used.
COCOMP - Used to store components for a shipment line if the item
shipped is a kit.
COLINE - Used to provide customer order line information.
COLINEDTL - Used to provide customer order line detail information.
COLINEUOM - Used to provide customer order line pricing information when
the line
is priced using multiple units of measure.
COMISC - Used to print customer order add-on charge information.
COSGBLK - Used to validate the segment block.
CUSTDESC - Used to display Accounts Receivable customer information.
CUSTORDER - Used to validate the customer order.
CXCASEHEAD - Used to default case header record data.
CXCASEPREF - Used to print pick tickets by preference.
CXCOMPANY - Updates the last used PO Interface Reference Number for the
company.
CXCPIUAVAL - Stores the user analysis values for a patient case.
CXITEMHIST - Not in use.
CXPREFDIAG - Used to validate case preference diagnostic codes.
CXPREFITEM - Used to update the print status on an item.
CXPREFJOBS - Used to validate case preference burden codes.
HCPATCHRG - The Patient Charge file, used in editing.
HCPATVISIT - Used in editing.
HOLDCODES - Used to validate hold codes. If this is the first time the
hold code is
referenced, the used flag is set.
ICACTIVITY - Used in the Inventory Control edit routines.
ICCOMPANY - Used to validate the Inventory Control company.
ICHISTORY - Used in inventory update routines if the invoice line is
deleted.
ICLOT - Used in inventory update routines if the invoice line is
deleted.
ICRECEIPTS - Used in inventory update routines if the invoice line is
deleted.
ICTRANS - Used in inventory update routines if the invoice line is
deleted.
ICTRANSDTL - Used in inventory update routines if the invoice line is
deleted.
INSTDETAIL - Maintains Intrastat detail records.
INSTHEADER - Maintains Intrastat header records.
INSTNBR - Generates the next Intrastat number availble when the
Intrastat transaction is added.
ITEMLOC - Used to validate the Inventory Control item location.
ITSERIAL - Used in inventory update routines if the invoice line is
deleted.
MMDIST - Contains general ledger account postings for inventory
transaction.
MMUAVAL - Updates user analysis information.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEAUDIT - Used to store order audit records.
OECOMPANY - Used to validate the Billing company.
OECREDCARD - Used to validate credit card types.
OECUSTCODE - Used to validate customer codes. If this is the first time
the customer
code is used, the used flag is set on.
OEFRTCODE - Used to validate freight codes.
OEINVCCOMM - Used to store comments associated with an invoice or its line
items.
OEINVCDTL - Used to store lot/serial information for an invoice line for
subsequent
printing on the invoice form.
OEINVCLINE - Used to store all information for an invoice line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
OEINVCTAX - Used to store tax amounts calculated when the invoice is
released.
OEINVCTYPE - Used to validate invoice types. If this is the first time the
invoice type
is referenced, the used flag is set.
OEINVCUOM - Used to store invoice line pricing information when the line
has been priced
via multiple units of measure.
OEINVHDR - Invoice Batch Header file. Created when an invoice is added,
if it does not
already exist. Batch totals are updated as invoices are added
for the batch.
OEINVOICE - Stores all information for an invoice.
OEINVSGBLK - Stores user analysis values for processing through the
Strategic Ledger system.
OEMETHOD - Used to validate the shipping method.
OEMISC - Used to validate the Billing add-on charge code.
OEORDCMNT - Used to store order comments related to customer order(s) or
customer order
line(s).
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate reason codes. If this is the first time the
reason code is
referenced, the used flag is set.
OESOURCE - Used to validate order source codes.
ORDERTYPE - Used to validate order types.
POAOCDTL - This file contains all add-on costs in relation to a purchase
order.
POAUDIT - Used to store audit records for changes made to purchase
orders and their
lines.
POCOMMENTS - Used to store purchase order header and line comments.
POCOMOUT -
POHDROUT -
POINTAOC - Used to pass add-on charges from customer order to purchase
order when the
customer order is a dropship order.
POINTCMTS - Used to pass comments from customer order to purchase order
when the
customer order is a dropship order.
POINTERFAC - Used to pass line items from customer order to purchase order
when the
customer order is a dropship order.
POLINE - Used to store purchase order line items for dropship orders.
POLINEOUT -
PORETURNHD - Used in the purchase order revision routines.
POVENDOR - Used to store vendor purchasing parameters used as defaults
and controls
when adding a purchase order.
PURCHORDER - Used to validate the purchase order number. Only used for
dropshipments.
REQHEADER - Used to verify requisition information.
REQLINE - Used to verify requisition line information.
ROUTEDOC - Used to obtain route information for the demand line.
ROUTEHDR - Used to validate customer delivery route.
ROUTESTOP - Used to store route stop total.
SALESREP - Used to validate sales representatives. If this is the first
time the sales
representative is referenced, the used flag is set.
SHIPTO - Used to validate ship-to numbers.
SOHDETAIL - Used to store lot, bin, and/or multiple unit of measure
quantities for those
items that use them.
STPOLINE - Used to validate standard purchase order line items.
STPURCHORD - Used to validate standard purchase order numbers.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code
is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes
general ledger accounts if they are defined at the company
level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
WHDEMAND - Used to store customer order and requisitions quantities
ordered by item and
location and expected ship date. Contains quantities to be
allocated or
backordered.
WHDEMNDCMT - Contains comments for the demand records. Created from order
comments
and requisition comments.
WHDEMNDDTL - Contains detail information about bins, lots, serials and
multiple units of
measure for the demand lines.
WHDEMNDHDR - Contains header information for the demand line.
WHSCMNTOUT -
WHSCOMPOUT -
WHSHIPCOMP - Used to store the make-to-order kit components to be shipped
for this
shipment line.
WHSHIPLINE - Used to store shipment line information including feedback
quantity.
WHSHIPMENT - Used to store shipment header information.
WHSHLAUD - Used to audit feedback changes to the shipment line. This is
only used when
"full" feedback is not performed for a shipment line.
WHSHLDTL - Used to store shipment line detail quantities for bin, lot,
serial and
multiple unit of measure detail tracked items.
WHSHPMTOUT -
WHSLINEOUT -
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity code.
ACCAL - Used in the Activity Management edit routines.
ACCALX - Used in the Activity Management edit routines.
AGINGCODE - Used in the Accounts Receivable customer edit routine.
AMASSET - Used to edit Materials Management distribution edit routine to
edit
asset codes.
AMTEMPLATE - Used in the Asset Management asset edit routine.
APACCRCODE - Used in the vendor edit routine.
APCOMPANY - Used in the Accounts Payable vendor edit routine.
APCPYVND - Used in the vendor edit routine.
APDISTCODE - Used in the Accounts Payable vendor edit routine.
APHLDINV - Used in the vendor edit routine.
APPROCLEV - Used in the Accounts Payable vendor edit routine.
APVENCLASS - Used in the Accounts Payable vendor edit routine.
APVENGROUP - Used in the Accounts Payable vendor edit routine.
APVENLOC - Used in the Accounts Payable vendor edit routine.
APVENMAST - Used in the Accounts Payable vendor edit routine.
ARCOMMENT - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and Update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
AROIHDR - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BILLOFLAD - Used to provide Bill of Lading information.
BILLTO - Used to validate the customer bill-to entered on the order.
BUYCLASS - Used to validate buyer class. Only used if order was a
dropship.
BUYER - Used to validate buyers. Only used if order was a dropship.
COMPONENT - Used to store Inventory Control kit components.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CXBURDEN - Used to validate template burdens.
CXCTIUAVAL -
CXDIAGNOST - Used to validate template diagnoses codes.
CXPRACPROC - Used to validate the case procedure for the practitioner
entered.
CXPRACTNR - Used to validate the case practitioner.
CXPREFTEMP - Used to create case preference records.
CXPTMPDIAG - Maintains diagnoses for the template.
CXPTMPITEM - Used to maintain items for template.
CXTMPJOBS - Used to validate the case jobs record.
FOBCODE - Used to validate FOB codes. Only used for dropship orders.
GLADDRESS - Used in the General Ledger company edit routine.
GLCHART - Used in the General Ledger account verification routine.
GLCODES - Used in the General Ledger account verification routine.
GLINTCO - Used in the General Ledger account verification routine.
GLSYSTEM - Used in the General Ledger account verification routine.
HCCHRGITEM - Used in editing.
HCPATIENT - Used to validate patient ID and display default information.
ICBIN - Used in inventory update routines if the invoice line is
deleted.
ICCATEGORY - Used in inventory update routines if the invoice line is
deleted.
ICCOUT -
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
INSTREGN - Validates the Intrastat region code.
ITEMADDON - Used to trigger automatic creation of add-on charges for
specific items when
sold in specified states (or all states). The add-on charge
is created at
the invoice line level.
ITEMMAST - Used to validate Inventory Control item numbers.
ITEMSUB - Used to identify substitutes for inventory tracked items.
KITITEM - Used in inventory update routines if the invoice line is
deleted.
MAJORCL - Used in inventory update routines if the invoice line is
deleted.
MINORCL - Used in inventory update routines if the invoice line is
deleted.
MSDSACK - Used in shipment line update routines if the invoice line is
deleted.
NATACCT - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECUST - Used in the Accounts Receivable customer edit routine.
OECUSTITEM - Used to store customer item numbers for Inventory Control item
numbers.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the
pricing routine.
OEORDDISC - Used to validate order discount codes.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and
contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and
contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and
contract.
OEROUTE - Used in shipment processing routine.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
nonstock line types.
OPERATOR -
POAOCMAST - Used to validate purchase order add-on costs.
POAOCSPRD - Used in the purchase order revision routines.
POAPPROVE - Used to store invoice approvals against purchase orders.
POCOMPANY - Used to validate the purchase order company.
POFRTTERM - Used to validate purchase order freight terms.
POINVOICE - This file contains header information for a purchase order
invoice.
POITEMVEN - Used to store pricing and packing information for items
purchased from
a specific vendor.
POLOCCON - Used in the purchase order revision routines.
POQUOTES - Used to obtain vendor quote prices when pricing an purchase
order line item.
PORECLINE - Used to store receipts against purchase order lines.
POVENDLOC - Used to store vendor purchase from location information.
REASON - Used to validate a reason code and display the description.
RQLOC - Used to validate the requisition location.
SHIPTOCMNT - Stores order comments for ship-to codes. These comments are
copied to any
orders or invoices for this ship-to.
STATICCUST - Used in the Accounts Receivable customer edit routine.
STCOMMCODE - Used to validate standard comment codes for purchase orders.
SYSTEMCODE - Used by the General Ledger system edit routine.
TXTAXRATE - Used when calculating sales tax for an invoice line.
WFSETUP -
WHDEMNDDTL - Contains detail information about bins, lots, serials and
multiple units of
measure for the demand lines.
WHPROCTYPE - Used to validate the process type.
INVOKED Programs
ACAC
IFCR
IFSG
IFCU
CXCP
IFAC
IFAU
SLSE
SLSU
IFCC
IFOB
IFRS
SLSS
BLSU.1 - System Setup
Use the System Setup form as a convenient guide when performing the
procedures that activate the Billing system. Form tabs group the procedures
into logical sequences. Choose buttons to access specific setup forms. All of
the required and optional procedures are included.
For more information, see the Billing Procedures manual.
Updated Files
CKPOINT -
Referenced Files
None.
BL120 - Invoice Batch Release
Run this program to print unreleased invoice batches and optionally release
the batch when it runs. You can preview invoices by selecting the report-only
mode. This will allow you to see sales tax and downpayment information before
the batch is released.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ARCODE - Used to validate Accounts Receivable codes. If this is the
first time the Accounts Receivable code is
referenced, the used flag is set.
ARPROCLEVL - Used to validate the Accounts Receivable process level. If
this is the first
time the Accounts Receivable process level is referenced, the
used flag is set.
CBBANKINST - Used to validate payment codes.
CKPOINT - Used to control program restart logic.
HOLDCODES - Used to validate hold codes. If this is the first time the
hold code is
referenced, the used flag is set.
OECOMPANY - Used to validate the Billing company.
OECUSTCODE - Used to validate customer codes. If this is the first time
the customer code is
used, the used flag is set on.
OEINVCCOMM - Used to store comments associated with an invoice or its line
items.
OEINVCDTL - Used to print lot/serial information for invoice lines.
OEINVCLINE - Used in the invoice process routine.
OEINVCMISC - Used in the invoice process routine.
OEINVCTAX - If invoices are being released, sales taxes are calculated and
stored in
this file.
OEINVCTYPE - Used to validate invoice types. If this is the first time the
invoice type
is referenced, the used flag is set.
OEINVCUOM - Used in the Invoice process routine.
OEINVHDR - Used to validate invoice batches. If the release invoice
option is chosen,
the Invoice Batch record is deleted after its invoices are
released.
OEINVOICE - Used in the Invoice process routine.
OEINVSGBLK - Stores user analysis values for processing through the
Strategic Ledger system.
OEMISC - Used to validate add-on charges. If this is the first time
the add-on charge is referenced, the used flag is set.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate reason codes. If this is the first time the
reason code is
referenced, the used flag is set.
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in sales tax calculation.
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCAL - Used in the Activity Management edit routines.
ACCALX - Used in the Activity Management edit routines.
AGINGCODE - Used in the Accounts Receivable customer edit routine.
APACCRCODE - Used in the vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable customer edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
AROIHDR - Used in the customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
COLINE - Used to print customer order line information.
COLINEUOM - Used to provide customer order line pricing information when
the line is priced
using multiple units of measure.
multiple units of measure.
COMISC - Used to print customer order add-on charge information.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in the currency conversion routine.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
CUSTORDER - Used to print customer order information.
GLCODES - Used in the General Ledger account verification routine.
GLSYSTEM - Used in the General Ledger edit routine.
ICCATEGORY - Used to validate inventory control general ledger categories.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
INSTREGN - Validates the Intrastat region code.
ITEMADDON - Used to trigger automatic creation of add-on charges for
specific items when
sold in specified states (or all states). The add-on charge
is created at
the invoice line level.
ITEMLOC - Used to validate the Inventory Control item location.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEFRTCODE - Used to validate freight codes.
OEORDCMNT - Used to print customer order comments.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OESLSACCT - Used to validate sales class accounts.
OPERATOR -
ORDERTYPE - Used to validate order types.
SHIPTO - Used to validate ship-to codes.
STATICCUST - Used in the Accounts Receivable customer edit routine.
SYSTEMCODE - Used by the General Ledger system edit routine.
TXTAXRATE - Used when calculating sales tax for an invoice line.
WHSHIPLINE - Used to store shipline information including feedback
quantity.
WHSHIPMENT - Used to store shipment header information.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
IFOB
IFRS
SLSS
BL121 - Invoice Print Edit Report
Use this form to preview invoices before printing. Viewing invoices before
printing is a required step in invoice processing if the Run Invoice Edit
option was selected at the company or process level.
This form is the last chance to preview invoices before printing. After an
invoice is printed, it cannot be changed.
Updated Files
CKPOINT - Used to control program restart logic.
OEINVOICE - Used to print invoice information. Status is set to ready to
print invoice
after printing in this report.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
APACCRCODE - Used in the vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable customer edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMLOC - Used to validate the Inventory Control item location.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to determine whether this program can be run. Option is
either on the
Billing company or Billing process level.
OECUST - Used in the Accounts Receivable customer edit routine.
OEINVCCOMM - Used to print invoice/invoice line comments.
OEINVCDTL - Used to print lot/serial information for invoice lines.
OEINVCLINE - Used to print invoice line information.
OEINVCMISC - Used to print invoice add-on charge information.
OEINVCTAX - Used to print invoice sales tax information.
OEINVCUOM - Used to print invoice line pricing information when the line
has been priced
via multiple units of measure.
OEMISC - Used to validate add-on charges.
OEPROCLEV - Used to determine whether this program can be run. Option is
stored on either
the Billing company or Billing process level record.
SHIPTO - Used to validate ship-to codes.
STATICCUST - Used in the Accounts Receivable customer edit routine.
TXTAXCODE - Used to validate tax codes.
TXTAXRATE - Used when calculating sales tax for an invoice line.
TXTAXTABLE - Used in the sales tax calculation routine.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL122 - Invoice and Register Print
Run this program to print invoices and the invoice register or to reprint EDI
invoices for re-sending. This program is run at the company or process level,
depending on the invoicing option selected when you defined the company.
Running this program is a required step in the invoicing process. You cannot
run this program if BL121 (Invoice Print Edit Report), OE129 (Daily Shipment
Journal), or BL123 (Sub-System Update) are running at the same time. When run,
this program reflects a zero balance due when a client has a negative balance.
Invoices printed with this program print in either service or standard
format, depending on what you have selected in BL06.1 (Invoice Types). The
service format prints invoices on plain paper in letter style, with room for
comments at the top and bottom. The standard format prints invoices in the
standard style, with columns and headings.
Note: Once an invoice is printed it cannot be changed or deleted. The only
way to correct printed invoices is by creating credit or debit memos.
Warning: If you enter an invoice prefix in the Invoice Prefix field within
the Reprint Invoice Range parameter section, fill in the From Invoice Number
and To Invoice Number fields also. If an invoice number range is not
specified, the system will automatically default a value of "0" in the From
Invoice Number field and the highest invoice number with the specified invoice
prefix in the To Invoice Number field. This will result in the printing of
every invoice with the specified invoice prefix.
Updated Files
ARPROCLEVL - Used to validate the Accounts Receivable process level. If
this is the first
time the process level is referenced, the used flag is set.
CKPOINT - Used to control program restart logic.
OECOMPANY - Used to validate the Billing company. Used in Invoice
processing routine.
OEINVOICE - Primary file updated by this program. Status is set to
invoice printed.
OEPROCLEV - Used to validate Billing process level. Used in invoice
processing routine.
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERMS - Used to validate terms code. If this is the first time the
terms code is
referenced, the used flag is set.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
TXTAXTRAN - Contains all tax transaction records that have been created
for the Tax system by the Accounts Payable and/or Accounts
Receivable systems.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
APACCRCODE - Used in the vendor edit routine.
APCOMPANY - Used in the vendor edit routine.
APCPYVND - Used in the vendor edit routine.
APHLDINV - Used in the vendor edit routine.
APVENCLASS - Used in the vendor edit routine.
APVENGROUP - Used in the vendor edit routine.
APVENMAST - Used to validate the Accounts Payable vendor.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable customer edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
COLINE - Used to print customer order line information.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
CUSTORDER - Used to print customer order information.
FROPTIONS -
GLADDRESS - Used in the General Ledger company edit routine.
GLCHART - Used in the General Ledger account verification routine.
GLSYSTEM - Used in the General Ledger company edit routine.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
INSTREGN - Validates the Intrastat region code.
ITCOMMENT - Used to print item comments.
ITEMGROUP - Used in the Item edit routine.
ITEMLOC - Used to validate the Inventory Control item location.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the Accounts Receivable customer edit routine.
OECUSTITEM - Used to print customer item information.
OEFRTCODE - Used to validate freight codes.
OEINVCCOMM - Used to print invoice/invoice line comments.
OEINVCDTL - Used to print lot/serial information for invoice lines.
OEINVCLINE - Used to print invoice line information.
OEINVCMISC - Used to print invoice add-on charge information.
OEINVCTAX - Used to print sales tax information.
OEINVCTYPE - Used to validate invoice types.
OEINVCUOM - Used to print item pricing information when the invoice line
was priced via
multiple units of measure.
OEMETHOD - Used to validate the shipping method.
OEMISC - Used to validate add-on charges.
OESTDCOMM - Used to print standard comments.
SHIPTO - Used to validate ship-to codes.
STATICCUST - Used in the Accounts Receivable customer edit routine.
TXTAXRATE - Used in the tax code edit routine.
WHSHIPMENT - Used to store shipment header information.
INVOKED Programs
ACAC
IFCR
IFSG
IFCU
IFAC
IFAU
SLSE
SLSU
IFCC
BL123 - Sub-System Update
This program updates the status of invoices and credit memos that have been
printed. The following updates take place. Invoices are interfaced into the
Accounts Receivable system. You run AR560 (Transaction Interface) to update
the Accounts Receivable database. Secondly, journal entries are created (in
detail):
Sales
Discounts
Freight
Inventory (for returns)
Miscellaneous charges
Sales tax
Cost of Goods Sold
Accounts receivable
The Order Entry Distribution file is updated and used by BL293 (GL
Distribution Report) to list journal entries created by the system.
Updated Files
ARCODE - Used to validate Accounts Receivable codes. If this is the
first time the Accounts Receivable code is
referenced, the used flag is set.
ARIDISTRIB -
ARIITEM - Used in the customer edit routine.
ARITRANS - Primary updated by this program. Accounts Receivable invoices
are stored in
this file.
ARPROCLEVL - Used to validate the Accounts Receivable process level. If
this is the first
time the process level is referenced, the used flag is set.
CKPOINT - Used to control program restart logic.
JBOOKHDR -
OECOMPANY - Used to validate the Billing company.
OEDIST - Primary file updated by this program. Billing distribution
records are
created.
OEINVOICE - Invoice status is updated to Ready To Purge after processing
by this program.
OEINVSGBLK - Stores user analysis values for processing through the
Strategic Ledger system.
OEPROCLEV - Used to validate the Billing process level.
SYSTEMCODE - Used by the General Ledger system edit routine.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes. Also provides General Ledger
account for sales
tax postings.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
APACCRCODE - Used in the vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable customer edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
AROITEMS - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
COCOMP - Used to store components for a shipment line if the item
shipped is a kit.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
CUSTORDER - Used to print customer order information.
GLADDRESS - Used in General Ledger account edit routine.
GLCHART - Used in the General Ledger account verification routine.
GLSYSTEM - Used in the General Ledger account edit routine.
ICCATEGORY - Used to obtain inventory account for stock lines.
ICCOMPANY - Used to validate the Inventory Control company.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMLOC - Used to validate the Inventory Control item location.
ITEMMAST - Used to validate Inventory Control item numbers.
JBKOPCODE -
JBKSYSCODE -
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the Accounts Receivable customer edit routine.
OECUSTITEM - Used to store customer item numbers for Inventory Control item
numbers.
OEFRTCODE - Used to validate freight codes.
OEINVCLINE - Used to print invoice line information.
OEINVCMISC - Used to print invoice add-on charge information.
OEINVCTAX - Used to print invoice sales tax information.
OEINVCTYPE - Used to validate invoice types.
OEMISC - Used to validate add-on charges.
OEORDDISC - Used to validate order discount codes.
OESLSACCT - Used to obtain sales and cost of goods sold accounts for stock
and non-stock
invoice lines, and cost of goods offset account for non-stock
lines.
STATICCUST - Used in the Accounts Receivable customer edit routine.
TXTAXRATE - Used in the tax code edit routine.
TXTAXTABLE - Used in the tax code edit routine.
WHSHIPCOMP - Used to store the make-to-order kit components to be shipped
for this ship line.
WHSHIPLINE - Used to store shipline information including feedback
quantity.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
IFFC
IFGT
IFCC
IFOB
IFRS
IFSC
SLSB
SLTV
SLFD
BL130 - Create Recurring Invoices
Use this program to create recurring invoices in unreleased status. This
program uses invoice dates according to the settings in BL30.1 (Recurring
Invoice).
After running this program, you must release the invoice batch (use BL29.1
(Batch Control) to find and release the batches) and continue normal invoice
processing: run BL121 to edit the invoice (if required), BL122 to print the
invoice and register, and BL123 to update the invoice to an interface file in
the Accounts Receivable and General Ledger systems.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ARCODE - Used to validate Accounts Receivable codes. If this is the
first time the Accounts Receivable code is
referenced, the used flag is set.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
BLRICCOMM - Stores comments attached to either a customer recurring
invoice header or a
recurring invoice line comments.
BLRICLINE - Stores information and control parameters to control creation
of invoices
for an item.
BLRICMISC - Stores information and control parameters to control creation
of invoices
for an add-on charge.
BLRICSGBLK - Stores header information for customer recurring invoices.
BLRICUST - Used to validate customer recurring invoice numbers.
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Stores information and control parameters to control creation
of customer
recurring invoice line items and the subsequent invoices
created from those
customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those
customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
CBBANKINST - Used to validate payment codes.
CKPOINT - Used to control program restart logic.
HOLDCODES - Used to validate hold codes. If this is the first time the
hold code is
referenced, the used flag is set.
OECOMPANY - Used to validate the Billing company.
OECUSTCODE - Used to validate customer codes. If this is the first time
the customer code is
used, the used flag is set on.
OEINVCCOMM - Used to print invoice/invoice line comments.
OEINVCDTL - Used to store lot/serial information for an invoice line for
subsequent printing
on the invoice form.
OEINVCLINE - Used to store all information for an invoice line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
OEINVCTAX - Used to store tax amounts calculated when the invoice is
released.
OEINVCTYPE - Used to validate invoice type. If this is the first time the
invoice type is
referenced, the used flag is set.
OEINVCUOM - Used to store invoice line pricing information when the line
has been priced
via multiple units of measure.
OEINVHDR - Invoice Batch Header file. Created when an invoice is added,
if it does not
already exist. Batch totals are updated as invoices are added
for the batch.
OEINVOICE - Stores all information for an invoice.
OEINVSGBLK - Stores user analysis values for processing through the
Strategic Ledger system.
OEMISC - Used to validate the Billing add-on charge code.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate reason codes. If this is the first time the
reason code is
referenced, the used flag is set.
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCAL - Used in the Activity Management edit routines.
ACCALX - Used in the Activity Management edit routines.
AGINGCODE - Used in the Accounts Receivable customer edit routine.
APACCRCODE - Used in the vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and Update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit and Update
routines.
AROIHDR - Used in the customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit and Update
routines.
BILLOPER - Used to validate operator authority to enter item or add-on
charge.
BILLTO - Used to validate the customer bill to entered on the
order.
COLINE - Used to print customer order Line information.
COLINEUOM - Used to provide customer order line pricing information when
the line is priced
using multiple units of measure.
COMISC - Used to print customer order add-on charge information.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used to display the Accounts Receivable customer information.
CUSTORDER - Used to print customer order information.
GLCODES - Used in the General Ledger account verification routine.
GLSYSTEM - Used in the General Ledger account verification routine.
ICCATEGORY - Used to validate inventory control general ledger categories.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
INSTREGN - Validates the Intrastat region code.
ITEMADDON - Used to trigger automatic creation of add-on charges for
specific items when
sold in specified states (or all states). The add-on charge
is created at
the invoice line level.
ITEMLOC - Used to validate the Inventory Control item location.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to validate the price base name.
OECOMMHDR - Used to validate standard comment codes.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEFRTCODE - Used to validate freight codes.
OEORDCMNT - Used to print customer order comments.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
OESTDCOMM - Used to print standard comment code comments.
OPERATOR -
ORDERTYPE - Used to validate order types.
SHIPTO - Used to validate the ship-to number.
STATICCUST - Used in the Accounts Receivable customer edit routine.
SYSTEMCODE - Used by the General Ledger system edit routine.
TXTAXRATE - Used in the tax code edit routine.
WHSHIPLINE - Used to store shipline information including feedback
quantity.
WHSHIPMENT - Used to store shipment header information.
INVOKED Programs
ACAC
IFCR
IFSG
IFCU
IFAC
IFAU
SLSE
SLSU
IFCC
IFOB
IFRS
SLSS
BL140 - Base List Worksheet Creation
Run this program to create worksheet prices that can be updated by BL41.1
(Worksheet) or downloaded to a personal computer for updating.
An existing item price source, it's issue cost, last cost, or other price
base can be modified to become a new price base. See the Billing Procedures
Manual for more information on the worksheet process.
Run this report to print the worksheet price base and use the worksheet
effective date as the next effective date for this new base. The program
prints error messages stating why an item cannot be priced, if appropriate. If
you select the spreadsheet format, the program flags this worksheet for
personal computer updating and you cannot maintain it using BL42.1 (Worksheet
Items).
Also, you cannot delete unwanted worksheets processed by this program. You
can purge these worksheets by running BL340 (Base List Worksheet Purge).
Reprint worksheets by running BL240 (Worksheet Reprint).
Updated Files
CKPOINT - Used to control program restart logic.
OEWKPRICE - Temporary file created that carries the item's price.
OEWKSHEET - Worksheet parameters used to create work price files. Status
is updated.
Referenced Files
APCOMPANY - Used in the vendor Master edit.
APCPYVND - Used in the vendor Master edit.
APHLDINV - Used in the vendor Master edit.
APVENCLASS - Used in the vendor Master edit.
APVENGROUP - Used in the vendor Master edit.
APVENMAST - Used to validate vendor selection.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
GLSYSTEM - Used in the General Ledger company edit routine.
ICCOMPANY - Used to edit item locations.
ICLOCATION - Used to edit item locations.
ITEMLOC - Optional source for item work prices.
ITEMMAST - Used to edit item numbers.
OEBASE - Optional source for item work prices.
OECOMPANY - Used to validate the Billing company.
INVOKED Programs
IFCC
IFCR
IFSG
BL141 - Base List Worksheet Update
This program takes released worksheet price bases and updates these work
bases into an existing base or creates a new base. The worksheet price base
effective date must be greater than the system date and the worksheet price
must not be zero to allow updating the base.
The worksheet(s) processed by this program continue to remain on file and can
be reprinted. Unwanted worksheets can be purged by running BL340 (Base List
Worksheet Purge).
Updated Files
CKPOINT - Used to control program restart logic.
OEBASE - Item price base records are created and updated by this
program.
OEBPAUDIT - Audits of changes to base records are stored in this file.
OEWKSHEET - Worksheet parameters direct the update of the base records.
Status is updated.
Referenced Files
APCOMPANY - Used in the vendor Master edit routine.
APCPYVND - Used in the vendor Master edit routine.
APHLDINV - Used in the vendor Master edit routine.
APVENCLASS - Used in the vendor Master edit routine.
APVENGROUP - Used in the vendor Master edit routine.
APVENMAST - Used to validate vendor selection.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate inventory locations.
ITEMMAST - Used to validate item numbers.
OECOMPANY - Used to validate the Billing company.
OEWKPRICE - Stores worksheet prices by item. Source for new prices being
updated into
the item price base.
INVOKED Programs
IFCC
BL199 - Subledger Close
Run this program at the end of a period to close the period in the Billing
and Order Entry systems. This program must be run before closing the period in
the General Ledger system.
When run, this program checks for unposted records, such as unposted invoices
or returns. If any exist, the system creates a report telling you there are
items that require posting. This program also allows you to purge
distributions that were created when entering the cutoff general ledger date.
If entered, the program purges distributions with dates prior to the cutoff
general ledger date.
Updated Files
CKPOINT - Used to control program restart logic.
GLCODES - Used in the General Ledger account edit routine.
OEDIST - Optionally, this program purges records from the Billing
Distribution file.
Referenced Files
GLADDRESS - Used in the General Ledger account edit routine.
GLCHART - Used in the General Ledger account verification routine.
GLSYSTEM - Used in the General Ledger account edit routine.
OECOMPANY - Used to validate the Billing company.
OEINVOICE - Used to ensure that no invoices exist that need to be posted
for the period
being closed.
OIINVOICE - Used to update and validate invoice header information.
RETURNHDR - Used to ensure that no return lines exist that need to be
posted for the
period being closed.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL200 - Company Listing
Use this program to list company settings and options that you selected when
defining your company.
Updated Files
CKPOINT -
Referenced Files
ICCOMPANY - Used to print Inventory Control company information.
ITEMGROUP - Used to print Inventory Control comment type information.
OECOMPANY - Used to print Billing company information.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL201 - Process Level Listing
Run this program to list all process levels for your company. Process levels
are defined using BL01.1 (Process Level).
Updated Files
CKPOINT - Used for batch recovery.
HOLDCODES - Used to print Accounts Receivable hold code information.
Referenced Files
ARCOMP - Used to validate the Accounts Receivable company.
ICLOCATION - Used to validate the Inventory Control location.
OECOMPANY - Used to print Billing company information.
OEPROCLEV - Used to print process level information.
OEREASON - Used to validate reason codes. If this is the first time the
reason code is
referenced, the used flag is set.
ORDERTYPE - Used to print order type information.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL202 - Ship-To Listing
Run this program to list all ship-to numbers, addresses, and ordering options
for one or all customers within your company. Define customer ship-to
locations using BL02.1 (Ship To).
Updated Files
CKPOINT - Used for batch recovery.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
APCOMPANY - Used to validate the Accounts Payable company when a carrier
is entered.
APCPYVND - Used in the Accounts Payable vendor edit routine.
APHLDINV - Used in the Accounts Payable vendor edit routine.
APVENCLASS - Used in the Accounts Payable vendor edit routine.
APVENGROUP - Used in the Accounts Payable company edit and Accounts Payable
vendor edit routines.
APVENMAST - Used to print carrier (Accounts Payable vendor) information.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to print the Accounts Receivable customer information.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
CUCONV - Used to validate currency conversion.
CURELAT - Used to validate currency relationships.
CUSTDESC - Used to print the Accounts Receivable customer information.
GLSYSTEM - Used in the GL account verification routine.
ICLOCATION - Used to print Inventory Control location information.
INSTCTRYCD - Stores the Intrastat country code.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to print Billing company information.
OECUST - Used in the Accounts Receivable customer edit routine.
OEFRTCODE - Used to print freight code information.
OEMETHOD - Used to print Order Entry shipping method information.
SHIPTO - Used to print customer ship-to information.
SHIPTOCMNT - Stores order comments for ship-to codes. These comments are
copied to any orders or
invoices for this ship-to.
STATICCUST - Used in the Accounts Receivable customer edit routine.
TXTAXCODE - Used to print tax code information.
TXTAXRATE - Used in the tax code edit routine.
TXTAXTABLE - Used in the tax code edit routine.
BL203 - Standard Comments Listing
Run this program to list all standard comments. As an option, you can also
select a range of comment codes to print on the report.
Updated Files
CKPOINT -
Referenced Files
OECOMMHDR - Used to print standard comment code information.
OECOMPANY - Used to print Billing company information.
OESTDCOMM - Used to print standard comment lines.
BL204 - Customer Item Listing
Run this program to list the customer item cross-references created by BL04.1
(Customer Item Cross Reference).
Updated Files
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CKPOINT - Used for batch recovery.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to print Accounts Receivable company information.
ARCUSTFLDS - Used in the Accounts Receivable customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable customer edit routine.
ARCUSTOMER - Used to print Accounts Receivable customer information.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
CUSTDESC - Used to print Accounts Receivable customer information.
ICCOMPANY - Used to print Inventory Control company information.
INSTCTRYCD - Used to store the Intrastat country code.
ITEMMAST - Used to print Inventory Control item information.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to print Billing company information.
OECUST - Used in the Accounts Receivable customer edit routine.
OECUSTITEM - Used to print customer item information.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL205 - Sales Class Accounts Listing
List all sales class accounts defined in the system and specified on the
report submission parameters. Define sales classes using BL05.1 (Sales Class
Accounts).
Updated Files
CKPOINT -
Referenced Files
ICCOMPANY - Used to print Inventory Control company information.
MAJORCL - Used to print Inventory Control major sales class information.
MINORCL - Used to print Inventory Control minor sales class information.
OECOMPANY - Used to print Billing company information.
OEPROCLEV - Used to validate the Billing process level.
OESLSACCT - Used to print Billing sales class information.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL206 - Invoice Type Listing
Run this report to list all invoice types that have been created for a
company.
Updated Files
CKPOINT -
Referenced Files
OECOMPANY - Used to print Billing company information.
OEINVCTYPE - Used to print invoice type information.
BL207 - Reason Code Listing
Use this report to list all reason codes that exist for a company. Reason
codes are used when canceling orders or entering credit memos in the Billing
system.
Updated Files
CKPOINT -
Referenced Files
OECOMPANY - Used to print Billing company information.
OEREASON - Used to validate reason codes. If this is the first time the
reason code is
referenced, the used flag is set.
BL208 - Location Tax Listing
Run this program to list all locations defined using BL08.1 (Location Tax
Option) from which items were ordered.
Updated Files
CKPOINT -
Referenced Files
ICCOMPANY - Used to print Inventory Control company information.
ICLOCATION - Used to print inventory location third-party taxing
information.
BL209 - Add-On Charges Listing
Run this report to list all add-on charges that exist for a company. You can
place these charges on orders at the header or line level.
Updated Files
CKPOINT -
Referenced Files
OECOMPANY - Used to print Billing company information.
OEMISC - Used to print add-on charges information.
POAOCMAST - Used to print purchase order add-on cost information.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL210 - Item Add-On Listing
Run this program to list all item add-on charges for a company. The system
assesses the charge automatically when entering an invoice, credit memo, or
debit memo.
Updated Files
CKPOINT -
Referenced Files
ICCOMPANY - Used to print Inventory Control company information.
ITEMADDON - Used to print item add-on information.
ITEMMAST - Used to print Inventory Control item information.
OECOMPANY - Used to print Billing company information.
OEMISC - Used to print add-on charge information.
BL212 - Freight Code Listing
Run this report to list all freight codes that exist for a company. Define
freight codes using BL12.1 (Freight Codes).
Updated Files
CKPOINT -
Referenced Files
OECOMPANY - Used to print Billing company information.
OEFRTCODE - Used to print freight code information.
BL213 - Credit Card Type Listing
Use this report to list all the credit card types that exist for a company.
Define credit card types using BL13.1 (Credit Card Types).
Updated Files
CKPOINT -
Referenced Files
ARCODE - Used to print Accounts Receivable code information.
OECOMPANY - Used to print Billing company information.
OECREDCARD - Used to print credit card information.
BL214 - Customer Code Listing
Run this report to list the customer codes that exist for a company.
Updated Files
CKPOINT -
Referenced Files
OECOMPANY - Used to print Billing company information.
OECUSTCODE - Used to print customer code information.
BL215 - Recurring User List
Run this program to list users that have authority for adding items or add-on
charges to recurring invoices. If you did not select the Control Recurring
Charge Entry flag at the company level and then select users with BL15.1
(Recurring Invoice User), no users will print on the listing.
Updated Files
CKPOINT -
Referenced Files
BILLOPER - Used to validate operator authority to enter an item or add-on
charge.
ICCOMPANY - Used to validate the Inventory Control company.
ITEMMAST - Used to validate Inventory Control item numbers.
OECOMPANY - Used to validate the Billing company.
OEMISC - Used to validate the Billing add-on charge code.
BL220 - Invoice Status
Use this report to list invoices. You can select from several invoice status
selection parameters.
Updated Files
CKPOINT -
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
routines.
ARCUSTGRP - Used in the Accounts Receivable customer edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CUSTDESC - Used to validate the Accounts Receivable customer.
ICCOMPANY - Used to validate the Inventory Control company.
INSTCTRYCD - Used to store the Intrastat country code.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEINVCCOMM - Used to print invoice/invoice line comments.
OEINVCLINE - Provides invoice line for printing.
OEINVCMISC - Provides invoice/invoice line add-on charge information for
printing.
OEINVHDR - Used to validate Invoice Batch selection.
OEINVOICE - Provides invoice information for printing.
OEMISC - Used to validate add-on charges.
OEPROCLEV - Used to validate the Billing process level.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL230 - Recurring Invoice Listing
Run this program to list master recurring invoices. You can limit the listing
by a master recurring invoice number range and start and stop date parameters.
Updated Files
CKPOINT -
Referenced Files
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
BLRIMCOMM - Stores comments attached to either a recurring invoice header
or a recurring
invoice line.
BLRIMLINE - Stores information and control parameters to control creation
of customer
recurring invoice line items and the subsequent invoices
created from those
customer recurring invoice line items.
BLRIMMISC - Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those
customer recurring invoice add-on charges.
ICCOMPANY - Used to validate the Inventory Control company.
ITEMMAST - Used to validate Inventory Control item numbers.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OEMISC - Used to validate the Billing add-on charge code.
BL231 - Customer Recurring Invoices
Use this program to list customer recurring invoices. You can limit the
listing by using a customer recurring invoice number range and start and stop
dates.
Updated Files
CKPOINT -
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
routines.
ARCUSTGRP - Used in the Accounts Receivable customer edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BLRICCOMM - Stores comments attached to either a customer recurring
invoice header or a
recurring invoice line comments.
BLRICLINE - Stores information and control parameters to control creation
of invoices
for an item.
BLRICMISC - Stores information and control parameters to control creation
of invoices
for an add-on charge.
BLRICUST - Used to validate customer recurring invoice numbers.
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
CUSTDESC - Used to display the Accounts Receivable customer information.
ICCOMPANY - Used to validate the Inventory Control company.
INSTCTRYCD - Used to validate the Intrastat country code.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMMHDR - Used to validate standard comment codes.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEMISC - Used to validate the Billing add-on charge code.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL232 - Billed To Date
Run this program to list all invoices that have been billed (printed) or
updated to GL by the system for a recurring invoice (or a range of recurring
invoices). You can limit the listing to invoices created for one customer, a
range of customers, or all customers.
Updated Files
CKPOINT -
Referenced Files
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
ICCOMPANY - Used to validate Inventory Control company.
OECOMPANY - Used to validate the Billing company.
OEINVCLINE - Used to store all information for an invoice line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
OEINVOICE - Stores all information for an invoice.
OEMISC - Used to validate the Billing add-on charge code.
BL240 - Worksheet Reprint
Run this program to reprint worksheets. Base list worksheets are initially
printed by running BL140 (Base List Worksheet Creation).
Updated Files
CKPOINT -
Referenced Files
APCOMPANY - Used in the vendor edit routine.
APCPYVND - Used in the vendor edit routine.
APHLDINV - Used in the vendor edit routine.
APVENCLASS - Used in the vendor edit routine.
APVENGROUP - Used in the vendor edit routine.
APVENMAST - Used to print Accounts Payable vendor information.
ICCOMPANY - Used to print Inventory Control company information.
ICLOCATION - Used to print Inventory Control location information.
ITEMMAST - Used to print Inventory Control item information.
OEBASE - Used to print item price base information.
OECOMPANY - Used to print Billing company information.
OEWKPRICE - Used to print item work price base information.
OEWKSHEET - Used to print pricing worksheet information.
INVOKED Programs
IFCC
BL241 - Price Audit Report
Use this report to list price base changes. You decide whether or not to
audit changes made to item price bases when defining your company.
Updated Files
CKPOINT -
Referenced Files
ICCOMPANY - Used to print Inventory Control company information.
ICLOCATION - Used to print Inventory Control location information.
ITEMMAST - Used to print Inventory Control item information.
OEBASE - Used to print item price base information.
OEBPAUDIT - Used to print item price base audit information.
OECOMPANY - Used to print Billing company information.
BL243 - Price Book Print
Run this program to print an existing price book. Price books are used to
display pricing information. You can add comments to price books by sales
classes and specific items.
Updated Files
CKPOINT -
Referenced Files
ICCOMPANY - Used to print Inventory Control company information.
ITEMMAST - Used to print Inventory Control item information.
MAJORCL - Used to print Inventory Control sales major class information.
MINORCL - Used to print Inventory Control sales minor class information.
OEBASE - Used to print item price base information.
OECOMPANY - Used to print Billing company information.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEPBCLASS - Used to print price book sales class comments.
OEPBITEM - Used to print price book item comments.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCBOOK - Used to print price book information.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
WFSETUP -
BL244 - Discount Code Listing
Run this program to print discount codes for a specific company. Define
discount codes using BL44.1 (Discount Code).
Updated Files
CKPOINT -
Referenced Files
OECOMPANY - Used to print Billing company information.
OEDISCOUNT - Used to print discount code information.
BL245 - Price List Listing
This program prints all price lists or a selected price list for a company.
Individual sales class and item records set up for a price list also print.
This is a file listing of price lists, not a price book.
Updated Files
CKPOINT -
Referenced Files
ICCOMPANY - Used to print Inventory Control company information.
ITEMMAST - Used to print Inventory Control item information.
OECOMPANY - Used to print Billing company information.
OEDISCOUNT - Used to print discount code information.
OEPLCLASS - Used to print price list sales class parameters.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to print price list parameters.
BL246 - Contract Listing
Run this program to list existing contracts for a company, company/customer
combination, or a single contract. A report to look at a contract's status
also exists.
Updated Files
CKPOINT -
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to print Accounts Receivable company information.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
routines.
ARCUSTGRP - Used in the Accounts Receivable customer edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
CUSTDESC - Used to print customer address information.
ICCOMPANY - Used to print Inventory Control company information.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMMAST - Used to print Inventory Control item information.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE -
OECOMPANY - Used to print Billing company information.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to print discount code information.
OEPLCLASS - Used to print contract sales class parameters.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to print contract parameters.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL247 - Promotion Listing
Run this program to list existing promotions for a company. To define or
update a promotion, use BL47.1 (Promotion).
Updated Files
CKPOINT -
Referenced Files
ICCOMPANY - Used to print Inventory Control company information.
ITEMMAST - Used to print Inventory Control item information.
OECOMPANY - Used to print Billing company information.
OEDISCOUNT - Used to print discount code information.
OEPLCLASS - Used to print promotion sales class parameters.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to print promotion parameters.
BL248 - Base Listing
Run this program to list price base parameters. Define a price base using
BL40.1 (Price Base).
Updated Files
CKPOINT -
Referenced Files
CUCODES - Used to print currency code information.
ICCOMPANY - Used to print Inventory Control company information.
ITEMMAST - Used to print Inventory Control item information.
OEBASE - Used to print item price base information.
OECOMPANY - Used to print Billing company information.
BL290 - Sales Journal
This report lists invoices that have been created in the Order Entry or
Billing system with invoice dates within the date range specified. Each
invoice prints, along with the line items on the invoice and the shipment
number of the order the invoice belongs to (if the goods were shipped).
Process level invoice totals and report totals are also printed by this
report.
Updated Files
ARCODE - Used to validate Accounts Receivable codes. If this is the
first time the Accounts Receivable code is
referenced, the used flag is set.
CKPOINT - Used for batch recovery.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
APACCRCODE - Used in the vendor edit routine.
ARCOMP - Used to print Accounts Receivable company information.
ARCUSTFLDS - Used in the Accounts Receivable customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable customer edit routine.
ARCUSTOMER - Used to print customer information.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
ICCOMPANY - Used to print Inventory Control company information.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMLOC - Used to print Inventory Control location information.
ITEMMAST - Used to print Inventory Control item information.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to print Billing company information.
OECUST - Used in the Accounts Receivable customer edit routine.
OEFRTCODE - Used to print freight code information.
OEINVCCOMM - Used to print invoice comments.
OEINVCDTL - Used to print invoice line lot/serial information.
OEINVCLINE - Used to print invoice line information.
OEINVCMISC - Used to print invoice/invoice line add-on charge information.
OEINVCTAX - Used to print sales tax for invoices.
OEINVCUOM - Used to print pricing information for lines priced via
multiple units of
measure.
OEINVOICE - Used to print invoice information.
OEMISC - Used to validate the Billing add-on charge code.
Used to validate add-on charges.
OEPROCLEV - Used to validate the Billing process level.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
SHIPTO - Used to print ship-to information.
STATICCUST - Used in the Accounts Receivable customer edit routine.
TXTAXCODE - Used to validate tax codes.
TXTAXRATE - Used in the tax code edit routine.
TXTAXTABLE - Used in the tax code edit routine.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
IFCC
BL291 - Invoice Register
Run this program to reprint invoices and invoice registers (a separate print
file is created for invoice registers). Once an invoice prints, you cannot
change or delete it; the only way to correct printed invoices is by creating
credit or debit memos.
Updated Files
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CKPOINT - Used to control program restart logic.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
routines.
ARCUSTGRP - Used in the Accounts Receivable company Edit routine.
ARCUSTOMER - Used to validate Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
CUSTDESC - Used to display Accounts Receivable customer information.
CUSTORDER - Used to print customer order information.
INSTCTRYCD - Used to validate the Intrastat country code.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEINVOICE - Stores all information for an invoice.
OEPROCLEV - Used to validate the Billing process level.
STATICCUST - Used in the Accounts Receivable customer edit routine.
BL293 - GL Distribution Report
Run this program to produce a report of postings made to the General Ledger
system by the Order Entry or Billing system. Postings are updated for
inclusion on this report by running BL123 (Sub-System Update) and OE130
(Returns GL Posting).
The report totals by process level and company and can be limited to a
specific process level or date range.
Updated Files
CKPOINT - Not used.
Referenced Files
OECOMPANY - Used to print Billing company information.
OEDIST - Used to print General Ledger posting information.
OEPROCLEV - Used to validate the Billing process level.
WFSETUP -
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL320 - Invoice Purge
Run this program to purge invoices that have completed processing.
Updated Files
CKPOINT - Used to control program restart logic.
OEINVCCOMM - Purged by this program. Used to print invoice/invoice line
comments.
OEINVCDTL - Purged by this program. Used to store lot/serial information
for an invoice line for subsequent printing on the invoice
form.
OEINVCLINE - Purged by this program. Used to store all information for an
invoice line.
OEINVCMISC - Purged by this program. Used to store all information for an
add-on charge attached to an invoice or invoice line.
OEINVCTAX - Purged by this program. Used to store tax amounts calculated
when the invoice is released.
OEINVCUOM - Purged by this program. Used to store invoice line pricing
information when the line has been priced via multiple units of
measure.
OEINVOICE - Purged by this program. Stores all information for an
invoice.
OEINVSGBLK - Stores user analysis values for processing through the
Strategic Ledger system.
Referenced Files
OECOMPANY - Used to validate the Billing company.
SACOMPANY - Used to validate the Sales Analysis company.
SHIPTO - Used to validate the ship-to number.
INVOKED Programs
IFSG
BL330 - Recurring Invoice Purge
With this program, you can purge recurring invoices that have completed
processing.
Updated Files
BLRIMAST - Purged by this program. Stores information and control
parameters to control creation of customer recurring invoices
and the subsequent invoices created
from those customer recurring invoices.
BLRIMCOMM - Purged by this program. Stores comments attached to either a
recurring invoice header or a recurring invoice line.
BLRIMLINE - Purged by this program. Stores information and control
parameters to control creation of customer recurring invoice
line items and the subsequent invoices
created from those customer recurring invoice line items.
BLRIMMISC - Purged by this program.
Stores information and control parameters to control creation
of customer
recurring invoice add-on charges and the subsequent invoices
created from those customer recurring invoice add-on charges.
BLRIMSGBLK - Stores header information for customer recurring invoices.
CKPOINT - Used for batch recovery.
Referenced Files
BLRICUST - Used to validate customer recurring invoice numbers.
ICCOMPANY - Used to validate the Inventory Control company.
ITEMMAST - Used to validate Inventory Control item numbers.
OECOMPANY - Used to validate the Billing company.
OEMISC - Used to validate the Billing add-on charge code.
INVOKED Programs
IFSG
BL331 - Customer Recurring Invc Purge
Run this program to purge customer recurring invoices that have completed
processing.
Updated Files
BLRICCOMM - Purged by this program.
Stores comments attached to either a customer recurring
invoice header or a
recurring invoice line comments.
BLRICLINE - Purged by this program.
Stores information and control parameters to control creation
of invoices
for an item.
BLRICMISC - Purged by this program.
Stores information and control parameters to control creation
of invoices
for an add-on charge.
BLRICSGBLK - Stores header information for customer recurring invoices.
BLRICUST - Purged by this program.
Used to validate customer recurring invoice numbers.
CKPOINT - Used for batch recovery.
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
routines.
ARCUSTGRP - Used in the Accounts Receivable company edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BLRIMAST - Stores information and control parameters to control creation
of customer
recurring invoices and the subsequent invoices created from
those customer
recurring invoices.
CUSTDESC - Used to display Accounts Receivable customer information.
ICCOMPANY - Used to validate the Inventory Control company.
INSTCTRYCD - Used to validate the Intrastat country code.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEMISC - Used to validate the Billing add-on charge code.
STATICCUST - Used in the Accounts Receivable customer edit routine.
INVOKED Programs
IFSG
BL340 - Base List Worksheet Purge
Run this program to purge base list worksheets that are no longer needed to
update price bases in the system. These worksheets are created as a way of
performing mass updates to price bases.
Updated Files
CKPOINT - Used to control program restart logic.
OEWKPRICE - Primary file purged by this program.
OEWKSHEET - Primary file purged by this program.
Referenced Files
APCOMPANY - Used in the Accounts Payable vendor edit routine.
APCPYVND - Used in the vendor edit routine.
APHLDINV - Used in the vendor edit routine.
APVENCLASS - Used in the Accounts Payable vendor edit routine.
APVENGROUP - Used in the Accounts Payable vendor edit routine.
APVENMAST - Used to validate the Accounts Payable vendor.
ICCOMPANY - Used in the Inventory Control Item edit routine.
ICLOCATION - Used to validate the Inventory Control location.
ITEMMAST - Used to validate Inventory Control item numbers.
OEBASE - Used to print item base price information.
OECOMPANY - Used to validate the Billing company.
INVOKED Programs
IFCC
BL341 - Base List Audit Purge
Run this program to purge the base list audit file by date. The audit file is
only created for those companies that chose to audit price changes when
defining the company.
Updated Files
CKPOINT - Used to control program restart logic.
OEBPAUDIT - Primary file purged by this program.
Referenced Files
ICCOMPANY - Used in the Inventory Control Item edit routine.
ICLOCATION - Used in the Inventory Control Item edit routine.
ITEMMAST - Used to validate Inventory Control item numbers.
OECOMPANY - Used to validate the Billing company.
BL520 - Billing Interface
This program serves as an interface for invoices and credit memos that are
brought into the Order Entry or Billing system from an outside source. There
are interface files to which you move invoices and credit memos from your
system and from which this billing interface pulls the invoices and credit
memos.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ARCODE - Used to validate Accounts Receivable codes. If this is the
first time the Accounts Receivable code is
referenced, the used flag is set.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CBBANKINST - Used to validate payment code.
CKPOINT - Used to control program restart logic.
HOLDCODES - Used to validate hold codes. If this is the first time the
hold code is
referenced, the used flag is set.
OECOMPANY - Used to validate the Billing company.
OECUSTCODE - Used to validate customer codes. If this is the first time
the customer code is
used, the used flag is set on.
OEINVCCOMM - Used to store comments associated with an invoice or its line
items.
OEINVCDTL - Used to store lot/serial information for an invoice line for
subsequent printing
on the invoice form.
OEINVCLINE - Used to store all information for an Invoice Line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
OEINVCTAX - Used to store tax amounts calculated when the invoice is
released.
OEINVCTYPE - Used to validate Invoice Type. If this is the first time the
Invoice Type is
referenced, the used flag is set.
OEINVCUOM - Used to store Invoice Line pricing information when the line
has been priced
via multiple units of measure.
OEINVHDR - Invoice Batch Header file. Created when an invoice is added,
if it does not
already exist. Batch totals are updated as invoices are added
for the batch.
OEINVOICE - Stores all information for an invoice.
OEINVSGBLK - Stores user analysis values for processing through the
Strategic Ledger system.
OEMISC - Used to validate the Billing add-on charge code.
OEPROCLEV - Used to validate the Billing Process Level.
OEREASON - Used to validate Reason Codes. If this is the first time the
Reason Code is
referenced, the used flag is set.
OIINVCCOMM - Primary file created by this program. Pass invoice comments
to Billing.
OIINVCLINE - Primary file created by this program. Pass invoice line items
to Billing.
OIINVCMISC - Primary file created by this program. Pass invoice add-on
charges to Billing.
OIINVOICE - Primary file created by this program. Pass invoice header
information to Billing.
OISGBLK -
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the Used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCAL - Used in the Activity Management edit routines.
ACCALX - Used in the Activity Management edit routines.
AGINGCODE - Used in the Accounts Receivable customer edit routine.
APACCRCODE - Used in vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
routines.
ARCUSTGRP - Used in the Accounts Receivable customer edit routine.
ARCUSTOMER - Used to validate Accounts Receivable customer.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
AROIHDR - Used in the customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
COLINE - Used to print customer Order Line information.
COLINEUOM - Used to provide customer order line pricing information when
the line is priced
using multiple units of measure.
COMISC - Used to print customer order add-on charge information.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used to display Accounts Receivable customer information.
CUSTORDER - Used to print customer order information.
GLCODES - Used in the General Ledger account verification routine.
GLSYSTEM - Used in the General Ledger account verification routine.
ICCATEGORY - Used to validate inventory control general ledger categories.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
INSTREGN - Validates the Intrastat region code.
ITEMADDON - Used to trigger automatic creation of add-on charges for
specific items when
sold in specified states (or all states). The add-on charge
is created at
the invoice line level.
ITEMLOC - Used to print Inventory Control location information.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to print item base price information.
OECOMMHDR - Used to validate standard comment codes.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEFRTCODE - Used to validate freight codes.
OEORDCMNT - Used to print customer order comments.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
OESTDCOMM - Used to obtain comments for standard comment codes.
OPERATOR -
ORDERTYPE - Used to validate order type.
SHIPTO - Used to validate Ship To number.
STATICCUST - Used in the Accounts Receivable customer edit routine.
SYSTEMCODE - Used by the General Ledger system edit routine.
TXTAXRATE - Used in the tax code edit routine.
WHSHIPLINE - Used to store shipline information including feedback
quantity.
WHSHIPMENT - Used to store shipment header information.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
IFCC
IFOB
IFRS
SLSS
BL546 - Expired Contracts
Run this program to extract expired contracts for a specific date range and
company. The program extracts data for the expired contracts into a comma
separated value (CSV) file for use in the Contract Expiration Process Agent.
Updated Files
CKPOINT -
Referenced Files
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
WFUSRPROFL - Used in the Workflow interface routines.
BL720 - Product Tax Category Update
This data initialization program is a critical part of the upgrade process
from any Lawson pre-7.2.2 release to release 7.2.2 or greater. The purpose of
this post-install program is to scan open order lines, unprinted invoice
lines, and corresponding add-on charges and load appropriate values to the
Product Tax Category (PROD-TAX-CAT) field in the COLINE, COMISC, OEINVCLINE,
and OEINVCMISC database files.
Note: If you are using the Tax Category on the item master definition, you
must run this program regardless of which tax system is being used.
Updated Files
CKPOINT - Not used.
COLINE -
COMISC -
OEINVCLINE - Used to store all information for an invoice line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
Referenced Files
CUSTORDER -
ICCOMPANY - Used to validate the Inventory Control company.
ITEMMAST - Used to validate Inventory Control item numbers.
OEINVOICE - Stores all information for an invoice.
OEMISC - Used to validate add-on charges.
BL802 - Ship-to Load
Run this program to convert non-Lawson ship-to codes to Lawson. You can
change ship-to codes after converting them if they are activated. Use Bl02.1
(Ship-To) to activate ship-to codes after converting. For more information,
see the Billing Conversion Workbook.
Updated Files
CKPOINT - Used for batch recovery.
SALESREP - Used to validate sales representatives.
SHIPTO - Used to validate ship-to numbers.
SHIPTOCMNT - Stores order comments for ship-to codes. These comments are
copied to any orders or
invoices for this ship-to.
TERITORY - Used to validate territories.
TERMS - Used to validate Accounts Receivable terms.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
Referenced Files
AGINGCODE - Used in the customer edit routine.
APACCRCODE - Used in the vendor edit routine.
APCOMPANY - Used in the vendor edit routine.
APCPYVND - Used in the vendor edit routine.
APHLDINV - Used in the vendor edit routine.
APVENCLASS - Used in the vendor edit routine.
APVENGROUP - Used in the vendor edit routine.
APVENMAST - Used in the vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the customer edit routine.
ARCUSTGRP - Used in the Accounts Receivable customer edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the customer edit routine.
ARLOCKBOX - Used in the customer edit routine.
ARPAYMENT - Used in the customer edit routine.
CUCONV - Used for currency editing.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used in the Accounts Receivable customer edit routine.
GLSYSTEM - Used in the General Ledger edit routines.
ICLOCATION - Used to validate the inventory control location.
INSTCTRYCD - Used to validate the Intrastat country code.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEFRTCODE - Used to validate freight codes.
OEMETHOD - Used to validate the shipping method.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
STATICCUST - Used in the Accounts Receivable customer edit routine.
TXTAXRATE - Used in the tax code edit routine.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL820 - Invoice Conversion
Run this program to convert non-Lawson invoices to Lawson. For more
information, see the Billing Conversion Workbook.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ARCODE - Used to validate the Accounts Receivable code on the invoice.
ARPROCLEVL - Used to validate the Accounts Receivable process level. If
this is the first
time the process level is referenced, the used flag is set.
CBBANKINST - Used to validate the payment type.
CKPOINT - Used for batch recovery.
HOLDCODES - Used to validate the hold code.
ICCOMPANY - Used to validate the Inventory Control company.
ITEMLOC - Used to verify the inventory control item location. Also used
to store available, allocated, in process quantities for an
item location combination.
OECOMPANY - Used to validate the Billing company.
OECUSTCODE - Used to validate customer codes.
OEINVCCOMM - Used to store comments associated with an invoice or its line
items.
OEINVCDTL - Used to store lot/serial information for an invoice line for
subsequent printing
OEINVCLINE - Used to store all information for an invoice line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
OEINVCTAX - Used to store tax amounts calculated when the invoice is
released.
OEINVCTYPE - Used to validate invoice type.
OEINVCUOM - Used to store invoice line pricing information when the line
has been priced
via multiple units of measure.
OEINVHDR - Invoice Batch Header file. Created when an invoice is added,
if it does not
already exist. Batch totals are updated as invoices are added
for the batch.
OEINVOICE - Stores all information for an invoice.
OEINVSGBLK - Stores user analysis values for processing through the
Strategic Ledger system.
OEMISC - Used to validate the Billing add-on charge code.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate reason codes.
SALESREP - Used to validate sales representatives.
TERITORY - Used to validate territories. If this is the first time the
territory is referenced, the used flag is set.
TERMS - Used to validate Accounts Receivable terms.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the tax code edit routine.
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCAL - Used in the Activity Management edit routines.
ACCALX - Used in the Activity Management edit routines.
AGINGCODE - Used in the customer edit routine.
APACCRCODE - Used in the vendor Edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the customer edit routine.
ARCUSTGRP - Used in the customer edit routine.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARCUSTTOTS - Used in the customer edit routine.
ARLOCKBOX - Used in the customer edit routine.
AROIHDR - Used in the customer edit routine.
ARPAYMENT - Used in the customer edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
COLINE - Used to verify customer order line information.
COLINEUOM - Used to verify order line multiple pricing units of
measure.
COMISC - Used to verify order and order line add-on
charges.
CUCONV - Used for currency editing.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used in the customer edit routine.
CUSTORDER - Used to verify customer order information.
GLCODES - Used in the General Ledger edit routines.
GLSYSTEM - Used in the General Ledger edit routines.
ICBIN - Used to obtain inventory control bin information.
ICCATEGORY - Used to validate inventory control general ledger categories.
ICLOCATION - Used to validate the inventory control location.
INSTCTRYCD - Used to validate the Intrastat country code.
INSTREGN - Validates the Intrastat region code.
ITEMADDON - Used in the order line edit routine. Automatically adds
add-on charges to an order when an item is ordered.
ITEMMAST - Used to validate the inventory control item.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OEBASE - Used to determine item pricing for the invoice line.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the Accounts Receivable customer edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEFRTCODE - Used to validate freight codes.
OEORDCMNT - Used to store order comments related to customer order(s) or
customer order line(s).
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
OPERATOR -
ORDERTYPE - Used to validate order types.
SHIPTO - Used to validate ship-to numbers.
STATICCUST - Used in the Accounts Receivable customer edit routine.
SYSTEMCODE - Used by the General Ledger system edit routine.
TXTAXRATE - Used in the tax code edit routine.
WHSHIPLINE - Used to store shipline information including feedback
quantity.
WHSHIPMENT - Used to store shipment header information.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
IFOB
IFRS
SLSS
BL902 - Ship-to Conversion
Run this program to convert non-Lawson ship-to codes to Lawson. You can
change ship-to codes after converting them if they are activated. Use Bl02.1
(Ship-To) to activate ship-to codes after converting. For more information,
see the Billing Conversion Workbook.
Updated Files
CKPOINT - Not used.
SALESREP -
SHIPTO - Used to update and validate ship-to numbers.
SHIPTOCMNT -
TERITORY -
TERMS -
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE -
Referenced Files
AGINGCODE - Used in the Accounts Receivable customer edit routine.
APACCRCODE - Used in the vendor edit routine.
APCOMPANY -
APCPYVND -
APHLDINV -
APVENCLASS -
APVENGROUP -
APVENMAST -
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
routines.
ARCUSTGRP - Used to display the Accounts Receivable customer group name
for the company.
ARCUSTOMER - Used to validate the Accounts Receivable customer. Updated
with the customer default ship-to number.
ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.
ARLOCKBOX - Used in the Accounts Receivable customer edit routine.
ARPAYMENT - Used in the Accounts Receivable customer edit and update
routines.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used to display Accounts Receivable customer information.
GLSYSTEM - Used in the General Ledger company edit routine.
ICLOCATION - Used to validate the Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
NATACCT - Used in the Accounts Receivable customer edit routine.
NATBALANCE - Used in the Accounts Receivable customer edit routine.
OECOMPANY - Used to validate the Billing company.
OECUST - Used in the Accounts Receivable customer edit routine.
OEFRTCODE -
OEMETHOD -
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
STATICCUST - Used in the Accounts Receivable customer edit routine.
TXTAXRATE -
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
BL940 - Invoice Conversion Program
Run this program to convert non-Lawson invoices to Lawson. For more
information, see the Billing Conversion Workbook.
Updated Files
ACCOMMIT -
ACCOMMITX -
ARCODE - Used to validate AR codes. If this is the first time the AR
code is
referenced, the used flag is set.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CBBANKINST - Used to validate payment code.
CKPOINT - Used to control program restart logic.
HOLDCODES - Used to validate hold codes. If this is the first time the
hold code is
referenced, the used flag is set.
ICCOMPANY - Used to validate Inventory Control company.
ITEMLOC - Used to print Inventory Control Location information.
OECOMPANY - Used to validate the Billing company.
OECUSTCODE - Used to validate customer codes. If this is the first time
the customer code is
used, the used flag is set on.
OEINVCCOMM - Used to store comments associated with an invoice or its line
items.
OEINVCDTL - Used to store lot/serial information for an invoice line for
subsequent printing
on the invoice form.
OEINVCLINE - Used to store all information for an Invoice Line.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
OEINVCTAX - Used to store tax amounts calculated when the invoice is
released.
OEINVCTYPE - Used to validate Invoice Type. If this is the first time the
Invoice Type is
referenced, the used flag is set.
OEINVCUOM - Used to store Invoice Line pricing information when the line
has been priced
via multiple units of measure.
OEINVHDR - Invoice Batch Header file. Created when an invoice is added,
if it does not
already exist. Batch totals are updated as invoices are added
for the batch.
OEINVOICE - Stores all information for an invoice.
OEINVSGBLK - Stores user analysis values for processing through the
Strategic Ledger system.
OEMISC - Used to validate the Billing add-on charge code.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate reason codes. If this is the first time the
reason code is
referenced, the used flag is set.
SALESREP - Used to validate sales representatives. If this is the first
time the sales representative is referenced, the used flag is
set.
TERITORY - Used to validate territories. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate terms codes. If this is the first time the
terms code is
referenced, the used flag is set.
TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
the tax code is used.
TXCOMPANY - Stores company information and which tax system the company
uses. Includes general ledger accounts if they are defined at
the company level.
TXTAXCODE - Used to validate tax codes.
TXTAXTABLE - Used in the Tax Code Edit routine.
Referenced Files
ACACCTCAT -
ACACTGRP -
ACACTIVITY -
ACCAL -
ACCALX -
AGINGCODE - Used in the AR Customer Edit routine.
APACCRCODE - Used in Vendor edit routine.
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the AR Customer Edit and Update routines.
ARCUSTGRP - Used in the AR Company Edit routine.
ARCUSTOMER - Used to validate Accounts Receivable customer.
ARCUSTTOTS - Used in the AR Customer Edit routine.
ARLOCKBOX - Used in the AR Customer Edit routine.
AROIHDR -
ARPAYMENT - Used in the AR Customer Edit routine.
BILLTO -
COLINE - Used to print Customer Order Line information.
COLINEUOM - Used to provide customer order line pricing information when
the line is priced
using multiple units of measure.
COMISC - Used to print customer order add-on charge information.
CUCONV - Used in converting monetary amounts between currencies.
CURELAT - Used in converting monetary amounts between currencies.
CUSTDESC - Used to display Accounts Receivable Customer information.
CUSTORDER - Used to print Customer Order information.
GLCODES - Used in the GL account verification routine.
GLSYSTEM - Used in the GL account verification routine.
ICBIN -
ICCATEGORY -
ICLOCATION - Used to validate Inventory Control location.
INSTCTRYCD - Used to validate the Intrastat country code.
INSTREGN - Validates the Intrastat region code.
ITEMADDON - Used to trigger automatic creation of add-on charges for
specific items when
sold in specified states (or all states). The add-on charge
is created at
the invoice line level.
ITEMMAST - Used to validate Inventory Control item numbers.
NATACCT - Used in the AR Customer Edit routine.
NATBALANCE - Used in the AR Customer Edit routine.
OEBASE - Used to print item base price information.
OECREDCARD - Used to validate credit card types.
OECUST - Used in the AR Customer Edit routine.
OEDISCOUNT - Used to validate discount codes and provide discount
information for the pricing routine.
OEFRTCODE - Used to validate freight codes.
OEORDCMNT - Used to print Customer Order comments.
OEPLCLASS - Used to store sales class pricing parameters for price list,
promotion, and contract.
OEPLITEM - Used to store item pricing parameters for price list,
promotion, and contract.
OEPRCLIST - Used to store default pricing parameters for price list,
promotion, and contract.
OESLSACCT - Used to obtain invoice line accounts for inventoried and
non-stock line
types.
OPERATOR -
ORDERTYPE - Used to validate order type.
SHIPTO - Used to validate Ship To number.
STATICCUST - Used in the AR Customer Edit routine.
SYSTEMCODE - Used by the General Ledger system edit routine.
TXTAXRATE - Used in Tax Code edit routine.
WHSHIPLINE - Used to store shipment line information including feedback
quantity.
WHSHIPMENT -
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
IFOB
IFRS
SLSS
BL960 - Customer Recurring Invoice
Updated Files
BLRICUST -
CKPOINT - Not used.
Referenced Files
ACACTREL - Referenced in the conversion of non-Lawson activity
information to the Activity Management system.
BL961 - Recurring Invoice
Updated Files
BLRIMAST -
CKPOINT - Not used.
Referenced Files
ACACTREL - Referenced in the conversion of non-Lawson activity
information to the Activity Management system.
BL962 - Order Entry Company
Updated Files
CKPOINT -
OECOMPANY - Used to validate the Billing company.
Referenced Files
None.
BL963 - Order Entry GL Distribution
Updated Files
CKPOINT - Not used.
OEDIST -
Referenced Files
ACACTREL - Referenced in the conversion of non-Lawson activity
information to the Activity Management system.
GLCONVJE -
BL964 - Invoice Type
Updated Files
CKPOINT - Not used.
OEINVCTYPE -
Referenced Files
None.
BL965 - Order Entry Process Level
Run this program to load invoices from release 5.0 to release 6.0.
Updated Files
CKPOINT - Used to control program restart logic.
OEPROCLEV -
Referenced Files
None.
BL966 - Interface invoices
Updated Files
CKPOINT - Not used.
OIINVOICE - Used to update and validate invoice header information.
Referenced Files
None.
BL967 - Customer Ship To Address
Updated Files
CKPOINT - Not used.
SHIPTO - Used to update and validate ship-to numbers.
Referenced Files
None.
BL968 - Invoices
Updated Files
CKPOINT - Not used.
OEINVOICE - Stores all information for an invoice.
Referenced Files
None.
BL96A - Interface invoice lines
Updated Files
CKPOINT - Not used.
OIINVCLINE -
Referenced Files
ACACTREL - Referenced in the conversion of non-Lawson activity
information to the Activity Management system.
BL96B - Interface invoice AOC
Updated Files
CKPOINT - Not used.
OIINVCMISC -
Referenced Files
ACACTREL - Referenced in the conversion of non-Lawson activity
information to the Activity Management system.
BL96C - Invoice Line
Updated Files
CKPOINT - Not used.
OEINVCLINE - Used to store all information for an invoice line.
Referenced Files
ACACTREL - Referenced in the conversion of non-Lawson activity
information to the Activity Management system.
BL96D - Invoice Miscellaneous Charges
Updated Files
CKPOINT - Not used.
OEINVCMISC - Used to store all information for an add-on charge attached to
an invoice or
invoice line.
Referenced Files
ACACTREL - Referenced in the conversion of non-Lawson activity
information to the Activity Management system.
OEINVOICE - Stores all information for an invoice.
OEMISC - Used to validate add-on charges.
BL96E - Invoice Taxes
Updated Files
CKPOINT - Not used.
OEINVCTAX -
Referenced Files
ICCOMPANY - Used to validate the Inventory Control company.
ITEMMAST - Used to validate Inventory Control item numbers.
OEINVCLINE - Used to store all information for an invoice line.
TXTAXCODE - Used to validate tax codes.
|