PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

400+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

Query Price List in SAP Business One

SAP Business One Tips Query Price List
SHARE ON


In SAP Business One, you can use a variety of selling and buying prices. Of course, if you have a lot of items and a lot of price list too, you will be a little difficult to check whether the price to be input is correct or not.

For this reason, here are tips and queries to find the prices that apply at that time:

SELECT T0.[ItemCode], T0.[ItemName], T1.[Price], T2.[ListName] FROM OITM T0

INNER JOIN ITM1 T1 ON T0.[ItemCode] = T1.[ItemCode]

INNER JOIN OPLN T2 ON T1.[PriceList] = T2.[ListNum]

WHERE T2.[ListName] = [%0]

Here are the results of the query, then please select the price list in the list:

SAP Business One Tips - Query Price List in SAP Business One

SAP Business One Tips – Query Price List in SAP Business One

These are tips for the Pricelist Query SAP business One, hopefully, it can help.

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , , , , , ,