Jump to content
Jam

Quantity in Invoices Section

Recommended Posts

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

image.thumb.png.56b845ea44bb017aef8ad3e2466e7296.png

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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!!!

 

 

Share this post


Link to post
Share on other sites

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 by Kian

Share this post


Link to post
Share on other sites
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).

Share this post


Link to post
Share on other sites
 
 
 
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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated