When I use the Bank Transaction List, to enter batch invoices from bank deposits, every invoice from the past, that ends with the same numbers shows and I have to scroll down to the last, which is the most current. (SAL-INV-2022-00123/2023-00123/2024-00123). You get the point.
I am entering dozens of invoices on one deposit, so I only enter the last numbers. In the past, I’ve entered the customer’s name but if they buy often, some of the invoices don’t even show in the results and again, there is a lot of scrolling down.
I have had this iteration only since Aug of '22 but I’m imagining that in the next few years, there will be so many more, and eventually, this will become burdensome.
If the code were written to hide those invoices that have already been reconciled, that would ease the burden and speed things up immensely.
Is there a reason you’re matching Invoices to Bank Transactions manually and not using the reconciliation tool? The tool does exactly what you’re describing, showing Invoices/Payments/etc that haven’t yet been matched to bank entries.
If you prefer to edit the Bank Transaction directly, you could probably write a custom query for the Link field. Be warned, though, that it’s likely going to be a lot more complicated than might appear. Matching is not a property of the Invoices but rather the Bank Transactions, so you’ll have to iterate through all existing documents to filter out the ones that haven’t yet been matched.
For the majority of my reconciliation process, yes, I use the tool. The issue comes when one transaction (deposit) is actually 3 or 7 or 21 individual invoices that all need to be reconciled for that transaction. I have to use the list view to add lines and account for all the invoices associated with that transaction.
I have an outside firm curating our erp system and the connection to our website, so I would have to ask them if they could do something like you’re suggesting.
