Dear all,
Mr Kelkar has come up as usual with another new feature, seemingly not
available in any other software of this level.
I think it will be good if we can implement this.
When and How can be decided by the team after due discussion.
For developers:
The changes to the system are subtle, yet fundamental as the voucher
table will be altered for this. Even the interface will have another field.
What this will do is that the existing users will have a slight
difficulty upgrading to the new version.
But new users will like this feature a lot.
In any case, we are writing a data migration tool so this problem may
not be so big.
Happy hacking.
Krishnakant.
-------- Forwarded Message --------
Subject: new feature outstandings report
Date: 18 Oct 2016 02:56:40 -0000
From: arun kelkar <arunkelkar@xxxxxxxxxxxxxx>
To: kk@xxxxxxxxxx
CC: imasdekar@xxxxxxxxxx
Dear All
The feature given below is a unique feature and I have not seen this or
such a rich feature in any other software so far. It is for this reason
I have not put it in the developer's list.
Pl let me have your feed back and when we can implement this.
UNPAID INVOICES REPORT.
WHAT IT WILL ACHIEVE
This feature will further enhance the utility of GNUKhata.
When activated this feature will display a list of invoices which are
unpaid as on a particular date.
HOW IT WILL BE DONE
The user will have to enter Invoice Number while recording the following
types of transactions:
1. Credit Purchase,
2. Credit Sale,
3. Purchase Return,
4. Sale Return,
5. Debit Note,
6. Credit Note,
7. Receipt of amount from a customer,
8. Payment of amount to a supplier.
This means one more field for entering the invoice number will have to
be provided IN THE UI while recording these eight types of transactions.
HOW THE REPORT WILL BE SEEN
The Report Menu of the Menu Bar will have one more button “Outstanding
Invoices”.
When this option is selected the user will be asked to select either
“Outstanding Sales Invoices” or “Outstanding Purchase Invoices”.
After this the user will be asked to select the date as of which he or
she wants to see the Report. If no date is specified the “to date” will
be presumed to be the current date (system date). This means the current
date (system date ) will be the default date. Thus the “From Date” for
this report will always be the first date of the financial year.
Thus separate reports will be generated for unpaid sales invoices and
for unpaid purchase invoices.
The heading of the report will be “Outstanding Sale/Purchase Invoices as
on ddmmyyyy”.
It will be a columner report and the column headings will be:
1. Sr. No.,
2. Date of transaction,
3. Invoice No.,
4. Customer or Supplier Name,
5. Sub Total (of outstanding invoices) for each month,
6. Grand Total of all outstanding invoices.
Even partly paid invoices will be included in this report and only the
amount remaining to be paid will be shown. In the report such records
will be, some way or other, highlighted.
All items will be displayed chronologically.
The report will have the following variants.
1. All Outstanding invoices with subtotal for each month and grand
total(this is the normal report);
2. All Outstanding Invoices Partywise with subtotals for each party;
3. All Outstanding invoices ONLY of a particular supplier or customer
with total;
4. All Outstanding invoices for UNPAID amounts equal to or more than the
amount specified by the user; or
5. All Outstanding Invoices which are unpaid for or more than the days
specified by the user (For example, invoices which are outstanding for,
say, more than 30 days).
6. All Outstanding Invoices for which part payment is either received or
made.
There will be no Drill Down for this report, since all the details of a
transaction are displayed in the report.
arun kelkar
