Finding % discount on payment on OVPM (Outgoing Payments) table

[Former Member]

Hi guys,

I'm reporting on the Outgoing Payments table in SBO's query wizard, but none of the fields, specifically the discount fields, show the discounts I make on payments.

e.g. when making an outgoing payment, I enter some number in the "Discount %" field before posting the payment.

All I can report on is the discounted, net amount. Is there any way to view the value I input to the "Discount %" field?

As always, I'm very appreciative of any help.

James.

[Former Member · Accepted solution]

You may edit your query from query manager after you select all other fields available. Then add the following:

Dcount in OVPM stands for Discount %. DcntSum would be Discount Amount

Thanks,

Gordon

[Former Member · Accepted solution]

Hi again Gordon,

I ahve DcntSum in the query, but it still returns 0. I've included every available field, and none of them show a discount amount. I'm double-checking on the outgoing payment document and there is definitely a discount.

Slightly lost...

James.

[Former Member · Accepted solution]

Include DcntSum in VPM2 to try then.

[Former Member · Accepted solution]

That's great Gordon, thanks.

Do you also have any idea on how to include credit notes in the report? At the moment I can only do Outgoing Payments or Outgoing Payments - Invoices. None of these show credit note details in payments...

[Former Member · Accepted solution]

You may post a new thread for this new question and refer to this thread. One question for one thread. This is forum rule.