Forum Replies Created
-
AuthorPosts
-
MSchapplerModerator
Tom,
I have pasted the help on decompressing transactions from the NV2 manual below. The help can be found in the NV2 Manual by clicking on the plus next to Appendix B – NV1 Users > Converting NV1 to NV2 > Decompressing Transactions.
Regards,
Martin
DECOMPRESSING TRANSACTIONS
Compressed transactions are recorded in Journal/General/DOS NewViews Import/Compressed Transactions. A summary debit and/or credit entry is posted to each account for each month prior to the “Begin Full Detail” date, and a balancing entry is posted to GENERAL account “COMPRESSED_TRANSACTIONS”.
To decompress summary transactions, mark a block of transactions and issue the Tools>Script Evaluate command. A prompt window to select a script file name is presented. If you installed NV2 in c:/nv then select the script:
c:/nv/nv20.exe/object/newviews/journal/general/decompress_transactions.qw_script.
If you installed NV2 in another directory, substitute c:/nv with the appropriate directory.
Transactions should be decompressed “bottom up”, meaning start with the most recent date and work backward.
MSchapplerModeratorJim,
We could add Edit Title under Windows (right mouse click on the Function title bar) and allow you to change the title like you can on the title bar above function. I’ll forward you request and advise when/if this will be implemented in an upcoming release of NV2.
The word function indicates what the user is allowed to do in the books. Generic names should be allowed to change and I will forward your request.
You can minimize this window by clicking on the box button below the X button on the access_tos explorer. The button changes to two boxes (minimized). Click this button to go back to the original state of the access_tos explorer.
Regards,
Martin
MSchapplerModeratorWhere these rounding errors found in an account on a journal report specified next to journals in the NVEXPORT prompt? Is this account a journal? If it is not a journal but was found on the journal report move it to another report and rerun NVEXPORT again.
The accounts you had mentioned are General Account types. If the account in question does not fall into one of the eight account types listed in ATYPE or TATYPE then it is a General account type. By default accounts that are not ATYPE’d are general accounts. You cannot overuse any account types.
The warning in regards to your bank account being a credit normal balance is just a warning. Usually bank accounts are debit normal balances. You can quickly change the normal balance in NV2.
Once the accounts have been ATYPE’d properly you do need to ATYPE them again. The conversion plan referring to the different weeks is referring to running NVEXPORT. NVEXPORT exports all transactions in the books, you cannot export weekly transactions to an existing NV2 database.
Information about indexing in NV2 can be found by reviewing the NewViews 2.04 manual and click on the search tab. Type indexes and press enter. You will see a list of manual pages below Select Topic which you click on to get information quickly about indexes on the particular page.
To make the NV1 Import shorter, set the transaction compression date to say Jan 1, 2005. This way only 8 months of transactions will import in full detail. You can decompress the past transactions later. I suggest that you have a gigabyte of RAM on your system.
Regards,
Martin
MSchapplerModeratorI’m using version 2.04 and I chose (ight mouse click) Print All and then set Print Zero-Balance Accounts to No – Destination Display and then clicked Print which gave me a Excel spreadsheet show only thoose accounts with account balances.
Are you running NV2 version 2.04? Click your Help about menu to verify.
Regards,
Martin
MSchapplerModeratorI’ll look into the Print All option with Print Zero Balance Accounts set to No and let you know.
Regards,
Martin
MSchapplerModeratorHenry,
Select Custom Analysis instead of Multiple Period. Right mouse click on the blue custom analysis table and choose View > Analysis > New Column.
Regards,
Martin
MSchapplerModeratorType in the journal name in the procedure SETUPS in SalesInvoice Journal Name(s).
Regards,
Martin
MSchapplerModeratorHenry,
PRREPORT when set to details will provide a breakdown of the employee cheques that should make up the amount of the CRA remittance (you must use the correct date range) including the employers E.I. and C.P.P. contributions. The employer accounts are specified in the notes view of the template.
Martin
MSchapplerModeratorZip up the NV1_NV2 file and email it to support@qwpage.com and I’ll look into it.
Include in your email the account(s) that this is occuring in.
Regards,
Martin
MSchapplerModeratorDenis,
Check your Excel windows tool bar Tools > Options. One of your options has been set to place a comma on numbers > 1000.
Regards,
Martin
MSchapplerModeratorThe indexing of accounts.
Go to NewViews > Account > Total and right mouse click on the blue table. Plus on File > Sort > Select Index. In the select index window, press F3 on the Index value and plus on .index > /id. You will now see all of your total accounts in your database.
When an NV2 set of books is born, the indexing of NewViews > Account > Total is set to .index/name/root.
Regards,
Martin
MSchapplerModeratorHenry,
Like in NV1 (PRREPORT) there is Payroll Report in NV2 which you can access by right mouse clicking on the top green table (shows employees) Print > Payroll Report.
There are two templates available for Payroll Withholdings:
American Users: payroll_us_withholdings_payable.xls
Canadian users : payroll_ca_withholdings_payable.xlsPress F3 in the Template value field in Payroll Report to see a list of the available templates.
Note: You must complete the Payroll Report Codes Window to define the account suffixes and employer accounts to report on the template. See the NewViews 2.0 manual Payroll > Custom Payroll Reports for more information.
I also suggest that you review the template in Excel.
Regards,
Martin
MSchapplerModeratorHenry.
It’s working for me and I can increment by the day as per the example above. Changing the view to Closed (X) from ledger and clicking on Reconcile with the chevron down (V) shows the transactions in the correct order.
I suggest you convert a set of books on your end and test it.
Regards,
Martin
MSchapplerModeratorI don’t see any reason why NV2 will not be able to run on Windows XP 64 bit. The 64 bit version of XP runs both 64 bit and 32 bit programs. With more memory and processing power on XP 64 bit, NV2 should run as fast as NV1.
Install it and run it. I’d be interested in knowing the results. Send me and email at schapple@qwpage.com if you have any problems.
Regards,
Martin
MSchapplerModeratorClick on a field (cell) on the column you wish to change and press F11. A Setup Columns window appears. Click on the Format Value and press F3 to see your available choices. Click on your choice and then click on the window you had pressed F11 on to see the change. Try Integer as your format type. This is in the manual under Commands and Shortcut Keys > Keyboard Commands or the Windows Tool bar Help > Keyboard.
In the Custom Analysis view on reports, you can add columns by right mouse clicking View > Analysis > New Columns > add the columns you want and then press F11 and work from the Setup Columns window and work through this table to change your dates for each column.
Regards,
Martin
Post Edited (07-28-05 17:47)
-
AuthorPosts