Visual Cash Focus FAQs

Click on the question to open the answer. To close an open question click on question again.

FAQs VCF

Import actuals into Visual Cash Focus

This shows how to import actuals into Visual Cash Focus

In the Universal import option, the Specifications button gives the structure of the import file for Actuals.


Tip: The easiest way to see the required structure of an import file is to open an existing model that has actuals, and export the Actual data.The file that is created can be used as an example for the import file: change some of the amounts and then import the same file back into the model. You will see that the model now contains the imported actuals.

The import file needs only three pieces of information: the account number, the period and the actual amount.

 

Example:

a) The import file is an ASCII file:

SALESDEPT,    -1,    1000
SALESDEPT,    -2,    2000
SALESDEPT,    -3,    3000
b) The import file is a spreadsheet:

A         B     C
——      —    —-
1   
SALESDEPT   -1    1000
2   
SALESDEPT   -2    2000
3   
SALESDEPT   -3    3000

Account number: The first figure is the account number. The account number must exist in the model – if an invalid account number is used, the line is not imported. Note that the profit centre does not need to be specified in the import file, as the account number defines it.

Period number: The second figure is the period number. This can be -1 or less. If duplicate period numbers are specified for the same account number, only the last one in the file is used.

Actual amount: The third figure is the actual amount. 

 

 

Additional feature is available in these editions: Corporate, Enterprise

Move some accounts:

How Move some accounts works

You can set up a schedule of accounts to move.

If “Move some accounts during import” is checked:During the importing of actuals, the balances in selected accounts will be moved (i.e. transferred) to other accounts.

Any amounts in duplicate account numbers will be added.

Note:

  • The import file can contain accounts that are not in Visual Cash Focus.
  • During the importing of actuals, the balances in selected accounts will be moved (i.e. transferred) to other accounts according to your schedule.

 

On the Import /export options page, check: Move some accounts during import.

Import actuals using a schedule

 

Click Enter schedule to create the schedule of accounts that are to be moved. Here is an example:

Schedule to import actuals

The Info buttons on the page explain how to use this module. In the example above, it shows how several GST accounts in the firms books can be consolidated and transferred into the Visual Cash Focus GST account.

After closing the Import actuals set, select the appropriate schedule to use.

Import actuals - select schedule

Now import the actuals file in the usual way. If Move some accounts during import is checked, then not only will the actual amounts be imported, but also the amounts will be automatically transferred to the accounts in your schedule.

 

 

How to re-install the software, and then transfer the models into the new installation

Re-install the software
How to re-install

This assumes that the existing location will be the same after the re-install.

Visual Cash Focus example (other software is similar):

If Visual Cash Focus is installed in C:\VCF8, then rename this folder. E.g rename to C:\VCF8_old.
Install the software from the CD or setup program that was supplied initially.
Start the software and register as normal. Close the software.
Copy the models: copy all the folders under C:\VCF8_old\Models to C:\VCF8\Models
In C:\VCF8_old\Data there are 3 files that are called Model, namely model.dbf, model.fpt, model.cdx. Copy these three files into C:\VCF8\Data.
Start the software.
Open a model and get to the map.
Run the option: Check shared tables. It is under the Utilities menu, under Technical utilities.

How to – Import accounts into Visual Cash Focus

This shows how to import your chart of accounts into Visual Cash Focus

 

In the Universal import option, the Specifications button gives the structure of the import file for the various options: Accounts, Budgets, etc.

 

Data can be imported from an Excel spreadsheet. Also, data can be exported to an Excel spreadsheet. In addition to Excel spreadsheets, import / export is also supported for the common file types: eg text file, spreadsheet, database, etc. This import / export routine is mainly used when you wish to import data from an external source into the software.

 

Tip: The easiest way to see the required structure of an import file is to open an existing model and export the data.

 

 

This is an example of how to import accounts using: Method 1: Specify the account details on each line. (A lookup file is not used).

 

Right click on the link to download this example file: vcf_import_accounts.xls

The “blue bit”

If you open this file in Excel, notice that towards the bottom is a blue line called the “bottom bit”.

In your own spreadsheet, you will put your own accounts (as per the accounts shown above the blue line), and then copy into your spreadsheet the rows from the blue bit to the end.

The purpose of the blue bit is to give your accounts a link to the existing folders and accounts already in the software. The link is done by correctly filling in column F for your accounts to match the accounts in the blue bit.
This is explained in the software via the Specifications button.

Link accounts to the blue bit

The under_acc is a real account number, e.g. 2-1500.

The bottom bit is your link to the standard accounts in VCF.

So:
If you want to change the account number for Expense – operating accounts, you do that in the bottom bit. Here you would change EXP-OE to say 4-444. If you do that, you need to change the under_acc from EXP-OE to 4-444 for all the under_acc. If you don’t change EXP-OE, then you can leave under_acc to EXP-OE.

The major folders in VCF are given account numbers. This allows you to put an account under it. When you put an account under a major folder, you must use its account number
The ** designator

In an import file, we need a way to designate that a row contains a major folder (Note: a major folder is not under anything). That’s where we use the ** designator.

Take a look at my example. Look for the blue bit at the bottom, which I tend to add to most spreadsheets when I’m importing accounts.

The purpose of this blue bit is to allow me to assign account numbers to the major folders. For example, for BANK I’ve assigned an account number of BANK. You could have used 12345 or any number. The **BANK tells me that this is the major Bank folder, so it knows where to put this account number.

Then in the spreadsheet the under_acc column, I can use the account number for the bank folder (BANK in my case, or 12345).

You only need to add the blue bit to the import file if you want to assign account numbers to the major folders. If they already have account numbers you are happy with, then you don’t need the blue bit. I usually add the blue bit anyway to remind me of its purpose. It can be at the top or bottom – I find the bottom more convenient.

 

 

If the import file is a spreadsheet, your import file will look something like this:

Note: Export the accounts from one of your models and you will see something similar to that shown below.

A B C D E F G H
1 Revenue S Bread # 130 FALSE # 99 Administration N
2 Revenue S Fruit & Vegetables 119 FALSE # 33 Administration N

 

Column A:

The first figure in the import file (Revenue) is the type of account. This field is for convenience and is not imported. Anything can be entered here, or it can be left blank.

 

Column B:

The second figure is the code for the Type of account. This is imported if it contains one of the designated letters below. S is used for Sales or revenue. Valid selections are:

Selection Used for:

S                        Revenue

Z                        Direct costs

X                        Expenses

O                        Other income

C                        Cash at bank

r                        Accounts receivable

N                        Inventory

6                        Other current assets

F                        Fixed assets

8                        Intangible assets

V                        Investments

B                        Bank overdraft

p                        Accounts payable

7                        Other current liabilities

G                        Long term loans

H                        Leases / hire purchase

E                        Equity

W                        Quantity item

 

Column C:

The third figure is the account description (account). Examples: Bread, Fruit & Vegetables. This is used to create new accounts. Note: On page 4 choose the Account description checkbox. If checked (the default) and you use a new account description for an existing account number, the account description in the import file will update the account description already in the model.

Column D:

The fourth figure is the account number. Use an existing account number to refresh the account details, or a new number to import a new account. The account number must be unique. If two rows in the import file contain the same account number, neither will be imported. You will be alerted if this happens.

Column E:

The fifth figure describes whether this line is a folder (is_folder). Can be TRUE or FALSE. Export any existing model to see how this field is filled. Note: On page 4 choose the Is a folder checkbox. If checked (the default) and you import an account that already exists, the account folder status in the import file will update the account folder status already in the model.

Column F:

The sixth figure is the account number that this account is under (under_acc). This number must exist in the model, or be included as a new account number in the import file. See notes below for more information on this entry.
Column G:

The seventh figure is the profit center that this account is under (under_pc). Example: Administration. The profit centres in the import file can be empty, or entered. You can use the profit center descriptions that already exist in the model (use exactly the same name, case insensitive). Note: On page 4 choose the Add new profit centers checkbox. If checked (the default) and you use a new profit center description, it will automatically be added to the model.

Column H:

The eighth figure is the kind of account (kind). Most accounts are “normal”, so usually use an N. If this field contains an N, is left empty or contains an * (asterisk), it will be taken as a normal account. If you want to use something other than Normal, valid entries for kind of account are shown in the  Specifications button.

 

Note regarding Taxation expense

 

 

There can be only one account for Taxation expense. The import file can be used to change the account number of the Taxation expense, but should not be used to add a new taxation expense account. (It will not import extra Taxation expense accounts). The easiest way is to delete your taxation expense account from the import file, and use the existing line in the blue bit if you want to enter an account number for the taxation expense.

 

 

 

Excel interface to Visual Cash Focus forecasting software

 

 

Tip: To find out what is needed to import a certain kind of account, try this:

Start a new model in Visual Cash Focus. Enter the account required. Then export the accounts. Look at the Excel file created and you will see what the fields are for that kind of account.

How to – Debtors Finance

This shows some ideas on how to implement debtors finance.

Example 1: How one can collect 80% of the invoiced amount via a debtors finance company.

You can do it automatically via the cash flow profile. The picture illustrates how you can set up the profile.

Here is the Visual Cash Focus model that shows the above.

Example 2: Here is another solution:

The timing window for the above solution looks like this:

Here is the Visual Cash Focus model that shows the above.

 

How to – Want Cash Flow and Profit and Loss Amounts to be Different for Salary & Wages:-.

Salary & wages:- want cash flow and profit and loss amounts to be different.

The cash flow for salaries and wages is say $1,000 per month. However, in the profit & loss account you want to show the expense as a function of the number of days worked per month.

A client pays Bill wages of $1,000 per month, total $12,000 for year.

In the cash flow you want:

$ per month

Jan    1,000

Feb    1,000

Mar    1,000

Total for year will be $12,000

 

 

However, you do not want the P&L to show the $1,000. Instead you want to work out the number of days Bill will work each month and allocate the $12,000 accordingly. So in the P&L you want:

$ per month

Jan    1,150

Feb      950

Mar    1,050

Total for year will be $12,000

 

 

Solution

 

A sample model is available to demonstrate this solution. Right click here and choose Save as (or Save target/link as).

 

To bring this sample model into Visual Cash Focus, open any model to get to the map. Then choose the File menu (at very top of page) and go to the Export / Import option. Then choose Zip or Unzip a model. On the form, initially Save is selected. Instead click on Retrieve, then click the Do it! button. Locate the wage_show.zip file that you downloaded above. Click Import. Click OK to the message. Give it a modelcode, for example WAGETEST and then click Proceed. You can then use the notes below to work through the model.

 

The total wages amount is $12,000 for the year. The total number of days worked for the year is 262

 

The table below shows the number of days worked per month. This is used to allocate the total wages amount of $12,000 to each month.

 

Wages
Allocate total wages amount to each month based on:
No of Days worked in month
Total wages for year 12,000.00
Days worked in month $ per month (P&L)
Jan 22 1,007.63
Feb 22 1,007.63
Mar 21 961.83
Apr 23 1,053.44
May 21 961.83
Jun 22 1,007.63
Jul 23 1,053.44
Aug 20 916.03
Sep 23 1,053.44
Oct 23 1,053.44
Nov 21 961.83
Dec 21 961.83
262 12,000.00

 

To enter this into Visual Cash Focus:

 

In Accounts and budgets, create a new Miscellaneous item called:

Days worked per month

 

On Budget per period page: Fill in the number of Days worked for each month:

 

 

 

Go to the Expense accounts, to Wages. Then click on the Budget setup page:

 


For Enter budget as choose: Price per miscellaneous item.

 

Click on Change and choose the Days worked per month miscellaneous item.

In the table above (under the Solution heading), the amount for each month is calculated  as:

 

Amount  =      days worked in month

——————–     x Total wages for year

Total days worked in year

 

 

For the first month, it is:

Amount  =      22

—–  x 12,000 = $1,007.63

262

 

 

Use the Equation functionality of the software to do this calculation, as follows:-

Check Use an equation (on the same page).

Click on the Equation builder button.

Enter the Equation as appropriate

e.g. {100}/262*12000

The $12,000 is the total wages amount paid for the year. The 262 is the total number of paid days in a year.

Note: The {100} is an Account

To see the Equation in words, click on Show account description.

You see the following:

—————————

{Days worked per month}/262*12000

Note: The result of this equation will be multiplied by the AMOUNTS on the budget per period page for Wages.

—————————

The info button next to the Show account description button has additional information.

Wages – go to the Budget per period page.

Enter a 1.00 for the price for every period.

The profit and loss for wages will now be calculated for each period. You can see this in Results – view.

Cash Flow

How do you instruct the program to divide the annual wages bill into 12 equal payments?

Use the technique discussed in the Help file for Tutorial 7. Irregular expense payments. Untick all the tick marks except for the 12th period.

The software will not process the monthly cash flows because they are unticked- instead it will calculate the total at the end of the 12th period (because it is ticked).

So all that remains is to create a cash flow profile to allocate the total to each month. As there are 12 periods, the amount to pay each month is:

100%/12 = 8.33

>Notice that a new cash flow profile has been created called Wages. Right-click it and choose View profile.

The profile has been split over 12 periods.

The allocation is spread evenly over the 12 periods. Note that there will be some minor rounding differences, as to get the total to add up to 100% we changed some rows to 8.34 instead of 8.33.

There are 12 rows, allocated to period 0 (current period), -1, -2 … to -11.

 

0 8.34
-1 8.33
-2 8.33
-3 8.33
-4 8.33
-5 8.33
-6 8.34
-7 8.33
-8 8.33
-9 8.33
-10 8.34
-11 8.34
100.00

>Although the Wages profile has been copied to all periods in the budget per period page, it will only be used by any row that is ticked. In our case, the 12th period is ticked. That will have the total wages bill for the year, and that will be allocated approximately evenly over each period.

You will see the results in the cash flow under Results – view.

When the cash flow report is printed under main report, it is usally printed without decimals and it will look like this:

Options are to use hours instead of days for the Miscellaneous item. The equation would then be changed appropriately. Also, on the budget per period page for wages, you could enter the hours per period instead of 1. Then the miscellaneous item could be Total number of hours in year, or total number of employees.

This example should help you set up your model as required.

 

 

Return to Visual Focus FAQs

Profit center assignment with imported accounts

Account number is: (?Name of a/c #) – Visual Cash Focus.

Answer:

When you enter accounts via the software, the profit center assignment is always correct. However, if you imported the accounts, you may have assigned the balance sheet accounts to the incorrect profit center. You must always use the Administration profit center for the balance sheet accounts.

Tip: If you import accounts, check the profit center for all the balance sheet accounts by running this option under the Utilities menu: Balance sheet – check profit cnt.

Visual Cash Focus – Suggestion on How To Handle “Fees in Advance”

Answer:

If you invoice an amount that you want to recognise as income over several months, our suggestion is to enter the revenue as invoiced, as that is the easiest way to get the debtors and bank accounts calculated. Then use an adjustment revenue account to modify the revenue total so that you achieve the desired recognition of income over several months. A full explanation of this implementation follows.

Example: Company send out invoices quarterly in the following months:

Amount invoiced
January 900
April 1200
July 1500
October 1800

The cash flow collection is typically:

month after invoice % collected
1 50 %
2 30 %
3 20 %

Visual Cash Focus will do all the calculations for the revenue, debtors and bank accounts.

 

Now: you want to recognise the income over three months. For example, the 900 billed in January should be regarded as income as follows:

Amount
January 300
February 300
March 300
Total 900

How do you handle this in Visual Cash Focus?

 

Our suggestion is to enter the revenue as invoiced, as that is the easiest way to get the debtors and bank accounts calculated.

 

Adjustment account

 

To cater for the income in advance, create an adjustment account under revenue. Then put both the revenue and the adjustment account into a new folder.

 

Here is an example:

 

Create a folder under revenue: Fee income on P&L.

 

Under this folder create two revenue accounts:

Fee income on P&L
Fees – a) amount invoiced – in advance
Fees – b) recognise as income adjustment
Total Fee income on P&L

The a) account contains the amount as invoiced, eg 900 in January.

 

The b) account contains an adjustment to split the income over the three months, eg

a) Amount invoiced b) Adjustment Folder total
January 900 -600 300
February 0 300 300
March 0 300 300
Total 900 900 900

 

The desired outcome is that the P&L shows an amount of 300 per month. The Adjustment account contains the appropriate amount to achieve this.

 

Note when you print the P&L report, you can suppress the folder details and print just the total.

 

It will be convenient to create a new account under Current Liabilities called: Fees in advance. The cash flow profile for the b) adjustment account can have the Bank account changed to this Current Liabilities Fees in advance account.

 

Here is an Excel spreadsheet illustrating the desired outcome.

 

Here is a Visual Cash Focus model showing the implementation.

Note: You need Visual Cash Focus to view the implementation. Save this zipped model file to a folder on the hard disk. Then use File, Import Zip to import the Zip file as a model.

Delayed GST or VAT.

Revenue is recognised on the profit and loss / income statement, but GST (or VAT) is required to be recognised only in the month in which the cash is received.

Answer:

This is accomplished by going to the Account, then to the Account property page.

Automatic GST / Automatic VAT / Automatic SALES TAX – normally this box is checked. Most users will never change this setting. In this case we want to enter the GST / VAT / SALES TAX amounts manually, so uncheck this box. See picture:

When Automatic GST or VAT is turned off, the GST / VAT will not be added automatically. Instead, the Budget per period page will display an extra column for entering the GST / VAT / SALES TAX amount yourself. See marker 4 is picture:

GST amount or VAT amount or Sales Tax amount – this column is normally not shown. The only circumstance in which it appears in the grid on the Budget per period page is if the user unchecked the Automatic GST/VAT/SALES TAX checkbox on the Account properties page.

The picture is now explained using the markers 1 to 4:

    • An amount of 10,000 is recognised as revenue in period 6.
    • Notice the P. The ‘P’ is used when you want the cash flow to be received in a Nominated period. Note: we are using the P option here because it clearly explains the process, and is often useful when entering the GST or VAT manually.
    • The Nominated period is shown in the To column. In the example, 10,000 of revenue recognised as income in period 6 will be paid in period 8. So 10,000 cash will be collected in period 8.
    • THE GST or VAT amount is shown in period 8. So the GST (or VAT) of 1,000 is charged in period 8.

Note: The usual sales profile could also have been used (“-“) to show when the income is recognised. The GST or VAT would still have been entered into the column as shown in 4.

Here are the results for this example:

Profit and loss / income statement:

 

The 10,000 is recognised as income in period 6.

Cash Flow:

 

In period 8 the income of 10,000 plus the 1,000 GST or VAT is received. Total 11,000.

In period 9 the GST or VAT is sent off to the tax office.

Balance sheet

The 10,000 is shown as A/R on the Balance sheet, and stays there until paid in period 8.

Cash at bank is 11,000 in period 8, and this reduced in period 9 by the 1,000 GST or VAT sent to the tax office.

Working with named cells in Excel via Visual Cash Focus

Excel interface to Visual Cash Focus

Named cells is a feature of Excel.

  • A name (eg. TOTAL) can be used instead of a normal cell reference (A1).
  • Names must be unique within the spreadsheet.

Excel interface to Visual Cash Focus

 

Using Excel is optional! One can type the numbers directly into the table on the Budget per period page. However, sometimes it can be useful to use Excel to do calculations and import the results into the table. On the Budget per period page there are two buttons that can be used to link the budget to an Excel spreadsheet.

 

Excel interface to Visual Cash Focus forecasting software

Go to a/c button: This takes you directly to Excel, to this account number, if it exists in Excel. If it does not exist, it will be created (assuming that the default properties are set correctly – discussed below).

“Get data” button: If this account number is in the Excel spreadsheet, then the data there will be transferred into the Budget per period table.

 

Note: The Excel spreadsheet is a supporting document. The Excel data should be imported into the table. It is the data in the table that will be used by the software.

 

In Visual Cash Focus, the account number is the link between the software and Excel.

Named cells are used to locate account numbers in a spreadsheet. The link to Excel is via the account number with a prefix of “_”.

Example:

Account number: HATS

Named cell in Excel: _HATS.

(Notice the underscore in front of HATS).

Excel named cell in Visual Cash Focus forecasting software

Notice in the picture above that the cell name is shown on the top left – just above the A column. When you click in a cell, it will either show the cell reference (C8) or the cell name (_HATS) if the cell has been named.

Tip: The link is automatic and you should not usually need to worry about the above – the software will do it all for you. A named cell will be created automatically in Excel. (Try it and see how easily it works!)

Note: To comply with Excel naming conventions, any spaces in the account number are changed automatically to “.” and funny characters like # are changed to “_”. If you need it, you can see the name of the cell for any account by click the Excel “i” button.

Another example:

The account number: “BLOOD TESTS” corresponds to the named cell: “_BLOOD.TESTS”.

 

Named cell magic

In Visual Cash Focus, when you go to the account, a named cell will be created automatically at the bottom of the spreadsheet.

Note: When Visual Cash Focus imports data from Excel, it looks for a named cell, and then the column directly underneath the named cell. It will import whatever data it finds there. When you first Go to the account, if it doesn’t exist yet, the software adds additional information above and to the left of the named cell. This information is for the convenience of the user, and is not read by the software. it should be regarded as decoration only, as far as the software is concerned. Sometimes the second column will be used, if appropriate. For example, if revenue is budgeted as price per quantity, the column directly under the named cell will be price, the column directly adjacent will be price. If you let the software create the named cell for you, the “decoration” that gets added to the Excel spreadsheet will identify the columns for you.

Note: The software always adds a new account underneath the last occupied row. It has no ability to add a named cell next to the previous one. But you can move it to wherever you want, even to another sheet in the same spreadsheet.

 

Cut and paste

Select the appropriate cells in Excel, including the named cell. Then “Cut and Paste” to a new location. The named cell will move to the new location. You can see that by clicking on the named cell and looking at the cell reference, which is shown at the top above the A column.

 

How to delete a named cell

Sometimes you may want to delete a named cell. Excel provides this functionality.

In Excel versions prior to Excel 2007, go to the Insert menu. Choose Name, then Define.

In Excel versions from Excel 2007: To open the Name Manager dialog box, on the Formulas tab, in the Defined Names group, click Name Manager.

You see a list of the named cells – click on the appropriate one and click Delete and remove it.

 

In Excel 2007, more information is available in the Excel help file, under: Manage names by using the Name Manager dialog box.

How to go directly to a named cell

Use the cell name box just above the A column at the top – click the selector and move down to the named cell you want. When it is selected, you will go directly to that cell.

 

How to create a named cell in Excel

Usually you will let the software create it for you. However, you can also create it manually if convenient.

First understand the naming convention used to link a Visual Cash Focus account number to a schedule in Excel:

As mentioned above, the name of the cell consists of an underscore plus the account number. If the account number contains spaces or funny characters, then they need to be changed: you can see the name of the cell for any account by click the Excel “i” button on the Budget per period page.

When you know what the name should be, you can create a named cell in Excel as follows:

Click in a cell, example F5. The cell name box (just above the A column at the top) will say F5. Type in the name required, eg _BLOOD.TESTS and press Enter. The cell is now named, as shown in the name box.

 

How to rename a named cell in Excel

If you wish to change the name of the named cell, delete the existing named cell, then enter a new named cell.

 

Do this using:

  • If Excel version is prior to Excel 2007, from the menu choose Insert, Name, Define.
    Excel 2007 named cell manager
  • In Excel 2007, use: Formulas, Name Manager

Note: In Excel 2007, you can edit the named cell and rename it directly.

 

 

Working with sheets

 

The named cell can be on any sheet within the Excel spreadsheet. If you have moved a named cell to another sheet, then:-

  1. In Visual cash Focus, if you move to another profit centre for the same account
  2. Go to the account via the Go to a/c button

the software will create the new named cell at the bottom of the appropriate sheet.

 

Working with actuals

 

The software does not import actuals via the named cell mechanism; instead, there is a specific option for importing actuals on the Universal import form under the File, Export / import menu.

When using the named cell functionality, budget data (not actuals) is imported into the Budget per period page.

Note: If the spreadsheet is used to supply data to the Budget per period page,and then the model is rolled over, the first cell under the named cell will be regarded as the data for period 1 of the budget. However, there is a mechanism to tell the software that the first row should not be imported. Go to Defaults, to the Excel / graph page. Notice below the Excel name is a checkbox for “Actual rows at start“: When unchecked, the first row is period 1 of the budget. However: if checked the first row (or rows) will be reserved for actuals.

Why is this useful:

Example:

a) A budget is entered into a spreadsheet with period 1 the first budget period.

b) The data is imported.

c) Then you roll over one period.

In the spreadsheet, the first row is now actuals, and the second row has the start of the budget.

Note: To use the spreadsheet again, add a row for the period rolled over. Then if “Actual rows at start” is checked, the software will automatically take row 2 as the new budget for period 1.

If the model already has actuals before you start using the named cell features, then if this is checked, when you go to the account for the first time, it will add additional rows at the start as placeholders for actual periods. If you have three periods of actuals, then the first row that will be imported will be the 4th row below the named cell.>

Rollover

Rollover does not make any changes to the Excel file. If you want to use the schedules to update the budget data again, after a rollover you need to do some housekeeping on the Excel spreadsheet. Typically you will:

  1. Add a row at the bottom of each schedule.
  2. Use this new row to fill in the new amount for the last period
  3. Also you will probably want to change the decoration around the relevant schedule to designate A (Actuals) and B (Budget) data and periods.

You can see which row the software will start importing from by using the Go to a/c button. It takes you to the row it will use for the period 1 budget. Then, if you have a 15 month forecast, it will import whatever data you have entered for the next 15 rows.

Remember Excel is a free format vehicle. It gives you a lot of flexibility. However, the rigorous checking that the software does using its own internal forms is not available in the Excel schedules. When importing, the software will only do this:

It will go to the first row below a named cell that it expects to contain the budget for period 1.

It will import the next rows in sequence.

Example: Typically a total of 15 rows will be imported when the model is for 15 periods.

The flexibility that Excel gives you is unlimited. For example, you could have calculations on different sheets or even different spreadsheets. Your responsibility is to ensure that the budget data that will be imported into the software appears below the named cells, and the budget data is provided for all the periods in the model.

We suggest you start simply and practice on a small model. It is really quite easy, you just have to take responsibility to provide the budget data in the correct place under a named cell.

 

 

Useful links:

http://office.microsoft.com/en-us/excel/HA101471201033.aspx

http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

Program does not start because of other programs eg Payroll (runtime placement issue)

Program does not start because of other programs eg Payroll (runtime placement issue)

Microsoft has a recommended location for their runtimes. Unfortunately we have found some vendors put the runtimes directly into the Windows folders, which is incorrect. If the other vendor has used an older edition of the runtime, our program does not start correctly (as we use some of the features in the latest editions).

Answer:

Use one of the solutions offered below:

Solution 1: Download the runtimes and put them directly into the application

The runtimes can be downloaded here.  runtimefox.zip 5mb

 

Unzip the file you downloaded into a temporary folder:

Copy the three files (they all start with vfp9) directly into the application.

  • Examples: Copy the three files into C:\VCF8 for Visual Cash Focus. If you have ABC Focus, also copy the three files into C:\ABC4
  • Start the software. All should now work.

 

 

Solution 2: Removes the files from the wrong location.

 

Look in the Windows folder, in the three folders that start with sys:

See if there are any files that begin with VFP9. If there are, then these are causing the problem. These files should NOT be installed in any of the system folders. If you find any, remove them (copy them to a temporary folder that is not under Windows, e.g to C:\test).
Note: As our program will have installed the latest runtimes to the correct location, removal of old runtimes will result in all programs using the latest runtimes.

Data type mismatch error

Data type mismatch error

Users in Japan and Thailand report that they get an error when they run Visual Cash Focus. The error is similar to the following: Error 9. Message: data type mismatch. Procedure proapp.referentialintegrity in vpmapp.vct (approx line no 218).

Solution:

Download a document that describes a solution from here.

Map drives for network versions

How to map the drives for Network versions

If you run the network version of the software, and install the software to a file server, then you must map the installation drive to a letter. All workstations must see the same drive letter, eg. F:

Visual Cash Focus example (other software is similar):

If Visual Cash Focus is installed in F:\VCF8, then the workstations should also have access to F:\VCF8. The drive letter cannot be different on different workstations.

The first workstation that runs the software will set the location of the files. Any other workstation that subsequently runs the software will use the locations that have been set. If it cannot use these locations, it will warn you to fix the drive mapping. The software should start in exactly the same location on all workstations.

If you need to start again, do this:

Example: Visual Cash Focus

In the VCF8 folder, delete these two files: svcffapd.apd and svcffapd.fpt.

Then make a copy of these two files: svcffapd2.apd and svcffapd2.fpt and rename the copies to: svcffapd.apd and svcffapd.fpt.

For the other software packages, the procedure is similar – look for the file with the .apd extension for the file name.

Unable to locate ArmAccess.DLL

On startup, get the message: Unable to locate ArmAccess.DLL

Solution:

The file used to start the program (goVCF.exe) must be updated. The solution is to install the updated file.

Download technical support module below

There is one file to download. Right-click on the link below. Then choose: Save target as:
Important: use the right-click on your mouse, not the left-click!

Right-click here to get module File name is: govcf.exe 13 kB

Save this file into a temporary folder. Then copy it into your VCF6 folder, overwriting the one already there.

Visual Cash Focus – Network technical support module

This page is for technical support. Only download this module if instructed by technical support. If you need it, we will email you instructions.

Network technical support module

This page is for technical support. Only download this module if instructed by technical support. If you need it, we will email you instructions.

 

Download technical support module below

There is one file to download. Right-click on the link below. Then choose: Save target as:

 

Important: use the right-click on your mouse, not the left-click!

Right-click here to get technical support module File name is: net.EXE 20 mb

(Instructions are emailed to you if you need this file)

Tip for users with slow internet connections:

Our server supports resume download. If you have a slow internet connection and are not using a resume download tool, do yourself a favour and get one. Here is a shareware one which we like: www.getright.com. If your internet connection goes off in the middle of a download, this tool allows the file to continue downloading from where it left off.

Visual Cash Focus – support modules

Note: Only use these modules when instructed to do so by technical support.

Visual Cash Focus budgeting forecasting software

Visual Cash Focus support modules

There are two options:-

Option 1

Download support module 1. Save it to a temporary folder or to the desktop. Then run it. Tip: Right-click on the link below. Then choose: Save target as or Save link as:

Download support module 1 (faq-vcf8-setupRTF.exe, 1.5MB)

Option 2

Usually module 2 is not required. Only download and install support module 2 if the support module 1 above did not solve your problem!

Download support module 2 (faq-vcf8-setupCONTROL.exe, 10.2MB)

How to download

Right-click on one of the links above. Then choose: Save target as or Save link as:

Tip: To download, use the right-click on your mouse, not the left-click!

(Instructions are below)

Instructions:

1. Download one of the files above into a temporary directory.

2. Run the program to install the support module.

“Open” window appears after entering user name and password.

User enters user name and password. Then a windows shows with title "Open" and first line of windows has "Look in" on VCF6 folder. User clicks Cancel and after a few messages software exits.

Solution:

A required component has not been installed. The solution is to install it.

Download technical support module below

There is one file to download. Right-click on the link below. Then choose: Save target as:

Important: use the right-click on your mouse, not the left-click!

Right-click here to get module    File name is: vcfePaper.EXE    0.5 mb

Save this file into a temporary folder. Then run it and follow the instructions on the screen.

Visual Cash Focus version 8 – Help Files For Network Users

Question: Help file problem: The topics on the left display, but the contents on the right page do not display.

Cause
When you open the help file this is what happens: – the help file comes up with all topics in the tree on the left, but a Page Not found or Operation Aborted or Action cancelled message shows on the right.
Why this is happening: Microsoft released a Windows security patch that prevents viewing help files (CHM format) that are stored on a network drive. It does not, however, prevent viewing help files that are stored on a local drive.

 

Solution

We have implemented a simple solution for Visual Cash Focus users who are on at least version 8 of the software.
Note: If you use other versions please see:

Getting help to work in a network environment

The solution is to put the help file onto a local drive, and then tell Visual Cash Focus where to find the help file. Here is how to do this:-

  1. Create a folder on the local drive for each user, e.g. C:\VCFHELP. This should be the same drive and folder for all users.
  2. Copy the help file vcfhelp.chm from the F:\VCF8 folder into the C:\VCFHELP folder on each users computer.
  3. Delete the vcfhelp.chm file from the F:\VCF8 folder. (Drive F: is just an example – you may have used a different drive letter).
  4. Finally, use Notepad to create a file in the F:\VCF8\DATA folder.See below:-

It should contain just one line:

C:\VCFHELP

Save the notepad file as help.txt.

 

Now when the user runs the software and accesses help, it will use the local copy of the help file and display its contents correctly.

 

Unicows.dll not found

When I start the program I get this message: The Microsoft Layer for Unicode (unicows.dll) can not be found. The program will now exit.

Applies to: Visual Cash Focus when run on some Windows 98 or Windows ME platforms. Does not occur on Windows XP or later.

Solution:

Copy unicows.dll into the VCF6 folder. This file will probably be on your computer in this folder: C:\Program Files\Common Files\Crystal Decisions\2.0\bin.

Microsoft files

Note: This file is for use by Cash Focus software clients only.

Question: When zipping a model, get an error message:
Library file c:\vcf8\vfpcompression.fll is invalid.

 

CauseYour PC does not have a Microsoft file called msvcp71.dll installed.

 

Solution

This Microsoft file needs to be on your PC.

Solution 1: Download Microsoft file

Here is where to get the file. There is one file to download. Right-click on the link below. Then choose: Save target as:

Important: use the right-click on your mouse, not the left-click!

Right-click here to get the file File name is: msvcp71.zip 130 kb

 

Instructions:

1. Download the file above into a temporary directory.

2. Unzip the zip file you downloaded to obtain msvcp71.dll.

3. Copy msvcp71.dll into the VCF8 folder where you installed Visual Cash Focus.

4. Your Zip option should now work.

 

 

Usually the above fix works. If it doesn’t, make sure that you have the DLL file in the VCF8 folder (not the ZIP file you downloaded). If it still does not work:

 

Solution 2: Download setup program for Microsoft’s C++ version 8 runtimes

Here is where to get the setup program. There is one file to download. Right-click on the link below. Then choose: Save target as:

Important: use the right-click on your mouse, not the left-click!

Right-click here to get the setup fix File name is: SetupC8runtime.exe 1.7 mb

 

(Instructions are below)

Microsoft’s C++ version 8 runtimes

 

Instructions:

Note: Only do this if Solution 1 above did not work.

1. Download the file above into a temporary directory.

2. Run the program SetupC8runtime.exe to install the runtimes.

3. Install for all users, and install into the VCF8 folder where you installed Visual Cash Focus. Your Zip option should now work.

Visual Cash Focus – Vista and Crystal Reports issue

Visual Cash Focus and Crystal Reports

Background

Visual Cash Focus (VCF) was installed on a computer running Vista 64 bit.

When running a report, got the message: Crystal Report Viewer: Not implemented.

Solution

 

  • Uninstall VCF
  • Disable Vista Data Execution Prevention – ( bcdedit.exe /set {current} nx AlwaysOff )
  • Ensured UAC was disabled (was already off)
  • Reboot
  • Install VCF via Right Click -> Run as Administrator
  • Register the program
  • Run Report

 

 

Contributed by:

Aaron Rasmussen
IT Systems Analyst
SSI Group

General FAQs

FAQs general

New Zealand Sales and Support

Sales and support in New Zealand is available locally.

To place an order, or for support, please contact your local office below.

 

New Zealand sales and support

If you are in New Zealand, please talk to Steve on (04) 479 3039
or email him: steve@strategicfocus.co.nz

Destination drive during install

Question: When installing software, the Remaining Disk Space is negative.

Cause
An invalid drive has been selected. Or the mapping is not recognized.

 

Solution

If you are on a Windows 7 or Vista PC, see: Windows 7 and Vista drive mapping

 

If you are on an ealier version of Windows: change the drive to a valid drive. If it is a mapped drive, check that the drive is accessible in Windows Explorer.

 

 

Network users – speed of processing

Network versus PC performance

Network versus PC performance

For normal data entry (i.e. when you enter data into the software), you won’t notice much difference between running the software on a PC or over a network.

However, when the data is activated, the speed of the network becomes a factor. You will see this because the same model will often take longer to activate over the network than on a PC. The speed of software operation is a function of the speed of your network. Also, your virus checker can have a significant influence (see below).

 

Suggestions for speeding up performance

 Citrix /  Terminal server

If your network is Citrix or Terminal server, the speed of activation will usually be as good as on a PC, and often better (because usually one has better hardware on such a server).

 

For other servers, here are some suggestions:

1. Turn off indexing of the folder on the server

If the server is running Windows, turn off indexing of the VCF8 folder.

For example, for Windows server 2008, in Windows Explorer, find the VCF8 folder, right click on the folder and select Properties. This is what you see:

VCF8 folder

Click Advanced.

Make sure “Index this folder for faster searching” is unticked. Click OK twice.

VCF8 folder index faster searching

 

 

 

2. Temporary file location

During activation the software does a lot of processing and needs to work with a lot of data. That is why on a slow network it may take a while. Also, if TEMP files are configured to a network share, everything will be slow.

You can speed things up by telling it to put its working files onto a local drive. That should speed up processing because some of the data is used on the fast local C drive rather than the slower network drive.

How to tell the software to put its working files onto the local drive

Do this:

  • Create a new folder on the local C drive.
  • Call it say c:\work (or c:\temp)
  • Open config.fpw with notepad. This file is in the application folder (e.g. VCF8 for Visual Cash Focus).
  • Near the top change TMPFILES, for example:

* Temporary file location:
* Can change this to a faster drive. Example: TMPFILES=C:\temp
*TMPFILES=SYS(2023)
TMPFILES=c:\work

 

If the folder you are using contains spaces, then put it in quotes, example

TMPFILES=”C:\steve work area”

Don’t leave spaces around the equal sign, and remove the asterisk in front of TMPFILES (if it exists) as shown in the example above.

 

All user must have this directory.

If on a network, all users must have the working directory. In the example above c:\work must exist on all the workstations.

This technique should speed it up. However, one can never expect the same fast speed as when operating the software on a local drive, as the speed of moving data over the network is limited by the speed of the network itself.

 

Where are the temporary files being stored?

Right-click here
for a program that can be used to show the current location of the temporary files. Then choose Save target as or Save link as to download the file showt.exe.

Note: Using Windows Explorer, put showt.exe into your VCF8 folder and then run it. If you change config.fpw, you can run it again to check the temporary folder location.

 

3. Speed of hard disk and speed of network

The network speed and server hard disk performance are performance factors. You want the fastest hard disk you can get.

Also the network itself can often be the bottleneck. The (GigaBit) LAN device and hard disk speed on the server should be as good as possible for optimum performance.

4. Virus checking

During activation a lot of data is processed, and your virus checker can cause a significant slow down. To speed it up, these are some options:

Tell it to exclude the VCF8 folder, and all its subdirectories.

Alternatively, tell it to exclude checking of the following files:

  1. *.DBF
  2. *.FPT
  3. *.CDX
  4. *.IDX
  5. *.DBC
  6. *.DCX
  7. *.DCT

 

Also, tell your virus checker not to check any files in the temp folder (E.g. in c:\work as discussed above). This has been reported to result in a significant speed improvement.

Peer to peer network

If you have a peer to peer network rather than a real server, with one of the clients holding the data, then such a setup is inherently slow at data processing. It is fine for data entry or word processing applications, but for data activation it will be slower. The techniques described here will help, but if you work with large models, then running the software locally instead of over the network may be a good solution for you.

5. Other suggestions

If you have big models, and want better performance, then consider running them on your local PC. For backup purposes, you can then zip the models and store the zipped files on your network if required.

 

The techniques discussed above should help you achieve better performance.

 

 

Allowed user count exceed message

When the software is installed on a server, the software counts the number of users currently logged on.

To assist you to keep within the number of licences you have purchased,the software alerts you if the number of users exceeds the number of licences purchased.

 

 

 

Please ask us for a licence for additional users if you see this message.

 

 

Tip: Occasionally the number of users reported will be incorrect. This can happen if a user exits the software abnormally. This is usually self correcting, as the next time the user logs in, when he exits his user flag will be released normally.

 

If you wish to reset the flags, do this:

  1. Exit the software. Important: do not use the re-login button for this. 
  2. Start the software and Log in as Supervisor with the Supervisor password. 
  3. Open a model (or start a new one if none are available to choose). 
  4. Go to the menu option shown below to reset the users.

 

Reset users

 

Help file problem: The topics on the left display, but the contents on the right page does not display

 

When you open the help file this is what happens: – the help file comes up with all topics in the tree on the left, but a Page Not found or Operation Aborted or Action cancelled message shows on the right.

Visual Cash Focus users who have at least version 8: Your solution is here: http://www.cashfocus.com/faq-vcf8-helpnet

For the other software packages, read on.

Why this is happening: Microsoft recently released a security patch that prevents viewing help files (CHM format) that are stored on a network drive.

The security patch and its effects are fully described on Microsoft’s web site at http://support.microsoft.com/kb/896358 and http://support.microsoft.com/kb/892675/

Answer:

Comment: The fixes and workarounds that Microsoft suggests are not for the novice. Here is a work-around you may prefer:

Our recommendation:

 

For Visual Cash Focus users, try this: rename the file vcfhelp.chm to: zvcfhelp.chm.

If that does not work, read on:

 

The problem only exists when the help file is installed on a network drive. You can copy the help file to your desktop. To do this: copy the file vcfhelp.chm from the vcf7 folder in your network drive onto your desktop. Double-click the file on your desktop to open it. You should now be able to read the help file without problem. Unfortunately this does not maintain the links between the software and the help file, but at least you can read it.>

 

Other options are mentioned here: http://west-wind.com/weblog/posts/2928.aspx
One of the suggestions there is:
The simplest method is to RIGHT-CLICK on the file, select PROPERTIES and UNBLOCK.

 

This security patch affects many major programs – personally, we are going to see if Microsoft releases a more user-friendly solution before applying their recommended patch.

 

For advanced technicians only:

 

If you have access to technical resources, you can ask them to fix it the Microsoft way.

 

Important: Make comprehensive backups of everything before doing any of this, just in case.

 

This note might be useful:

 

If you trust all the computers on your LAN or intranet (and the people using them), you can lower the restrictions on the Local Intranet zone to allow CHM files to be displayed with the following steps:

 

1. Click Start, click Run, type regedit, and then click OK.
2. Locate and then click the following subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\ItssRestrictions
If this registry subkey does not exist, create it.
3. Right-click the ItssRestrictions subkey, point to New, and then click DWORD Value.
4. Type MaxAllowedZone, and then press Enter.
5. Right-click the MaxAllowedZone value, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7. Quit Registry Editor.

 

 

If this solution does not work for you, please see http://support.microsoft.com/kb/896358 and http://support.microsoft.com/kb/892675/ for alternatives.

OLE error, class not registered

Answer:

These messages occur when the software libraries have been overwritten by other software installations. The easiest way to fix them is to re-install the software from the original CD, using the following procedure:

The example below is for Visual Cash Focus.
If the software is installed on the local C drive (see below for network installations).

Rename the c:vcf6 folder to something else, for example c:\vcf6now.
Install the software from the CD into the c:\vcf6 folder.
Delete the c:\vcf6 folder. This step may surprise you – during step 2 all the libraries that are required by the software were installed. Deleting the vcf6 folder does not delete those libraries, which we wanted to install.
Rename the folder you created in step 1 (for example c:\vcf6now) to c:\vcf6.

All should now work OK.

If not, it may be a rights issue. You may have to repeat the installation as administrator.
If the software is installed on the network:

Run the net.exe file from Windows explorer, which is in F:\vcf6\net\ (assuming F is the network drive). Be sure to change the directory suggested from C: to F: (assuming F is the network drive – change to the appropriate letter for your installation).
Note: If that does not solve it, update your net.exe from this page. Then repeat the step above.

Error on starting or installing the software

a) Cannot communicate with Machnm1.exe!

b)  c:\windows\system32\autoexec.nt. The system file is not suitable for running MS-DOS and Microsoft Windows applications.

c) Can’t run 16-bit Windows program

Answer:

The latest versions of our software tools are all 32 bit applications. One or two users have reported the above error when starting the software.

An internet search on the above phrase shows that it is common in a wide range of situations and there are several suggested solutions.

How to fix:

Note: We use C:\WINDOWS in the notes below, but on some systems the folder may be called C:\WINNT. Substitute as necessary when following these instructions.

Solution 1: Firstly, see if you have the following files in your C:\WINDOWS\system32 directory.

 

Machnm32.sys

Machnm64.sys

 

If these files are missing:

 

Right-click on the link below. Then choose: Save target as (or Save Link as):

Important: use the right-click on your mouse, not the left-click!

Right-click here to get file File name is: machfiles.zip

Save this file into a temporary folder. Then unzip it and copy the two files: Machnm32.sys and Machnm64.sys into your C:\WINDOWS\system32 directory.

Start the software. The problem should be resolved. If not, reboot your PC, then start the software. The problem should now be resolved.

If there is still the same problem, read on for further solutions.

 

Solution 2: Microsoft has a fix for it.

Research on this issue on the Microsoft site and other places suggests the following solutions.

Reason for error: A file (Autoexec.nt) in your operating system is faulty or missing.

Easy fix:

1. Look at the C:\ WINDOWS\System32 directory. If there is a file called Autoexec.nt here, rename it to something else.

2. Look in the C:\ WINDOWS\Repair directory. You will probably find that Windows had automatically made a backup copy of Autoexec.nt, so just copy this file into your C:\WINDOWS\System32 directory. The problem will now probably be fixed. (You should reboot and then start the software again).

 

Alternative solutions:

Note: If you can’t find a copy of the missing file (Autoexec.nt) in your Repair directory, use your original Windows CDROM to get the missing files. (You may also be able to get it from another PC running the same operating system).

At the command prompt type the following commands:

expand e:\i386\autoexec.nt_ c:/windows/system32/autoexec.nt

exit

Substitute “e:\” for your CD-ROM driver letter, and “c:\windows” for where your OS is located.

Microsoft’s solution:

Microsoft has a fix for this issue. Here is a link to Microsoft’s fix:-

http://support.microsoft.com/default.aspx?scid=kb;en-us;324767

Other comments found on the internet that may be useful:-

Comment 1:

The autoexec.nt file needs to be replaced. You can copy this file from your Windows XP CDROM. Go to a command prompt (Start/Run/cmd), making sure your CDROM is in the drive. Then type in:

expand d:\i386\autoexec.nt c:\windows\system32\autoexec.net (note that I am assuming your cd drive is “d”, if not then substitute with the correct drive letter, also note that there is a space before c:\…..)

Press enter after you type in the command and you should see the file being copied.

If it does not copy, try this command:

expand c:\windows\repair\autoexec.nt c:\windows\system32\autoexec.nt

Press enter. Hope that helps!

Comment 2:

Customer is getting a message when he tries to open MYOB “C:\windows\system32\autoexec.nt

The system file is not suitable for running MS-DOS and Microsoft Windows applications.

Choose close to exit. Tried this: Copied C:\windows\repair\autoexec.nt to C:\windows\system32 Re-ran Application and was able to get in and everything looked ok.

Comment 3:

Try replacing autoexec.nt again, but this time, right click autoexec.nt, select properties, and select “read only”, click ok.

Comment 4:

It’s because one of the following files is missing from \WINNT\System32:

      • Config.nt
      • Autoexec.nt
      • Command.com

 

Check to see that these files are there. If not, expand them from the install CD and copy them to \WINNT\System32 They’ll be in the \I386 folder as Config.nt_ autoexec.nt_ command.co_ From a command prompt window, type Expand /? to get instructions for using Expand

 

Cannot delete a model

Why can’t I delete the model?

If a model has been created with a Windows reserved word, then Windows will not allow you to delete the model.

Windows does not like folders to be named with reserved words. For example, do not use directories that contain these:

      • \COM1, \COM2 or \COM3
      • \LPT1, \LPT2 or \LPT3
      • \PRN, \PRN1, \PRN2 or \PRN3
      • \AUX, \CON, \NUL, \CLOCK$

 

Say you inadvertently create a model called CON. How do you delete it?

Answer:

Step 1: In Windows Explorer, delete all the files in the CON folder.

Step 2: Rename the folder CON. (See below for instructions on how to do this).

 

Windows Explorer won’t allow you to delete the folder called CON. It also won’t allow you to rename it. To be able to delete the folder CON, it must be renamed. Here is how to do it:-

 

Example: c:\vcf7\Models\Con 

Note: The notes below refer to the example above. You should change the commands below to your own situation:

 

In Windows, choose Start, Run.

 

Type cmd and click OK.

 

Type the following:

c: (press enter)

cd\vcf7\models (press enter)

 

ren con xxx1 (press enter)

 

 

 

(There should be no messages from any of the above three commands).

 

Close the command window.

 

Now using Windows Explorer, delete the xxx1 folder you created above.

 

The job is done.

Number of files in zipped file archive compared to model folder

When I Zip a model, there are fewer files in the Zip archive than in the model folder. Why?

Answer:

The Zip archive contains everything that is needed to re-make the entire model.

When you use the Zip option within the software:

 

The zip routine is quite clever – it extracts just what it needs to re-create a model. Some of the files are only required when the program is run, so there is no need to include them in the zip archive, as they will automatically be re-made. This enables the zip file to be quite small, which is convenient when emailing a model to someone.

So if you unzip a model, and run the software, you will find that the entire model is there.

Printer issue (printer prints garbage)

Printer prints garbage. Instead of words, it prints symbols or Greek characters.

Solution: “UNICODE ISSUE”

This is a function of your printer. We use Crystal Reports for reporting, and this requires that the printer used supports Unicode. Almost all recent (5 years) printers do. You should check with the printer suppliers to see if your printer supports Unicode and how to activate it. If not you should use a different printer.

Here is a reference to this issue on the Crystal web site.

http://support.crystaldecisions.com/library/kbase/articles/c2013278.asp

This is what they say:

Printing from Crystal Reports 9 displays cryptic symbols: This will occur if the printer driver does not support Unicode. CR 9 uses Unicode functions to print. Previous versions of CR did not use Unicode. To determine if your printer driver supports Unicode, see the printer driver manufacturer’s support website.

Note: Most modern printers do have drivers that support Unicode. Contact the printer supplier to ask them. For example, Kyocera Mita originally had a driver that did not support Unicode, but they brought out a revised driver that does. So the solution was to get the latest driver.

If you contact the printer company and are advised they do not have a UNICODE print driver, we suggest you find another printer that does. An alternative could be to use emulation mode for your printer. For example one of our clients found that one of the HP LaserJet drivers worked for their printer. You may have to install a few HP printer drivers until you find one that works.

Printer issue (export reports)

When attempting to export a Crystal report, the following error message appears: Export DLL cannot be found

This scenario occurs on a computer with a Citrix Server or Terminal Server environment when working with Crystal Reports.

Other error messages that may be applicable: “No Database DLLs Found…”

 

Solution:

On the Crystal Reports web site, there is an article called “Citrix Server and Windows Terminal Server” that describes this error.

Steps to Resolve:

To resolve these issues, copy files from the Crystal directory to the Citrix Server’s or Terminal Server’s System directory.

This means that you should copy files from c:\program files\Common Files\CrystalDecisions\2.0\bin to C:\WINNT\SYSTEM32\

CAUTION Do not delete the c:\program files\Common Files\CrystalDecisions\2.0\bin directory. Other Business Objects products may require this directory.

With the DLLs in the System directory, the User Path Variable will be able to locate them. The error messages should be resolved and exporting should be successful.

Printer issue (crystal reports not loaded)

Cannot open report ….Filename.rpt. Try again?

Applies to: Visual Cash Focus when run on some non-English Windows platforms. Does not occur on English Windows.

Download technical support module below

 

There is one file to download. Right-click on the link below. Then choose: Save target as (or Save Link as):

Important: use the right-click on your mouse, not the left-click!

Right-click here to get module    File name is: CrystalDo.exe    10.5 mb

Save this file into a temporary folder. Then run it and follow the instructions on the screen.

Mapped drives and Windows

Note: This file is for use by Cash Focus software clients only.

Question: When installing software onto a Windows PC, the mapped drives cannot be selected.

 

Cause
Unfortunately some versions of Windows do not find the drive mappings when install programs are run.

 

Solution

This implements the solution mentioned in Microsoft’s KB937624. Download and run the file below. After installation a reboot is required.

 

 

Download setup program for Windows drive mapping

Here is where to get the setup program. There is one file to download. Right-click on the link below. Then choose: Save target as:

Important: use the right-click on your mouse, not the left-click!

Right-click here to get the map setup fix    File name is: setupMap.exe   1.3 mb

 

(Instructions are below)

 

 

Instructions:

Note: Close the installation program you were busy with.

1. Download the file above into a temporary directory.

2. Run the program setupMap.exe to install the map setup fix.

3. It will ask you to reboot. Do so, then run the normal install program. Your mapped drives should now be found.

 

Note: if the drive mappings are still not available, restart your computer one more time.

 

 

Background

Install programs automatically elevate your rights so that files can be installed. Windows 10, 8, 7 and Vista require the drive mappings to be redone or made available. The setup program provided here sets a system policy registration key entry for “EnableLinkedConnections”, as per Microsoft Knowledge Base Article KB937624 available here: http://support.microsoft.com/kb/937624.

 

Reg virus

Support file to fix REG virus – only run when advised by customer support Support

 

How to re-install the software, and then transfer the models into the new installation

Re-install the software
How to re-install

This assumes that the existing location will be the same after the re-install.

Visual Cash Focus example (other software is similar):

If Visual Cash Focus is installed in C:\VCF8, then rename this folder. E.g rename to C:\VCF8_old.
Install the software from the CD or setup program that was supplied initially.
Start the software and register as normal. Close the software.
Copy the models: copy all the folders under C:\VCF8_old\Models to C:\VCF8\Models
In C:\VCF8_old\Data there are 3 files that are called Model, namely model.dbf, model.fpt, model.cdx. Copy these three files into C:\VCF8\Data.
Start the software.
Open a model and get to the map.
Run the option: Check shared tables. It is under the Utilities menu, under Technical utilities.