Stock summary report(custom)

[meesam]

Hello Managers,

I create a report in custom reports for stock summary by custom field the problem is report shows double quantity of invoices how it fix .?

Invoices total Qty is:-
Dostea 175ml = 14
Dostea 112ml= 4

But it double see the report

See the report and invoices below

[lubos]

Do not use Groups to collapse checkbox until your custom reports show the right transactions.

So first, uncheck Groups to collapse checkbox and then see what you get.

[meesam]

Thanks for your kind rply @lubos

I try as you say please check this pics problem still

[lubos]

Add Account column to your Select... section so you can see what accounts are these quantities posted to.

[meesam]

Add account please check

![IMG_20200810_141126|375x500]

Still problem in quantity

[lubos]

Now you see sales invoice makes two transactions for each inventory item. One to Inventory on hand account and the other one to Inventory - sales account.

So you just need to filter out one of those two accounts.

For example, if you want to see Inventory on hand transactions only, you can do something like…

Where... - Account - Name - Contains - Inventory on hand

This will eliminate Inventory - sales account transactions.

[meesam]

@lubos

got it thanks sir