Hello ERPNext Community,
I’m setting up ERPNext for a construction company and need guidance on the best approach to handle our specific business scenario.
Current Situation:
- We’re a construction company managing multiple project sites
- We don’t maintain physical warehouses
- Materials (like steel and cement) are purchased and delivered directly to project sites
- Currently, we record these purchases as direct expenses to each project/site
Requirements:
- Need to use Purchase and Sales modules in ERPNext
- Want to track material costs per project
- Need to generate reports showing:
- Total cement/steel quantities used per project
- Cost analysis per material type per project
- Real-time project material consumption
Example Scenario:
Let’s say we have “Project A - Residential Building”:
- Purchase 1: 100 bags of cement @ $10/bag delivered to site
- Purchase 2: 2 tons of steel @ $1000/ton delivered to site
We need to track these materials and their costs specifically for Project A.
Questions:
- What’s the recommended setup for handling direct-to-site material purchases?
- Should I create virtual warehouses for each project site?
- How can I configure the system to track materials without physical warehouse management?
- What’s the best way to link purchases directly to projects for cost analysis?
Current Challenges:
I’ve tried setting up the purchase module but couldn’t configure it to work as needed. The standard warehouse setup seems more oriented towards physical inventory management.
Any guidance or best practices would be greatly appreciated.
Thank you in advance!
1 Like
There’s detailed explanatory video on EPC segment, you should check this one out. Here’s the link : https://www.youtube.com/watch?v=x47RzI_vUgQ
1 Like
So what is the latest in greats on this thread? Any such existing Construction modue?
1 Like
You can handle this cleanly in ERPNext without true warehouse management:
-
Create a “Project Warehouse” per site (virtual/non-stock location). This lets you use Purchase/Sales modules while keeping inventory tied to a project.
-
Link every Purchase Order/Receipt to the Project and set the project’s virtual warehouse as the target.
-
Use Stock Items for cement/steel so quantities are tracked, even if they’re consumed immediately.
-
Issue materials to the project via Material Issue (Stock Entry) or consume directly on receipt if you don’t need on-hand balances.
-
For reporting, use Stock Ledger + Project filters and Item-wise consumption reports to get quantities and costs per project/material in real time.
This approach preserves ERPNext’s inventory logic, enables cost analysis per project, and avoids managing physical warehouses.
If you don’t want to manage inventory at all, set cement and steel as Non-Stock Items and link Purchase Invoices directly to the Project. This allows ERPNext to track costs and quantities per project through Project Costing reports, without using warehouses. It’s a simpler setup and works well when materials are consumed immediately on site and detailed stock tracking isn’t required.
This is a common issue in construction projects where materials go directly to the site.
One simple way is to create a separate warehouse for each project, even if it’s just for tracking. This helps you manage materials like cement and steel properly.
Another option is to not use inventory at all and just record all costs directly under the project. This works well if materials are used immediately.
I think it depends on how detailed you want your tracking to be.
What do others prefer — tracking materials or just tracking costs?