IntroductionThe Multi-DB feature allows you to maintain company-wise data in separate databases when you run more than one company. It enables the user to create multiple companies (other than the default company) and provides an option to select the company at the time of login. All data entered or created in a particular company login will be stored in the respective database. Thus, user can create masters, make transactions, maintain the transaction data, accounts details and reports in separate databases for each and every company created. This is helpful to track company-wise transactions and reports separately.
Business Scenario
In cases where the POS is integrated with HQ, the default company is linked to HQ. All the transactions, reports & accounts created and maintained in the default company will be reflected in HQ. Any new item can not be created or sold from the default company as the items created under HQ environment alone can be considered for sales and other transactions.
For users who owns a second company (in addition to the default company) and want to maintain the data and reports in a separate database, multi-DB is recommended. With this feature, the user can create a second company in which the user can add new master data and make all the required transactions. Thus, multi-db plays a vital role for users who need to create two or more companies, want to maintain all the data in separate databases.
Apart from this, the details of sales, purchase and other transactions will be posted in separate accounts for each company. For VAT submission, the VAT reports can be generated separately for each company. This enables the user to view or maintain company-wise accounts and VAT reports.
For HQ customers, the default company database alone will sync with HQ. The other companies created are standalone companies and work independently of each other.
Remarks:
1. By default, Multi-Db feature is not enabled in the product. To buy this feature, you need to get a separate custom license.
2. With one custom license order, you can create up to 3 companies (other than the default company). To create more than 3 companies, you must purchase another custom license.
Steps to create Multi-company
Current Limitations :
No.
|
Features supported
|
Default Company
|
Other Companies
|
1
|
Offline Billing |
Yes
|
No
|
2
|
Snapshot |
Yes
|
No
|
3
|
VSS |
Yes |
No |
4
|
RayMedi Alert & GoFrugal Alert
|
Yes |
No |
5
|
Web Reporter |
Yes |
No |
6
|
Practice data clean-up |
No
|
No |
7
|
HQ
|
Yes
|
No
|
1. The memory space occupied by the other companies data will not be shown while checking the DB size
2. In client backup, the backup of the default company database alone can be taken since offline billing is not supported in other companies
3. While doing re-installation, the transactional approval window will show only the default database transactions
4. Backup restoration can be done only via DB maintain tool
5. Restoring the old data of the default company alone is not recommended but restoring along with the other companies data is recommended
6. For Paint vertical, this feature is not supported
7. Users having more than one company in RPOS7 can not use this feature
8. This feature is available only for the professional edition
9. In Beauty parlour/Hair Salon vertical, 'SOT Appointments' module works only for default company and not for the other companies
For FAQs: click here