Agriculture

[François de Ryckel]

I was wondering if anybody has every tried to use erpnext for agriculture and how to go about it?

It is just a special kind of "manufacturing".  

Expect 

workstation are "farm field"  (with many special fields such pH of soils, type of soils, etc.)

Then you have all your inputs (seeds, agrochemicals, etc.) spread over the duration of the crop.

You have an output 3 to 12 months later depending of your crop.

We should be able to track:

The total amount & costs of all inputs + labor for a certain crop

The total yield (and income) for that certain crop.

What would be the cost to develop a module which can track these things?  

I'm not a developer but I would be willing to finance part of such a project.  The agricultural ERP i've checked, web-based or not, are ridiculously expensive.

Best,

François

[Sunil Kumar]

Hello Francois,

Sounds interesting. Its a nice idea to do some sort of precise analysis on feasibility of deploying ERPNext for Agriculture sector.

The reason I'm excited about this is- India is the second largest country in farm output worldwide. And almost 50% of Indian workforce are working for agriculture sector. And adding a module/features for agriculture sector in ERPNext would be a great idea. Now, coming back to ERPNext, our core philosophy is to address the relatively larger and common gap in society by developing and promoting open source software. And I'm sure, agriculture sector deserves the best.

Definitely, Rushabh would be interested in considering your features request. Thank you so much once again Francois for coming up with such an innovative thought. 

----

Sunil

Nescode (http://nescode.com)

Partner for ERPNext

[François de Ryckel]

Thanks Sunil,

I'm just starting using ERPnext, I am still in the trial period ;-).  I've used salesforce and tryton, but I really find erpnext so much easier to use, the cloud version is an absolute deal and what we get for that price is just great.  

I mentioned agriculture as I'm quite involve there and I do see lots of potential for such a module / customizations.    It is understood that erpnext and any development is open source.

Best,

François

[chetan sharma]

Hi Francois 

       Its awesome that you are using it for Agriculture purpose. 

[Corinne Claypool]

I haven't used ERPnext for agriculture in such a direct manner before, but I am working in a related field.  If you only want to know how much did it cost to produce this crop on this field as an aggregate, they I think you should be set.  If you want to use that number to decide for example how many acres to plant in this particular crop (ie forcasting) then you might run into issues.  Let's assume that ultimately you would want to track your crops as a production ratio per acre(bushels per acre etc).  If that is the case, you will have a similar issue to what I am having. There is a certain minimum cost to run the cycle (season) just get the machinery and labor into the field, then, as your acres/field gets larger, the cost is spread out over more acres and therefore keeping the field serviced is less/acre.  The way that ERPnext is currently set up, you would not be able to adjust for this efficiency.  It would give you a cost per acre that is the same whether your field is 10 acres or 40.

So while I think you can certainly track your crop costs the way you are outlining, it really depends on what you want that data for .... record keeping? then I think you are on track.  Forecasting and planning for future crop cycles? you might need some tweaking from your current proposal, again depending on exactly what you want to plan/forecast.

Good luck!

[Rushabh Mehta]

On 27-Aug-2014, at 3:39 pm, Corinne Claypool <c.cla...@gmail.com> wrote:

I haven't used ERPnext for agriculture in such a direct manner before, but I am working in a related field.  If you only want to know how much did it cost to produce this crop on this field as an aggregate, they I think you should be set.  If you want to use that number to decide for example how many acres to plant in this particular crop (ie forcasting) then you might run into issues.  Let's assume that ultimately you would want to track your crops as a production ratio per acre(bushels per acre etc).  If that is the case, you will have a similar issue to what I am having. There is a certain minimum cost to run the cycle (season) just get the machinery and labor into the field, then, as your acres/field gets larger, the cost is spread out over more acres and therefore keeping the field serviced is less/acre.  The way that ERPnext is currently set up, you would not be able to adjust for this efficiency.  It would give you a cost per acre that is the same whether your field is 10 acres or 40.

Corrine - thanks, we will add that feature soon - I think it would be a valuable addition.

So while I think you can certainly track your crop costs the way you are outlining, it really depends on what you want that data for .... record keeping? then I think you are on track.  Forecasting and planning for future crop cycles? you might need some tweaking from your current proposal, again depending on exactly what you want to plan/forecast.

Please feel free to edit this wiki:

https://github.com/frappe/erpnext/wiki/Agri---Farm-ERPNext

Good luck!

On Saturday, August 23, 2014 8:12:23 AM UTC-5, François de Ryckel wrote:

I was wondering if anybody has every tried to use erpnext for agriculture and how to go about it?

It is just a special kind of "manufacturing".  

Expect 

workstation are "farm field"  (with many special fields such pH of soils, type of soils, etc.)

Then you have all your inputs (seeds, agrochemicals, etc.) spread over the duration of the crop.

You have an output 3 to 12 months later depending of your crop.

We should be able to track:

The total amount & costs of all inputs + labor for a certain crop

The total yield (and income) for that certain crop.

What would be the cost to develop a module which can track these things?  

I'm not a developer but I would be willing to finance part of such a project.  The agricultural ERP i've checked, web-based or not, are ridiculously expensive.

Best,

François

--
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/1733c14c-1489-4fbb-8632-fdda962931db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[François de Ryckel]

Good morning,

Thanks for creating this wiki.  

I've added quite a few items on it.  I'm not too used to this so I hope I didn't messed it up too much.

I've made these additions from a documents I was planning to share: 

https://docs.google.com/document/d/1RtDBF_FmIumQ-EXCUoWl24oFvhRgwOfdwzA8oWi8Prs/edit?usp=sharing

I hope this help.

Best,

François

You received this message because you are subscribed to a topic in the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/Vhu0z__ijFU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to erpnext-user-fo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/C25DBC74-6555-40D5-BA79-15DEFA3BE31D%40gmail.com.

[François de Ryckel]

On 27 Aug 2014, at 12:09, Corinne Claypool <c.cla...@gmail.com> wrote:

I haven't used ERPnext for agriculture in such a direct manner before, but I am working in a related field.  If you only want to know how much did it cost to produce this crop on this field as an aggregate, they I think you should be set.  

One things I'm struggling with is to add a date "field" into the child table of BOM.  As you know timing is everything in agriculture, we can put the step, but I would love to have a date attached to these steps.

If you want to use that number to decide for example how many acres to plant in this particular crop (ie forcasting) then you might run into issues.  Let's assume that ultimately you would want to track your crops as a production ratio per acre(bushels per acre etc).  If that is the case, you will have a similar issue to what I am having. There is a certain minimum cost to run the cycle (season) just get the machinery and labor into the field, then, as your acres/field gets larger, the cost is spread out over more acres and therefore keeping the field serviced is less/acre.  The way that ERPnext is currently set up, you would not be able to adjust for this efficiency.  It would give you a cost per acre that is the same whether your field is 10 acres or 40.

So while I think you can certainly track your crop costs the way you are outlining, it really depends on what you want that data for .... record keeping? then I think you are on track.  Forecasting and planning for future crop cycles? you might need some tweaking from your current proposal, again depending on exactly what you want to plan/forecast.

Good luck!

On Saturday, August 23, 2014 8:12:23 AM UTC-5, François de Ryckel wrote:

I was wondering if anybody has every tried to use erpnext for agriculture and how to go about it?

It is just a special kind of "manufacturing".  

Expect 

workstation are "farm field"  (with many special fields such pH of soils, type of soils, etc.)

Then you have all your inputs (seeds, agrochemicals, etc.) spread over the duration of the crop.

You have an output 3 to 12 months later depending of your crop.

We should be able to track:

The total amount & costs of all inputs + labor for a certain crop

The total yield (and income) for that certain crop.

What would be the cost to develop a module which can track these things?  

I'm not a developer but I would be willing to finance part of such a project.  The agricultural ERP i've checked, web-based or not, are ridiculously expensive.

Best,

François

[Nabin Hait (ERPNext)]

Add a custom date field in “BOM Item” document via Setup -> Customize -> Custom Field.

You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/3167BB90-F1D3-44A1-BB5C-91BE3D5923FA%40gmail.com.

[Nabin Hait (ERPNext)]

Add a custom date field in “BOM Item” document via Setup -> Customize -> Custom Field.

On Aug 28, 2014, at 2:22 PM, François de Ryckel <f.der...@gmail.com> wrote:

You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/3167BB90-F1D3-44A1-BB5C-91BE3D5923FA%40gmail.com.

[Corinne Claypool]

Seeing as things are time related, maybe you could set up BOM's for much smaller steps (like plant, ground prep, apply amendment etc)

I am kind of thinking out loud here and possibly am wandering off track, but here are some of my thoughts: Could a crop be a project and then you could set up a timeline and cost the project?

or you could set up a maintenance schedule for each of the substeps involved ... the installation notes would let you track actual time spend and any relevant notes?

To unsubscribe from this group and all its topics, send an email to erpnext-user-forum+unsub...@googlegroups.com.

[François de Ryckel]

I've tried that many time but I can't figure it out. 

I would like to add date in the document "BOM" but on both the child table "operation" and "items"

When I do it.  Nothing comes up.  Any options to tick?

Thanks

François

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/39588A54-300D-49C2-8A76-CE5F33CDE96A%40iwebnotes.com.

[robert]

Interesting discussion; integration of ERP and GIS is still a  relatively barren terrain. rgds robert

[François de Ryckel]

Thanks Corinne for all your good ideas and suggestions.  

I'm not confortable enough yet with ERPnext to understand the scope of Project Vs Manufactaring.  I do like the idea of manufacturing where I can keep track of all the inputs (items) & work (operation) I put for a specific crop.  

I did link the BOM to the project (Which the Crop growing from start to selling).  

I managed to add a date to each input and operation, and employee to each operation.  

I'll keep trying.  

@ Robert: GIS is really booming now in agriculture (especially in the case of commercial farming).  In big field / orchard all nutrients application is now done with some sort of GPS device that do allocate the amount of nutrient in respect to the location in the field and the results of the multiple soil / leaves analysis.

Best,

François

To unsubscribe from this group and all its topics, send an email to erpnext-user-fo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/9cfda465-0ffe-46cf-ad0a-61d8c50a088c%40googlegroups.com.

[Rushabh Mehta]

I was thinking about it too.

A simple start would be to add lat, long properties on all masters - this way at least we can start geo-tagging objects and show them on a map?

[Corinne Claypool]

Oh wow... Would that be fantastic... I have growers with multiple ranches and service tasks that are soil samples. I would love to have a "customer map" that located all the properties and the icing on the cake would be to track the location of installation notes or maintenance visits!

Sent from my iPad

[Corinne Claypool]

For an erp that maybe, but SuiteCRM has a really neat mapping/gps feature ... Maybe there is some inspiration to be found there

Sent from my iPad

[François de Ryckel]

Good afternoon Rushabh,

What do you mean by lat/long on all masters?  What are the masters?

I think a set of coordinates would me more useful such as shapefile. 

http://en.wikipedia.org/wiki/Shapefile

Best,

François

To unsubscribe from this group and all its topics, send an email to erpnext-user-fo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/568151c9-e12c-4f29-b182-2aa4ca3e1d48%40googlegroups.com.

[robert]

But than we only have points; no lines or polygons (like an agricultural field). I have suggested the link ERP-GIS already as a potential research topic for an MSc in our Geoinformatics department. Will remind them.

GIS is indeed taking of in (precision ) farming. However, integrating the spatial farm production proicess has been done so far (i believe) from the GIS side (modelling production in a GIS environment) not from the ERP end.

There are plenty of opensourcee gis initiatives such as Ilwis,Mapwindows,QGis,.....as said : would be nice research...

A new kind of functionality would/could be a mix between project and manufacturing. In agriculture inputs are changed during a growth cycle of a crop (a bit extra water or fertilizer) and the output (kg/ha) not know beforehand. So production cost are variable.

I now that Finlays, producing tea, flowers and vegetable in Kenya do use an ERP system, but no glue if their field level farm management is part of the over all ERP