Erpnext - Stock Balance report error - incorrect value and valuation rate!?

Favaz_Shah · May 24, 2018, 4:31pm

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

clarkej · May 24, 2018, 6:02pm

“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

clarkej · May 24, 2018, 6:59pm

Frappe has one basic ReportBuilder and query report test for each of these…

github.com

frappe/frappe/blob/develop/frappe/core/doctype/report/test_report.py

# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
# License: MIT. See LICENSE

import json
import os
import textwrap

import frappe
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"]


class TestReport(FrappeTestCase):

This file has been truncated. show original

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?

clarkej · May 30, 2018, 1:34pm

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

https://frappe.erpnext.com/kb/stock/how-valuation-rate-is-calculated-for-an-item