New fields in Batch creation

Hi,

I am from the Pharma Trading industry and I have been evaluating and playing around with ERPNext to configure Sales and Purchase modules so that features are according to workflow needed for wholesale Pharma Distribution.

Could anyone help if is there any way that I can select different batches for individual SKUs (items) because in the pharma industry, the distributor receives multiple batches for individual items from suppliers (manufacturers).

For instance, while creating a new batch in an item during purchase data entry or material receipt entry, I wish to enter multiple batches for individual SKUs (received at the inbound dock) along with the medicine expiry date. I am attaching a screenshot of our existing ERP for your required data field understanding:

For Purchase Data Entry I need the following fields while creating a new batch:

  1. Purchase price (Price to Stockist - PTS).
  2. Purchase Scheme structure
  3. Net cost price (After deducting scheme discount)
  4. Selling price (Price to Retailer - PTR)
  5. Selling Scheme structure
  6. MRP of that particular batch.

Please suggest how to configure sales and purchases to have the above-mentioned data fields (configuration).