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: [image] the report shows blanks for repeated item names as below : [image] could some1 help figuring the porb out as i’ve tr…

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: [image]

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

I also need this and i tried your example, it doesn’t work for me [image] HERE IS THE RESULT [image]

[image] 𝔚𝔞𝔦𝔱𝔦𝔫𝔤 𝔣𝔬𝔯 𝔐𝔦𝔯𝔞𝔠𝔩𝔢: Try this [image] This works fine Thanks Can you please post a custom report to get Supplier & Purchased items if possible

[image] AMM: Can you please post a custom report to get Supplier & Purchased items if possible Please note the FAQ - Manager Forum for two reasons: Don’t divert topics to new subjects in midstream. Start a new topic. and Be non-commercial. …Do not ask Forum members to develop themes, r…

@AMM see also reply to similar request by you in 2023 by @Mark , i.e.: [image] Custom Report Value by inventory location Extracted from the Forum’s FAQ (already indicated numerous times on the forum): [image]

Still not working for me [image] here is the result [image]

@Najrash Make sure you have Sales and Credit Note transactions within the date range you selected for the period. Also, ensure you choose the correct account name that used in your transaction.

Custom report issues (Cusomer & Bought items)

eko December 26, 2024, 7:25am 9

@AMM see also reply to similar request by you in 2023 by @Mark, i.e.:

Topic		Replies	Views
How to sort the details of what items are purchased?	13	492	October 13, 2022
Custom report Customer and products	19	1831	December 1, 2021
Item wise report for customer	1	65	August 12, 2025
Custom Reports	4	369	May 24, 2021
Request: How to create reports	21	906	April 27, 2023

Custom report issues (Cusomer & Bought items)

Related topics