The toolbar on this page offers options
that are relevant for the feature, such as Save.
Other options that are standard for other RME pages, such as New,
Next and Previous
are not relevant and are not displayed.
In this topic Hide
The RME Finance Feeder is designed to import the transactions financial data from a finance system to the RME Projects module, Transaction Financials related item and Account Codes records so that RME always has the most up to date transactions and account code information. It is normally scheduled to run as a Windows scheduled task using the RME Feeder Service Configuration Utility.
Data feed and field details: You can view low-level details for this feeder in the System > Documentation > Feeder Service page (under Finance Feeder). The Type field was added to the Finance Feeder in v7.7.0 but is not fully supported. The value is hard-coded as the default value, Finance Category, which supports legacy feeder integrations. If you want to use this field to interface RME with external systems, use an RME API instead.
The toolbar on this page offers options
that are relevant for the feature, such as Save.
Other options that are standard for other RME pages, such as New,
Next and Previous
are not relevant and are not displayed.
Menu path: RME > Integrations > Finance Feeder Service > Configuration tab
The sections below provide information to help you complete the fields in this page. For full details about the feeder service, refer to the RME Finance Feeder Guide (PDF) provided separately in the RME build package when you have the product key.
Before running the service, ensure that you have set up source data files using comma delimited CSV files as the fixed source for the file format. You can download a template that provides the data headers and the order you must use from RME > System > Documentation > Feeder Service. For details, see: Feeder Service.
Field or section (in default order on the page) |
Description |
Finance Feeder Path |
Where in your network all the source files for the RME Finance Feeder are or will be located When setting up the location, it is important to grant necessary read and write access permissions to the user under whose account the RME Finance Feeder Windows scheduled task will run. The program that generates the Finance source data file must be able to access the network location with write access. All CSV files in the root network location will be considered as files for processing and will be processed at the next scheduled time. |
Default for xxx |
Finance category associated with the specified transaction type as the default, from a defined list This allows reporting of transactions not only per year but also per category. The Finance Category for each transaction is populated based on the provided category code, as follows: • If the category isn’t provided and a finance category is linked to the specified account code, it will be populated for the transaction. • If the account code doesn’t have the category linked, the default values specified in the Finance Feeder configuration page will be populated for the relevant transaction type. • If the default values are not specified, the transaction will not have any category associated with it. |
Accounting Periods |
Specified periods to identify the date for each transaction record if the dates for each transaction are not available; the last date defined in the period will be used as the transaction date You can add as many accounting periods as you need. To add and configure a period, click Add at the top of the grid. See: Accounting Period You can delete an accounting period record at any point, as needed. |
When the service is run, the results display in the Import Results tab. This is a summary report of all the scheduled runs of the RME Finance Feeder Service, which includes the following information in the grid:
Column |
Description |
Started |
Date the feeder service began To view the time stamp, click the Open icon next to it in the grid and view the full Feeder Results. If you export the data from the grid, the time stamp will also be included in the data. |
Completed |
Date the feeder service finished To view the time stamp, click the Open icon next to it in the grid and view the full Feeder Results. If you export the data from the grid, the time stamp will also be included in the data. |
Successful |
Number of records that were successfully imported |
Ignored |
Number of records that were ignored during the import process To view the full details,click the Open icon next to it in the grid and view the full Feeder Results. |
Failed |
Number of records that were not imported To view the full details, click the Open icon next to it in the grid and view the full Feeder Results. |
Log Message |
A brief message for the feeder service if anything has gone wrong If you can't see the full message, click Export at the top right of the grid and export the data so you can see it. |
You can monitor the overall status of the Finance Feeder Service in the Finance Feeder Results page. See: Finance Feeder Results
Product Key: Feeder - Project Finance
Page ID: FDR008.htm