frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
21.82k stars 7.33k forks source link

Project Costing and Billing #26268

Open heyberting opened 3 years ago

heyberting commented 3 years ago

Is your feature request related to a problem? Please describe. Project Module's Costing and Billing portion does not include costs/expenses logged manually under Journal Entry. It does not reflect the accurate gross margin compared to the Profit and Loss Statement.

Describe the solution you'd like Total Purchase Cost (via Purchase Invoice) can be modified to Total Purchase Cost (via Purchase Invoice and Journal Entry) and perform adjustment in the calculation to include manual JVs. The same with Total Sales Amount to include manual JVs.

Describe alternatives you've considered Make a separate field for Other Costs (via Journal Entry)

Additional context image

mujeerhashmi commented 3 years ago

Also, include the Total Purchase Amount (via Purchase Orders). Total Advances (Payment Entries) received from the client for the project.

heyberting commented 3 years ago

If we add Total Purchase Amount (via Purchase Orders), it might include items that are already booked in the expenses (via Purchase Invoice). How about only filter those unbilled PO items tagged under the Project?

Also can we also add the total advance payments made for the pending Purchase Orders under the Project. Others might be interested in the information.

stale[bot] commented 2 years ago

This issue has been automatically marked as inactive because it has not had recent activity and it wasn't validated by maintainer team. It will be closed within a week if no further activity occurs.

federicocalvo commented 2 years ago

the JV's have the link to the project, but have no implications as this issue states in terms of cost calculations.

Besides it also does not have the linkage on the dashboard.

Although they then comment on the POs, this could be separated in another issue, to validate the JV issue and be able to perform a PR, as it is extremely necessary.

@ankush with three users validating the request (also not very complex to understand in this case) shouldn't it reopen?