Share
ReportHow to retrieve Item Selling Price for all items using econnect or any storedprocedure or function?
*This post is locked for comments
You’re offline. This is a read only version of the page.
1,145
How to retrieve Item Selling Price for all items using econnect or any storedprocedure or function?
*This post is locked for comments
Hi Sekar,
The unit price comes from the Price List. The Price List prices are based on:
The Price Level
The Currency
The Quantity
The Unit of Measure
You may only have one line on your price list, meaning you do not have any quantity breaks, you have only one currency, one unit of measure and one price level.
If that's the case, then your unit price would be simple, just pluck it out of table IV00108. In any event, that's the right table, you just may have to provide more parameters than simply the item number.
Is this what you needed?
Kind regards,
Leslie
Hi Leslie, thanks for your reply. I want to retrieve unit price for particular item, for example we are creating SOP Order, here we have to select one item GP will automatically shows the unitprice for that particular item. I need to retrieve this unitprice, how can we do this please help.
Thanks in Advance
Sekar V
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
