Thank you for the efforts which you and your team are doing!
Kindly advise the possibility of having 2 types of prices :
1- B2C price which is the standard master
2- B2B price as the secondary optional price
so as I imagine it can be like:
1- Customer type in the customer profile (Business or Retail)
2- 2 columns for prices in inventory (B2C & B2B)
3- In the sales invoice, once I choose the customer, Prices come from the inventory table as per his classification as Business or Retail.
I know that theoretical requests look simple and it is very complicated in the back end, but it is just a step on the road.