Forum Replies Created
-
Posts
-
There is a method currently to template an NV2 application database to a new application database but it is not as elegant as NV1 Make Books by choosing a template that you had created with the following command:
nvreorg NV1BOOKS /TEMPLATE:TNAME
Create a new application database from the workstation table by entering under the file column thus:
mynewbooks.nv2
Open the application database to which you will receive a message that it dows not exist, do you wish to create? Answer Yes and allow the default setup to complete.
Once done, open the mynewbooks.nv2 application (target) database and the current (source) application database on your workstation. From the target application database create the reports from Newiews > Reports and click on Folder Management and enter the report names and descriptions that appear in your source application database. From each source report (Account Setup) click block all (ALT BA) and then issue Block Copy. Enter a reusable Current Settings name and press enter (after clicking the new button) and Press F5 or the Copy button. You will see in the Block Copy/Paste Window what your have copied. Click the Save to Clipboard button (or F6) to copy the contents to the windows clipboard.
Go to the report in the target application database (Account > Setup) and issue Block Paste and click the button Load from Clipboard (or F7). You will see the contents copied from the source appear in your Block Paste taget window. Click the Paste button.
Repeat these steps for your other reports. As you proceed you will begin to see mynewbooks.nv2 will look like your source books.
I suggest that you close the target books after pasting a few reports to create a safe point.
Once complete, issue Tools > Script Evaluate from the (close the target) workstation table and select the following script:
nv2.exe > system > database_id_set.qw_script
When the window appears, navigate to mynewbooks.nv2 by clicking on the folder button.
Once the database has been changed, you can use mynewbooks.nv2 or even copy it to another location to create other application databases from it. Remember to change the database ID as per the script above.
Regards to All,
Martin
You can set the destination (Print > Checks) to display and and from the displayed check in Excel you can alter the address displayed in Excel.
To permanently have the correct address displayed, go to the vendor account and select the Address button and change the address of the vendor in this table.
Regards to All,
Martin
Open the template in Excel 2007 and right mouse click on the logo and select Format Picture and select the Properties Tab. Select the Move and size with cells radio button and click OK. File > Save the template.
This seems to be a problem with Excel 2007.
Regards to All,
Martin
Check the Normal representation of the accounts in question by selecting the Accounts button > Setup and review the Normal Rep column. If the column is blank block the accounts (Block All) and set one account to Periodic (press F3 to select) and then isssue Tools > Fill Column to set all of the block accounts to Periodic.
From the columns where you have set your dates ranges, select a value in the particular column and press F11. Enter your begin and end dates and set Respect Normal Rep to Yes. This will show you the ledgers for the date ranges asked for.
If your accounts above have a normal rep set to Perpetual. Press F11 on a values in your columns and set the Respect Normal Rep to No.
Hope this helps.
Regards to All,
Martin
Linda,
Yes you can. Download and install the 2.16.2 version that is now available at http://www.qwpage.com.
Regards to All,
Martin
John,
It’s been replaced with the payroll update which is version 2.16.2. Download and and install it.
Regards to all,
Martin
Enter as your comment
Payment; 1207 1245 1269
Run Tools > Apply Deposits again.
Are your Vendor Trust accounts reconciled properly before issuing Tools > Apply Deposits (The Invoice aging is correct).
Regards to All,
Martin
You will need to create a new employee list for monthly payroll for your current semi-monthly employees. Create the sub-folder by selection NewViews > Payroll > Country > and select the Advanced Button > Sub Payrolls > Folder Management. Insert a new for the new monthly payroll and then select Employees > List and add your employees with a new prefix. You can use Tools > Copy Existing Employee Accounts to copy the existing semi-monthly employee layout to your new Monthly sub-folder.
I suggest that you have this done for the first payroll in 2010.
Regards to All,
Martin
To correct the W2 list, go to the employees list and click on the employee and select the Transactions Tab button and select Paychecks. Adjust the FICA wages for a paycheck in 2009 for the 142.17 difference.
The W2 list collects the amounts from the employees paychecks columns.
Regards to All,
Martin
The reconcile text is not date sensitive which will not provide you with an Aging as of date. The Aging is real time with the transactions reconciled as they are now.
Copy the application database to a new target location and then change it’s database ID and go into the copied application database and then unreconcile the transaction to print the report for your clients.
A good method to avoid the above is to enter all month end transactions before posting payments in the following month and then backup the application database and name the application database to company_name_monthend_date.nv2 and change it’s database ID so as you can print the aging as of the previous month end and with th current application database where the payments were entered and reconciled show the current payments in an Excel spreadsheet.
Regards to All,
Martin
Email the template you are using to support@qwpage.com and quote this form posting in the text.
Regards to All,
Martin
Click the Accounts Tab button and select Setup. Look for a column called Ledger Indexed. Set it to Yes (I suspect this is a total account, other bank accounts make up this balance) by clicking on the blank value and press F3 and select Yes.
Once selected, cursor off of the line or press F5.
For Journals, select the Journals Tab button and choose Settings. Look for a column called Transactions Indexed. Set it to Yes.
Regards to All,
Martin
Click the Accounts Tab button and select Setup. Look for a column called Ledger Indexed. Set it to Yes (I suspect this is a total account, other bank accounts make up this balance) by clicking on the blank value and press F3 and select Yes.
Once selected, cursor off of the line or press F5.
For Journals, select the Journals Tab button and choose Settings. Look for a column called Transactions Indexed. Set it to Yes.
Regards to All,
Martin
Add detail items to the Pay Check details after processing the next Payrun and manually add the missing details referencing the April 2, 2009 Check in the Notes Tab button of the Pay Check.
Regards to All,
Martin
