As promised during ERPNext Conference, here I present Asset Maintenance Management. Some of you might remember me presenting Equipment Maintenance we have implemented for our company ESO Electronic and many of you wanted that feature. So we have enhanced it and extended it to the new Asset Module.
For each asset create a Asset Maintenance record listing all the associated maintenance tasks, maintenance type (Preventive Maintenance or Calibration), periodicity, assign to and start and end date of maintenance. Based on start date and periodicity the next due date is auto-calculated and a ToDo is created for the Assignee.
This combined with the support module means ERPNext can be a bare-bones standalone CMMS. That’s pretty cool considering there’s no real, reasonably simple, and supported open source CMMS available today, and the present paid options are EXPENSIVE!
One small suggestion is to rename “Asset Repair” to “Asset Work Order” or just “Work Order” - that’s the more common terminology in the CMMS world.
Ideally, based on the maintenance schedule, a “Work Order” is automatically generated which needs to be attended to. But, this implementation works as well!
Another feather to ERPnext. It was just this week i wrote about ehancement of maintenance module and our amiable @JayRam said we should wait a bit for the manufacturing module enhancement to be done and this facility management will be integrated to it.With this ERPnext stand tall as Facility Management Software.
Kudos to the Team and community.
@KanchanChauhan Can you guide me how to create barcode for each item from this module? The items can be located in remote locations hence the need for PDA access to conduct audit trail. Can the controls team access the module through hand held device to conduct audit of stock in EPRNext versus actual physical stock by scanning the printed barcode. Something similar to what supermarkets do to check inventories at retail outlet. I am testing this module on V10 currently.
Thanks for the help. Wishing you a happy new year.
How do I log completion of a Maintenance task after the Due Date?
After creating an Asset Maintenance, a log is created for 19-05-2019, on 21-05-2019 I want to record completion of the task, I tried it in the following 2 ways
When I mark the Status as Completed and Save the Asset Maintenance Log, the status changes to Overdue since the Due date was 19-05-2019 and I am trying to mark it as completed on 21-05-2019
When I try to add a Completion Date; 21-05-2019, there is an error saying “Please select Maintenance Status as Completed or remove Completion Date”
Hi, I am trying to set up an Asset Maintenance program.
When i create an asset there is a mandatory field for ‘Asset Name’ which I fill in but when i create an Asset Maintenance it uses the Asset Series number as the Asset Name.
How do i get the Asset Name to copy to the Asset Maintenance?
Using erpNext Hosted Cloud v12
@KanchanChauhan this was good feedback. But it seems “Work Order” is reserved for manufacturing module – as a manufacturing/production “Work Order”. I guess we have to use “Asset Work Order” or “Maintenance Work Order” or something else.
For us, we are working on replacement for our work order system (a CMMS). The Asset / Maintenance module is probably great for those that don’t have experience with other systems @felix is referring to, but this Assets/Maintenance module becomes a little confusing with the processes and workflows for different things.
Primarily site maintenance teams will have something like this:
Single table of all “Work Orders”
The single “Work Orders” doctype should combine ALL TYPES of work on an asset such as, commissioning, repair, calibration, maintenance, pm, retirement, etc. (just make a work_order_type field). This makes reporting, filtering, dashboards, etc. very easy. This is where current module has an issue (IMO) by giving “Maintenance” and “Repair” different doctypes.
“Recurring Work Orders” would be something like special version of auto-repeat. This is what you are already doing with “Asset Maintenance”. Instead of defining task task task within a single “Asset Maintenance” record, it is probably better to define each as their own doc/record because in the real world each activity probably has specific instructions, SOP’s, defined parts or parts kits to be used, etc. I.e. if asset is vehicle, the every 3 months oil change, has much different instructions (and instructions probably required for tech) than every 5 years engine rebuild.
The “Recurring work order” should just create a “draft” document in the “Work Orders” table assigned to whomever was indicated in the recurring work order template, or TBD by work manager (work_order_assigned_to = 0).
As others suggest, additional frequencies/intervals probably need to be considered (sometimes people have service interval of 3 times per year, or every 5 years, etc.). There will be a minutes frequency for auto-repeat soon, so this should help define whatever frequency anyone needs.
For a CMMS, the Assets/Maintenance module is probably too heavy on finance side. But on the other side of this, it is probably important to be able to link a “work order” to “purchase order” - for finance
Parts / Stock linkage is another nice feature to have . If “work order” is to change oil on vehicle, then maybe the technician processing the work order will consume 5 quarts of oil stock, as well as 1 oil filter from stock. It is nice if this can be indicated within the work order. Probably don’t want to have a technician have to leave the ‘work order’ to go to a different view for Parts/Stock. Let them do within the work order and update qty based on what they report as used/consumed.
In many environments, “work order” must be reviewed/approved by a manager or another person. Work Order should be able to be submittable document with capability for workflow.
Integration with to “todo” for assigned maintenance tasks is nice because it uses frappe methodology - but maybe makes workflow more complicated than needs to be? A simple “Assigned to me” button on top of doctype “Work Order” could work for technicians to see what is assigned to them. (refer to my question here as example… How to make filtered results BUTTON on top of doctype results?)
Problem is this is now 3-4 years later and some people have probably already adopted Assets/Maintenance module as it is. Only thing for me to do is either do is use Assets/Maintenance module as-is (and add new fields I require) or create new app from scratch. But I would use locations, assets, items, etc. still. Difficult decision.