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