ACCT GL (General Ledger)

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.

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 Sale control 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 Sale control 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 Sale control 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 User Home, 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	Yes - Budgets for the fiscal year. No - Budgets for the calendar year.
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

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

Options	Yes - Only accounts with non-zero balances display. Use the Show Zero Amounts hot key on the Business Sales Detail screen to view accounts with zero balances. No - All accounts display.
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

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: Branch That Controls Branch That Receives Credit For The Sale Branch That Received Credit For The Sale
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.

ACCT GL (General Ledger) Control Maintenance Records