BPCS 4.05 Ledger Specifics
Use the following table to enter data in the Spreadsheet Server Settings > Ledger Specifics >BPCS 4.05CD panel, or to access other functions:
| Field | Description |
|---|---|
BPCS 4.05CD Connection Options: |
|
Retrieve account balances and descriptions for preloaded local PC database |
If selected, Spreadsheet Server retrieves |
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 4.05CD Library Options: |
|
Budget Library |
Specify the name of the library containing budget data. |
Budget File Name |
Specify the name of the file containing budget data. |
Library for RCOL01 |
Specify the name of the library containing the |
BPCS 4.05CD Processing Options: |
|
GXL: Include opening balance in YTD format calculations |
If selected, the |
GXL/Drill Down: Include consolidated accounts |
If selected, the |
Drill Down: Allow journal lines |
If selected, drill down to journal lines is permitted. This function is password protected. |
List Accounts: Exclude inactive accounts |
If selected, the List Accounts function excludes inactive accounts. |
BPCS 4.05CD 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 |
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). |
See Spreadsheet Server Settings for more information.