Separate Accounts and Payroll Databases (Enterprise 2018)
Options
Mark Saunders_9755253
Member Posts: 3 ✭
Hi Team,
We are using Reckon Enterprise 2018 and our Database file is apx. 1.5Gb.
This has started to cause issues whereby when running Payroll, we cannot pull reports or access the Database as usual.
Recommendation has been to move Payroll Processing onto a new .QBW Database file and keep our Accounts processing on the original .QBW.
We will eventually have to move our Accounts Processing to a new Database (.QBW) as well.
Questions:
1. How do we create a new .QBW file specifically for Payroll?
2. What data would we need to export and import to make sure we can carry on with Payroll Processing as usual on the new Database file?
3. How would we arrange this data Export and Import.
Would really appreciate any guidance you could offer.
We are using Reckon Enterprise 2018 and our Database file is apx. 1.5Gb.
This has started to cause issues whereby when running Payroll, we cannot pull reports or access the Database as usual.
Recommendation has been to move Payroll Processing onto a new .QBW Database file and keep our Accounts processing on the original .QBW.
We will eventually have to move our Accounts Processing to a new Database (.QBW) as well.
Questions:
1. How do we create a new .QBW file specifically for Payroll?
2. What data would we need to export and import to make sure we can carry on with Payroll Processing as usual on the new Database file?
3. How would we arrange this data Export and Import.
Would really appreciate any guidance you could offer.
0
Comments
-
Hi Mark
I wouldn't recommend moving just the Payroll to a separate file as you need payroll figures (in real time) within your company file financials! Only Lists are able to be exported/imported - not transactions - so if you're going to start a new Company File, I'd advise doing so in its entirety (eg incl Payroll)There are a few things you can try first to decrease/optimise your company file including ....
- Verify the Co File & Run Rebuild 3 times
- Delete the .tlg File (Backup first!)
- Re-sort all your Lists to their default order
- Delete any transactions sitting in Print Queues
- Defragment Co File DB & - if necessary - also your PC HD / Create & Restore Portable Co File
http://kb.reckon.com.au/issue_view.asp?ID=3793
Hope that helps.
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 63 About Reckon Community