Quantity total below create / view / edit invoice
Hello Recently in India GST was implemented. The government requires to report sale / purchase quantity too in invoice. When I create / view / edit invoice, I can see Invoice total and tax total in status bar. Is it possible to add Quantity total too? Or is there any other way? Thanks in advance. Amish ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Quantity total below create / view / edit invoice
Op donderdag 19 oktober 2017 02:56:27 CEST schreef Amish: > Hello > > Recently in India GST was implemented. > > The government requires to report sale / purchase quantity too in invoice. > > When I create / view / edit invoice, I can see Invoice total and tax > total in status bar. > > Is it possible to add Quantity total too? Or is there any other way? > The only way I see is to create your own custom invoice report, which will unfortunately require you to write some code in the guile/scheme language. Regards, Geert ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Quantity total below create / view / edit invoice
On Thursday 19 October 2017 01:00 PM, Geert Janssens wrote: Op donderdag 19 oktober 2017 02:56:27 CEST schreef Amish: Hello Recently in India GST was implemented. The government requires to report sale / purchase quantity too in invoice. When I create / view / edit invoice, I can see Invoice total and tax total in status bar. Is it possible to add Quantity total too? Or is there any other way? The only way I see is to create your own custom invoice report, which will unfortunately require you to write some code in the guile/scheme language. Regards, Geert I think you are mixing my query with a similar query posted earlier today. I am not talking about reports. But I am talking about "Invoice tab" that is opened when feeding data about Invoice. As we keep adding "Invoice items", the status bar shows "Total, Subtotal and tax total" I think it would be nice if "Quantity" total is also shown in status bar. This would require source code changes and not guile/scheme. Thanks and regards, Amish ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Quantity total below create / view / edit invoice
On Thursday, 19 October 2017 10:35:53 BST Amish wrote: > On Thursday 19 October 2017 01:00 PM, Geert Janssens wrote: > > Op donderdag 19 oktober 2017 02:56:27 CEST schreef Amish: > >> Hello > >> > >> Recently in India GST was implemented. > >> > >> The government requires to report sale / purchase quantity too in > >> invoice. > >> > >> When I create / view / edit invoice, I can see Invoice total and tax > >> total in status bar. > >> > >> Is it possible to add Quantity total too? Or is there any other way? > > > > The only way I see is to create your own custom invoice report, which will > > unfortunately require you to write some code in the guile/scheme language. > > > > Regards, > > > > Geert > > I think you are mixing my query with a similar query posted earlier today. > > I am not talking about reports. But I am talking about "Invoice tab" > that is opened when feeding data about Invoice. > > As we keep adding "Invoice items", the status bar shows "Total, Subtotal > and tax total" > > I think it would be nice if "Quantity" total is also shown in status bar. > > This would require source code changes and not guile/scheme. > > Thanks and regards, > > Amish Hi Amish, Whilst I don't ignore the stupid rules that tax authorities around the world dream up, I don't understand how summing the quantities of line items on an invoice is in any way useful. E.g. your customer buys 1 bulk box containing 10 widgets (line 1 - and costing less than 10 individual widgets) and 3 sprockets (line 2). you list those on the invoice as quantities 1 and 3. What use is the number 4? your customer has 13 discrete items... I completely can see that the line item quantity numbers should be shown on the invoice, and a government could mandate that. If they really do want a "total quantity" shown at the bottom of the invoice, then that would be the GC invoice template that needs a mod, not the register window? 0.02 Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Quantity total below create / view / edit invoice
On Thursday 19 October 2017 03:27 PM, Maf. King wrote: On Thursday, 19 October 2017 10:35:53 BST Amish wrote: On Thursday 19 October 2017 01:00 PM, Geert Janssens wrote: Op donderdag 19 oktober 2017 02:56:27 CEST schreef Amish: Hello Recently in India GST was implemented. The government requires to report sale / purchase quantity too in invoice. When I create / view / edit invoice, I can see Invoice total and tax total in status bar. Is it possible to add Quantity total too? Or is there any other way? The only way I see is to create your own custom invoice report, which will unfortunately require you to write some code in the guile/scheme language. Regards, Geert I think you are mixing my query with a similar query posted earlier today. I am not talking about reports. But I am talking about "Invoice tab" that is opened when feeding data about Invoice. As we keep adding "Invoice items", the status bar shows "Total, Subtotal and tax total" I think it would be nice if "Quantity" total is also shown in status bar. This would require source code changes and not guile/scheme. Thanks and regards, Amish Hi Amish, Whilst I don't ignore the stupid rules that tax authorities around the world dream up, I don't understand how summing the quantities of line items on an invoice is in any way useful. E.g. your customer buys 1 bulk box containing 10 widgets (line 1 - and costing less than 10 individual widgets) and 3 sprockets (line 2). you list those on the invoice as quantities 1 and 3. What use is the number 4? your customer has 13 discrete items... I completely can see that the line item quantity numbers should be shown on the invoice, and a government could mandate that. If they really do want a "total quantity" shown at the bottom of the invoice, then that would be the GC invoice template that needs a mod, not the register window? 0.02 Maf. I agree if units are different then quantity makes no sense. But in my case its always "PCS" (pieces) so it should help a bit. Also we dont have to print quantity on Invoice but every month we have to file tax return which mentions HSN code of item and number of pieces sold. I know its crazy but then who can say anything to Government? I will try to see if I can learn report templates. Thanks all for replies. Amish. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Quantity total below create / view / edit invoice
Op donderdag 19 oktober 2017 11:35:53 CEST schreef Amish: > On Thursday 19 October 2017 01:00 PM, Geert Janssens wrote: > > Op donderdag 19 oktober 2017 02:56:27 CEST schreef Amish: > >> Hello > >> > >> Recently in India GST was implemented. > >> > >> The government requires to report sale / purchase quantity too in > >> invoice. > >> > >> When I create / view / edit invoice, I can see Invoice total and tax > >> total in status bar. > >> > >> Is it possible to add Quantity total too? Or is there any other way? > > > > The only way I see is to create your own custom invoice report, which will > > unfortunately require you to write some code in the guile/scheme language. > > > > Regards, > > > > Geert > > I think you are mixing my query with a similar query posted earlier today. > No, I was misinterpreting your query because I found it confusing in itself. Your message starts with the statement that your government requires to report sale/purchase quantity (too) in invoice. I interpreted this as the requirement to add a total quantity on the printed invoice which means it should be added to an invoice report. That's why I suggested to alter an existing report. > I am not talking about reports. But I am talking about "Invoice tab" > that is opened when feeding data about Invoice. > > As we keep adding "Invoice items", the status bar shows "Total, Subtotal > and tax total" > > I think it would be nice if "Quantity" total is also shown in status bar. > > This would require source code changes and not guile/scheme. Rereading your message I understand this now. And yes that would mean changing the C code. But I'm not sure that would be the most efficient solution to your direct problem: reporting total amounts invoiced to the government. It would still require you to open each invoice in a tab, read the amount and make a sum manually. It would be more useful and efficient to create a tax report tailored to your local regulations that lists all the information you require in one summary. That would really save you some time in the long run. It does require guile/ scheme knowledge I'm afraid. There are a few localized tax reports available in GnuCash that may be used as a starting point. But that's just one suggestion from my point of view of course. Regards, Geert ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Quantity total below create / view / edit invoice
On 10/19/2017 05:24 AM, Amish wrote: On Thursday 19 October 2017 03:27 PM, Maf. King wrote: On Thursday, 19 October 2017 10:35:53 BST Amish wrote: On Thursday 19 October 2017 01:00 PM, Geert Janssens wrote: Op donderdag 19 oktober 2017 02:56:27 CEST schreef Amish: Hello Recently in India GST was implemented. The government requires to report sale / purchase quantity too in invoice. When I create / view / edit invoice, I can see Invoice total and tax total in status bar. Is it possible to add Quantity total too? Or is there any other way? The only way I see is to create your own custom invoice report, which will unfortunately require you to write some code in the guile/scheme language. Regards, Geert I think you are mixing my query with a similar query posted earlier today. I am not talking about reports. But I am talking about "Invoice tab" that is opened when feeding data about Invoice. As we keep adding "Invoice items", the status bar shows "Total, Subtotal and tax total" I think it would be nice if "Quantity" total is also shown in status bar. This would require source code changes and not guile/scheme. Thanks and regards, Amish Hi Amish, Whilst I don't ignore the stupid rules that tax authorities around the world dream up, I don't understand how summing the quantities of line items on an invoice is in any way useful. E.g. your customer buys 1 bulk box containing 10 widgets (line 1 - and costing less than 10 individual widgets) and 3 sprockets (line 2). you list those on the invoice as quantities 1 and 3. What use is the number 4? your customer has 13 discrete items... I completely can see that the line item quantity numbers should be shown on the invoice, and a government could mandate that. If they really do want a "total quantity" shown at the bottom of the invoice, then that would be the GC invoice template that needs a mod, not the register window? 0.02 Maf. I agree if units are different then quantity makes no sense. But in my case its always "PCS" (pieces) so it should help a bit. Also we dont have to print quantity on Invoice but every month we have to file tax return which mentions HSN code of item and number of pieces sold. I know its crazy but then who can say anything to Government? I will try to see if I can learn report templates. Thanks all for replies. Amish. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. This is really starting to sound like a job for some sort of inventory control software, not an accounting package. Regards. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Quantity total below create / view / edit invoice
On Thursday 19 October 2017 08:06 PM, Ronal B Morse wrote: This is really starting to sound like a job for some sort of inventory control software, not an accounting package. Regards. Nope I am not asking for item tracking. (sold, purchase, in stock). Its just stupid Government compliance issue and for actual business I have no use of "total quantity" feature. Amish. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Quantity total below create / view / edit invoice
For individual invoices you should already be able to see columns for quantity and price per line item. As for a report that consolidates this data across various invoices - no, you’ll need to modify or write a new report, or save the invoices in html, parse the line items to csv, and then use a spreadsheet or other means to manage the actual report. Regards, Adrien > On Oct 19, 2017, at 12:15 PM, Amish wrote: > > On Thursday 19 October 2017 08:06 PM, Ronal B Morse wrote: > >> This is really starting to sound like a job for some sort of inventory >> control software, not an accounting package. >> >> Regards. >> > > Nope I am not asking for item tracking. (sold, purchase, in stock). > > Its just stupid Government compliance issue and for actual business I have no > use of "total quantity" feature. > > Amish. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
