gnukhata issueshttps://git.fosscommunity.in/groups/gnukhata/-/issues2017-06-01T10:46:28Zhttps://git.fosscommunity.in/gnukhata/gkwebapp/-/issues/669Automatic Bank Reco2017-06-01T10:46:28ZGNUKhataAutomatic Bank Reco*Created by: arun kelkar*
This module will greatly enhance the utility of GNUKhata. No such module is provided in any existing accounting software.
Banks allow its customers to download their bank accounts. These downloads are, amongst...*Created by: arun kelkar*
This module will greatly enhance the utility of GNUKhata. No such module is provided in any existing accounting software.
Banks allow its customers to download their bank accounts. These downloads are, amongst other formats, in a spreadsheet format. The spreadsheet has many columns of which important columns from the point of view of Auto Bank Reco are 1. Date, 2. Amount, 3. Instrument No., 4. Transaction Remarks or Description or Narration and 5. Dr/Cr. Not all banks have the DR/Cr column.
While recording a receipt or payment, the user will, apart from the usual fields, be filling in the following fields.
1. Mode: The user will select one from the drop down consisting of Cash, cheque, DD, Net Banking, RTGS, NEFT, IMPS.
2. If by Cheque or DD, then A) instrument No., B) Name of the Bank and C) Name of the Branch.
From the Instrument No., Name of the Bank and Branch and Amount a transaction can be identified, both in the Ledger account and the bank statement.
How it will be done?
Assuming the user wants to do Auto Bank Reco.
The user will down load the Bank Statement in the spreadsheet format for the period for which the reconciliation is to be done.
When the Bank Reco module is activated, the user will be asked to select the bank and the period for which the reconciliation is to be done. The ledger for the specified period will be displayed with cursor on the first row of the Clearance Date column.
The software will take up the first transaction from the ledger account. Pick up its instrument No., amount and date.
The software will search for the instrument No in the bank statement. (It could be in any column of the bank statement. Some banks have a separate column for this, while some show it in the Description or Narration column). Similarly it will search for amount and if these match it will check the Clearance Date with the date of transaction. If the Clearance Date is subsequent to the date of transaction in the ledger then software will fill the Clearance Date field of the transaction with the date picked up from the bank statement. And take up next transaction from the ledger and so on.
If the payment is made by any mode other than cheque or DD, that is, through Credit Card, Net Banking, Credit Card, NEFT, RTGS etc then there would not be any Instrument No., but there would be a unique number identifying the transaction. This number could be from 9 to 14 digits.
In such cases, the user is expected to fill this unique number in the Instrument No field.
1. Where cash is withdrawn from ATM.
In the Transaction Remark of the statement this will be identified by the words ATM/Cash WDL/ ATW.
2. Where payment is made through a Payment Getway, the transaction is identified by either a 12 or 14 digit number and the name of the party to whom the payment is made.
3. Where payment is made towards Income Tax, the unique No of the transaction will consist of the BSR Code of the Bank plus date in ddmmyyyy format plus the Challan No.
Thus the data entered in the Instrument No field becomes crucial for the success of Auto Bank Reco.
Where it is not possible to enter anything in this field, the Clearance Date will have to be entered manually.
In reality this will be semi automatic bank reco.https://git.fosscommunity.in/gnukhata/gkcore/-/issues/259Create Category2017-03-11T04:16:13ZGNUKhataCreate Category*Created by: arun kelkar*
When a user creates a Parent Category and saves it, a new screen opens and the cursor is on Parent Category, but the word "Primary" appears in the drop down. GNUKhata does not have Primary as category.*Created by: arun kelkar*
When a user creates a Parent Category and saves it, a new screen opens and the cursor is on Parent Category, but the word "Primary" appears in the drop down. GNUKhata does not have Primary as category.https://git.fosscommunity.in/gnukhata/gkwebapp/-/issues/670Create Product2017-06-03T03:41:54ZGNUKhataCreate Product*Created by: arun kelkar*
The message under Select Category should be "If you want to put this product under a Category/Sub-Category, you must create it first."*Created by: arun kelkar*
The message under Select Category should be "If you want to put this product under a Category/Sub-Category, you must create it first."https://git.fosscommunity.in/gnukhata/gkcore/-/issues/261Bill wise Accounting Part I2017-03-13T02:28:46ZGNUKhataBill wise Accounting Part I*Created by: arun kelkar*
This is a major feature of an accounting software and is a very useful tool for the businessmen.
PFA[bill_wise_accounting_part_I.odt](/uploads/0c81da1f4b73d2a7357ef604d1e7c861/bill_wise_accounting_part_I.odt)*Created by: arun kelkar*
This is a major feature of an accounting software and is a very useful tool for the businessmen.
PFA[bill_wise_accounting_part_I.odt](/uploads/0c81da1f4b73d2a7357ef604d1e7c861/bill_wise_accounting_part_I.odt)https://git.fosscommunity.in/gnukhata/gkcore/-/issues/262Bill wise Accounting Part II2017-03-13T02:39:04ZGNUKhataBill wise Accounting Part II*Created by: arun kelkar*
[bill_wise_accounting_part_II.odt](/uploads/0fc090eec6981fb1c72ee2a42ab02ead/bill_wise_accounting_part_II.odt)*Created by: arun kelkar*
[bill_wise_accounting_part_II.odt](/uploads/0fc090eec6981fb1c72ee2a42ab02ead/bill_wise_accounting_part_II.odt)https://git.fosscommunity.in/gnukhata/gkcore/-/issues/263Bill wise accounting part III2017-03-14T03:51:17ZGNUKhataBill wise accounting part III*Created by: arun kelkar*
[billwise_accounting_part_III.odt](/uploads/38a4a1fd8a01e4dceffc35eaee7ae3dd/billwise_accounting_part_III.odt)*Created by: arun kelkar*
[billwise_accounting_part_III.odt](/uploads/38a4a1fd8a01e4dceffc35eaee7ae3dd/billwise_accounting_part_III.odt)https://git.fosscommunity.in/gnukhata/gkwebapp/-/issues/673Edit Organisation Details2017-07-06T10:24:20ZGNUKhataEdit Organisation Details*Created by: Reshma Bhatawadekar*
When a new organization is created, how can there be Edit Organisation Details option in the Master Tab of the Menu Bar? It should be Enter Organisation Details. Also the title of the next screen should...*Created by: Reshma Bhatawadekar*
When a new organization is created, how can there be Edit Organisation Details option in the Master Tab of the Menu Bar? It should be Enter Organisation Details. Also the title of the next screen should be Organisation Details and not Edit Organisation.
**Imported comments:**
*By Reshma Bhatawadekar on 2017-07-06T10:24:20.592Z*
removed milestone
*By Reshma Bhatawadekar on 2017-06-03T10:23:09.228Z*
removed ~1986319 label
*By Reshma Bhatawadekar on 2017-06-03T10:21:57.387Z*
mentioned in merge request !568
*By Reshma Bhatawadekar on 2017-06-03T09:22:11.490Z*
added ~1986319 labelhttps://git.fosscommunity.in/gnukhata/gkcore/-/issues/265Extension of Financial Year2017-03-17T03:47:11ZGNUKhataExtension of Financial Year*Created by: arun kelkar*
Presently, in GNUkhata after Close Books and Roll Over, the user is saved from the botheration of creating a new organization, opening new accounts, bringing down opening balances etc. This is great.
But can w...*Created by: arun kelkar*
Presently, in GNUkhata after Close Books and Roll Over, the user is saved from the botheration of creating a new organization, opening new accounts, bringing down opening balances etc. This is great.
But can we allow a user to extend the Financial Year after Close Books?
It goes without saying that the user will not be able to make entries in the books which are closed.
This will achieve many things. Roll Over will become optional (Even Extension of Financial Year would be optional). If Extension of Financial Year is allowed, not only the financial and Inventory structure and records of the earlier year will be available for display and study, but also other things such as Godowns, users with their passwords etc will also be available. This will aid in future when Payroll Module etc will be introduced in GNUkhata.
Also under the proposed GST, goods returned within six months of the sale or purchase are to be considered while calculating GST payable. If the Extension of Financial Year is allowed, the records of the earlier year(s) would be available for verifying the dates of transactions effected in the last months of the earlier year.
Of course, this is a major decision and a lot of discussion would have to take place about this.https://git.fosscommunity.in/gnukhata/gkcore/-/issues/266Stock Valuation Methods2018-07-12T10:33:27ZGNUKhataStock Valuation Methods*Created by: arun kelkar*
[valuation_of_stock.odt](/uploads/5f792b02bd0878446ba40d4a02ed1beb/valuation_of_stock.odt)*Created by: arun kelkar*
[valuation_of_stock.odt](/uploads/5f792b02bd0878446ba40d4a02ed1beb/valuation_of_stock.odt)https://git.fosscommunity.in/gnukhata/gkcore/-/issues/267Drill Down from Trial Balance2017-03-19T04:57:14ZGNUKhataDrill Down from Trial Balance*Created by: arun kelkar*
When a user drills down from Trial balance he sees a ledger account but this account is seen without narration, can we not provide a button whereby the user can see all the narrations along with the transactions.*Created by: arun kelkar*
When a user drills down from Trial balance he sees a ledger account but this account is seen without narration, can we not provide a button whereby the user can see all the narrations along with the transactions.https://git.fosscommunity.in/gnukhata/gkwebapp/-/issues/677Username and password notification Issue in consolidated accounts2017-06-13T10:52:53ZGNUKhataUsername and password notification Issue in consolidated accounts*Created by: NIshigandha*
1)open consolidated account
2)select any org
3)click next
4)without entering any username and password click submit
"error msg should be changed to- please enter username and password "
**Imported commen...*Created by: NIshigandha*
1)open consolidated account
2)select any org
3)click next
4)without entering any username and password click submit
"error msg should be changed to- please enter username and password "
**Imported comments:**
*By Reshma Bhatawadekar on 2017-06-13T10:52:53.433Z*
removed assignee
*By Reshma Bhatawadekar on 2017-06-13T10:52:43.235Z*
removed ~1986319 label
*By Reshma Bhatawadekar on 2017-06-13T10:52:27.628Z*
removed milestone
*By Reshma Bhatawadekar on 2017-06-13T08:55:22.413Z*
assigned to @reshma1
*By Reshma Bhatawadekar on 2017-06-13T08:55:11.979Z*
changed milestone to %12
*By Reshma Bhatawadekar on 2017-06-13T08:55:06.082Z*
added ~1986319 label
*By Prajkta Patkar on 2017-06-05T09:58:28.970Z*
changed the descriptionhttps://git.fosscommunity.in/gnukhata/gkwebapp/-/issues/678Stock on Hand Report2017-06-05T11:20:19ZGNUKhataStock on Hand Report*Created by: arun kelkar*
Where I select Godownsise report, I can select a godown and see the report but after this the only option I have is "View Another Stock( the appropriate word here is Product and not Stock). I should be given an...*Created by: arun kelkar*
Where I select Godownsise report, I can select a godown and see the report but after this the only option I have is "View Another Stock( the appropriate word here is Product and not Stock). I should be given an option of viewing the same product for another godown.https://git.fosscommunity.in/gnukhata/gkwebapp/-/issues/681Bug inTAX while creating Sales invoice2017-06-06T16:48:17ZGNUKhataBug inTAX while creating Sales invoice*Created by: Bhavesh Bawadhane*
when user creates a sales invoice and selects tax applicable as central, then whatever entered amount against tax rate is erased and made zero.
Steps towards this should be-
1. Let user decide tax type ...*Created by: Bhavesh Bawadhane*
when user creates a sales invoice and selects tax applicable as central, then whatever entered amount against tax rate is erased and made zero.
Steps towards this should be-
1. Let user decide tax type for an invoice then if the selected product already has a tax amount for that type of tax then apply it[Again it is editable].
2. If the tax is not specified while creating product, then let user apply any tax type and rate in invoice.https://git.fosscommunity.in/gnukhata/gkcore/-/issues/270Record Purchase Invoice2017-03-24T06:52:16ZGNUKhataRecord Purchase Invoice*Created by: arun kelkar*
Delivery Notes Nos should appear in ascending order of the entire No. Presently 054 comes before 006.*Created by: arun kelkar*
Delivery Notes Nos should appear in ascending order of the entire No. Presently 054 comes before 006.https://git.fosscommunity.in/gnukhata/gkwebapp/-/issues/683Default image for organisation logo2017-06-09T06:00:41ZAbhijith Balanabhijithb21@openmailbox.orgDefault image for organisation logo*Created by: Abhi1tb*
Add a default image for organisation logo in edit organisation page.
**Imported comments:**
*By Abhi1tb on 2017-06-09T06:00:41.574Z*
changed the description*Created by: Abhi1tb*
Add a default image for organisation logo in edit organisation page.
**Imported comments:**
*By Abhi1tb on 2017-06-09T06:00:41.574Z*
changed the descriptionhttps://git.fosscommunity.in/gnukhata/gkwebapp/-/issues/684SALE RETURN, PURCHASE RETURN, DEBIT NOTE, CREDIT NOTE REGISTER2017-06-09T06:39:10ZGNUKhataSALE RETURN, PURCHASE RETURN, DEBIT NOTE, CREDIT NOTE REGISTER*Created by: Bhavesh Bawadhane*
These reports will be in columnar form and amount columns will have totals at the bottom. The contents of these reports will be almost similar. The contents are:
1. Sr. No.
2. Invoice No.
3. Invoice Da...*Created by: Bhavesh Bawadhane*
These reports will be in columnar form and amount columns will have totals at the bottom. The contents of these reports will be almost similar. The contents are:
1. Sr. No.
2. Invoice No.
3. Invoice Date
4. Name of the buyer
5. Name of the consignee, if different from the buyer, and his address.
6. Name of the Godown from where the goods dispatched.
7. Party’s VAT and CST Registration No.
8. Party’s PAN
9. Voucher No.
10. Purchase / Sale Order No.
11. Purchase / Sale Order Date
12. Total of Invoice
13. Net Amount
14. Type of Tax
15. Tax Amount
There are different types of taxes, such as, VAT, CST, Service Tax, GST/ Excise, Additional Duty, Countervailing Duty, Higher Education Cess, Swatchha Bharat Cess and these are to be shown separately.
At times other charges are levied, such as Freight, Insurance, Packing Forwarding etc. and these have to be shown separately. In short all amounts shown in the Invoice will be shown separately in these reports.https://git.fosscommunity.in/gnukhata/gkcore/-/issues/273create Sales Invoice2017-03-24T06:58:37ZGNUKhatacreate Sales Invoice*Created by: arun kelkar*
Unnecessary large space is left between the first two rows. The field Customer Name can be shifted one row above so that all the details can fit in two rows.
I cannot use up down arrow key for scrolling. I th...*Created by: arun kelkar*
Unnecessary large space is left between the first two rows. The field Customer Name can be shifted one row above so that all the details can fit in two rows.
I cannot use up down arrow key for scrolling. I think it is happening in all reports. Pl check.
I had mentioned earlier that the buttons at the bottom of the screen should be visible at all times in all screens. I think I had mentioned this earlier.
Total Amount should appear in words.
In this module also a zero and a minus figure is accepted as Price per unit.
The width of the column Price Per Unit should be reduced and the width of Tax Amount should be increased.
Tax Rate% should be changed to Tax Rate %.
Why is the space left after the Total Column?
When I scroll down by using mouse the name of the Organisation and the Financial Year gets hidden.
In the attached screen shot a figure of -2300 is seen as Total, where did it come from?https://git.fosscommunity.in/gnukhata/gkcore/-/issues/274Create Rejection In Note and Rejection Out Note.2017-03-23T02:34:40ZGNUKhataCreate Rejection In Note and Rejection Out Note.*Created by: arun kelkar*
For Rejection In Note the fields will be
1. Invoice No. or Delivery Out Note No. User will select either of this from the drop down and when this is done the date of Invoice and the Customers details will appe...*Created by: arun kelkar*
For Rejection In Note the fields will be
1. Invoice No. or Delivery Out Note No. User will select either of this from the drop down and when this is done the date of Invoice and the Customers details will appear.
Also all the items supplied under the selected Invoice will appear in a table below. This table will have the following columns. (1)Sr. No. (2)Product Name, (3)Quantity Supplied. (4) Quantity Rejected. (5) Price Charged. (6) Type of Tax (7) Tax Rate Charged in the Invoice. All the columns will be filled with data automatically once the Invoice No is selected. User will enter the quantity rejected. Quantity cannot be zero or less than zero. Godown Name, if created.
For Rejection Out Note the fields will be similar, except here the user will select the Purchase Invoice No. or Delivery Note No. The column headings will suitably changed.https://git.fosscommunity.in/gnukhata/gkwebapp/-/issues/686Create Product2017-06-11T09:58:00ZGNUKhataCreate Product*Created by: arun kelkar*
When I create product want to record stock godown-wise, I am able to select only one godown. After I enter the quantity of the first godown and I press enter or tab key the cursor goes directly to save button.
...*Created by: arun kelkar*
When I create product want to record stock godown-wise, I am able to select only one godown. After I enter the quantity of the first godown and I press enter or tab key the cursor goes directly to save button.
**Imported comments:**
*By Prajkta Patkar on 2017-06-11T09:58:00.505Z*
If you have only 1 godown then the behavior of software is right.https://git.fosscommunity.in/gnukhata/gkcore/-/issues/275New Modules and reports2017-03-24T02:50:12ZGNUKhataNew Modules and reports*Created by: arun kelkar*
Following Modules are to be prepared.
1. Rejection In Note. 2. Rejection Out Note.
Following reports are to be prepared
1. List of Transfer Notes
2. List of Rejection In Note
3. List of Rejection Out Note.*Created by: arun kelkar*
Following Modules are to be prepared.
1. Rejection In Note. 2. Rejection Out Note.
Following reports are to be prepared
1. List of Transfer Notes
2. List of Rejection In Note
3. List of Rejection Out Note.