Non-inventory item custom report with cash basis

1

I have a custom report to display inventory items. I have set the report to cash basis. However, the Qty column is doing cash basis (e.g. based on paid invoices only) but the Sales column is doing accrual basis (including unpaid invoices). Is there any way I can make both columns match according to paid invoices?

I’m unable to upload an image to the forum presently, but setup is:

From 2024-1-1 to 2024-12-31 Cash Basis

Select
Non-inventory Item > NameWithCode (Alias: Item)
Qty (Alias: Qty)
SalesAmount (Alias: Sales)

Where…
Non-inventory Item > Code > is not empty

Group by…
Non-inventory item > Code

When I disable the “Group By”, I see that there are line items adjusting for the cash basis with a negative amount, but not adjusting the quantities.

Basically, I’d like it to match the Inventory Quantity Summary report, wherein a cash basis report excludes both quantities and monies if the invoice hasn’t been paid.

2

Why? It would really help us to help you.

3

When I try to upload an image, I receive a message: “Sorry, an error has occurred.”

4

What is the format of that picture?

5

jpeg

6

I was able to insert an image hosted somewhere else:

860×643 29.1 KB