ACCT GL (General Ledger) Control Maintenance Records
The following control maintenance records belong to the GL (General
Ledger) area within the ACCT (Accounting) category.
Auto Payroll Balance Accounts
Use the Auto Payroll Balance Accounts screen to specify offset accounts
for each branch for posting differences that occur when journal entries
for automatic payroll do not balance. 
More:
|
Options
|
For
each branch, complete the following fields:
-
G/L Account - Specify
the G/L account to use when creating payroll journal entries
for the designated branch.
-
Posting Br - Specify
the posting branch for the G/L account.
If multiple branches use the same account and posting branch,
use the Set All
hot key to set the G/L account and posting branch for
every branch to be the same as the line on which the cursor
is positioned, or the Copy
hot key to copy the G/L account and posting branch from
the line the cursor is on to a specified branch, territory,
or branches.
In addition, use the following options
to complete the definition of the auto payroll set up:
-
Click
the Record Layout
button to display the User Defined Auto Journal Entry
screen and define the record layout
of the file being imported.
-
Click
the Message User
button and specify the user or message group to notify
whenever a journal entry is made to one of the G/L accounts
listed as a result of importing the payroll file.
|
|
Outcome
of setting this control record
|
Identifies the
accounts the system should use for posting automatic payroll
differences.
|
|
Default
Value(s)
|
None
|
|
Dependencies
|
Use the User Defined
Auto Journal Entry screen described below to define the file
format for importing a payroll file received from a third-party
payroll system and creating journal entries for each branch.
|
|
Action
if set to Null
|
Differences that
occur when journal entries for automatic payroll do not balance
are not posted.
|
To define
the record layout of the file being imported:
-
On the Auto Payroll Balance
Accounts window, click the Record
Layout button to display the User Defined Auto Journal
Entry screen. By default the system displays the format you viewed
last.
-
In the Work
ID field, enter an ID for this record layout. At the prompt,
press Enter to confirm
that it is a new ID.
-
In the Description
field, enter a description of the Work ID.
-
In the Branch
field, indicate which branch or branches this record layout is
valid for.
The system populates the Jr1
Date field.
-
Click
the File Format button
to display the Upload File Format screen and then define the file
format.
-
In the Record
Type field, press F10
and select whether the record type is blocked (fixed-length) or
variable-length.
-
In the Record
Length field, if the record type is blocked, specify the
record length. If records are terminated with a carriage return
or line feed character, enter 0
as the record length.
-
In the Delimiter
Char field, press F10
and select whether data fields within records are separated by
a comma or tab character.
-
In the Delete
Chars field, enter any characters in the import file that
are not related to the data and can be deleted, such as quotes.
-
Click OK
to save the file format information and return to the Auto Payroll
Balance Accounts screen.
-
In the Heading
field, enter the description to display in the journal entry.
-
In the Data
Format column, define where the required information is
located in each input file record. This includes identifying the
G/L account, amount, and branch.
-
For blocked records, in
the Start and Lngth
columns, specify the starting position and length of each data
item listed in the Data Format
column.
-
For variable records,
in the Decimal Places
column, specify the relative position in the import record of
each data item listed in the Data
Format column.
-
If a decimal point is
not a part of the Amount
data item, enter the number of decimal positions in the Dec# field.
To post a journal entry to an Eclipse G/L account,
import records must specify one of the following:
-
In the Eclipse
G/L ID # field, specify an Eclipse G/L account ID. Optionally,
you can also specify a subledger of the account in the G/L
SubLedger field.
-
In the G/L
Account Ref # field, specify another system's G/L account
number, which has been cross-referenced to an Eclipse G/L account
ID in the Key Words field
on the G/L Account Maintenance screen.
If records identify both accounts, the system
processes them using the Eclipse account ID.
-
Click Save
to save the journal entry format.
Bank Reconciliation Settings
Use the new Bank Reconciliation Settings control record to determine
how the system handles adjustments, starting date, and the auto-match
criteria.
-
Transactions
tab - The adjustment transaction types that your bank typically charges.
From the Bank Account list field, select the bank to set up an adjustment
type. Create the adjustment type by completing the Description,
Branch, GL Account,SubLedger (optional). You
can select the Default Date to Statement check box, if you
want the entry date to be the statement date.
-
Settings
tab - Configuration for the starting reconciliation date.
Using the Bank Reconciliation window, select the branch and the bank
account. When you select the Update button, the system uses the
Initial Date in the Control Record to start the transaction search.
If you choose branches not in the Control Record, the system uses the
Default Initial Date for the transaction search. You can set multiple
branches in the Control Record with the same Initial Date.
-
Default Initial Date - The starting date the system searches for unreconciled transactions.
-
Bank Account - Select the bank from the Bank Account drop-down field. You can save
settings for different bank accounts.
-
Branch - In the Branch table column, enter the branch number associated with
your bank account.
-
Initial Date - Enter the system's starting date to search
for unreconciled transactions for that branch and bank account.
-
Match
Values tab - To use the automatic matching function,
you identify the parameters under which it operates.
-
Amount
- Set to Don't Match, Custom, Exact. For Custom, you further define
the amount with values in the Over/Short Value and Over/Short Percentage
fields.
-
Date
- Set to Don't Match, Custom, Exact. For Custom, you further define
the date with the Over/Short Value field.
-
Check
- Set to Don't Match or Yes.
-
Batch
- Set to Don't Match or Yes.
Branch That Receives Credit For
The Sale
For each branch, select the accounting postings to make for orders generated
when the pricing branch and shipping branch are not the same. More:
|
Options
|
-
Pricing
-
Shipping
-
Terminal
-
UserHome
|
|
Outcome
of setting this control record
|
Determine how the
system determines the branch to use for postings when an order's
pricing branch and shipping branch are not the same.
|
|
Default
Value(s)
|
None
|
|
Examples
|
The Branch
That Controls Branch That Receives Credit For The Salecontrol maintenance record is set to Pricing.
The system determines the pricing branch
for the order. Assume the pricing branch is Branch
3.
The system checks the Branch That Receives
Credit For The Salecontrol maintenance record to see which branch
is assigned to Branch 3.
|
If Branch 3 is set to...
|
Then all G/L postings for
an order segment go to the...
|
|
Pricing
|
pricing
branch, except for Inventory, which is posted to the
shipping branch with balancing entries made to the
Branch Exchange Account.
|
|
Shipping
|
shipping
branch.
|
|
Terminal
|
pricing
branch defined in Terminal Setup for each individual
port or user.
|
|
UserHome
|
home branch
of the writer of the sales order.
|
When the pricing branch on an open sales
order changes to a different branch, the system checks this
control maintenance record for the new pricing branch and
updates the G/L postings for the order segment. For example,
if you change the pricing branch on the order to Branch 4,
the system checks this control maintenance record for Branch
4. If it is set to UserHome, the system records all G/L postings
for the order segment to the writer's home branch.
|
|
Dependencies
|
This record works
with the Branch
That Controls Branch That Receives Credit For The Salecontrol maintenance record.
|
|
Action
if set to Null
|
Uses Pricing branch.
|
|
Additional
Information
|
After an order
is invoiced, if a user makes a change that affects the G/L
posting, such as changing the pricing branch, the user must
manually change the G/L branch. The system does not re-post
to a different G/L branch after an order is invoiced. When
copying one order to another, the logic for selecting the
G/L branch for the target order is the same at that for the
original order.
Important:
If this record is set to Terminal
or UserHome,
Web Integration implementations use the pricing branch, as
they do not know the user or terminal branch.
|
Budget Sales By Fiscal Year (Y/N)
Indicate whether the Sales Budgeting program creates budgets for the
company's fiscal year, rather than the calendar year. More:
|
Options
|
|
|
Outcome
of setting this control record
|
Forecasting expectations
are entered into a number of windows that set up the customer
and sales budget monthly default percentages. The Sales Budget
Analysis Report uses this information and the. If set to Yes, all of these applications
changed to work by the fiscal.
|
|
Default
Value(s)
|
No
|
|
Action
if set to Null
|
Same as if set
to No.
|
|
Additional
Information
|
None
|
Default Direct Through Stock Sales
Source
See SOE DTS (Direct Through Stock) in the
Sales Order Entry control maintenance record documentation.
Default iProcure Sales Source
Select the sales source to assign to orders created using the third
party software iProcure. The sales source must be a valid sales source
defined in G/L Sales Source
Maintenance.
Hide Zero Amount Accounts
In Business Summary Sales Detail Screen
Indicate whether to set the default view of the Business
Summary Sales Detail to hide accounts that have a zero balance. More:
|
Options
|
|
|
Outcome
of setting this control record
|
Determines where
the Business Summary Detail contains zero amounts.
|
|
Default
Value(s)
|
No
|
|
Action
if set to Null
|
Same as if set
to No.
|
|
Additional
Information
|
None
|
Limit Bank Selection By Branch
Use this control maintenance record to assign different bank accounts
to each branch. More:
|
Options
|
For
each branch, specify the bank accounts its users can select.
The options available are the accounts specified in the Cash
Account autopostings.
|
|
Outcome
of setting this control record
|
When receiving
and disbursing cash, the system prompts users to select a
bank assigned to their branch.
|
|
Default
Value(s)
|
Blank
|
|
Action
if set to Null
|
Users at that branch
can select from all available bank accounts.
|
|
Additional
Information
|
You can only set
this control maintenance record in Eterm. Use the Multi
hot key to specify multiple bank accounts for a branch.
|
Manually Reported Total Sales Posting
Accounts
Specify the credit and debit G/L accounts to which to post a journal
entry for manually reported sales.
Post A/P Entry Freight To Sales
Order G/L Branch
New in Release 9.0.1
Allows users to post account payable freight to a sales order general
ledger branch respecting the current control maintenance records. More:
|
Options
|
-
Yes - Freight from A/P
Entry posts to the designated G/L branch based on the
combination of the dependent control maintenance records
listed below.
-
No -Freight from
A/P Entry posts to the purchase order branch as it did
prior to Release 9.0.1.
|
|
Dependencies
|
The following control
maintenance records must be set to the appropriate branch:
|
|
Outcome
of setting this control record
|
Freight from A/P
Entry posts to the designated G/L branch based on the combination
of the dependent control maintenance records listed above.
If changes are made to the branch entries,
the system recalculates the appropriate branch, if needed.
Important:
If you select more than one payable to process in A/P Entry,
the system prompts you to select the G/L branch to which you
want to post.
|
|
Default
Value(s)
|
Blank
|
|
Action
if set to Null
|
Same as No.
|
|
Additional
Information
|
Reconciling
Purchase Orders to Invoices
Entering
and Editing Payables
|
Print Statuses To Define Sales
In Process For Business Summary
Specify the order print statuses to be considered as in-process sales
by the Business
Summary sales-in-process calculation. More:
|
Options
|
-
Q - Invoice Preview
Queue
-
P - Detailed Invoice
Preview Report
-
M - Flag to be Placed
on Manifest
-
H - Hold-No Batch Print
-
B - Batch Print
|
|
Outcome
of setting this control record
|
The system gathers
orders with the print statuses that you specify to calculate
the sales in-process information in the Business Summary.
|
|
Default
Value(s)
|
Blank
|
|
Action
if set to Null
|
The Sales
IP check box in the Business Summary window is not
active.
|
|
Additional
Information
|
Separate multiple
statuses by commas with no spaces.
|
Show All G/L Type Detail
In The G/L Acct Business Summary
Indicate whether to show all G/L Type detail in the G/L Account Business
Summary. More:
|
Options
|
-
Yes - Shows the detail
for all orders for that G/L account whe th e cursor is
on the main G/L Type account in the Business Sales Detail
window. all G/L Type detail.
-
No - Displays orders
for the G/L product type Only..
|
|
Outcome
of setting this control record
|
Affects how order
detail displays when viewing business sales information.
|
|
Default
Value(s)
|
No
|
|
Action
if set to Null
|
Same as if set
to No.
|
|
Additional
Information
|
Access the Business
Sales Detail window from File menu in the Business Summary
window.
|
Use G/L Account Type Flags For
Trial Balance
Indicate whether the G/L Report Generator respects G/L account type
flags when displaying actual data for a trial balance type of report.
More:
|
Options
|
-
Yes - The Actual
column on the report shows negatives for all accounts
that are carrying a credit balance.
-
No - The Actual
column on the report only shows a negative amount when
the account is carrying a balance opposite of its "natural"
balance.
|
|
Outcome
of setting this control record
|
Affects the actual
balance display in trial balance reports.
|
|
Default
Value(s)
|
No
|
|
Action
if set to Null
|
Same as if set
to No.
|
|
Additional
Information
|
None
|
Valid Cost Center Types
Enter cost center types to assign to G/L accounts for reporting purposes
in G/L
Template Maintenance.