Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Example: Download an Update Asset Book Configuration Spreadsheet Template with Data

Example: Download an Update Asset Book Configuration Spreadsheet Template with Data

This example illustrates how to download an Update Asset Book Configuration spreadsheet template with data.
Your company is implementing multibook asset accounting. You want to prepare a spreadsheet that you can use to migrate your existing assets to the new IFRS asset book. You download a spreadsheet:
  • With all your assets in the Accounting book that don't have a status of
    Disposed
    .
  • In the format expected by the Update Asset Book Configuration EIB.
  • You have an asset book named Accounting that contains the assets you want to migrate.
  • You've created an inbound EIB for the
    Update Asset Book Configuration
     web service and named it Update Asset Book Configuration EIB.
  • Security: These domains in the Integration functional area:
    • Integration Configure
    • Integration Event
    • Integrations: EIBs
  1. Access the
    View Integration System
     report.
  2. Enter
    Update Asset Book Configuration EIB
     in the
    Integration System
     prompt.
  3. Click
    OK
    .
  4. From the related actions menu of the integration system, select
    Template Model
     >
    Edit
    .
  5. Click the
    Edit Template with Data Options
     button on the
    Edit Template Model
     page.
  6. Select the
    Condition Rule Filter
     option on the
    Edit Generate Spreadsheet Template with Data Options
     page.
  7. Add 2 rows to the
    Rules Conditions
     grid with these values:
    And/Or
    Source External Field or Condition Rule
    Relational Operator
    Comparison Type
    Comparison Value
    And
    Asset Book
    in the selection list
    Value specified in this filter
    Accounting
    And
    Status
    not in the selection list
    Value specified in this filter
    Disposed
  8. Click
    Generate Spreadsheet Template with Data
    .
  9. Select the
    Generate Spreadsheet with Data
     check box.
  10. Click
    Submit
    .
  11. Click
    Refresh
     in the
    View Background Process
     page until the process completes.
1 file displays in the
Output Files
 tab.
Download the output file and:
  • Verify that it contains all the assets that you want to add to the new IFRS asset book.
  • Update the information in the spreadsheet.
  • Load the assets with the Update Asset Book Configuration EIB.