Thanks Tim, this require further studies and may be a blog post.... 👍

@ncantral better to join ARRegister (2 sets), ARPayment and ARInvoice. Why - because invoice can be "paid" not necessarily by a payment. Your quer...

Or can follow the guide from the blog here

As Acumatica report designer was made under the influence of Seagate Crystal, it handles grids very badly. But, to overcome, if your report is just ...