Import-Asset Master List: Difference between revisions

Revision as of 01:54, 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.

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

NOTE: 
DO NOT rename the sheet name.

FA.GROUP.OPF
Column	Length	Remark
Code	20	Eg. Motor Vehicle (Asset Group Code : FA-MV)
Description	160	Example
DeprMethod	1 (Integer)	Example
AssetAcc	10	Example
AccumDeprAcc	10	Example
DeprAcc	10	Example
DisposalGainAcc	10	Example
DisposalLossAcc	10	Example

@@ Line 17: / Line 17: @@
 ==Preparation-Asset Master Import Excel Template==
-:1. Download the [https://download.sql.com.my/customer/Asset/Asset_Master_Import.xlsx Asset Master Template]
+Download the [https://download.sql.com.my/customer/Asset/Asset_Master_Import.xlsx Asset Master Template]
 {| class="wikitable"
 |+ Asset Master Template (xlsx)
@@ Line 32: / Line 32: @@
 |}
+ NOTE:
+ DO NOT rename the sheet name.
+===1. FA.GROUP.OPF (Maintain Asset Group)===
+{| class="wikitable"
+|+ FA.GROUP.OPF
+|-
+! Column !! Length !! Remark
+|-
+| Code || 20 || Eg. Motor Vehicle (Asset Group Code : FA-MV)
+|-
+| Description || 160  || Example
+|-
+| DeprMethod || 1 (Integer)   || Example
+|-
+| AssetAcc || 10 || Example
+|-
+| AccumDeprAcc || 10 || Example
+|-
+| DeprAcc || 10 || Example
+|-
+| DisposalGainAcc || 10 || Example
+|-
+| DisposalLossAcc || 10 || Example
+|}
 ==See also==