Import-Asset Master List: Difference between revisions

From eStream Software
(Created page with "==Import Asset Master== ''Menu: File | Import | Excel Files...'' :1. Click '''Open folder''' button. ::600px <br /> :2. Select the Asset T...")
 
No edit summary
Line 9: Line 9:


  '''Download:'''
  '''Download:'''
  [https://download.sql.com.my/customer/Asset/Asset Master Import.xlsx Asset Master Import Template]
  [https://download.sql.com.my/customer/Asset/Asset Master Import.xlsx Asset-Import-Template]


==Generate Asset Opening vs GL Maintain Opening Balance Report==
==Generate Asset Opening vs GL Maintain Opening Balance Report==

Revision as of 08:26, 14 December 2022

Import Asset Master

Menu: File | Import | Excel Files...

1. Click Open folder button.
Asset Master-Import 01.jpg


2. Select the Asset Template excel file...
Asset Master-Import 02.jpg


Download:
Master Import.xlsx Asset-Import-Template

Generate Asset Opening vs GL Maintain Opening Balance Report

Menu: Asset | Maintain Asset Item...

1. At Maintain Asset Item, click Preview button.
Asset-OpeningRpt-01.jpg


2. For instance, the Out of Balance result get from the comparison between Asset Opening Balance and GL Maintain Opening Balance.
Asset-OpeningRpt-02.jpg


3. With the Asset Opening Breakdown in the report, it helps you to ensure the asset data inputs are correctly recorded in Maintain Asset Item.
Asset-OpeningRpt-03.jpg


See also