Skip to Content
0
Former Member
Oct 13, 2014 at 12:52 PM

Trying to create a query for invoices paid in the current month

689 Views

I'm currently working on SAP B1 ver 8.82

I can easily enough create a Paid/Unpaid report for invoices in the current month that's based on the the Invoice date or on the due date, but what I actually need to be able to do is find invoices that had a payment applied to them anytime in the current month. I also only want invoices that are 100% paid. How can I do this? In some cases the entire invoice would have been paid by the down payment, but this is not always the case. Does anyone have a query for find the date payments were applied to an invoice?

Thank you,