Hi all,
Our nature of business is pharma manufacturing, so customer will provide the MRP of a product which has to be printed in the packaging, item price list has only rate which is in turn used in sales transactions.
I’m wondering what is the best approach to customize whether in item price to add new MRP field and pull it in all the sales transactions ( its important to tag the batch to the rate and MRP as well ) or to create new doctype and include it as link field ?
Seeking suggestions here as it seems a common use case.
Thanks.
Hi
The following item table reflects how FMCG business pricing model operates within secondary and tertiary distribution environment. The Pharma industry has government controlled prices and batches which ERPs have to control on item level effectively. The price list rate has been identified as MRP which can be defined in either item price list or in item master’s standard selling rate field.
The Trade Pricing and further discount on TP can be configured on customer or customer group depending upon the requirements.
By the way, the sales invoice item table illustrated above requires little coding as this is not standard function of the ERPNext.
Hi @ahsantareen,
Thanks for your reply this item pricing of yours looks very comprehensive. Apologies for my late response.
My use case would be the rate / basic price would be cost to manufacture a product (which we can use it from the price list rate which is already present in the system ) billed to the customer and MRP will be quoted by the customer that has to be printed in the packaging of the product as the business is primarily third party pharma manufacturing so other prices we dont really consider in our business, refer the pic from a legacy erp where price list is maintained for the customer as below with validity ( similar feature is present in the price list already in ERPNEXT )
I think would it be correct to modify the price list ( selling ) to add MRP and pull that in sales transactions ? Would like to hear your thoughts on this
Thanks.
[update] added MRP in item price to maintain customer wise and transaction date wise pricing for the product and later query in Sales Order using a script on item addition to item table.
Added a good to have Update MRP button to update MRP if there is a change in MRP in item price list.
The above design did the job for my use case
