Automatic Mapping of Asset Keys

Summary:

Automatic Mapping of Asset Keys

Content (required):

Hello,

I need to do an automatic mapping of the asset keys with Account payables – asset clearing account or depreciation expense account. The asset keys have been created based on the chart of account segments.

The asset keys are as follows:

Entity   

Destination (service)

Project

Chart of accounts are:

Entity

Account

Service

Product

Project

Future1

Future2

As per requirement, when the depreciation expense or asset clearing account code combination is generation for Mass Addition, the asset keys should be populated as per values generated for the code combination.

An example:

Asset clearing account code combination from Accounts Payable: