Custom report issues (Cusomer & Bought items)

1

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
image840Γ—601 16.1 KB

the report shows blanks for repeated item names as below :

image
image752Γ—614 9.41 KB

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

Thanks in advance

2

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
image1080Γ—672 26.3 KB

2 Likes
3

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

4

You must be running a different version of Manager.

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

5

I also need this and i tried your example, it doesn’t work for me

image
image1140Γ—777 26.1 KB

HERE IS THE RESULT

image
image723Γ—595 14.6 KB

6

Try this

image
image1406Γ—839 110 KB

1 Like
7

This works fine Thanks
Can you please post a custom report to get Supplier & Purchased items if possible

8

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, reports, or localizations for you unless you have already tried yourself. Then (as mentioned above), post your own work and the results, stating clearly the problem you are having.

9

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

10

Still not working for me

image
image1021Γ—826 32.2 KB

here is the result

image
image607Γ—493 9.67 KB

11

@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.

12

Yes, most of my sales are sales invoices for the selected period, and there is also a credit note on some invoices.

I don’t understand this, can you please explain better?

13

Look at this

image
image630Γ—114 23.1 KB

image
image1358Γ—178 66 KB

or you can share edit form of your sales transaction to see what sales account name used.

14

@Mahmoud_Mohsen1 you did not reply to @Ealfardan. Please note the FAQ - Manager Forum specifically:

Be specific. … If your question relates to an apparent software problem (rather than an accounting topic), tell us your operating system (including the version), Manager edition (desktop, server, or cloud), …

Also from same:

Manager advances very quickly, simplifying and adding features and capabilities. Sometimes, bugs occur with new releases. But these are usually fixed rapidly, often within minutes. So if you encounter a problem with the desktop or server editions, update Manager , even if you recently did. (The cloud edition is always up to date.) You can check the latest version at https://www.manager.io/desktop/download/ .

15

Hi Eko,

I’m very grateful for @Ealfardan for his help
I understand your point , thanks for sharing it . it’s abit hard to follow up on the updates as it’s quickly advancing " which is a great +"

Thanks again folks

16

Thanks, my sales transaction is not inventory sales, thats why is not showing anything, it now showing as expected now

17

I have two questions:

  1. Please, can I select the customer I want to generate their report?

What I mean is, assuming I have 40 customers but I only want to filter to generate items bought of 20 customers, how can I do that, please?

  1. Assuming a customer buy a product called speaker 50 cartons today and also bought another 70 cartoons the second week, can the system accumulate the sales together to give total figure bought instead of show 50 sperately and 70 seperately.