nka Posted August 16, 2011 Share Posted August 16, 2011 Hello, Well, I wish to be able to track mileage directly on WHMCS. At first, I was thinking I could just add a products called "Miles" at a cost of 0$ and then invoice in quantity, so I could just get a report at the end of the year. But WHMCS is not made to be able to know the quantity that have been invoiced. Do you have an idea? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted August 16, 2011 WHMCS Support Manager Share Posted August 16, 2011 You would need to create a quantity configurable option, set the unit price there and the quantity can be defined there: http://docs.whmcs.com/Configurable_Options 0 Quote Link to comment Share on other sites More sharing options...
nka Posted August 16, 2011 Author Share Posted August 16, 2011 (edited) Quantity configurable options look very what I need... But how to add it to the invoice directly? Cause, I could create a produts called "Mileage" and then add configuration option to it, but I don't understand how I could add "20" of them on the next invoice then an other 30, and so on. Except by editing manually the number each time (this won't work, I'll loose tracking, I'll stick to the Excel sheet then) or creating a new product each time. Edited August 16, 2011 by nka 0 Quote Link to comment Share on other sites More sharing options...
nka Posted August 16, 2011 Author Share Posted August 16, 2011 I was thinking It could be very simple to add x "hours" of a products called "Mileage", but WHMCS dosen't keep the quantity in the DB, so I can't compile it at the end of the year and in case of inspection, I wont be able to tell where the KM was. Association with the invoice would be VERY easy to track! 0 Quote Link to comment Share on other sites More sharing options...
nka Posted August 16, 2011 Author Share Posted August 16, 2011 Oh... I just fond that in tblbillableitems, there's still the number of Hours in the table. The "id" of the item is linked to "relid" in table tblinvoiceitems. tblinvoiceitems contain the invoice number... cool, I'll send that to my programmer now! 0 Quote Link to comment Share on other sites More sharing options...
nka Posted August 16, 2011 Author Share Posted August 16, 2011 Oh, but, I just remember there's no "product id" associated with that billing item, so I'll need to filter from the description! 0 Quote Link to comment Share on other sites More sharing options...
nka Posted August 16, 2011 Author Share Posted August 16, 2011 and there's no "creation date". Still doable, but creating a lot more job since we will have to validate into many tables. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.