Skip to Content
avatar image
Former Member

Formatted Search

How can i show my unit price in base price automaticlly by FMS?

When i use this code in my base price by FMS,it is static not dnyamic.I want when i enter item-code,then base price will be unit price(1st of list price) automaticlly

SELECT T1."Price" FROM OITM T0 INNER JOIN ITM1 T1 ON T0."ItemCode" = T1."ItemCode" INNER JOIN OPLN T2 ON T1."PriceList" = T2."ListNum" WHERE T2."ListNum" = 1 AND T0."ItemCode" = [%0]

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers