Better reporting for casual invoices

[decor]

hello

I do casual invoices for items that are not in the products list like web design and adwords, etc.

 

Is there a way i can tag a invoice with a generic description and then at the end of the month run a report that will show what all the extra invoices were for . Current reports show products that are in the system but nothing for other invoices.

 

Thanks

ian

[tomdchi]

Anything that you generate an invoice for on the fly (no product pre-defined) will have a relid of zero in the database table tblinvoiceitems. The relid would normally be the id of the product in tblproducts. If you know how to code php you could make a custom report to pull invoices where tblinvoiceitems.relid = 0.

[tomdchi]

edit above. relid is not id of tblproduct but is the id of the table coresponds to what is in the type field. If hosting is the type then relid is the id in tblhosting.

[decor]

Thanks for that , would have prefered if a id / usable description could be entered at invoice creation time, would save time when running reports

 

Ian

[zomex]

While this isn't a feature request I'd also love to see this added. If anyone is thinking about making a module for this functionality I'd buy it

 

Jack

[debodie]

I would also buy this. I submittted a request to support for this same thing however they told me it cannot be done.