I am writing a Query Report script and would like to include the customer’s credit balance. As far as I know this is only located in the customer credit balance report which wont work as it seems reports are not tables in erpnext. What is the best way to go about this??
Select the record from another report is not possible.
You can write a query report to fetch the value you want.
Would I call it ‘tabCustomer Credit Balance’? Or is it a different abbreviation since it’s a report? When I tried this it gives an error saying “tabCustomer Credit Balance’ does not exist”. I already have other values selected and joined from other doctypes but am getting this one error when trying to select from the credit report in the query
For each DocType there is a MariaDB table at the backend, Report doesn’t have any table the data of the report is fetched either from single doctype (table) or using joins from multiple tables, Here tabYourDocType is just a MariaDB table name. So you cannot use tabReportName to fetch values from another report. Just write a query to fetch data from another report.
I could find a method that enables me to use other reports. It is by getting the whole report text as a nested select statement inside the new query report.
It is simply explained here:
What Is a Nested Query in SQL? | LearnSQL.com
I have not finished the new report yet, But I guess it will be helpful for me and any new readers.
I wish if ERPNext adds something like SQL snippets, that we can reuse in new SQL reports.