I have an issue with stock balance report. stock in and stocknout qty is correct. but invallue and out vallue is completely wrong. the valluation rate is also wrong. i don’t know what to do. inhave hired few people from freelancer and upwork, wasted bit money. they couldn’t help me. the valluation rate in the stock balnce report is not same from purchase invoice or item master.
i have attached the item master, purchase price and balance report
please someone help me
“i don’t know what to do.” “please someone help me”
Welcome to ERPnext,
Of course open source offers options and opportunities.
Hence why not implement your own tests here?
The idea is to validate the reports you require and depend on, based on a data set that you know and trust.
Then if you contribute those tests back to the codebase, everyone benefits.
Until a comprehensive test suite exists to validate and debug reports, they will be questionable.
just my thoughts
Frappe has one basic ReportBuilder and query report test for each of these…
This file has been truncated.
# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
# License: MIT. See LICENSE
from frappe.core.doctype.user_permission.test_user_permission import create_user
from frappe.custom.doctype.customize_form.customize_form import reset_customization
from frappe.desk.query_report import add_total_row, run, save_report
from frappe.desk.reportview import delete_report
from frappe.desk.reportview import save_report as _save_report
from frappe.tests.utils import FrappeTestCase
test_records = frappe.get_test_records("Report")
test_dependencies = ["User"]
And within ERPNext there are these 30+ standard business and financial reports
But to correspond with these there seem to be no report-specific tests to validate
data content in these reports. So perhaps no test coverage exists for any of these reports?
Some more thoughts
“i have attached the item master, purchase price and balance report”
No sign of these attachments!?
These may offer you insight into your valuation rate issue
here I manually added the rows of the p.inv expenses and taxes (P.inv 00100)
20,000+1,000+500+400/1,000(qty) = 21.9SAR (gross unit cost)… and that number never showed in my reports… only the exactly item purchasing rate showed there (20SAR), which is very very problematic…
and here I only chose the predefined template, and it automatically added the rows for me (P.inv 00105)
500+500+1,000/500 (qty) = 22SAR (Per unit)… and that was exactly what appeared in the SL
here’s the …