Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
The problem is that (in this particular instance) there was a posting to the wrong cost center. The first record (Invoice# 1000) was posted as an Invoice. Then it was later discovered that it was posted to the wrong cost center. So a credit was posted (Invoice# 1234) and the proper invoice to the correct cost center was posted right after (Invoice# 1235). The result of this is that there are three records showing up in the query where there should only be one.
Cust_Code Job_No Invoice_No Inv_Date Trans_Type Amount Cost_Ctr ACME 987654 1000 2011-03-27 I 12345.67 ABC ACME 987654 1234 2011-03-27 C 12345.67 ABC ACME 987654 1235 2011-03-27 I 12345.67 XYZ