Skip to Content
0
Jul 28, 2020 at 06:13 AM

Querie report outgoing payments for supplier

85 Views

Hi,

I need a querie to make a report for my suppliers that I can send so they can see which invoices and credit note I have paid.

I need the following:

When starting the querie I need to select:

Payment date

Supplier name

When I enter these conditions the report need the following things:

Payment date

Supplier name

Reference from invoice or credit note (=NumAtCard)

Total amount from invoice/credit note

Payment discount

Total amount incl. discount

Thanks!