Skip to content

Agri Farm ERPNext

Jump to bottom
Tropicalrambler edited this page Feb 3, 2016 · 31 revisions

1. Land Assets (Tree)

  • Estate. For a Company having more than one estate or farm and in multiple localities
  • Division. Estate may be divided into divisions or may not be divided depending on the organisation structure. Generally its divided for operational efficiency.
  • Field. Divisions are further divided into fields like field 1, 2 etc. This is for work allocation. Work is always allotted based on field nos..
  • Blocks (sometimes big fields have been sub-divided into blocks, useful when soil analysis has been done at several places on the field)

Example:

  1. Company: Future Farming Enterprises Inc.
  2. Divisions: Atlantis Farm, Mulligan Farm 1. Atlantis Farm (contains 2 fields)
    1. Fields: A, B
    2. Field A (contains 7 blocks) 1. Blocks: 0101, 0102, 0103, 0104; 0201, 0202, 0203
    3. Field B (contains 3 blocks) 1. Blocks: 0101, 0102; 0201 1. Mulligan Farm (contains 3 fields)
    4. Fields: A, C, D
    5. Field A (contains 4 blocks) 1. Blocks: lettuce, kale; spinach, spinach02
    6. Field B (contains 9 blocks) 1. Blocks: 0101, 0102, 0103, 0104, 0107; 0201, 0203; 0301, 0304
    7. Field B (contains 2 blocks) 1. Blocks: test-organic, test-regular

One would be able to refer to Atlantis Farm**>Field A>**Block 0103

2. Setup (Documents)

  • Estate or Farm Master.

  • Division Master.

  • Field Master.

    • Name (text)
    • Location
    • Size + UoM (among others: sq meter, sq feet, acres, Ha, etc.)
    • Coordinates (upload a set of coordinates)
    • Type of soil (ie. sandy, loamy, sandy-loam, etc.)
    • Color
    • Soil analyses (child table)
      • date,
      • pH
      • ECEEC
      • clay %
      • UoM (for the results)
      • N, P, K, Ca, S, Fe, Mg, Cu, Zn, Mn, B, Mo,

  • Crop Master: All the crops that are cultivated. It may range from perennial, medium term like 2-3 years, annual and short term like 7-120 days. (Hydroponic production of microgreens, takes only 7 days from seed to harvest)

    • Questions: would this be equivalent to the manufacturing process. So each crop would create a "work in progress" warehouse that is just for that specific crop?
    • Name (text)
    • Variety (text)
    • Field (lookup to field/name)
    • Date planted (Date)
    • Comments (text)

  • Agricultural products [just another kind of item of type “raw material”]

    • Type of product (Fertilisers, Fungicide / insecticide, adjuvants, Biological product)
      • if fertilizer needs % composition for each nutrients
      • if fungicide, insecticide, adjuvant need the name of the active ingredients with UoM per UoM
    • Name
    • MoA group
    • Packaging type (dropdown menu with possibility to add more)
    • Quantity in package (number)
    • UoM (lookup for UoM)
    • Labelled application rate (UoM per UoM)
    • Link to label (website link, link to a file)
    • Link to safety sheet

  • Work Master: All the various activities that are involved like plucking, weeding, spraying etc..

    • Agrochem application [it should be instead of the item {products} in manufacturing]

      • Name (auto)
      • Crop (lookup to crop/name)
      • Date, (date)
      • start time (hh:mm)
      • end time (hh:mm)
      • Type of application: foliar, drench, overhead irrigation (foliar + drench)
      • Amount of water (Quantity + UoM)
      • Products (table)
        • drop-down menu: fertilisers, fungicide, insecticide, adjuvants, Biological products
        • Product (lookup to agricultural products)
        • Quantity (in term of UoM of item)
      • Supervisor(s)
      • Worker(s) (lookup to Employee(s) can be more than 1 person) (or relation to task)
      • can automatically create a time log for that crop task or for that application of products
      • each of this application should create a costs for the product used, like for manufacturing
      • each of these application should create an inventory change with the amount of product used

    • Crop related Task (employee should be related to time log & task). This is really to help calculate the costs involved in growing that crop

      • Name
      • Crop (lookup to Crop/name)
      • Date
      • Start time (hh:mm)
      • End time (hh:mm)
      • Supervisor (lookup to Employee)
      • Worker(s) (lookup to Employee) can be more than one
      • Description
      • [each of these tasks should create a costs for that crop]
      • [all tasks should related to employee not to users. Most labor is not erp users.]

    • Harvest. [the finish product]. This is when the final products go from “crop” warehouse to a storage “warehouse” waiting to be sold.

      • Name (text)
      • Date (date)
      • Crop (lookup to crop).
      • Note that the harvest of a crop can be done over multiple days. So it should be possible to have multiple “harvest record” for a specific crop.
      • Start time
      • End time
      • Supervisor(s)
      • Employee(s)
      • Harvested products (child table)
        • Name (lookup item)
        • one harvest can lead to several type of products. Example, we harvest oranges, and we get oranges Large, oranges Medium and oranges Small (each one are a different item)
        • Quantity
        • UoM
        • Comments (on the quality of the product harvested)
      • Each harvest record will create inventory changes, from the "field" warehouse to the "storage warehouse".

  • Labour Master: All labour data and class of employee – permanent, temporary, casual etc.. The labour is estate specific and hence the master has to be estate specific. We cannot have a labour master for the company as a whole. (part of HR Module)

  • Staff Master: Similar to labour master

  • Asset Master: All fixed assets and their follow up through out the life cycle

  • Allowances Master: Wages and salaries include various components of allowances which need to be flexible as they change from time to time, season to season etc..

3. Activity Reporting

  • Time Logs (extending existing functionality - work done etc)

  • Activity Master

  • Calculate Wages

  • All records tagged to a land asset

  • time logs for machines, task work. tagged to a land asset meaning?

  • labour report - attendance, work done for a certain period consolidated for full labour force at estate level and also individual labour wise report.

  • we need to generate all reports with comparative data for the same period last year or for two years. if this is possible it would help a lot. for eg. on a daily basis we get the crop figures for the day, for the month, for the year. The same is compared with the current year last month and also for the last year. please give it a thought.

  • Field

    • Name of field.
    • Location
    • Size + UoM (among others: sq meter, sq feet, acres, Ha, etc.)
    • Coordinates (upload a set of coordinates)
    • Crop history (Child table related to previous crop on that field)
      • Date planted, date harvested, Crops name, crops variety, Yield per UoM

  • Soil analyses history (child table)

    • date, N, P, K, Ca, S, Fe, Mg, Cu, Zn, Mn, B, Mo,

  • Crops Nutrient program (analytics)

    • Absolute values of fertilisers added Vs time
    • Drop down to select Crop, to select date, to select field
    • check box on:
      • type of application (drench, foliar, overhead, hydroponic)
      • type of nutrient (N, P, K, S, Ca, etc.)
      • Cumulative values of fertilisers added Vs time
    • Drop down to select Crop, to select date, to select field
    • Calendar (with summary of all agrochem applied) - Gantt style
      • check box to select any kind of products (Fertilizers, fungicide, insecticide, adjuvants, Biological products) + different color for each type of product.

  • Crops expenses (analytics)

    • Absolute values of Direct Costs Vs time (bar chart with different color for type of costs such as tasks, fertilizers, fungicide, adjuvants, Biological, etc.)
    • Drop down to select Crop, to select date, to select field
    • Cumulative values of Direct Costs Vs time (bar chart with different color for type of costs such as tasks, fertilizers, fungicide, adjuvants, Biological, etc.)
    • Drop down to select Crop, to select date, to select field

4. Weather Reporting

  • Weather Reading (type of measure, value) Unit of measure to be flexible. Eg. we measure rain in one place in cents and inches and in another place in mm.

5. Inventory Management

  • Planning (fertlizer etc) - BOM? should be fine
    • BOM should have a date on each item added.
  • Harvesting (Stock Entry) some crops are harvested and sold immediately. eg. tea leaves, fruits etc. how do we handle the same?
  • All records tagged to a land asset so that reports can be made

6. Checklists

  • Checklists for various activities like Nursery, Transplanting, etc.
  • Checklist Template
  • Checklist
  • Tagged to Land Asset good idea. we can expand the scope to other activities too like spraying, fertilizer application etc.. can be kept optional so users can decide if they want to use it or not.

HR

let the hr data be estate/ farm wise from which we can generate a company wise consolidated report if required. all employees can be tagged to a particular estate/ division

Fleet Management

details of vehicle usage - kms run / day, fuel consumption, service records, major repairs, hours, etc. something similar for machinery too like sprayers, weeding machines, pruning machines, chain saws etc.

Other

  • Field Operation Diary: More of a report complied with all the above data recorded. Gives an idea what is happening for a day. This should have details for all the fields, divisions etc. The farming operation in totality.

  • Post Harvest Management/ Production: In case value addition is done at the farm itself. I think the current software can handle this part.

  • Planning of season and daily work for each crop: Like a calendar/ scheduler which helps managers plan the work.

  • Work scheduling: Allotment of work based on the planner

  • Calculators: labour required for a particular task, spraying calculators, fertiliser calculators

Reports:

  • Irrigation report
  • Work report: separate report for each work activity like plucking, spraying etc..
  • Rainfall and other weather data report
  • Labour attendance report
  • Harvesting Report

ERPNext

Wiki Links

External Links

Clone this wiki locally