New Customer and Supplier Report

It would be very useful a new report (exportable) that with this settings:

  1. starting date
  2. ending date
  3. sorting (by date or by credit/debit amount)

summarize these datas in columns for each costumer (supplier):

  1. name of the costumer (supplier)
  2. starting credit (debit) at the starting date
  3. amount invoiced
  4. amount of credit (debits) notes
  5. amount received/spent by cash/bank
  6. finale credit (debit) at the ending date
1 Like

This sounds like a Customer Statement … except it shows details for more than just one Customer at a time.

Am I understanding correctly?

Yes… the combination of the two (costumers and suppliers) is very useful for calculation the variation of the working capital. I would also suggest an extra column with the control account each costumer and supplier is linked. @lubos?

I support this. The more info you get from one window the better

Added to the latest version (19.9.10)

1 Like

Thanks… I tried but I get this error:

Internal Error
19.9.10 (Server)
/customer-summary-view?Key=d47afa35-f092-4a31-ac49-9cf9f8a06a1a&FileID=4ec5be78-18a6-45e0-bb8c-864c3815bf33&Referrer=70a4159b-f7c1-4db1-97b6-0936199e95ef
System.Exception: Exception of type ‘System.Exception’ was thrown.
at ManagerServer.HttpHandlers.Businesses.Business.Reports.CustomerSummary.CustomerSummaryView.GetViewModel (Manager.Model.CustomerSummary report) [0x002d4] in <22c3d0fab4ed4a1382002c18ed3aa065>:0
at ManagerServer.HttpHandlers.Businesses.Business.Reports.Report2`1[T].GetViewModel () [0x00037] in <22c3d0fab4ed4a1382002c18ed3aa065>:0
at ManagerServer.HttpHandlers.Businesses.Business.Reports.Report2.Get () [0x00000] in <22c3d0fab4ed4a1382002c18ed3aa065>:0
at HttpFramework.HttpApplication.ProcessRequest (HttpFramework.HttpRequest request, HttpFramework.HttpResponse response) [0x000ae] in <2f8915cb83b9458594dc58410aeb7f45>:0
at ManagerServer.HttpApplication.ProcessRequest (HttpFramework.HttpRequest request, HttpFramework.HttpResponse response) [0x00763] in <22c3d0fab4ed4a1382002c18ed3aa065>:0

By reducing the reporting period I don’t get the error.

I think it’s a very useful report. It would be perfect if you can add the possibility (optionally) to group them by control accounts to which they are assigned.

Try version 19.9.11. Either it’s fixed or the error will be slightly different to reveal what’s exactly wrong.

Me too - I get a very similar error on the Supplier Summary Report

For one month - 01 Aug 2019 to 31 Aug 2019 works
image

but a longer period gives the error
image

Version:1.0 StartHTML:000000338 EndHTML:000002156 StartFragment:000000449 EndFragment:000002124 StartSelection:000000449 EndSelection:000002124 SourceURL:http://localhost:61027/supplier-summary-view?Key=68d38417-e997-42e4-9018-88e0ea83bda6&FileID=7d2122d4-761b-4f45-a270-b594abc6f88d&Referrer=c6fe817d-0da3-4438-8680-7982b91cd285

Internal Error

19.9.11 (Desktop)

/supplier-summary-view?Key=68d38417-e997-42e4-9018-88e0ea83bda6&FileID=7d2122d4-761b-4f45-a270-b594abc6f88d&Referrer=c6fe817d-0da3-4438-8680-7982b91cd285

System.Exception: ExpenseClaim at ManagerServer.HttpHandlers.Businesses.Business.Reports.SupplierSummary.SupplierSummaryView.GetViewModel(SupplierSummary report) at ManagerServer.HttpHandlers.Businesses.Business.Reports.Report2`1.GetViewModel() at ManagerServer.HttpHandlers.Businesses.Business.Reports.Report2.Get() at ManagerServer.HttpApplication.ProcessRequest(HttpRequest request, HttpResponse response)

It seems like the issue was when customer or supplier was used in expense claim transaction. Fixed in the latest version (19.9.12)

Thanks. I really appreciate having new features those are very useful for users.
I would like to suggest one thing.
when we used multi currency, if there only one customer or vendor for that currency, report didn’t show summary for that currency
is this possible to show total even one customer or supplier


image

Why would it be necessary to repeat the same numbers? Or even desirable?

it is possible to have these reports in base currency so we can prepare detailed trail balance

This is a completely different kind of report. It’s an extension of General Ledger Transactions also to subledgers. I think it’s already in the ideas since I’ve asked it many times.

1 Like

I believe this new report should not be in base currency.

On the other hand if there could be an option to show this report in base currency or in all currencies that would be great.

you are correct main reports must be as it is. an additional report in base currency or option to generate these report in base currency well help u generate the desired report for reporting