Skip to Content
0
Former Member
Jul 03, 2012 at 05:46 AM

Query Item List with Special Sell Price

431 Views

Dear All,

I am needing to write a query that will generate the following information:

  • Business Partner Code
  • Business Partner Name
  • Item Code (i.e. will be items we sell to the BP)
  • Item Name
  • Standard Cost
  • Sell Price
  • Discount - ie the % entered in Special Price Screen
  • Special Sell Price - after the discount (if any is recorded against the BP)

Will appreciate the assistance.

Regards

Raj