Custom report issues (Cusomer & Bought items)

Hello Managers,
i do not seem to understand how the report show blanks
Below is the custom report setting for inventory items bought by each customer during the month:

the report shows blanks for repeated item names as below :

could some1 help figuring the porb out as i’ve tried diff settings and it still show the blanks

Thanks in advance

That’s because it’s doing a full join on Inventory Items & Transactions table. You will get ghost entries because you didn’t filter out the redundant result.

Try this:

2 Likes

Thanks Alot for the solution , I truly appreciate it but I’m afraid the field " Qty Invoiced" is not visible in my software however

You must be running a different version of Manager.

You can use the plain Qty field. That would work too