[MSchappler]

Check the Normal Representation column of your Trial Balance accounts and ensure that the Balance Sheet accounts are set to Perpetual and the Income Statement accounts are set to Periodic.

The Balance Sheet accounts should be totaling to the Proof Account at the bottom of the Trial Balance Report which must be set to Perpetual. The Income Statement accounts should be totaling to the opening Retained Earnings account which totals to the Proof account. This Opening Retained Earnings account normal representation must be set to Opening. Set the dates on the Trial Balance Tab to your Fiscal Year and then menu select Print > All and check your balances via Excel.

If you still do not balance, check the normal representation of your accounts again for errors and the totaling explained above.

A proper example can be found in the Canadian and U.S.A. demo books by select Demo Books from the NewViews 2.0 menu..

Regards to All,

Martin

[MSchappler]

For now, use the Print Detail Windows in the General Journal which will print the details and then Block All of the General Journal ledger. Once both are in excel, you will move to merge the ledger with the details manually.

A better method for performing this task will be included in the next update to NV2.

Regards to All,

Martin

[MSchappler]

I suggest that you download the updated Auto Reconcile script from the following URL address:

https://newviews.com/improved-auto-reconcile-tool-now-available/

If you encounter a problem with the updated script then email support@qwpage.com the OFX file(s). Include the .qbo and .qfx file(s) if you have tried the other formats. Include that these files were generated from the Royal Bank.

Regards to All,

Martin

[MSchappler]

Block the desired Purchase Journal Entries and then issue Print > Detail Windows and set lines 1 to 3 to None (Press F3 to select) and Include Empty to No. This will output all entries to one sheet.

You can set Item Separator to Sheet if you wish each item to appear on a separate sheet.

Regards to All,

Martin

[MSchappler]

I suggest that you review the CRA documentation regarding the Quick Method of Accounting for GST/HST.

Use your desired search engine to search for quick method hst. From the documentation, you still have to maintain proper records for GST/HST sales and purchases.

Regards to All,

Martin

[MSchappler]

Hello Cameron,

Sorry no. When a procedure is displayed you can ^D ^S ^E ^X etc which provides the movements but these characters are ignored when programming the display prompt.

An alternative would be to write a custom procedure that imports the data but this would have to be altered each time and for non programmers could be quite dangerous if something is altered that should not be.

Entering the dates in the prompt is the easiest.

Regards to All,

Martin

[MSchappler]

You can give the application database to whomever you wish.
This is the wrong place to ask about how to convert NV2 data to another accounting package. Try the target software package.

Regards to All,

Martin

[MSchappler]

The text on your description lines for the various earnings maybe too long to display when printing the paycheck.
You can use the following in the description:
@T hrs x @R / hr @Y YTD
which produce the following in the paycheck details:
15 hrs x 15.00 / hr 10305.00 YTD

If you have @Y YTD in your earnings description and it displays in the paycheck details but it is too long to display on the paycheck, you can go into the template and set the description field to Shrink to Fit using Format cells.

Regards to All,

Martin

[MSchappler]

The error message indicates that CrossOver has not implement Windows COM objects in it’s environment.

NewViews uses COM objects to direct output to Excel and Word.

Regards to All,

Martin

[MSchappler]

This problem should be fixed for the next update to NV2 which will be 2.28.2.

The problem occurs if the report is in a sub folder. You can move the report to the root of the report folder and then make it a Private Setup. Moving it back to the original sub folder will not keep it private.

Regards to All,

Martin

[MSchappler]

Navigate to NewViews > Account > Expenses on the Database Explorer and select the drop down arrow above the Accounts button tab which will display a selection list. Select Trade Tax Info which will display all of your expense account Tax 1 and Tax 2 statuses. Click on the applicable expense account and press F3 under the Tax 1 Status column. Select Exempt to make the expense account exempt from Tax 1. Do the same for the Tax 2 Status if applicable. From this table you can specify which expense account are exempt from taxes. The default is taxable which is set in the Purchase Invoice Journal.

An alternative to the selecting the drop down arrow above the Accounts tab is to press Ctrl F11 and select the drop down arrow next to current settings in the Define Columns window and select Trade/Tax Info.

Regards,

Martin

[MSchappler]

Are you posting payroll through a journal other than CANADA or USA? Check the Journal column of your Bank entry to determine.

What version of NV2 are you using? The latest version is 2.28.1.

Send a screen display of the bank entry showing the details and include the Personal Info tab for review to support@qwpage.com.

Regards to All,

Martin

[MSchappler]

Where are you printing the checks from? Updating the Personal information updates all areas for Print Checks.
Can you provide some more information from where you are printing the checks from? For example, the Bank Account, Payroll Journal, Payruns > Print Checks window.

Many thanks,
Martin

[MSchappler]

I wonder if there is a problem with the workstation that you are using. Create a new workstation on your machine and enter the application database and redo Print Account Ledgers > Simple on some of the accounts you have mentioned.

If this works, select Default Setup on the report title bar and click setup using the original workstation.

I would need to see a copy of the application database as from your posting you seem to have checked the Print > Account Ledger settings.

Regards to All,

Martin

[MSchappler]

I suggest that you backup your current workstation and then on the purchase invoices when where your are encountering this error, right mouse click on the blue title bar and select Windows > Default Setup. Click setup and this error message will not appear.

You could also restore a workstation backup and continue entering your purchase invoices.

Backup your workstation at least on a weekly basis.

Regards to All,

Martin

[Author]

Posts