BOM Explorer, Custom field calculation

1

Hello Team,

I have added two custom fields in BOM Explorer at the item level such as

  1. Percentage.
  2. Total Price.

For the Quotation purpose, We need to edit the Percentage (custom field) created at the BOM explorer such as 10%, 20%, or 30% and Multiply with Last purchase Rate as shown below to arrive total price automatically.

pls do suggest the any client script for this , thanks

image
image1433×669 56.8 KB

2

Hey this is a report and client script should not be used in the report. For that you have to develop or customize the report

3

We need to generate BOM Pricing with including the buffer allowance, so the required fields are

BOM Number
Item Name
Description
Qty
Last Purchase Rate (Deriving from PO)
Percentage (Editable Field)
Total Price ( Shall calculate from Last Purchase Rate X Percentage)

Do you suggest what kind of report fulfill this requirements. thanks and appreciate your time

thanks

4

Please check the report code and set it the scenario according.

5

thanks , will explore the option