We have an account that has had a 1 cent overpayment showing on the reports (both built in and the SSRS reports) since 2011 (it was just pointed out me today). Normally when there is a discrepancy the accounting dept. just makes an adjustment in GP Dynamics and all is good - however, in this particular case any attempt to make the normal adjustment comes with a response from GP that there are no overpaid or unbalanced documents to apply against. I have checked in the database and can see the entry in both tables RM30101 and RM30201 for $55.76 (should have been $55.75) and can see the document trail the reports are building from which does confirm the 1 cent discrepancy - not sure why GP says there isn't anything to apply against. Has anyone else come across this and if so what is the proper solution. (I would rather a solution that is run from within GP 2013 rather than one that involves directly meddling with the data in SQL - I have already tested changing the value in both tables indicated - but that yielded a broken report so I rolled them back to their original values - I assume there are other tables involved.)
*This post is locked for comments