on 11-10-2011 2:10 PM
Hi There,
I'm currently still learning the product and have been tasked with finding this out, so please bear with me and let me know if there is further information that is required.
I have a customer running SAP B1 2007 who wishes to produce a report detailing all of the BP's that have a special price for an item.
Therefore it would ideally show the item number, all BP's who have a special price and what that price is.
Is there a standard report that can be run for this? Or would a query have to be defined?
Any help would be appreciated.
Hi,
AFAIK, no standard report for this. But need not to worry, you just need
SELECT ItemCode,CardCode,Price FROM OSPP ORDER BY ItemCode,CardCode
above simple query to cater your need.
Best Regards,
Hendry Wijaya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Welcome you post on the forum.
Try:
SELECT ItemCode,CardCode,Price FROM OSPP T0
WHERE T0.ItemCode = '[%0\]'
ORDER BY ItemCode,CardCode
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.