In this article, we will discuss about how to migrate assets from legacy ERP to HAL ERP in bulk using copy paste from excel or Item Grid.
- Go to Menu -> Bulk Asset Creation -> Create New
- Date : Date of loading the opening balance or beginning of HAL ERP.
- Select Import data=NO, as we are going to enter the data in Item Table or Grid.
- Select Duplicate docnum = NO.
- Select Approved = Yes.
In the next section select the Depreciation ledger and the Asset ledger. These selected ledgers will be applied to all the assets which are being entered in Item Details Table or Grid
Note:
1. You could add multiple items belonging to the same asset & depreciation ledger only in a single transaction.
(OR)
2. Create category based transaction i.e., one category belongs to same ledgers (asset & depreciation).
In the Item Details section, you can add the asset items to be created with the required details in the columns in the grid. You can also copy paste from excel sheet to the grid.
The columns in the grid:
Add the details of the item like the
- Docnum : Enter Asset Code
- Name : Name of Asset.
- Description : Description of an asset
- Purchase cost : Enter purchase cost. It's mandatory.
- Asset Type: This dropdown will decide the life of asset. Make sure to select the correct value. In order to create the value and define the correct % of depreciation, follow this link
- Asset condition
- Depreciation frequency: Most companies prefer depreciating monthly, so enter 12 which means depreciating 12 times a year. If 1 is selected, then once a year its depreciated.
- Total depreciation year: Is the number of years the depreciation has to be calculated or its the life of an asset. The value entered here should match with value selected in "ASSET TYPE"
- Booked amount: Enter the Depreciated value as of loading or migrating date.
- Opening Months ran: Enter the depreciated months count i.e., total number of months an asset is depreciated
- In stock: Select Yes
In above image, Purchase Cost = 4500, Date of Purchase = 01/01/2023, Assets are being migrated in July 2023, which means they are depreciated till June 2023.
Then Opening Months Ran will be 6.
Booked Amount = ((Purchase Cost / Total Dep Year) / Frequency) * No. of Month Dep. ran = ((4500 / 4)/12 ) * 6 = 562.50 for 6 months.
Note: It will take into consideration the date of purchase of Asset for depreciation i.e., if Asset was purchased in Mar 2023, then depreciation will start from Mar 2023.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article