Import-Asset Master List: Difference between revisions

From eStream Software
No edit summary
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 Master Template]


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

Revision as of 08:30, 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:
Asset Master 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