HomeClient SupportContact Us
A Cost-effective, Customizable
and Integrated solution for
small and medium size companies

Solvent Extraction (Edible oil Mfg.)

Procurement of seeds, Quality Control, and yield measurement and controls are key concerns in Edible Oil industry.

Lighthouse ERPTM has effectively addressed processes such as procurement through Agriculture Produce Market Committee (APMC) contracts, Direct contracts with traders and large farmers, Quality linked Bill passing, Debit/ Credit notefor dispatches not within stipulated duration.

Lighthouse ERPTM also focuses on handling multiple SKUs in production and sales, Depot/ Branches, broker wise sales.

Lighthouse ERPTM caters to following key processes in Solvent extract.

  • Purchase Management Records for Different types of Purchases i.e. Registered Dealers, Un-Registered Dealers (URD) Mandi Purchase (Kanta - Patti Management, Stock reconciliation) with Quantity of seeds received (both in Gunny Bags & Seed Weight).
  • Auto Generation of Debit/ Credit Note based on Quality received.
  • Brokerage against the Quantity & Grade of seeds received.  
  • Broker wise pending purchase order.
  • Multi Stage Quality Test Report for raw material. Average Quality Test Report for Multiple GRN and integrated with Bill Passing
  • Seed Recovery Report of projected Seed Recovery based on GRN wise samples, from received and accepted seeds, against actual seed recovery from GRN wise seed issued for production.
  • Plant & Shift wise Oil Production using Tank Dip Measurement.
  • Capturing day wise production and sales records of Crude Oil, Refined Oil & DOC etc.
  • Sales Contract, Delivery Orders, Dispatches and Domestic/ Export Invoicing
     

The modules covered under the scope for Solvent Extraction Industry are as follows :

1.   Finance & Accounts

  • General Ledger/ Accounts Receivables/ Payables
  • Bill Tracking – Allocations
  • Bank Reconciliation
  • Provisional Journals
  • Expense Analysis
  • MIS- Balance Sheet, P&L, Trial Balance, Cash Flow, Fund Flow etc.

2.   Taxation

  • Service Tax / VAT/ CST
  • Excise
  • TDS/ FBT
  • Entry Tax
  • Forms Tracking like C-forms, Waybills etc 

3.   Security Gate Management

  • Inward Register for all vehicles/ Outward Register
  • Generation of Loading & Unloading Slips
  • Report of all Vehicles in Plant

 

 

4.   Weighbridge Automation

  • Weighment Advice creation for Inward/Outward Material at Security Gate
  • Linking of Weighment Slip with weighment advice
  • Direct data acquisition from electronic WB machine to ERP
  • Multiple weighment option for a single vehicle carrying different products
  • splitting Weighment slips in GRNs for more than one PO.
 5.   Capital & Consumable Purchase
  • Indents including Auto indents
  • Vendor Registration
  • Generation of Enquiry or Requests for Quotations (RFQ)
  • Generation of Comparative Statement Quotation comparison
  • Purchase Order with facility of Amendment, Cancellation & Reminders
 6.   Stores Inventory Management
  • GRNs for new, converted, rejected and repaired material
    Issues against department Requisitions, non/ chargeable Contractor,Loan
  • Inter Division Transfers
  • Division and Company wise Pipeline, Quality Approved Goods, Rejected and Repaired Material Stock.
  • Physical Stock verification/ Tools and Tackles Management
  • Generation & Tracking of Gate passes for Non-returnable, returnable, repair, conversion material.
 7.   Raw Material Purchase
  • Categories of Purchases like URD/RD/Mandi etc.
  • Purchase Order In two stages - Unapproved P.O. entry and subsequent approval by authorized executive.
  • Provisions to input test code wise quality for each product and auto debit note/credit notes
  • Provision for several Live Amendments of rates, quantity and other element to the P.O. based on the concept of From-Date and To-date
  • Auto calculation of Brokerage amount, based on brokerage rate master.
  • Brokerage rates definition for a broker, a product, on unit of measurement.
  • Online updated from GRNs
  • Pending order status reports item wise/Party wise/Delivery date wise etc.
  • Control of purchase orders, of valid up to date.
  • Declaration of gunny bag terms
     
8.   Raw Material Inventory Management
  • Multi GRNs linked to weighbridge
  • Raw Material wise/ group wise stock
  • Cash Freight Payment advice auto generation from the GRN.
  • Capturing of grade wise gunny bag details for every GRN
  • Identification of godown and Stack at the time of GRN preparation
  • Maintaining of stocks at godown and stack levels.
  • Identification of stocks with relation to its quality parameters
  • Linking and reconciliation of GRN with kanta patti in the case of mandi purchases
  • List of Pending GRNs awaiting inspection, valuation, approval in age wise and other formats
  • Bill Passing for multiple GRNs linked with QC details
    Landed value computation
  • Finished Goods to Raw material conversion
  • Stock adjustments/ Ground Loss 
9.   Quality Control
  • Linked with Sales order/ Purchase Order/ Sales/ GRNs/ Weighment slips
  • Options available to capture QC details, for vehicle not entered in factory premises (Counter–QC).
  • Capturing process wise qc details in production
  • Multi GRNs linking form one QC report.
  • Printing of QC Reports with GRNs.
  • Detailed analysis of test parameters
  • Auto calculation of deductions/bonus amount at the time of Purchase Bill processing as per the conditions defined in Purchase Order
10.   Production
  • Daily Consumption/ Production Entry for different plants
  • Production entries linked with bill of materials
  • Seed Oil recovery reports based on QC inputs
  • Capturing of breakdowns, man power utilization and store consumables consumed
  • Capturing of tank dip reading
  • Capturing of details of packing department
  • Capturing of stock movements in and between plants and godowns
  • Special Daily MIS on YTD/MTD/DTD basis

 

11.   Sales & Marketing

  • Two level sale order booking, contracts and delivery orders
  • Sales Order In two stages - Unapproved Sale Order entry and subsequent approval by authorized executive.
  • Provision for Contract and Sales Order Cancellation and Re-opening.
  • Online updated from delivery order and Sales Invoices for Quantity executed
  • Item / Party wise Pending Contract and Sale Order status
  • Control of credit limit while preparation of delivery orders.
  • Depot Transfer and Consignment sales
  • Sales Broker Management

12.   HRM & Payroll

  • Employee Data with qualification, previous jobs, family, hobbies etc.
  • Appraisals; Tour & Training details
  • Muster Roll with OT, C-off
  • Shift Management/ Leave Management/ Loan Management
  • Payroll Generation with Auto Arrears
  • Statutory Forms of PF/ ESCI/ Professional Tax/ Wage Register etc.
  • Gratuity Calculation
  • Income Tax Computation with Form-16 generation

13.   Freight Management

  • Freight Contract
  • Cash Freight Advice and Payment
  • Credit Freight Management for Inward and Outward bound material

 14.   System Administration (DBA)

  • Configuration Management
  • Security Management- User rights and controls
  • Data Freezing
  • Tests for data entry errors and rebuilding
  • Backup Management
  • Rectification of procedural errors like allowing editing after approvals.
  • Accounting year carry forwarding routines