Sundar Mishra
In this book, I document important ideas, data-related problems, and their solutions. I also share what I do, how I plan, and my experiences throughout the journey.
My Book
Transaction Entry Voucher Data Import Process for Aegis Software
1. Data Verification & Cleaning Before preparing the data for import, verify and clean the data ...
Aegis Software - HRM (Payroll) Module User Manual
🔧 1. Payroll Module Setup (Initial Setup) 1.1 Create Receivable Profile Path: Application >...
Aegis Important Config And Setting Tables
Module: Application And General Description: Stores logs of unexpected system errors.Table: pu...
TDS (Tax Deduction at Source) – Sales & Receivables Process
This document explains how TDS is calculated, deducted, and recorded in accounting from both the ...
Salary TDS Calculation (Nepal – FY 2082-83)
The calculation of Tax Deducted at Source (TDS) on salary is different from TDS on purchases an...
New Page
another hihi
My Ideas For Data Study
Data Study & Tallying Workflow – Sundar Mishra
I believe that data study and data tallying are hard because you cannot solve data issues just by...
Report Export Quety
Receipt Report SELECT fy.fiscal_year AS "Fiscal Year", r.transaction_date AS "Transaction...
Link Inventory Export Query
Link Inventory Export Query SELECT store.full_name AS "Store", inv.link_type AS "Link Type", ...
Fiscal Year Data Audit Process - Aegis Software
This chapter shows how to check and match data properly. It explains the common reasons why misma...
A. Clear Remaining Postings & Entries in Client Side, Verify Your User Rights
1. Clear Remaining Postings & Entries Advise the client to post or clear any pending entries...
B. Sales Verification & Sales Taxes Verification (STR VS Ledger)
1. What is Sales Verification? Sales verification means checking that the total value of issued ...
C. Purchase Verification with Ledger & Register
1. What is Purchase and Purchase Tax Data Verification? Purchase verification means checking whe...
D. Consumption / Receipt Return (Debit Note) Verification & Data Tally
1. What is Consumption / (Receipt Return) Debit Note Data Verification? Consumption / Debit Note...
Data Migration - IDS Software
A. Data Migration – Required Documents, Tables & Reports
1. Required Data / Reports The following documents, database tables, and reports are required fo...
B. FATAHTBL – Important Columns and Migration Reference
FATAHTBL is one of the main transaction tables required for accounting data migration. The table ...
C. artrntbl — Understanding Data & Similarities with fatahtbl
1. Purpose of artrntbl artrntbl appears to contain AR (Accounts Receivable) transaction-level in...