 |
 |
|
|
Postings from IRIS Fees can be exported into IRIS Accounts Production. To do this you will first need to setup the export directory, output definition file and your default nominal codes in the Fees Ledger.
You can then use the export facility to export your postings from Fees and then import the postings into Accounts Production.
Click the links below to jump to a particular section:
Setting Up the Export Directory
Setting Up the Output Definition File
Setup Your Default Nominal Codes
Using the Export Facility from Fees
Importing File in to Accounts Production
Export from Fees to Accounts Production
If you wish to export information from IRIS Fees you will need to set up the export facility.
On your system set up a directory you wish the export files to be written to, for example; C:\IRIS
Log into IRIS as MASTER and go into IRIS Fees.
Select Options | System and select the F/T tab.
Enter a database identifier; this is a 3 character identifier. It should be different at each site (if you have more than one office). This will be used as part of the default file name, and will help identify the files when they arrive at the central site.
Nominate the directory for the export files to go to, for example, C:\IRIS
Click OK to exit this
screen.
The output definition file determines what postings from the fees ledger will go into the file, and in what order.
In IRIS Fees Ledger, select File | Posting export definitions
Click New.
Select Nominal
and click OK.
The following screen displays.
Enter a format identifier.
Enter Description for the export file.
Ensure the following options are deselected:
Use header titles for first line of output
Eliminate control account from output
Reverse balance sheet sign on output
Reverse revenue sign on output
For Field surround select Nothing.
For Field separator select Comma.
For Record separator select Standard for Windows.
For Record Length ensure both options are deselected.
Once these options are set, select the Fields tab.
Click Add field and select at
end from the list.
The following screen displays.
On the Add Field tab:
Select Amount for the Posting type field.
In Length enter 12.
For Justify select the Right option.
Select the Format
tab at the top of the screen.
The following screen displays.
Ensure Prefix money with pound (£) sign is deselected.
Ensure Prefix negative money with minus (-) sign is selected.
Ensure Place commas after every 1000 for example, 1,234,567 is deselected.
Select 2 decimal places.
Click OK.
The following screen displays and a line has been entered.
If you wish to add another Field:
To add the next field to be exported click Add field and select at end from the list.
Select the Nominal code option.
In Length enter 12.
For Justify select the Left option
It is not necessary to select the Format tab in this case.
Click OK. This will enter the next line onto the New nominal definition screen.
Click OK to finish setting up the definition.
Click Close to leave the export definitions.
To make a change:
Click the magnifying glass on the field you wish to change.
Example, if you wished to change
the Bank account click the
magnifying glass to display the Nominal Accounts screen:
The following screen displays.
Click New.
The following screen displays.
Enter the Nominal account code that relates to the Bank account in IRISPTP Accounts Production.
Enter the Description.
Select Balance Sheet.
Click OK,
then click Select to update
the nominal code and return to the Fees
Ledger Options screen.
This will change the system default nominal code.
Only postings made after this change will have the new nominal codes, therefore it is possible you may not be able to transfer postings made before.
Repeat this on all the codes you wish to change.
Click OK to close the Fees Ledger Options screen.
After you have posted your invoices, as and when you want, you will need to select the postings for transfer.
To do this:
In the IRIS Fees Ledger, select Posting
| Posting Export and select Export
postings from the list.
The following screen displays.
Ensure you have selected the Fees period containing the items you wish to export.
Click New.
The following screen displays.
The options on this screen include:
Everything not yet selected - selecting this option will collect everything in the current period you have not yet selected.
Date range when posting actually made -the date that corresponds to the time the postings were made. Enter a date range.
This date range corresponds to postings in this period with this date.
Date range for date recorded in posting - the date on the postings, for example the invoice, receipt date.
Exclude receipts not yet matched - select if cash accounting. This will stop receipts from being exported that you have not sorted out the matching on.
Partner - select to restrict the output to a specific partner(s) clients enter the partner(s) identifier(s).
Manager - Select to restrict the output to a specific manager(s) clients, enter the manager(s) identifier(s).
Your choices will be worked out to determine what needs to be exported and a summary will be displayed.
Back - do the Export at a later stage (by going in to IRIS Fees and clicking on Posting | Posting export | Export postings highlighting the list you wish to export, and clicking View).
Export Now - export the data to a file now, displaying:
Select the Format name for the output by clicking the magnifying glass. This will give you a list of the file definitions available. Highlight IRIS and click Select.
Ensure Balance Sheet and Revenue are selected.
Ensure Totals only is selected.
Make a note of the file name, as
this is needed for importing into IRIS.
In the example, the file name is NTT0602.CSV
(you may need to change the extension to .csv).
Click OK.
Once the file has been created the following displays.
Once the file has been created all that remains is to import the file
into Accounts Production.
To do this:
From the IRIS main menu Accounts production.
Select the client account you wish to post into.
Select Posting
| Select and select the posting entry into which the data is
to be imported and click OK.
The Posting screen displays.
On the toolbar click Advanced
and select Import Postings
from the list.
The following screen displays
Select Standard (e.g. comma
separated) Import file.
The following screen displays.
Select the Standard Import
Map and click Select.
The following screen displays
Either enter the full path and name of the file in the File name field, for example, C:\IRIS\ntt0602.csv
or navigate to the CSV file created by Fees. Once you have found the
file click Open.
The Import Result message confirms the import details.
Click OK.
The imported postings are displayed in the Posting
screen.
After creating the batch you can view and edit the file before transferring. Editing the file will remove entries from it, so care is required.
To do this:
In IRIS Fees Ledger click on Posting | Posting export | Export postings
Make sure you have the correct period
selected and click View.
The following screen displays.
If you want to de-select an item from the list highlight the item and click De-select.
If you want to export the file from this point click Export.
Take care when using De select all as this WILL deselect all records.