We raise invoices with 4 decimal places for unit price. When customer pays us it is 2 decimal places but when processing mixed payment and matching the invoice IFS will write off the difference of 3rd and 4th decimal.
However, when we have payments on account, which are of higher value than invoice, we try to match/offset these but are always left with 3rd and 4th decimal place remaining on account as an outstanding value when the value is changed to match invoice.
How can we fix this so that the small difference is cleared in tolerance similar to when the correct value is paid.
Example:
Payment £1,234.56
Invoice £1,234.5678
Mixed payment writes off 0.0078
Payment £1,000
Payment £2,000
Payment £3,000
Invoice £5,123.4567
Amending line 3 to £2,123.45 to match and clear invoice leaves 0.0067 as a outstanding value on account
