Database Splitting is a very important tool in FusionRetail6. It allows you to split company data across multiple periods.
Split Database option is very useful to reduce the size of your database. Splitting a database may improve database performance and organize your data in small periodical data.
After splitting the database, FusionRetail6 creates the following three files separately.
Contains all the data of the database
Splitted (New) Database
Contains data from split date onwards.
Splitted (Old) Database
Contains data before split date
You should always take a backup of the database, before splitting it. It helps you to recover the data by restoring the backup copy.
In Split Data screen you have to enter the split date in “Split From (Opening Date)” field and then click “-S Split” button
Closing of the following will be made opening on the split date.
|1.||Trial Balance (Bill Wise)|
|2.||Stock Statement (Product Wise)|
|3.||Credit Note (Same as Trial Balance)|
|4.||Orders (Purchase and Sale) : (Pending order will not be shown)|
These will not Split
|1.||Customer Points: Customer points will be same as it was before split. This will become opening balance of the next day.|
|1.||In case of multi location it is advisable to synchronize the data till the split day.|
|2.||Root and Branch has to do the split independently.|
|3.||First Split the branch database then split the HO database otherwise the opening balance will again need to be transferred.|
|4.||Split will work on the default location only: That means you need to split the database of Root Location at Root and Branch Location at Branch.|
|5.||The opening balance will only be created for the location where split is done. This means the Root Location has to get the opening balance from all the locations after split.|
|6.||The opening balance should be transferred to HO|
|1.||At Branch Location:|
|•||Be sure that the newly created opening balance was transferred to the HO.|
|2.||At Root Location:|
|•||Be sure that you got the opening balance (stock and accounts) from the respective location.|
|3.||Failing to do this will show wrong stock at HO.|
Suppose you have one HO and five BRANCHES. Today is 10-Dec-2009 and you have to split the database from 1-Apr-2009 of root location and 5 branches.
|•||Split will remove all the transaction data of all location before the input date.|
|•||It will create the opening for root location only. Not for all location – this means at this point the stock and accounts of the branch will be displayed without the opening balance.|
|•||After split the opening balance is created for the location where you are splitting the data.|
|•||This opening is also goes to other location based on the ML rules. It create data in outbox.|
Note: The book begins date will be set to 1.4.2009 in the above case.