Forum Replies Created
You must port forward port 7890 to your router. The instructions vary depending on the router model you are using. But generally you must access your router. This can be done by typing 192.168.1.1 as an address in your internet explorer. You will then be prompted for a user name and password. Fill in your user name and password respectively. Afterward you should have an option for port forwarding. For more information on how to port forward for you router use a search engine and search for “how to port forward for your router model”. Usually they give a much more detailed explanation than to the one I am giving.October 7, 2010 at 3:34 am in reply to: Print to Excel 2003 suddenly is funny on a dual screen monitor #14257
I to use dual screens and have never come up with this problem. Can you please give us more information such as what your operating system is and what is your screen resolution.
Also I would like to note that excel seems to open up in the same position that it was last used. For instance, if I had excel open up in one screen and I closed it, next time I print it comes out on the same screen. Likewise, if the last time I used excel and it took up two screens, when I print to excel it takes up two screens.
So, in my opinion try opening excel on one screen, close it and then print to it. Try to see if that fixes the problem.
What that error message states is that there is no credit account set. And as you know every transaction must have a debit and credit. When using the NV1 style transactions NewViews automatically inputs JOURNAL_BAL as the credit account. Sometimes these defaults are cleared. To restore this back to the default setting delete the current transaction that is causing the error and run a default setup on your journal.
The default setup can be accomplished by right clicking on the blue title bar, where it should say something in this manner (/JOURNAL/GENERAL/GENERAL – NV1 Style Transcations). After right clicking on the blue bar a menu will pop up, hit the + on window and select default setup.
After performing the default setup return to the NV1 Style transactions and try to create a transaction, hopefully the issue will be resolved.
I have performed the same procedure on a copy of my set of books and it works perfectly fine. Except, when I have the original database open. Please ensure when changing the database ID that the original database or the copy is not open.
P.S You no longer need to press F6 to see the ledgers of an account, just double click on the account.
In the versions after 2.14, Ledger indexes are turned off by default. That means that you will not be able to view the ledger of total accounts unless you turn them on. Ledger indexes have been turned off in the current version to increase speed and decrease database size. To turn ledger indexes on, go to the blue screen, change your view to setup (accounts + > Setup). After changing to the setup view you will now see a column that says ledger indexed, simply put the word “yes” in the rows where you want to see the ledgers. This only has to be done to total accounts, posting accounts will have no issues when viewing ledgers.
Perpetual amounts will be displayed unless you click on an amount field. This makes more sense when viewing all other views, Custom, multiple period, or budget.
Change the tag from financial to budget to view budget amounts.
Other than doing a Print Screen and pasting to a program that will print, the total explorer cannot be printed at this moment.
Use the Budget view or the Custom analysis to view a Budget-Actual report.
Do not use the Define Column to setup the Multiple Period Analysis. Here is cut and paste from our manual.
Customizing the Analysis Window for a Report
To customize the Analysis window:
Activate the report for which the analysis is to be customized.
If the Analysis window is not displayed (the title bar should read /REPORT/(report name) – Multiple Period Analysis), use the window select button at the left of the title bar to choose the Analysis window.
Issue the command View>Analysis>Column Setup>Edit Settings and fill in the column setup table as described above.
If you want to change the order of the columns for the analysis, issue the command View>Analysis>Column Setup>Display Forward or View>Analysis>Column Setup>Display Backward.
To specify the resolution (number of columns) for the analysis, issue the command View>Analysis>Resolution and choose None, Year, Month, Three Month, Four Week, Two Week, One Week, or Day.
To specify the representation of the amounts/quantities for the analysis, issue the command View>Analysis>Representation and choose perpetual, Perpetual From Range Begin or periodic.
We can only import a complete set of books exported from of NV1. The import feature that allows importing from 3rd party programs is complete and is in the testing stages. It will be available in the next several weeks.
Excel speadsheet values generated from NV2 are numbers. If you Print All/Block, you can autosum, round, etc.
How are you exporting to Excel?
I almost forgot… We recently discovered you can print negative cheques when the option to confirm invoices is set to NO. I would be surprised if this hasn’t already been fixed and just waiting for a build release.
Thanks for the heads up.
In order to transfer values from NV2 to an EXCEL spreadsheet, we had to assign names to cells/range of cells. You can’t delete the 2nd stub by highlighting it and pressing your delete key. Doing this will only delete the value of the cells but not the name of the cells. If you click on Insert > Name >Define, you will see the Cell names and what cells they refer to. More information can be found in our manual by selecting, NewViews > Printing > Printing documents > Document Templates.
You can delete the 2nd stub simply by highlighting the 2nd stub area and then right click on the highlighted area and choose Delete and delete the entire rows.
I’m using Office 2000 as well and what I see on the screen is what prints. I’m having a real hard time trying to duplicate your problem. I’m starting to wonder if the width of the column is cutting off part of the digits. Can you try widening the columns to see if its missing some numbers?
Did the program stop responding during the installation of v. 2.04 or after installing and running the program? We did not change how NV2 installs, if v. 2.03 installs, v. 2.04 should also.
There is something different about WinXP in where it will seem as if the program is not responding but a quick look in your task manager will show it is in deed running. We see this often during the setup of the different windows in NV2.
Click on the column you want to delete, hold down the CRTL key and press Delete.
ATYPE works on posting accounts only. The TATYPE procedure works on total accounts and it will correctly mark all posting accounts that total to it regardless of where they are located. In your example, all expense accounts that filter to the TE.T account will be marked as expense accounts.