Skip to Content
0
Apr 16, 2010 at 12:42 PM

Incoming Payment Discount

71 Views

Greetings Gurus...

I need to generate a report to show the incoming payment discount taken during cash application to customers. For example, a customer has an invoice for $100, they pay only $99, the AR clerk puts $1 discount in the Incoming Payments window on SAP B1.

What table holds that $1???

How can I write SQL to show the $100, $1, and $99...

Thanks - Zal