The Lentune Database Manager
Introduction
An overview of the Lentune Database Manager.
- Go to Settings > Database Manager.
Database Manager
An explanation of the fields on the Database Manager screen.
Title |
What Does It Do? |
Notes |
---|---|---|
Database Name |
The name of your database. This is mainly used for reports and email subjects. |
|
Default Currency For Database |
Your site’s default currency. If an account doesn’t have a currency specified, this default currency will be used. |
|
Default Country For Database |
The default country of your site. When maintaining addresses within the system the country here will be referenced (though most areas will allow you to override the default country). |
|
Default Company For Database |
The default company used for your site. This mostly applies to financial scenarios such as when posting a transaction or creating a batch analysis but it’s also used when sending a purchase order if the branch on the PO doesn’t have a company set. |
|
Default Branch For Database |
The site’s default branch which is applied when creating delivery notes, payable accounts, a quote from the quick search screen and other similar areas. |
|
Default Department For Database |
This is used in a lot of places: when you post or transfer an account transaction, post a cash book statement transaction, create expense batch analysis (CostConType11, CostConType3, LentuneLtd, LentuneLtdCashBookGST), create a dealer, create a deposit account, settle loan applications, create fixed assets, create a general ledger journal, create/import payable accounts, create/approve payable invoices, create receivable accounts, or post a stock transfer. |
|
Default User For Database |
The default user for scheduled tasks. |
|
Default Staff For Database |
The default staff for scheduled tasks. |
|
Region |
This is used in a Procore callback to determine if we need to replace lentune.co.nz with lentune.com.au. |
|
Cash Book Module Active |
Turn off/on the Cashbook Module. |
|
General Ledger Module |
Turn off/on the GL Module. |
|
Receivable Module Active |
Turn off/on the Receivables Module. |
|
Payable Module Active |
Turn off/on the Payables Manager. |
|
CRM Module Active |
Turn off/on the CRM Module. |
|
Fixed Asset Module Active |
Turn off/on the Fixed Asset Module. |
|
Stock Module Active |
Turn off/on the Stock Module. |
|
Quote Module Active |
Turn off/on the Quote Module. |
|
Yard Module Active |
Turn off/on the Yard Module. |
|
Project Module Active |
Turn off/on the Project Module. |
|
Sales Module Active |
Turn off/on the Sales Module. |
|
Finance Module Active |
Turn off/on the Finance Module. |
|
Time sheet Module Active |
Turn off/on the Timesheet module. |
|
Customer Portal Module Active |
Turn off/on the Customer Portal. |
|
Subscribe To Lentune Analytics |
Subscribe to the Analytics/Power BI Module. |
|
Subscribe To Lentune Analytics For ERP Financial Reports |
Subscribe to the ERP view of Analytics/Power BI |
|
Deposit Module Active |
Turn off/on the Deposit Module. |
|
Fixed Loan Module Active |
Turn off/on the Fixed Loan Module. |
|
Variable Loan Module Active |
Turn off/on the Variable Loan Module. |
|
Payment Claims Module Active |
Turn off/on the Payment Claims Module. |
|
Dealer Module Active |
Turn off/on the Dealer Module. |
|
Base Color |
Change/customise the Lentune colour scheme. |
|
Auto Lock After Duration (Seconds) |
If more than one user is logged in to a PC at the same time, a user can be automatically logged out after a defined period of inactivity. This only applies when multiple users are logged in to the same browser/PC. If only one person is logged in it won’t apply. |
|
Configuration Issue Email Address |
The address used by the system to send notifications. |
|
Consolidate Same Entities |
Consolidates entities with the same description. |
This will run as soon as you click it, there’s no ‘are you sure’. |
Consolidate Same Contact Points |
Consolidates contact points where all the following things match: Entity, Type, Description, Delivery Address, Street, Suburb, City and Postcode. |
This will run as soon as you click it, there’s no ‘are you sure’. |
Consolidate Staff |
Choose 2 staff records, one to remove and one to keep, then combine them. |
|
Portal Logo |
Upload a logo file for the customer portal. |
|
Move Account |
Select a receivable account and move it from its current company to a different one. |
|
Rebuild Account Month Balances (Use With Caution) |
This is unlikely to ever be needed as the month balances should be correct but it can reset the month balances to zero and then completely recalculate them. |
This shouldn’t be run without significant investigation into why it needs to be run. It will also likely take a very long time. |
Run Health Check |
Checks the system for any financial discrepancies. If there are none you will get a green OK message. If anything isn’t as expected, you will get an error message asking you to contact support. |
If an error occurs and a customer contacts support, support (or a developer) will need to do some digging to work out what the problem is, it won’t tell you. |
Custom References Setting |
On a timesheet user there is a Custom Reference section. By default, each field is named Custom Reference 1, Custom Reference 2 and so on. This setting allows you to rename that label. |
|
Was this helpful? If you need more information, or would like to contact us about this article, please email us at support@lentune.com.
Thank you. We value your feedback.
Last updated: 18 January 2023