BPCS Sign In
Follow the below steps to start the add-in component of Spreadsheet Server for BPCS ledgers:
Note:
- If a user's Spreadsheet Server Settings are set to start Spreadsheet Server during Excel startup, step 2 is not applicable.
- If unattended (auto) sign in is enabled, steps 3 through 5 are not applicable.
- Open Excel.
- In Excel, from the Spreadsheet Server Ribbon, select Disabled (or, click the down arrow under the Disabled button, and click Enable). The Sign On to Spreadsheet Server dialog box appears.
- In the Sign On to Spreadsheet Server dialog box, specify the following fields:
- Host Name or IP Address: the iSeries system name or IP address that hosts the database.
-
Database Library: the name of library or catalog containing the
GL
data. - User Name: the iSeries or SQL Server user name
- Password: the iSeries or SQL Server password.
- Click OK.
- For BPCS 6.02 users only, in the BPCS Chart of Accounts Name panel, specify the name of the chart of accounts to be used and click OK.
See Sign In, Control Panel, Disable or Enable Formula Calculations, and Reset Host Server Connection for more information.