Basic distance mile / km just using simple multiplication, saves distance and odometer readings in both Distance UOM
Odometer reading in Fill Up Record is validated so that only higher number is entered progressively. e.g. If previous fill up record has odometer 10KM current record can only accept value greater than 10 KM
Trip Record has validation for Arrival Odometer reading should be greater than Departure Odometer Reading.
We are also working on extending the previous version. If we can can contribute in any way - just ask. We will want to extend it into the arena of gps tracking and route planning/management in the new year.
To make the Fleet App useful I plan to generate following ratios:
avg kmpl: total distance / total fuel UOM min kmpl: min mileage from two consecutive fill-ups max kmpl: max mileage from two consecutive fillups last kmpl: mileage between last two fillups avg ₹/l: total price paid / total fill up volume min ₹/l: min price per fuel UOM from two consecutive fillups max ₹/l: max price per fuel UOM from two consecutive fillups last ₹/l: price per fuel UOM from last two fillups ₹/km: Total Price / Total Distance ₹/fill-up: Total Price / number of fill-ups km/₹: total distance / total price l/fill-up: total volume / number of fill-ups km/fill-up: total distance / number of fill-ups days/fill-up: total days from first fill-up to last fill-up / number of fill-ups
Doctype Fill Up Record is storing odometer_km and odometer_mile, so as per the distance UOM in Fleet Settings appropriate Docfield can be used to generate ratio in mpg or kmpl, etc.
Fill Up Record has link to Vehicle.
Doctype Vehicle stores link default_fuel to Item as fuel. So as per the selected Vehicle in Fill Up Record fuel UOM can be found (change in default_fuel and resulting change in fuel uom is not considered right now, may set the field to set once or will have to consider UOM conversions somehow)
Item’s stock_uom and distance UOM in Fleet Settings help decide mpg or kmpl etc.
We had begun work on expanding this version: https://github.com/dalwadani/fleet_management
Seems a waste of time and resources having four (that I know of) groups working on the same basic module when there is so much more needed.
We would work on adding routing using Leaflet elements and GraphHopper to your development if that makes sense. Our development is client funded so we have some restrictions on what we can work on. We are also looking at GPS tracking.
Would be interested in what others see as priorities within this project area.
was missing in erpnext. Nice. Interested. Cannot assist since am not a coder. Would be nice if integrated with accounts, so that petrol bills payments entered as a JV are linked to this app.
As I use the Cloud Subscription have to wait till Frappe “adopts” the devlopment
@revant_one Hi, I got some time right now between and having a fleet management system would be a really nice to have for my company when we’ll switch to ERP Next, so I’ll be willing contribute to your project.
This looks like it might make a good springboard for a Metered Billing app. I wish I knew how to code, because I would look into forking this myself, but it never hurts to suggest someone with an idea.
Off the top of my head, the two markets I can see Metered Billing used are Utility Companies (billing customer per KwH, Water, Gas, etc) and Managed Print Support.
To elaborate on Managed Print: some customers, who use office printers and copiers, have their equipment under contract, where they pay a monthly rate that is usually dependent on the number of pages their equipment prints (For example: the customer may be charged $.015 per page printed, and if they print 8,200 pages in a month, then they would receive a bill for $123 for that month), but will never receive individual bills for Supplies, Parts or Service.
There are commercial ERP solutions on the market, e-Automate and OMD probably being two of the largest, but they are incredibly expensive and cumbersome to setup. I would imagine that if someone developed similar functionality into ERPNext, it would provide them with a HUGE advantage in the open source market, since many of the small dealers are stuck using off the shelf software like Quickbooks, which doesn’t provide anything remotely close to a designated ERP.
Hi we have a script for metered billing. It works fine. It Calculates a bill for 3 tarifs and automatically creates the 3 lines in the invoice. Must say, hat Rushabh things the code is a lind of shaky and difficult to maintain. Our approach may assist you howver. It is done as a JS at the client side