Supplier / Vendor Price list based on UDFs

[Former Member]

Hi All,

I have some UDFs in Item master data namely Width, Length, Thickness, etc.

Supplier price lists need to be defined based on Width, Length and Thickness ranges

For eg: Item price for Width range 100m-200m and  Thickness range 1mm-4mm is $10.

Now in the Price list I can define the ranges and declare a price.

But how do I retrieve this price list data during Goods receipt and validate against price.

Thanks,

P.S

[Former Member · Accepted solution]

I am afraid you may need 2 level FMS. That will not be updated automatically.

The rule for this FMS will depend on all setting related to Thickness in UDF. What is the complete rule?

[Former Member]

Hi,

There are some fields in Item Master already related to the measurement. What is your UDF type here? Post a screenshot or give more detail.

Thanks,

Gordon

[Former Member]

Gordon,

Since Thickness was not available in the Item Master data, I created all of them as UDFs.

The UDFs are of Units and Totals Quantity type since I wanted to maintain them with decimals.

[KennedyT21]

Hi Pradeepa,

Create a User defined Table with following fields..

Supplier Code  Itemcode  Width      Length      Thickness      Price

And using the FMS you can retrieve the Price..

Hope Helpful.

Regards

Kennedy