1.7 5708 Allocated amount bug

Yesterday we had a funny invoice print - the amount paid  (which comes from the allocated amount field) showed $400 - an amount different to what was paid. When the invoice is printed now it shows the correct amount paid and this matches the allocated amount actually in the database (as revealed by an SQL query).

Trying to replicate the situation, if I invoice for $1234, then finalise and pay, the amount paid shows the actual amount paid ONLY if the account previously had a zero balance.  If there was an outstanding balance, then on the invoice, although it has just been paid in full, it says Amount Paid = $0.

In trying to document this better, I did invoice, finalise, don't pay; new invoice; finalise, pay - but only amount of invoice 2.

The invoice print shows as follows - note the amount paid - it is not what was paid ($1560) but rather $1560 less the remaining account balance.

Here is the Account page showing the paid amount is really $1560

If I print the invoice again, it still shows as above, ie Amount paid=$1289.60. If I look in the database with an SQL query, the allocated amount is indeed $1289.60

Wondering if this is some sort of 'cached in memory' problem, I logged out and back in again and did another invoice. Here is the payment screen for it:

and here is the invoice print:

and here is the account screen again:

If we now print the "unpaid" $270.40 invoice, it shows and amount paid of $270.40 - but (as indicated by the balance) it has not actually been paid.

 

Conclusion: If the account is running "clean" -ie each invoice entered and then immediately paid, things work OK. However, if there is an outstanding balance, the allocated amount field get wrongly set to the outstanding balance less the amount paid.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: 1.7 5708 Allocated amount bug

It is normal in an accounting situation that when a payment is made it is allocated against the oldest outstanding invoice / balance...hence say I have

Invoice 1: $100

Invoice 2: $200

Client Payment: $150 when invoices for 2

It will show on Invoice 2 amount paid as $50

Invoice 1 will have been fully paid

 

Remember in OPEN payments are NOT linked to a specific invoice. they are linked to the account.

Re: 1.7 5708 Allocated amount bug

Humm - you are correct Ben - but you must admit that the following print is confusing. 

I think I need to adjust my invoice.jrxml to be more cunning about what is shown in the 'Amount Paid' slot.

I think that the logic should be as follows:

allocated amount = 0: print Amount Paid $0.00 (or suppress the line)
allocated amount = total: print "Paid in Full"
else : print Amount Paid $allocated amount

and also change "Current Balance" to "Account Balance" (because 'Current Balance' could be taken to mean the balance of this invoice).

Note that the countersale.jrxml uses this sort of logic.

Thanks for your input.

I have added to the Concepts|Accounting page of the CSH text and have provied a link to this on the Customers|Account page.

Regards, Tim G

Syndicate content