Doctypes
Create the following Doctypes in your App with these minimum fields
-
Item
- Item Code (unique)
- Item Name
- Default Unit of Measurement
- Standard Selling Rate
-
Party
- Party Type (customer/supplier)
- Party Name
-
Account (tree view - charts of accounts)
- Account Number
- Account Name
- Account Type - Asset/Liability/Income/Expense
- Is Group
- Parent Account
- Opening Balance (set only once)
- Fiscal Year
- Year Name
- Start Date
- End Date
Transactions
Create the following transaction doctypes
-
Sales Invoice
- Naming Series
- Customer
- Posting Date
- Payment Due Date
- Items table
- Item
- Qty
- Rate
- Amount
- Total Qty
- Total Amount
- Debit To (Link field Account - filter (parent type should be accounts receivable))
- Income Account (Link field Account - filter - parent type should be Income)
-
Purchase Invoice
- Naming Series
- Supplier
- Posting Date
- Payment Due Date
- Items table
- Item
- Qty
- Rate
- Amount
- Total Qty
- Total Amount
- Credit To (Link field Account - filter (parent type should be accounts payable))
- Expense Account (Link field Account - filter - parent type should be Expense)
-
Payment Entry
- Naming Series
- Posting Date
- Payment Type - Receive / Pay
- Party Type - Customer / Supplier
- Party (dynamic link field)
- Account paid from
- Account Paid to
- Amount
-
Journal Entry
- Naming Series
- Party
- Posting Date
- Accounting entries table
- Account
- Party
- Debit
- Credit
- Description of transaction
- Total Debit
- Total Credit
- Difference (Debit - Credit)
-
GL Entry
- Posting date
- Due Date
- Party
- Account
- Debit Amount
- Credit Amount
- Is Cancelled
- Voucher Type
- Voucher Number
All Dump all transaction details in GL Entry. Should not be visible on Desk Page
Immutable Ledger:
Reverse Entries on cancellation of transactions
Tests
Write test scripts for the app
Possible scenarios to cover.
- GL Entry creation
- Total verification
- Data Correctness
Reports
- General Ledger Report
- Trial Balance - (Deals with Assets, Liabilities, Income, Expenses)
- Balance Sheet - (Deals with Assets, Liabilities)
- Profit and Loss Statement - (Deals with Income, Expenses)