Navigation:  Settings > Database Maintenance >

Optimize Database

Previous pageReturn to chapter overviewNext page

Main Menu > Settings > Database Maintenance > Optimize Database (T > D > O)

You can use this to shrink data, remove temp data, rebuild data and delete activity log.  FusionRetail 6 keeps the entire activity log which you may want to remove to save on space taken up in the database.

This also helps you to find inconsistent transactions. If inconsistent transactions is found, which is unlikely, you will be presented with a suggestion to either modify it or to delete it. You can directly open an inconsistent transactions in modify mode by pressing enter key and to delete a transaction use Ctrl+D.

Optimize Database Buttons:

–A Account

Although this report was created to check the voucher consistency, you will never require this report. This shows the accounting vouchers where total Debit amount do not match total Credit Amount along with difference amount and suggestion at every row level.

-I Inv Acc

This shows all inventory transactions where corresponding accounting entry is not present along with suggestion and remark.

-M Inv Mop

This shows all the sale transaction where bill amount and tender amount is not same.

-O Optimize

Use this to shrink database, remove temp data, rebuild data and delete activity log.

Related Faqs:

-D Discrepancy

Use this to display and remove partial transaction data.

-H Inv Header

This shows all the transactions where Total quantity/Total Amount/Total Tax Amount of Register in Voucher View does not match with Register in Product View along with suggestion at every row level. In this view Header implies the Voucher View and Detail implies the Product View.

Optimize Database Options

Main Menu > Settings > Database Maintenance > Optimize Database > Optimize