Import-Asset Master List: Difference between revisions

Revision as of 01:36, 20 September 2023

Menu: File | Import | Excel Files...

2. Click Open folder button.

3. Select the Asset Template excel file...

4. Click Execute (Direct Import). Click Verify if you wish to verify the excel data before import.

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

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

@@ Line 14: / Line 14: @@
   '''NOTE:'''
   Asset import function available in '''SQL Account version 5.2022.948.826''' and above.
+==Preparation-Asset Master Import Excel Template==
+:1. Download the [https://download.sql.com.my/customer/Asset/Asset_Master_Import.xlsx Asset Master Template]
+:2. Break into 4 sheets named :
+{| class="wikitable"
+|+ 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==