search by customer reference to make customer payment

Hi, have you had a look at Sales ->  Customer Transaction Inquiry and Customer Allocation Inquiry, maybe what you are looking for?

In transaction inquiry page, you can search by all customers or only a specific customer. You can also narrow the search by selecting a transaction type or change the date range. Update results table by clicking 'Search'.

The 'Reference' field when you create sales order can be amended with your customers order number, so '008/2018' could become '008/2018 ON-5678330' and to confirm this is the value that will appear in the 'Reference' column of the transaction inquiry/allocation inquiry page.

You can also adjust the number of rows retrieved per page by changing the value of Query page size: in Preferences

The reference column is printed in the customer balance report.

Does any of the above help/resolve the issue?

Do you have hundreds of due invoices per specific customer?

Yes, you are right that we can see customer reference in the order inquiry page. But we do need to see them in customer payment page with due invoices. Because we do direct invoices and in that case we do not have sales order except invoice and delivery document.
When we take payment for due invoices we need to search on a column by customer reference. How can we do that?

Do you mean something like this https://imgur.com/a/3727T11???

So options:-

1. pdf in landscape - horizontal
2. Download in excel

3. You can modify the customer balance report:-

Copy the file reporting/rep101.php to company/xx/reporting where xx is the company number, (0 for only one company)(after the file has been modified you will need to copy it to any other companies you require the report for)
You can now modify the report in company/xx/reporting without changing core files

Around line 130 you will see the following:-

reporting/rep101.php
130:     $cols = array(0, 95, 140, 200,    250, 320, 385, 450,    515);

0, 95 is the width of the 1st column 95, 140 is the width of the 2nd column etc

Look at the report see what columns you can reduce in width and adjust accordingly, you will then have extra space for the # column.

Looking at it, column 4 (due date) can be significantly reduced also columns 5 and up a little each, but those will depend on your currency

All numbers must increase. the 515 can be changed to 550 which gives you an extra 35 for starters
With a little time and patience you should be able to increase the 2nd column width.

Try the above 1st, if you still need more width in col 2, there are further options