Library Management with Frappe Framework
Features
Faris Ansari
May 19, 2021

Doctypes

Create the following Doctypes in your App with these minimum fields

  1. Item

    • Item Code (unique)
    • Item Name
    • Default Unit of Measurement
    • Standard Selling Rate
  2. Party

    • Party Type (customer/supplier)
    • Party Name
  3. 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)
  4. Fiscal Year
    • Year Name
    • Start Date
    • End Date

Transactions

Create the following transaction doctypes

  1. 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)
  2. 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)
  3. 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
  4. Journal Entry

    • Naming Series
    • Party
    • Posting Date
    • Accounting entries table
    • Account
    • Party
    • Debit
    • Credit
    • Description of transaction
    • Total Debit
    • Total Credit
    • Difference (Debit - Credit)
  5. 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)
Questions
After Assignment
muddy
2 years ago
Post
Dismiss

Hello everyone, Is there any place where we can share/post/publish our assignment for marking or just for ourseves to exchange the logic and concepts we got/used through the assignment??

muddy
2 years ago
Post
Dismiss

ourseves = ourselves, it's a typo.

DC Donald Chinhuru
2 years ago
Post
Dismiss

the issue is there are few peple on this i think, im just starting out so soon will be doing practises and sharing my experiences

DC Donald Chinhuru
2 years ago
Post
Dismiss

the issue is there are few peple on this i think, im just starting out so soon will be doing practises and sharing my experiences

Kleber Villa
2 years ago
Post
Dismiss

https://discuss.erpnext.com/

Ahsan Ali 019A
2 years ago
Post
Dismiss

please mail me

Jannat Patel
2 years ago
Post
Dismiss

This assignment is just for self practice. However if you face any issues you can reach out here or to the community at https://discuss.erpnext.com/

SG Sanjay Gunasekaran
3 months ago
Post
Dismiss

ok

Want to discuss?
Post it here, our mentors will help you out.