Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Example: Load Assets in Secondary Asset Books with an EIB

Example: Load Assets in Secondary Asset Books with an EIB

This example illustrates how to load assets in a secondary asset book with an Update Asset Book Configuration EIB.
Your company is implementing multibook asset accounting. You've downloaded an EIB spreadsheet with the assets that you want to migrate. You now update the spreadsheet and upload it in the EIB.
You've downloaded an EIB spreadsheet with all the assets in the Accounting book that don't have a status of
Disposed
.
The
Integration Reference ID
 of the asset book where you want to migrate the assets is
ASSET_BOOK_IFRS
.
Security:
  • Integrations: EIBs
     domain in the Integration functional area.
  • Integration Event
     domain in the Integration functional area.
  • Put
     access to
    Process: Non-Accounting Asset Books
     domain in the Business Asset Accounting functional area.
  1. Update the EIB spreadsheet:
    • Remove all the assets that you don't want to migrate.
    • For all the remaining rows, update the values in these columns:
    Add Only
    Asset Book
    Y
    ASSET_BOOK_IFRS
  2. Review the values in the other fields, and update them as necessary, such as:
    • Depreciation Start Date
    • Original Acquisition Cost
    • Residual Value
    • Fair Market Value
    • Remaining Useful Life
    • Accumulated Depreciation
    • Year to Date Depreciation
  3. Create a trial run to check your spreadsheet against validation errors:
    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
      Integration
       >
      Launch / Schedule
      .
    5. Review these values in the
      Launch / Schedule Integration
       page:
      Field
      Value
      Integration
      Update Asset Book Configuration EIB
      Run Frequency
      Run Now
    6. Click
      OK
      .
    7. Review or enter these values in the
      Integration Criteria
       grid on the
      Schedule an Integration
       page:
      Provider
      Field
      Value Type
      Value
      (Attachment) Update Asset Book Configuration (Web Service)
      Integration Attachment
      Specify Value
      Create an Integration Attachment
      (Workday Web Service) Update Asset Book Configuration (Web Service)
      Validate Only Load
      Specify Value
      Select the check box.
    8. Drop your spreadsheet in the
      Attachment
       section of the
      Create Integration Attachment
       page.
    9. Click
      OK
      .
    10. Click
      OK
       on the
      Schedule an Integration
       page.
    11. Click
      Refresh
       in the
      View Background Process
       page until the process completes.
    12. If you see a failure report in the
      Output Files
       tab, review and change the data in your spreadsheet to resolve the issues.
  4. When you've run an error-free trial run, load the spreadsheet data with the EIB:
    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
      Integration
       >
      Launch / Schedule
      .
    5. Review these values in the
      Launch / Schedule Integration
       page:
      Field
      Value
      Integration
      Update Asset Book Configuration EIB
      Run Frequency
      Run Now
    6. Click
      OK
      .
    7. Review or enter these values in the
      Integration Criteria
       grid on the
      Schedule an Integration
       page:
      Provider
      Field
      Value Type
      Value
      (Attachment) Update Asset Book Configuration (Web Service)
      Integration Attachment
      Specify Value
      Create an Integration Attachment
      (Workday Web Service) Update Asset Book Configuration (Web Service)
      Validate Only Load
      Specify Value
      Clear the check box.
    8. Drop your spreadsheet in the
      Attachment
       section of the
      Create Integration Attachment
       page.
    9. Click
      OK
      .
    10. Click
      OK
       on the
      Schedule an Integration
       page.
    11. Click
      Refresh
       in the
      View Background Process
       page until the process completes.
You can access the
Find Assets
 report for a selection of the business assets you migrated. When you drill down on the asset to view the business asset details:
  • Access the
    Cost Detail
     tab and review the new row for the IFRS book.
  • Access the
    Books
     tab on the
    View Business Assets
     page and review the new row for the IFRS book.
  • From the
    Books
     tab, drill into the new IFRS book configuration. Review these fields on the
    General Information
     section of the
    View Asset Depreciation Schedule
     page:
    • Asset Cost
    • Fair Market Value
    • Residual Value
  • When you specified depreciation information, access the
    Historical Information
     tab and review these columns for the IFRS book:
    • Depreciation Start Date
    • Remaining Useful Life
    • Accumulated Depreciation
    • YTD Depreciation