 |
 |
|
|
In this Topic Hide
A year end trial balance can be imported from IRIS OpenBooks into Accounts Production.
To import data, the following steps should be followed:
Enter the IRIS OpenBooks log in details (E-mail and Password), these details are accountants login details used to access IRIS OpenBooks.
The IRIS OpenBooks log in details need to be entered against the Accountant selected for the client, Client | View, Accountant, view the details of the selected accountant (Agent, Alternative accountant or Branch), select IRIS OpenBooks.
Create the link to the IRIS OpenBooks client
These details are entered within Client | View, click the magnifying glass next to the IRIS OpenBooks Company field, the Company Name and URL can be entered. When the details are entered, the Test URL should be used to check that the details are valid. Once the Test has been carried out, the posting data can be imported.
Before commencing the import, check that the posting entry dates in Accounts Production are consistent with the account period start and end dates in IRIS OpenBooks. If the dates don't match postings, Accounts production will not be able to locate postings to import from IRIS OpenBooks.
The posting data can be imported by selecting directly from the batch control window:
Select Posting | Select
When in the postings screen, select Batch Control from the toolbar (Hotkey Alt+B), to open the Posting Batch screen.
Postings can be imported into an existing batch by selecting Re-open, to importing into a new batch select New.
From the ReSpecify/Specify Batch screen select, Activate import from IRIS OpenBooks.
Once all the batch details have been entered in the ReSpecify/Specify Batch and OK is clicked, the import will be activated.
When the import is complete a results screen will be displayed and the postings will be displayed in the postings screen.
Select Posting | Select
Select the posting entry into which the data is to be imported.
In the postings screen select Advanced | Import Postings
Select D - IRIS OpenBooks
If the client does not have a default IRIS OpenBooks map selected, the list of available IRIS OpenBooks maps will be displayed, there are two import maps issued by IRIS:
IRIS OpenBooks Import Map L - this is for use with limited companies
IRIS OpenBooks Import Map P/S - this is for use with partnerships and soletraders
Highlight the required map and click Select.
If there is a default client map selected, the map will be displayed, click OK to continue and use the default map.
The import will begin, if the IRIS OpenBooks Company has not been entered, a prompt will appear to allow for these to be entered.
When the import is complete a results window will be displayed and the postings will be displayed in the postings screen.
To create an alternative IRIS OpenBooks import map:
Select Setup | Import Maps
Select the IRIS OpenBooks tab.
IRIS issued import maps can be copied and edited, select Copy to New, the new map will be created and can be edited.
To edit the mappings for one client only
Select Edit | Import maps
Select Change next to the IRIS OpenBooks Import map.
The chart level mappings can be Added, Remove and Changed for the client.