Skip to main content

BPCS 6.02 Ledger Specifics

Use the following table to enter data in the Spreadsheet Server Settings > Ledger Specifics >BPCS 6.02 panel, or to access other functions:

Field Description

BPCS 6.02 Connection Options:

 

Retrieve account balances and descriptions for preloaded local PC database

If selected, Spreadsheet Server retrieves GL balances from the preloaded local PC database. Otherwise, the system retrieves balances from the host General Ledger system.

Operate completely disconnected from host

If Retrieve Account Balances and Descriptions for Preloaded Local PC Database and this option are selected, the user can work while disconnected from the host system, and is unable to drill down to journal entry detail.

BPCS 6.02 Chart of Account Options:

 

Default Chart of Accounts

Click the drop-down list and select the BPCS chart of accounts from which to retrieve data.

Number of segments in account structure

Specify the number of segments in the account structure (Company, Division, etc.) to be displayed in Spreadsheet Server.

Segment 1-14

Specify the title of each account segment in the account structure. These default to the titles based in the chart of accounts selected, but may be changed if desired.

Account segment number used for GXD descriptions

Specify the segment number to be used for retrieving account descriptions of GXD formulas and in the Account Balances drill down panel.

BPCS 6.02 Processing Options:

 

GXL: Include opening balance in YTD format calculations

If selected, the GXL formula includes opening balances when calculating the YTD format.

GXE: Display analysis data in journal results

If selected, Analysis Data fields are populated when expanding the GXE formula in journals. If selected, response time varies based on the size of the journal detail file in the host system.

List Accounts: Exclude inactive accounts

If selected, the List Accounts function excludes inactive accounts.

Journal Entry Drill Down: View preference

Click the drop-down list, and select the type of journal entries to display in the Journal Entry Drill Down panel. Valid values are:

  • Posted Entries Only
  • Unposted Entries Only
  • Both Posted and Unposted

BPCS 6.02 Build a Template Options:

 

QuickText

Specify the button label to appear in the Spreadsheet Server Ribbon > Build a Template > General Ledger menu, to identify the ledger for building a GXL formula.

Tool Tip

Specify the tool tip to display for the associated QuickText item.
Button Description

Load Local PC Database

Displays the Load Local PC Database panel, allowing the user to download account balances to a local database, in order to optimize calculation speeds (see BPCS Load Local Data for more information).

Refresh

Clears the current segment descriptions, retrieves them based on the selected chart of accounts, then refreshes the list of available chart of accounts.

See Spreadsheet Server Settings for more information.

Was this article helpful?

We're sorry to hear that.

Powered by Zendesk