Import-Asset Master List

From eStream Software
Revision as of 01:36, 20 September 2023 by Csloo (talk | contribs)

Quick Import Asset List

Menu: File | Import | Excel Files...

1. Download the Asset Master Template
2. Click Open folder button.
Asset Master-Import 01.jpg


3. Select the Asset Template excel file...


4. Click Execute (Direct Import). Click Verify if you wish to verify the excel data before import.
Asset Master-Import 02.jpg


NOTE: 
Asset import function available in SQL Account version 5.2022.948.826 and above.


Preparation-Asset Master Import Excel Template

1. Download the Asset Master Template
2. Break into 4 sheets named :
Asset Master Template (xlsx)
Sheet Name Refer to
FA.GROUP.OPF Maintain Asset Group
FA.ITEM.OPF Maintain Asset Item
FA.ITEM.OPF.DeprSche Maintain Asset Item - Depreciation Schedule tab
FA.ITEM.OPF.Project Maintain Asset Item - Project tab



See also