Bulk Allocate Fixed Assets to Customer

The enhancement is about the bulk allocation of fixed assets to the Customer and Department to achieve this, three columns have been introduced such as Allocate To, Customer, and Project. You can import the Assets from Microsoft Excel Worksheet (.xlsx) and allocate them to the users in bulk. 

To Bulk Allocate fixed assets to customers, perform the following steps: 

1. Log in as an Analyst. 
   
   
2. Navigate to Asset > User > Manage Asset > Import > Bulk Asset Allocation. 
   The Bulk Asset Allocation configuration screen is displayed. 
    
   Figure: Asset Navigation
   
   

3. Select Tenant and click DOWNLOAD TEMPLATE in the ACTIONS panel. 
   An Excel file will be downloaded that contains multiple sheets. 
   
   Figure: Bulk Asset Allocation
   
   

   Note:

   New columns such as Allocate To, Customer, and Project are displayed in the Excel file. The analyst can re-write the data in the Excel sheet before importing.
   
   

   
   

4. Select Tenant and Category in the BULK ASSET ALLOCATION page, under the General tab.
   
   
5. Upload the source Excel file and click Submit. 
   A table listing all sheets from the uploaded Excel file is displayed.
   
   Figure: Bulk Asset Allocation - Asset Allocation Template 
   
   For information about the fields under the General tab, see Field Description.
   
   
6. Select Asset Allocation Template sheet to import the Assets. 
   The screen will be navigated to the MAPPING tab which will display newly added columns such as Allocate to, Customer, and Project.
   
   Figure: Bulk Asset Allocation - Mapping
   
7. Map the Source to the Destination by selecting the appropriate values from the dropdown list.
   
   For information about the fields under the Mapping tab, see Field Description.
   
   

8. Click NEXT. 
   The screen navigated to the Preview tab to upload the assets.
   
   

   In case of any invalid data in any of the row(s), force import is enabled, select Ignore checkbox, and click UPLOAD ASSETS.

   
   

9. A table listing all the mapped values is displayed under the Preview tab.
   This includes the newly added columns such as Allocate To, Customer, and Project.
   
   For information about the fields under the Preview tab, see Field Description.
   
   
   Figure: Bulk Asset Allocation - Preview
   
   
10. Click UPLOAD ASSETS.  
    The Assets are uploaded to the selected location and allocated to the respective users.
    
    Figure: Bulk Asset Allocation 
    
    
11. Click PREVIOUS ALLOCATION DETAILS to view the allocation details. 
    Details screen is displayed.
    
    Figure: Previous Allocation Details
    
    
12. Select Previous Transactions from the dropdown list and click SUBMIT. 
    The transaction details are displayed with the updated column values.
    
    Figure: Previous Allocation Details list

Field Description

The following table describes the fields of the page: