Skip to Content
0

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

Jun 30, 2017 at 11:37 PM

48

avatar image
Former Member

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 ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nagarajan K Jul 01, 2017 at 12:19 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Balaji Selvaraj Jul 01, 2017 at 06:06 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded