I don’t know if this has been asked before so apologies if it has. I’ve been entering a Purchase Invoice today for a number of items that have to be broken down. E.G. A reel of cord is sold by the metre so the invoice cost has to be divided by the number of metres on the reel to get the unit price. All the calculations for this have been carried out in Excel and all work through to match the invoice value, and these unit values have been entered the Inventory module. The problem I’m having is as follows: -
Invoice value £409.82
Purchase Invoice Entry Screen Total £409.8199
Purchase Invoice Printed Screen Total £409.79
<img src="//discourse-cloud-file-uploads.s3.dualstack.us-west-2.amazonaws.com/business5/uploads/manager1/original/2X/c/c46f208cb9d47fc15b2cc96911fe0d3c406cbe0b.png" width=“436” height=“196”
I’ve tried rounding the decimal places up and down and there always seems to be a £0.03 variance despite the fact the entry screen suggests the rounding should go to the £409.82 value as per the invoice. The summary sheet is showing £409.79 in Accounts Payable but if I “Spend Money” I have to adjust the value to reflect the invoiced amount.
Adjusted Value Paid - Bank Payment Screen
Going back to the the Purchase Invoice View it shows £409.79 “Paid in Full”, not the actual amount on the invoice being processed. Also, the summary screen is showing a supplier credit of £0.03 which is clearly incorrect.
This is probably all to do with how Manager rounds values up/down but if anyone can confirm this or explain why I’m getting this difference I would appreciate it as obviously the accounting entries should match the paperwork.
Thanks for the help.