Branch filter in gross profit report

hi all, i need some information in gross profit report. i need to create branch filter and branch table isn’t associated with any other table. should i associate it with warehouse or anyother, please confirm.

Hi @rahulrana0105,

If you want a branch filter in the report then you have to customize the report according to the scenario.

filter add-in gross_profit.js field and logic will apply on gross_profit.py

Thank You!

hi @NCP branch table is already in the database, i need to create a branch column also. but it should be associated with some table so it can be incorporated with the report. i want to know with which table should i associate it with?

To determine which table to associate the “branch” column with, consider where branch-specific information is most relevant . Think about which tables represent entities or processes that are tied to branches in your company (organization). For example, if sales orders, invoices, or transactions are handled separately for each branch, you might associate the “branch” column with tables related to these entities.

If the branch isn’t a table field, it might be easier to manage. I’m not sure about the specifics of your situation, but you can create a solution using business logic.

Thank You!

hi @NCP i am looking in this issue Need Branch Filter on Gross Profit Report · Issue #39879 · frappe/erpnext · GitHub. for that i needed specifics.