Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
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
|SQL Query to check if patient seen in prior 3 years||2||36|
|What task or combo of tasks can I use in ssis 2015 to load different file names into different tables into sql server?||7||28|
|Conversion failed when converting date and/or time from character string.||5||43|
|SQL Agent Timeout||5||28|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!