The integrator currently does not support List of Values (LOV) for the Expense Account column due to the need to accommodate dynamic insertion functionality in Oracle. As a result, users must manually enter valid Key Flexfield values into the Expense Account column. More4apps is actively working on an update that will provide support for both List of Values and dynamic inserts.
Location
The integrator currently does not support List of Values (LOV) for the Location column due to the need to accommodate dynamic insertion functionality in Oracle. As a result, users must manually enter valid Key Flexfield values into the Location column. More4apps is actively working on an update that will provide support for both List of Values and dynamic inserts.
Mandatory columns in the Assignments section must be completed to create an asset.
Column
Notes
Units Assigned*
The number of units currently assigned to the distribution. Whole numbers on e.g. 1
Employee Name
Employee identification name. Assign assets to the owner or person responsible for that asset. You must enter a valid, current employee.
Employee Number
Employee identification number. Assign assets to the owner or person responsible for that asset. You must enter a valid, current employee.
Expense Account*
The GL account where you wish to charge the depreciation each month. The GL account must be an expense type (i.e. not Revenue or Balance sheet).
Location*
Enter the valid physical location of the assets.
‘*’ Required
You are able to have multiple records in this section.
Employee Names
When working with Employee Names that appear to be duplicates, the tool requires a unique identifier to differentiate between them. To effectively manage such situations, follow these steps:
1. Employee Number requirement: To handle duplicate Employee Names, you must provide an Employee Number associated with each unique employee. This Employee Number serves as a distinct identifier that allows the tool to distinguish between the same names.
2. Using Data Form: If you encounter instances where you're unsure about the Employee Number, you can utilize the Data Form to search for them.
