Database Manager
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