There has been improvements to automatic credit allocations from version 17.9.28 which is a welcome feature as the users are able to better record deposits from customers and to suppliers and still show the transaction in customer or supplier statements. this was not possible when creating a separate account for the deposits and the customers or suppliers were worried about the statement not showing the deposits as the statements considered only the Accounts receivable and Accounts payable.
While this has provided an advantage, there is a drawback too.
When the payment is received as a sum of few of the pending invoices made and the same is allocated to particular invoices, it shows as overpaid and a user has to manually edit, calculate and reallocate the excess payment to other pending invoices.
For example, there are following sales invoice and their total.
Invoice 1 - $553
Invoice 2 - $1254
Invoice 3 - $5235
Invoice 4 - $1221
Invoice 5 - $235
Invoice 6 - $125
Invoice 7 - $516
Invoice 8 - $134
Invoice 9 - $5489
Invoice 10 - $54
Invoice 11 - $1231
Invoice 12 - $3568
This totals to $19615
Customer pays $9139 for upto Invoice 1 to 7.
Now, when entering the payment its more than a headache as the user has to allocate the payment to every invoice matching the exact invoice value in a single receipt. adding more to the headache is the inability of the user to see the invoice details on the same screen.
Not selecting an invoice when making a receipt will automatically allocate the credit to pending invoices but the user will lose the ability to record deposits as mentioned earlier.
There are two suggestions to overcome this which will improve Manager even further.
Possibility to create a chart of accounts under liabilities and assets, say Customer Deposits and Supplier Deposits, which would enable to choose the customer or supplier when receiving or spending money?
at present the customer or supplier can be selected only when the Accounts receivable or Accounts payable account is selected.
To avoid the chances of users misusing this, maybe this can be implemented as a default rather than giving the user the ability to create such an account.
The form design needs modification to incorporate things like in the below example
here, the total payment received is entered in a separate box. the pending invoices are shown in separate table where the invoice total, the balance due and the payment applied towards the invoice is shown. the total payment received is automatically distributed according to the invoice age and the balance due. also, there is ability for the user to manually allocate the value to another pending invoice if needed.