In the reports of both customers and suppliers, there is a report named Supplier Statements (Transactions) and Customer Statements (Transactions).
We want two other reports, Customer Statements (Transactions Details “Lines”) and Customer Statements (Transactions Details"Lines").
Most of the program users do not have developers and they havn’t personal experience in developing the program and in case of trying through custom reports, we cannot reach a typical and 100% correct report.
@contabl2006, your suggestion would not make sense. In Manager, Customers and Suppliers are subsidiary ledgers of Accounts receivable and Accounts payable control accounts, respectively. A sales or purchase invoice results in one debit or credit to the subsidiary ledger, regardless of the number of line items on the invoice. Likewise, a receipt or payment posted against a sales or purchase invoice produces one credit or debit to the subsidiary ledger.
In other words, subsidiary ledger entries are not made line item by line item. The Customer/Supplier Statement (Transactions) reports describe entries to the ledgers, not line items the customer/supplier has purchased or sold. That information is available in the Sales Invoices and Purchase Invoices tabs by slicking on the Lines buttons at the bottom. Depending on exactly what information you want, an advanced query can narrow the list. Copying to the clipboard and pasting into a spreadsheet will help you produce a report.
None of this requires any programming skill.
Your response that my suggestion is illogical is always the case. I will explain the implementation idea, perhaps it will help you, and we will take customer accounts as an example:-
To implement the idea, we need to merge the results of the query for the desired customer from the Sales Invoices tab, Credit Notes tab, Receipts tab, Payments tab, and Journal Entries tab into one report.
1- Sales Invoices — Lines
2- Credit Note - Lines
3- Receipt - Lines
4- Payments — Lines
5- Journal Entries
Therefore, my request is very logical, especially since the tools to implement it are already present in the program. All we need is to merge them into one report.
I doubt you will see the addition of a new hard-coded report when the same result can be achieved with an advanced query. That is why the developer introduced advanced queries—because different users always want different things.
Although I am just a regular user and use the free version, I view the program as if it were my child and want it to be the best. I have lived through the stages of its development with you and see that the two reports should be fundamental because they are a requirement for all establishments and companies, especially those with commercial, industrial, and service activities, and not just a personal request from me. As I have previously explained, queries require exporting all data from the mentioned tabs to an external program like Excel and merging them to extract the report. You can imagine the time and effort spent to obtain the summary, not to mention the errors that may occur during execution. So why not have it through a ready-made report? The two required reports may seem unimportant or useless to you, but from my experience, I have explained your program to more than one of my friend, and they were very impressed with everything in it, but we always stopped at these two reports.
Please post your best attempts and explain why you think it is still inappropriate.
You state an assumption. But your preferences are certainly not universal. Thousands of users around the world in all sorts of businesses get along without the report you seem to think is essential.
@contabl2006 Yes these detailed reports are requested by many users and already in ideas.
Lets hope this is implemented soon.