How to display the price of a selected item in a user-defined field ?

[former_member441176]

Hi,

I'm working on Formatted search. I've added an user defined field in A/R marketing document to display the price of the item from the bill of material (Production). This price is stored in the pricelist (5). We want that our user-defined field displays this price when the item is selected in the row in an AR invoice. Unfortunately, when we select two or three items, SAP B1 displays the same price for all three items that's to say the price of the first item.

This is our query :

SELECT T0.[Price] FROM ITM1 T0 WHERE T0.[ItemCode] = T0.[ItemCode] AND T0.[PriceList] = 5

What we want is that when you select an item in the invoice, that SAP B1 displays the price of that selected item. And when you select another, that the system displays its price and not for the first.

So, Can you provide me a good query for that ?

[former_member312729]

Try this

I had defined Price list '1 ' you can change it as per your need. I had kept auto refresh based on quantity field

SELECT T0.[Price] FROM ITM1 T0 WHERE T0.[ItemCode] = $[$38.1.0] AND T0.[PriceList] = 1

Regards:

Balaji.S

[kothandaraman_nagarajan]

Hi,

If you define price list for each item master, when you select these item in marketing documents, system automatically will add unit price.

Using this standard function, no need to FMS.

Regards,

Nagarajan