Mr. A is into Spices Trading business. He purchases material from the Auction market (market yard or Mandi) via authorized Brokerage agent in those markets. In the business of agro product, this is the common.
- Communication on emails first and then post entries into ERPNext. (Since the auction purchase is conditional & details not know in advance about Supplier, Price, Brokerage amount, Delivery date, etc… raising PO & then amending is does not make sense. The only thing know is quantity to be purchased.)
- When Purchase confirmation is received from Agent, PO in the name of Supplier-1 with his GST details is raised & then the rest of the transaction of Good received >> Payment.
- While raising the PO on supplier-1 above, We have to capture info on Brokerage amount, brokers name into the PO. Then later when the PI is received and paid to Supplier-1, the applicable Brokerage to Agent is also to be paid. The agents work for Mr.A on daily basis, hence they send Brokerage Invoice as a statement once a month.
How do we capture info for Brokerage payable on the PI, and get a reminder notification at the time of making PI payment? I was thinking if something similar to Sales Commission for SI is available for buying, I could not find.
Did anyone manage such a workflow? Suggest the best approach to handle.
The bottom line is to save time in doing the entire transaction & reduce manual interventions to the least possible level.