Check to enable permanent hiding of message bar and refuse all cookies if you do not opt in. We need 2 cookies to store this setting. Otherwise you will be prompted again when opening a new browser window or new a tab.

[MSchappler]

Create your first deduction account at 5% and set the annual limit to the dollar value (40,000) and also set the percent base to the account suffixes of the earnings accounts that make up the ceiling amount.

Once the amount 40,000 earnings has been reached the deduction account will stop deducting. You can then add the second deduction account at 7.5% – in the new calendar year you can set this second deduction to inactive.

From the reverse, you could set up two deductions accounts at the same time and leave the annual limit blank in the paycode window for the 7.5% account and set the 2.5% deduction to 1000 on Annual Limit (line 7).

Regards to All,

Martin

[MSchappler]

You can use Print > Account Ledgers on your accounts (NewViews > Account > AP and etc ..) and then Set the destination to display which will show the data in Excel. From Excel you can save the spread sheets to files that you can then forward to CRA.

I suggest that you review the Select Columns button in Print > Account Ledgers to choose the columns for your output to Excel.

Regards to All,

Martin

[MSchappler]

Copy the source application database file and then paste it to a target location of your choosing and then rename the target application database file to an appropriate name. Open your workstation and add a row and select the application database under the file column.

Before entering the target application database, right mouse click Tools > Script Evaluate > and select the following script:

nv2.exe > system > database_id_set.qw_script

Select the target database and click OK.

Enter the target application database and perform the default setup and then re-enter the application database. Remove the transactions from NewViews > Account > Ledgers that you do not wish to be shown using Block > Delete.

Regards to All,

Martin

[MSchappler]

No Worries.

Upload the application database again and then email me at support@qwpage.com that the file is here. When I have it, I’ll see that it is worked on for a quick return to you.

The journal will be moved to NewViews > Journal > General.

Regards to All,

Martin

[MSchappler]

Upload the application database for Monday morning September 14, 2009 and you should have them back the same day or Tuesday.

The journal will be moved to NewViews > Journal > General

E-Mail me at support@qwpage.com that the application is here.

Regards to All,

Martin

[MSchappler]

Perform Print > Checks again and set destination to Display (F3 to select) and then click Print. Are all of the checks displayed in Excel?

Does File > Print Preview display the separate checks?

What version of Excel are you using?

Email me at support@qwpage.com and quote this forum posting an attach the template you are using.

Regards to All,

Martin

[MSchappler]

Sorry for the delay.

Use your Application database for now and I will schedule a time for the journal to get moved.

I’ll let you know later today.

Regards to all,

Martin

[MSchappler]

Erlinda,

Yes. You can install NV2 on your new system and then copy the application databases to the new system along with the workstation.nv2 file.

Once NV2 is installed on your system, select the windows start button > All Programs or Programs > NewViews 2.0 > Register. A lock number will be displayed, qoute the displayed lock number along with the above message and email it to me at support@qwpage.com and I will register your system via return email.

Do not close the displayed registration screen. Leave it displayed on your screen until you receive a response from me.

Regards to All,

Martin

[MSchappler]

An Update.

The application database will now convert to 2.15.0 without a problem but the original workstation (with instance explorers) will require a new database explorer.

If you have changed the database ID of the application database above, you will not be effected.

Once the application database is converted the VIREMENTS journal will still be part of the root Bank Journal which will allow you to continue working. You can upload the application database again and we will move the VIREMENTS journal to NewViews > Journal > General for you without charge.

Regards to all,

Martin

[MSchappler]

OK. I’ll make sure the conversion to 2.15.0 sets the VIREMENTS journal to be of type JOURNAL/GENERAL.

Are you OK with the new database explorer after the script above? You can set unique desktops with the Tools > Script Evaluate:

nv2.exe > object > System > gui > desktop_create.qw_script

Perform this from the dark blue title bar of the Report Desktop. It works on Accounts, Journals, Payroll, and Reports. This script was introduced in version 2.09 to perserve the uniqueness of desktops in Reports.

Regards to all,

Martin

[MSchappler]

The above script reset the windowing structure of the application database. Your other application databases are not affected.

You can restore the workstation prior to doing the database_id_set.qw_script and continue. The problem with the workstation you had uploaded had each account and report set as a separate instance explorer (independant of each other). Did you set this up on your own?

In converting your application database to 2.15.0, we’ve noticed that you have a bank journal setup under NewViews > Journal > Bank that is not a Deposit or a Payment journal. What type of journal is this? Should it be a Bank Deposit or Bank Payment journal or a General Journal? The 2.15.0 version will be disallowing journals that do not fit in Bank > Deposit or Bank > Payment. Could this journal be moved to NewViews > Journal > General?

If the journal is moved to Newviews > Journal > General, there may be a way of saving your original workstation from not disappearing when perform File > Exit NewViews.

Let me know.

Regards to all,

Martin

[MSchappler]

Create branch accounts in NewViews > Account > Accounts Payable by clicking on the Accounts button and select Folder Management. From the blue table, right mouse click View > Sorted By > Select Index and choose /description > /interactive. This will sort the Accounts Payable by folders.

Insert new rows by pressing the insert key. Under Type press F3 to select Folder.

If the Vendor is United Parcel Service and you have an account by State, you can create the following under Folder Management:

Line Folder Name Description

1 FOLDER UPS United Parcel Service

add other Vendors here.

Once entered, cursor off the row entered and you will see Unit Parcel Service appear below Accounts Payable as page (as opposed to a folder). Click on the page which will show you a blank blue table. From this table, insert new rows for each state as follows:

Line Folder Name Description

1 FILE ALABAMA UPS Alabama
2 FILE ALASKA UPS Alaska
3 FILE ARKANSAS UPS Arkansas
4 FILE ARIZONA UPS Arizona

etc .. for each state.

Enter all invoices for UPS in state account.

Enter the address details in each account numbers Address Field (or select Accounts > Address under Folder Management). I suggest that for now, that you enter the account number under Salutation in the accounts Address table.

To print the AP checks for the Vendor UPS, use Tools > Pay Account. You will need to modify a check_AP template under c:nv2NV2.Datobjectnewviews and add the following defined name to where you wish to print the account name:

CONTACTSALUTATION

Save the template under a new name after making your changes.

Substitute the states above with your actual account numbers for each vendor.

For more information, see the following from the NewViews 2.14 Manual (Hel > Manual):

Printing > Document Tables > Naming Cell in Excel
Setting Up the Books > Adding Sub-Accounts
Setting Up the Books > Adding Accounts

Regardst to All,

Martin

[MSchappler]

Yes. I have the file and it is usable.

I can duplicate your problem. It appears you have set your explorer to display shallow instances. This method was discontinued in early 2006. I am currently testing to see if the workstation and application databases will convert to 2.15.0.

To remove the problem of the explorer tree from disappearing, you can run the following script from the workstation table by selecting Tools > Script Evaluate:

nv2.exe > system > database_id_set.qw_script

The above script will change the database ID of the application database and allow for default setup of a new window explorer to take place.

I’ll know more about the conversion of both databases by Monday.

Regards to All,

Martin

[MSchappler]

Can you upload a copy of the workstation before the explorer disappeared?

Upload it to the above and call the workstation DJOBINW.ZIP

Regards to All,

Martin

[MSchappler]

When you say you have lost the explorer I’m assuming upon entering the application database you are faced with a pink desktop screen with no possiblity to navigate within the application database (the books).

If this is the case then zip up the workstation.nv2 and the database.nv2 files to a file called DJOBIN.ZIP and upload it to the following URL address for review:

ftp://ftp.qwpage.com/pub/incoming

Copy the zip file through windows explorer and then open the above URL in the explorer window and then right mouse click Paste to begin the upload.

I’ll review it and prevent it from occurring in 2.15.0.

Regards to all,

Martin

[Author]

Posts