Database Manager

The Lentune Database Manager

Introduction

Database Manager


Introduction

An overview of the Lentune Database Manager.

  • Go to Settings > Database Manager.

Return to Top of Page


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