04/01/2025
0:00 Intro
Easily compute multiple assets' depreciation, auto-post to GL accounts, and calculate asset disposal gain/loss with SQL.
0:15 - Fixed Asset Master File Setup
Create an asset group linked to the GL code, input asset details (code, description, acquire date, cost, useful life, residual value), assign to group, agent, and area, choose depreciation frequency (yearly, monthly, half-yearly, quarterly), and save. SQL generates depreciation automatically.
0:52: Routine Asset Depreciation
Go to Asset | Process Depreciation, select a period (e.g., 01/01/2021-031/12/2021), and choose to post by asset group, item, agent, or area. Click Process to generate a journal voucher with calculated depreciation.
1:29 - Depreciation Reports
Access detailed asset reports with historical, year-to-date, accumulated depreciation, and net book values by asset group or item. Includes analysis for sold assets with gain/loss calculations.
2:08 - Disposal Gain/Loss Calculation
In Asset | Asset Disposal, select an asset, input disposal amount, and payment method. The system auto-calculates gain/loss and posts a journal voucher for disposal.
3:00 - Opening Balance for Fixed Assets
To include pre-SQL assets, insert opening balances with details (acquire date, cost). Process depreciation for prior periods before continuing.
https://youtu.be/B9mMED66PLg?si=wdkNwIp6FSXVuI8J
