Uploading financial data
You can capture financial summary data by downloading and uploading a spreadsheet that is configured as an offline content form.
Before you begin
Procedure
- Go to TRIRIGA\Cost Item folder. and open the
- Download the financial summary offline form.
- Complete the form and save it to your computer.
- Go to Add. and select
- Specify a name for the financial summary. Specify the content by uploading the financial summary offline form.
- Create the financial summary DTO.
What to do next
Run your company’s ETL Job Item to move the data from the Financial Summary record to the database.
When you are ready to process this Financial Summary DTO, find it in the Financial Summary DTO business object in the Job Manager and edit it and then process it.
The import is finished when the total found count is displayed at the top of the Line Items section. Compare this number with the number of records in your spreadsheet.
When the import is finished, the data is ready to be processed by the appropriate Load Financial Summary From Offline Staging Kettle Transformation ETL Job Item. The data is not represented in metrics until the ETL Job Item is complete.