I am an accountant. I am so impressed by Manager. and I want to thank the great developer behind it for the wonderful work done.
I tried to convince companies that I deal with to install Manager. and installed Manager in one of them. but I found one important issue stopping them from adopting it which is the detailed customer report. since in the business culture in my county customers frequently requests this report.
so I request from you to help me building custom report nearly the same as the available report “Customer detailed Statements (Transactions)” but the details of the invoices show also on it. this will help me a lot to convince many companies to adopt Manager as their main accounting software.
Thanks in advance for your support
waiting to hear from you
Have you tried building a custom report to do this yet? Please do not ask other forum members to do something you are unwilling to first try yourself. If you have problems, then ask specific questions. When you ask, show the definition of the custom report and the result. Tell how you want it to be different from what you have achieved.
Yes, I tried many many times but I didn’t succeed. so I asked the community to help me creating a custom report the same as “Customer detailed Statements (Transactions)” but including the details of the sales invoices.
I think this report will help many users. since I found it requested many times before in the community.
Then please do what I asked. Post a screen shot of the definition of the custom report that came closest to what you want, along with the result. You need to be a participant in the discussion if you want help.
Are you looking for a customer statement as in how much they have paid, been invoiced and what is outstanding or what do your customer’s use the report for?
I am locking form custom report the same as the available report “Customer detailed Statements (Transactions)” with the invoice details under each invoice (Item name, unit, price, the quantity bought and amount)
Your report does not include customer among your selected items.
You have not included quantity.
The sales price is only the price defined for the item, not the price at which you sold it. (That amount is not exposed currently for custom reports.)
*You have left second tier fields empty in your filtering that cannot be empty.
You are ordering and grouping by variables you did not select.
I think if what is suggested here been implemented it would be a great upgrade for Manager. Here in Turkey people expect to see the details of the invoices in a customer statement report. Without the invoice details it is regarded as lacking info. An option to include details would be perfect.
@aamra, here’s an attempt at your custom report. First a Customer Statement (Transactions) from a modified Northwind file for the customer Alfreds Futterkiste:
Because it does not show completely in the above, the Alias for the TransactionName is: Date<br>     Description - Reference - Date
Notes on the Where section:
For the custom report, data is needed from these accounts:
Cash at bank
Cash on hand
GST payable
Inventory - sales
The Where filter does not have “or” logic to get data only from the above accounts. So, “does not contain” is used to exclude other accounts and their unwanted data. Only you know your Chart of Accounts so if necessary exclude additional accounts by adding additional “does not contain” lines.
In the Where filter the line “Contact” is used to generate a report for a single customer. I’ve seen elsewhere that you have tried “Customer code”. That should work in place of Contact.
If you have multiple sales invoices to the same customer on the same day you may want to add another line to the “Group by” section:
