Is there a way to create P&L Report using custom field?
My requirement is to create P&L Report based on Sales Representative.
This is to know how much profit did a sales person make on 1 order. (Cost and Sales)
Can we have a custom field tab next to Tracking Code in the P&L Report?
I understand that Tracking Code works because we pick the tracking code on both Purchase Invoice and Sales Invoice and that’s how we can create P&L based on Tracking Code.
How can i do the same in case of Sales person. As Tracking Code lets us pick only one item.
For eg: we have Tracking Code for our Products. So we can create P&L Report based on Product we sell.
Similarly, i want each Purchase and Sales Invoice to have one more option to pick the Sales Representative in order to create P&L based on Sales person.
Hope i am clear enough in explaining my requirement.
Await a quick response on any possibility.