No Supported Databases are Set error while Logging into Sage 300

Supported Databases
Reading Time: 2 minutes

No Supported Databases are Set error while Logging into Sage 300

Sage 300 Dashboard

Sometimes after the Installation of Sage 300 on the Workstation, users might face the above Error “No Supported Databases are Set” where system asks to do the database setup instead of showing active companies in Sage 300 database setup even if database setup is done at server. User might face this issue due to not having appropriate/sufficient rights or permission for the files of Sage 300 installation directory on the server.

We can resolve this issue by granting permissions to Users so that they can login into Sage 300 without facing any errors.

We may follow below steps to grant permissions of Sage 300 installation directory to users:

Navigate to Sage 300 installation directory located on Application server. Then right click on the folder and select Properties. From the screen, navigate to Security tab.

Sage 300

Then click on the Edit button. The following screen will appear:
Sage 300 1

Then click on the Add button to create a new Group.

Sage 300 2

Enter the name of the Group. If you wish to assign rights to each & every user in the network, then you can type in “everyone”. Click on Ok. Now select permissions to be given to this group. You must at least assign Modify, Read & execute rights to the group/user.
Sage 300 Dashboard 3

If you do not wish to assign rights to everyone then you can type user ID & assign rights to them individually.

After doing this procedure, Restart Sage 300 on your workstation. The error will not appear again & you will be able to see all the active companies in Sage 300.

GL Security in Sage 300 Web Screen

GL security
Reading Time: 3 minutes

In the Sage 300 ERP, we have a powerful feature which is known as GL security which helps to restrict the user to use the GL account and GL segments throughout the Sage 300 web screen.

To Navigate to the “GL Security”

Go to General Ledger module -> G/L Setups -> Options screen.

On the “Options” screen go to the Account tab and tick the check box “Use G/L Security” and select the desired option i.e. “All Accounts or No Accounts” then click on the Save button to save the changes.

Below is the image for your reference  :

GL security

After enabling the “G/L Security” and saving this record user need to logout from the sage 300 web screen and login again to activate the “Account Permissions” option in GL Account. There is no Account permission screen present before logging out of the Sage 300 web screen so, to activate this security user needs to re-login the Sage 300.

Once you login again you would be able to see the “Account Permission” option in the General Ledger module -> G/L Accounts -> Account Permission.

Below is the image for your reference.

GL

Then select the user from the finder for which user you want to restrict the G/L Segment and Account.

On the “Segment” tab enter the required details.

Below is the image for your reference :

GL Screen Dashboard

On the “Account” tab enter the G/L account which you want to resist for the selected user and then click on the Add button to add the account permission for the user.

Below is the image for your reference :

Dashboard - Sage 300

Here we have restricted the GL Account number 1000 – 1020 for the user “TEST”. After these new permissions have been saved the user won’t be able to view the impacted GL accounts and section on any screen, including finders. If the user manually types GL account number that the user doesn’t have permission to see, an error message will be displayed as “You are not allowed to retrieve Account”.

Login to Sage 300 through a restricted user i.e. here we are login into the Sage 300 web screen using the “TEST” user and opening any screen and selecting the restricted GL account. You can check the below image that GL Account 1000-1020 is not even listed in the finder as well if the user tries to enter it manually then the system will show a restriction message.

In the below image you can see that G/L account 1000-1020 is not visible for ‘TEST’ users.

GL 1

Also, if the user manually types the G/L account number in the search box it will give the following error as shown in the below image.

GL 2

So, in this blog we have shown you how GL security works on the Sage 300 web screen.

Sage 300cloud Web Screen Keyboard Shortcuts

Web Screen - Sage 300
Reading Time: 4 minutes

Data entry is unavoidable in accounting, but that work doesn’t have to take up so much time. When entering a large number of transactions, switching between your keyboard and mouse can be ineffective. It slow-down your speed of data entry and also breaks your concentration which may cause errors in entry and accounting.

Until the Sage 300cloud 2021 version, keyboard shortcuts weren’t available on web screens. But with the new release of versions, there are a set of keyboard shortcuts available on the screen that will save you time navigating and performing some functions on your Sage 300cloud web screen.

Find below lists of Keyboard shortcuts in Sage 300 Web Screen 2022 :

Keyboard Shortcuts for data entry.

Enter Apply changes to the field you are editing.
Tab Go to the next field.
Fn + Pg Up Go to the top of the window in view.
Fn +PgDn Go to the bottom of the window in view.
Shift + Tab Go to the previous field.
Alt + Down Arrow Open the Finder for the field you are editing if there is a Finder.
Esc Close Finders, Pop-up screens, messages.

 

Keyboard Shortcuts to navigate and enter information in detail tables.

Enter Apply changes to the field you are editing.
Left or Right Arrow Scroll left or right in the table.
Shift + Tab Go to the previous field.
Tab Go to the next field.
Up or Down Arrow Go up or down one row.

 

Keyboard Shortcuts for in Finder to navigate through results and selected records.

Up or Down Arrow Go up or down one row in the table of results.
Fn + Pg Up If the table displays multiple pages of results, go to the previous page.
Fn + PgDn If the table displays multiple pages of results, go to the next page.
Fn + Home If the table displays multiple pages of results, go to the first page.
Fn + End If the table displays multiple pages of results, go to the last page.
Enter Select the record that is highlighted in the table of results.

 Find below some examples of keyboard shortcuts with images:

1. Alt + Down Arrow:

Web Screen

In the above image, the Invoice Number field is highlighted.

Now, if the user presses Alt + Down arrow key then it will open the finder for the invoice number field. Refer to the below image.

Sage 300cloud- Web Screen

2. Esc:

Sage 300cloud

In the above image, we can see that the finder pop-up screen for the invoice number field is opened.

Now, if the user clicks the Esc key then, this finder pop-up screen will be closed. Refer below the image where the finder pop-up screen is closed and the Invoice entry main page is displayed.

Sage 300cloud

3. Fn + End:

Sage 300cloud

In the above image, we can see that the Finder pop-up screen of the Item number is opened where we can select the item for entry.

As you can see there are multiple items pages listed and we are on the first page of the items list.

Now, suppose we want to navigate to the last page of resulted items then we can use the shortcut key Fn + End.

Refer to the image where we can see the last page of the resulted list.

Sage 300cloud

4. Fn + Home:

Sage 300cloud

In the above image, we can see that the Finder pop-up screen of the Item number is opened where we select the item for entry.

As you can see there are multiple items pages listed and we are on the last page of the items list.

Now, suppose we want to navigate to the first page of resulted items then we can use the shortcut key Fn + Home.

Refer to the below image where we can see the first page of the resulted list.

Sage 300cloud

 

STAY UPDATED

Subscribe To Our Newsletter

  • This field is for validation purposes and should be left unchanged.

 

At Sage Software Solutions (P) Ltd., we are home to world-class ERP software and CRM software that will solidify your business tech support fundamentals and enable you to build a customer-centric organization. You can also write to us at sales@sagesoftware.co.in.

Disclaimer: All the information, views, and opinions expressed in this blog are those of the authors and their respective web sources and in no way reflect the principles, views, or objectives of Sage Software Solutions (P) Ltd.