Fleet App for ERPNext

rmehta · November 13, 2015, 3:25am

Someone can only show interest if you share what you have.

Share your work! Just make a documentation site like @revant_one

This is an open source community, lets share what we work on. You never know, you may get feedback, users and even paid consulting work! Even we would love to help you.

You can always keep it all to yourself, but then this kind of sucks in this community. Lets build a community that shares by default

Edit: Thanks @revant_one for getting this started

revant_one · November 13, 2015, 6:46am

People with existing project with community friendly license can set a git repository and share link
https://help.github.com/articles/adding-an-existing-project-to-github-using-the-command-line/

Frappe now generates nice documentation webiste for github project and it is easy to set-up.
https://frappe.github.io/frappe/user/guides/app_development/generating-docs.html
All it generally needs for user docs is one .md file and related screenshots per doctype you create.

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.
Package measurement measurement · PyPI or any other package is not used as there are just two calculations right now.

Anyone interested in developing report or page or dashboard for Vehicle (like “Customer”/“Supplier” in ERPNext)?

Problems I face, I will be discussing on forum. Hopefully generating knowledge base!

Comments welcome.

BuilderMatic · November 13, 2015, 1:25pm

We had begun work on expanding this version: GitHub - dalwadani/fleet_management: Frappe app for managing the organization fleet.
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.

revant_one · November 13, 2015, 2:41pm

I also thought of forking fleet_management and working on that instead of new fleet.
I decided to start new fleet because

Last commit on fleet_management was 25 August 2014 and 2 forks are also even with main repo.
I use android based ACar (for personal use) which I wish to stop using and start using this free & open (clone) Fleet app.
Looked into screenshots of fleetio, It’s similar to ACar. There is no “model” for odometer log in both, I assume odometer is accurately logged when re-fueling.

Fork my repo and go ahead! I’d appreciate any contribution.

Relatively easy for me to code (may be I would push this before reports):

Make Purchase Invoice from Fill Up Record
Add Event Reminder for Vehicle Insurance Expiry

becht_robert · November 13, 2015, 8:15pm

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

chafor · November 23, 2015, 1:57pm

@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.

Thank you for the share.

dsslrbrandon · November 23, 2015, 11:38pm

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.

becht_robert · November 24, 2015, 1:11am

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

dsslrbrandon · November 24, 2015, 2:21am

I would love to see the script if you would not mind sharing! I would be willing to test it out at the least.

mostafa · May 24, 2016, 7:35am

ImportError: No module named fleet.hooks

revant_one · May 24, 2016, 3:10pm

I tried installing on my laptop and it worked.
can you describe the error in detail?

revant@revant-laptop:~/frappe-bench$ bench get-app fleet https://github.com/revant/fleet 
INFO:bench.app:getting app fleet
Cloning into 'fleet'...
remote: Counting objects: 341, done.
remote: Total 341 (delta 0), reused 0 (delta 0), pack-reused 341
Receiving objects: 100% (341/341), 2.41 MiB | 120.00 KiB/s, done.
Resolving deltas: 100% (160/160), done.
Checking connectivity... done.
installing fleet
INFO:bench.app:installing fleet
Wrote ./assets/js/print_format_v3.min.js - 18k
Wrote ./assets/js/frappe-web.min.js - 101k
Wrote ./assets/js/form.min.js - 113k
Wrote ./assets/js/report.min.js - 157k
Wrote ./assets/js/erpnext.min.js - 36k
Wrote ./assets/css/list.min.css - 6k
Wrote ./assets/js/erpnext-web.min.js - 1k
Wrote ./assets/css/report.min.css - 7k
Wrote ./assets/css/frappe-web.css - 51k
Wrote ./assets/js/list.min.js - 66k
Wrote ./assets/js/dialog.min.js - 58k
Wrote ./assets/js/desk.min.js - 874k
Wrote ./assets/css/form.min.css - 2k
Wrote ./assets/js/editor.min.js - 26k
Wrote ./assets/css/erpnext.css - 1k
Wrote ./assets/css/desk.min.css - 256k
Wrote ./assets/css/module.min.css - 2k
revant@revant-laptop:~/frappe-bench$ bench new-site fleet.local --install-app erpnext
MySQL root password: 
Installing frappe...
Updating frappe                     : [========================================]
Updating country info               : [========================================]
Set Administrator password: 
Re-enter Administrator password: 
Installing fixtures...
Installing erpnext...
Updating erpnext                    : [========================================]
Installing fixtures...
*** Scheduler is disabled ***
revant@revant-laptop:~/frappe-bench$ bench --site fleet.local install-app fleet
Installing fleet...
Updating fleet                      : [========================================]
Installing fixtures...

mostafa · May 29, 2016, 5:59am

Thank you It works good

I want to ask you, what do you mean by the following?

Supplier of fuel
_ Missed Fillup_
_ Partial Fillup_

revant_one · May 29, 2016, 7:39am

Select from list of Suppliers e.g. Shell Oil.

Check it if logging this fill up because it was missed before.

If the fill-up is partial. Check this if tank is not filled up to full capacity.

rahy · February 5, 2018, 12:52am

Has this been integrated into the core?
Thanks

aakvatech · May 15, 2019, 12:40pm

Is there a need for ERPNext Fleet Managment Working Group on Telegram to discuss this forward. We have some funds for sponsoring part of the development.

selensoft · May 20, 2019, 10:29pm

Hi, I would be happy to join this group.

mujeerhashmi · May 21, 2019, 5:48am

Hi @revant_one,
This sounds great. I would like to bring to your notice the open source server Traccar for gps based tracking. You have amazing APIs, can fetch the vehicle data into erpnext. Let me know your thoughts about its integration. They also have support for mobile based tracking in case you don’t have hardware GPS device.

aakvatech · July 10, 2019, 6:44pm

https://t.me/joinchat/BIsXOxQrYcYUfHWXqS2yqw

This is the telegram lnk for ERPNext Fleet and Transport Management Group.

Do join so that we can have an app if not a Domain created for ERPNext and Transportation industry.

I have some basic requirements documented.

idao · August 19, 2019, 7:08pm

I’m also very interested in this app, I may provide some funding for that

Iulian_Olaru · August 20, 2019, 2:29am

Likewise here, very interested in the app and willing to fund it.