[TThibodeau]

I think we found the problem yesterday.
They have an old Novell server that is constantly updating the time on the workstations. The clock on this server is gaining 30 min a day.

Thomas

[TThibodeau]

Have you tried function key F9 ?

[TThibodeau]

Hi Martin

I have tried printing with nv2.202 with office 2003 and 2010. I do not have access to 2007 today.

Printing with office 2003 windows XP sp3 system
Template t4_2010_gray_pdf.xls

The digit to the left of the decimal is not distorted. The decimal point is about half a character space to the right of the vertical line.

Using speedup command.

The digit has moved one quarter of a character space to the right. The lines of the box are not as dark. The vertical line just touches the side of the digit. (

Printing with Office 2010 Windows 7 64 bit
Template t4_2010_gray_pdf.xls

The digit to the left of the decimal Has move more to the right then any of the 2003 printing. The decimal point is about 3 quarter of a character space to the right of the vertical line.

Using speedup command.

Opposite effect of 2003. The digit has moved to the left and the line is just touching.

These test were done with bullzip pdf printer drivers.

From previous test this printer driver was equal to printing to an HP laser printer.

Thanks for the Nova Scotia payroll fix.

Regards
Thomas

[TThibodeau]

Hi Martin

Problem still continues in version 2.19.3

Thomas

[TThibodeau]

Hi Les

If you have not found your problem.

The first thing that I would check is the print setting.

Load the template and check the page setup.

Excel 2003 under file, click page setup and make certain “adjust to” is set and scaling is set to 100%.

[TThibodeau]

I believe I asked the same thing here.

http://www.qwpage.com/forum/read.php?11,2644,2644#msg-2644

2 computers
2 licenses

One computer running both server and workstation and another computer running a workstation.

The answer I was given was yes.

I have setup most of my clients this way.

I hope this answer your question.

Thomas

[TThibodeau]

Hi Kristie

I find this very frustrating too since I cannot reproduce what you describe, also I cannot find any reference to that type of change in the behavior change or bug fix.

I hope Martin visits the forum soon to clarify this. I would love to know why you can change the item_total on the sales journal and I get an error if I try on Ver 2.19.

Thomas

[TThibodeau]

Hi Kristie

I am not a QW Page employee but I do install and teach NewViews.

What you describe is not how the sales journal works but the way the purchase journal works. I have just confirmed it on a set of books.

If you try to enter an Item total amount on the sales journal you will get an error.

You can enter an after tax amount in the item total on the purchase journal and it will calculate the tax and before tax amount.
At least that is how it is working on my copy of 2.19.

Could you check again that you are on the sales journal and not on the purchase journal.

Regards
Thomas

[TThibodeau]

Hi Martin

According to the help file

The number format field is used to format the amounts/quantities displayed in the report. Press to select between none, dollar_minus_parentheses, dollar_minus_trailing, dollar and integer.

All dollar formats “dollar”,”dollar_minus_parentheses” or “dollar_minus_trailing” of a negative amount are the same (999.99).

From looking at the other formats of integer or rate should it not be

Dollar -999.99
dollar_minus_parentheses (999.99)
dollar_minus_trailing 999.99-

All these formats give (999.99)

regards
Thomas

[TThibodeau]

I assume you have mapped the shared folder where you data is stored

From the nv menu select “books”
When the new window opens hit the slash key “/”
select “drive”
you can now select the mapped drive where your data is stored

You can use the “/” key to navigate the directory structure of the mapped drive to expand or contract the folders.

[TThibodeau]

Thanks Martin

[TThibodeau]

I suspect you are trying to post to the salary expense account on your trial balance or income statement.

These are total to accounts and cannot be posted to directly as you have notices.
You can only post budget amounts to posting accounts.

When we ran into this problem there are 3 ways we found to overcome it.

1 post your budget to all the employees account on the payroll record. If you only have a few employees this is not that bad.

2 create a payroll budget report and create budget accounts that total to your salary expense account on income statement or trial balance.

3 create a fake employee named budget on your payroll record report, create all salary accounts for this employee. For example if you have salesmen that have commissions but management that have bonuses you will have to create both accounts for the fake employee. Post the budget amounts to this employee.

Cheers
Thomas

[TThibodeau]

Thanks Martin

The 3 organizations that we work with in Nova Scotia are 50% provincial also.

Thomas

[TThibodeau]

Thanks Martin

Thomas

[TThibodeau]

Hi Martin

I think we are talking about 2 different things.

Lest take it to the simplest form.

Create 2 empty databases.

Create a balance sheet report in both databases and create a total account “retained earnings”

In one database create part of an income statement.

Create a report called IS
In this report create 3 total accounts

Net income ( total this to retained earnings on the balance sheet)
Total income ( total this to net income)
Total expense ( total this to net income)

2 income accounts totaling to “Total income”
2 expense accounts totaling to “Total expense”

Now block all, Block copy, copy, save to clipboard

Open the other empty database

Create a report called IS

Now block paste, load from clipboard and paste.

Nothing will total to the 3 total accounts on IS except “net income” will total to “retained earnings” on the balance sheet.

You can see how the block paste works on large reports that total to another report.

The accounts are created and then you see a message box that says “creating total to’s”, so the accounts are created first and then total to’s are filled in.

So the question becomes why is it that when you “block paste” the above example the “total to” column does not get filled in, except for the account that is on a different report.

I hope with this example you can see what I am talking about.

Cheers
Thomas

[Author]

Posts