Stock balance report made simple

I need a simple simple stock balance report with just 2 columns.

  • Product name
  • Product balance (Qty available)

You can create a report for this See https://frappe.github.io/erpnext/user/manual/en/customize-erpnext/articles/making-custom-reports-in-erpnext.html.

Cheers,
Chris

None document have a stock balance property for knowing actual Qty

Hi @Franco_Fadini,
See here what I have done:

Is that the kind of thing you are looking for.

I agree, see this post, many reports have too many columns and are then becoming impractical. The ability to choose which columns we want would be a great addition…
But one step at a time :wink:

2 Likes

Exactly! how u do it?

It is a script report. You’ll have to follow up the procedures there
https://frappe.github.io/frappe/user/guides/reports-and-printing/how-to-make-script-reports.html
https://frappe.io/docs/user/en/guides/reports-and-printing/how-to-make-script-reports.html

I basically took the stock balance report (the .py file), took away all unwanted columns & resized the one of interest to me.

It is late here, but let me try tomorrow to see how to download that .py file from the server. Again i m not a developer so it will take me some time to figure it out again

Hello @Francois_Ifitwala

Can you help me to tell how to deploy after I change the .py file.
I have make change .py file but my report didn’t make any changes.

Please help me.

The attached link no longer works.