Quantity in Invoices Section

[Jam]

Is it possible to see the quantity of the product in the Invoices section that the client buys? 

[brian!]

9 hours ago, Jam said:

Is it possible to see the quantity of the product in the Invoices section that the client buys? 

that's a hardcoded page in the admin area, with no template - so there are only limited changes that you can make to it.

in any event, WHMCS doesn't store product quantities in the database as a separate value - they would need to be found by querying the database.

if you wanted this information. I suspect that it would be a simpler option to write a custom report / admin page and then you could decide what information needs to be shown.

[zitu4life]

Perhaps it is not what you are looking for, but if you first   create an  quote, than on quote you are able to specify    items   quantity   and  if you convert that quote to invoice,   your invoice  line description will   show

items quantity like:

5 x   hosting basic

3 x  addon     xyz

PS:  convert  quote  to invoice also   has it is limitation!!!

 

 

[Kian]

It would be possible but it's boring as hell:

1. In AdminAreaHeaderOutput use document ready event
2. Run a custom query to retreive quantity from descriptions of all invoices listed on the page
3. Use jQuery to add an additional columns and all rows based on invoice ID to display qty values

It takes an hour if you know what you're doing but it's not worth it. Writing a custom report / admin page like brian suggested page is a lot easier.

 

Edited December 12, 2019 by Kian

[brian!]

12 hours ago, zitu4life said:

Perhaps it is not what you are looking for, but if you first   create an  quote, than on quote you are able to specify    items   quantity   and  if you convert that quote to invoice,   your invoice  line description will  show items quantity like:

but they're not stored in the database like that - that's only how the invoice presents quantities in the descriptions (when the feature is enabled).

[Jam]

 

 

 

1

On 12/12/2019 at 2:26 AM, brian! said:

that's a hardcoded page in the admin area, with no template - so there are only limited changes that you can make to it.

in any event, WHMCS doesn't store product quantities in the database as a separate value - they would need to be found by querying the database.

if you wanted this information. I suspect that it would be a simpler option to write a custom report / admin page and then you could decide what information needs to be shown.

Hello Sir, What do you mean no template? Sorry I am new in using WHMCS

[brian!]

8 hours ago, Jam said:

What do you mean no template? Sorry I am new in using WHMCS

most pages in the admin area don't include a Smarty template - there are only a handful that do (the client summary page being the obvious one, plus viewing support tickets, the homepage, the sidebar and menus etc)... everything will be hardcoded in encrypted files that you won't have direct access to... I don't think there's a generic technical reason why they couldn't use more templates in the admin area, but WHMCS has seemingly always been this way.

so for those pages that have their own templates, you can edit them yourself; for those pages that don't (e.g the invoices page that you asked about), you only have limited options available to you to change things... e.g hooks, css etc.