Forum Replies Created
-
Posts
-
Currently you cannot import data into NV2 from Access or Excel. You can howewever import data into NV2 exactly like you could into NV1 using the IMPORT procedure. Importing into NV2 will be expanded in updated versions of NV2.
In NV2, you can right mouse click Tools > Import Records. An Import Records window appeaars prompting for a file name to import. See the NewViews 2.08 Manual > Appendix D – Importing Files into NV2 for more clarification of file formats / File Layout and how it works. The ASCII format is fully implemented as of NewViews 2.08. FIXED Length Records will be implemented in version 2.09.
As for writing scripts in NV2 (procedures), documentation may be added at a later date in the manual about this. See the NewViews 2.08 Manual > Appendix A > What’s Coming > Programmer Interface for some more information about this.
The NV1 procedures you had mentioned above are in NV2. Procedures like BLKCOPY and BLKPASTE in NV1 are located in the Block Folder (right mouse click on your table and plus on Block > Copy and/or Block > Paste). Block Copy and Block Paste is currently implemented in NewViews > Account > Sub Folders and NewViews > Journal > Sub Journals and posting accounts. It is not implemented in NewViews > Payroll yet. COPYCOL is under Tools > Fill Column (right mouse click on your table Tools > Fill Column).
GOX is on F9 (see Help > Keyboard for a detailed list of the Function Keys preprogrammed with NV2). XACCT is now F3 when choosing a posting account and RENAME is no longer present as you have the ability to change the name of an account that has postings in it by changing the name of the account from the blue table displaying the account names.
Regards,
Martin
Your printer is resetting itself. Issue /PAA (Print Advance Align) before sending a print job to ensure that your Print Options are respected.
To automate this, you can run JIG and give it a name and add the following code:
~pa”a”.
Run the procedure FKEYS and place the name used (above) on an unused function key.
Regards,
Martin
The is the procedure TOTAUDIT (productivity disk #5) which will allow you to print or review the total structure of a total account.
Another method is to run the procedure GO and press enter. Press /A and then type the name of the total account. Press /E (to expand) to see all of the accounts totaling to the account. To print, issue /X (enter) N (enter) 0 (enter).
Regards,
Martin
It sounds like you have purchased the update to productivity disk number 7. RUn GETLIB and type NV1PD7 and press enter. PRTCHKS should work now.
Regards,
Martin
If you want to print non-zero accounts set skip zero balance accounts to no. This will print all accounts on the setup view of the report.
Regards,
Martin
Change the view in the customer postings explorer to open (right mouse click on the green table View > Open). Check the account reconciliation.
Regards,
Martin
Go into the postings explorer of the customer account and right mouse click in the posting explorer (green table) View > Open. This will show you all of the open invoices in the customer account. Print > Statements prints the open items plus the items specified from the Print Statements screen.
Check your customer account reconciliation.
Regards,
Martin
Moving your old/inactive accounts from current reports to an old old/inactive report is a good way of organizing the NV1 books for presentation for printing in NV1. However, moving these accounts does not mean they do not need to be ATYPE’d for NV2. These accounts must be ATYPE’d so they come in properly in NV2 under NewViews > Account > Account types. I suggest that you review the NV2 Demo books to see a clearer picture of what I mean.
Setting up an Old Accounts Receivable Report etc does make things clearer in NV1 as well in NV2 as the report setups in NV1 will come over to NV2 after the NV1 Import has been performed.
Regards,
Martin
Run the procedure REPORT > Print Setup > Use Setup View Settings and set the page formatting and set skip zero balance accounts to yes.
Make sure that the company is specified under Global Settings.
Regards,
Martin
The PRTNON0 procedure in version 12 has its own print options. You could export the version 10b procedure code and bring into your books to prevent the print options from appearing. Get the 10b diskettes and install just the procedures (this will install the procedures in C:NVPROC).
Go into your books and run the procedure GETPROCS and enter the following:
Procedure(s) to import [PRTNON0 ]
Path to procedure(s) [C:NVPROC ]
Overwrite procedure(s) (YNP) [Yes ]
Preserve procedure notes [No ]Press F5 to continue.
Regards,
Martin
One of the journal accounts specified in Journals under NVEXPORT totals to an account called CASH on the Balance Sheet.
You can do one of two things:
1. Move the offending journal account off of your journal. To do this change the report name under Rep from JR (if your journal report is called JR) to another report in your books. You could create an account called NON-JR in your books and
move this journal account from JR to NON-JR.2. Unhook the total to on this journal account from totaling to the account called CASH on your Balance Sheet.
Run NVEXPORT again.
Regards,
Martin
Below is help from the NV2 online manual about this subject.
Journal X totals to account Y on non-journal report Z
The journal specified has been totaled to an account that is not on the journal report. In NV1, a journal should always have a zero balance; therefore totaling a journal to an account elsewhere in the books does not make any sense.
If the journal balance is zero (for all history periods), remove the total-to. This will have no effect on the rest of the books.
If the journal balance is not zero, it is quite likely that the account is not in fact a journal, and therefore should be moved off of the journal report.
The employee copy from an existing employee has been fixed in the latest update. You can download version 2.08.4 from http://www.qwpage.com.
Regards,
Martin
You can use Item_Account on your Accounts Payable templates. It must be within Item_Area.
Additional fields will be added to NV2. See the Help > Manual > Appendix A > What’s Coming for a list of Improvements coming to NV2.
Regards,
Martin
