1099 Box 2 Issues - NULL company_code_id - Tracker
Issue = Owner Amounts linked to OMAs (Owner Manual Adjustments) are being dropped off the 1099 Export because their company_code_id is NULL – Assumption is that this column is used to join Financials data back to Revenue.
Fix = Script all owner_amounts linked to OMAs and set the correct company_code_id
SQL to determine if bad data exists: -->
select count(*) from owner_amounts where company_code_id is NULL
SQL Statement to Update Data:
update owner_amounts set company_code_id = c.id from owner_amounts oa left join assets a on oa.asset_id = a.id left join company_codes c on a.company_code_id = c.id where oa.company_code_id is null
Client | NULL company_code_id OA's? | # of Records | Script run in Prod? | WEDEVOPS Ticket | Owner |
|---|---|---|---|---|---|
Flywheel | Yes | 2024625 | 12/21/2023 | WEDEVOPS-17653 | Nick |
IKAV | Yes | 2083 | 12/29/2023 | WEDEVOPS-17707 | Tyler |
Vital/Laredo | Yes | 928180 | 01/02/2024 | WEDEVOPS-17713 | Micah |
GME | Yes | 880691 | 01/08/2024 | WEDEVOPS-17837 | Micah |
Terra | Yes | 8724897 | 01/04/2024 | WEDEVOPS-17791 | Micah |
Highpeak | Yes | 56920 | 01/02/2024 | WEDEVOPS-17716 | Nick |
Riverbend | Yes | 6527 | 12/29/2023 | WEDEVOPS-17709 | Micah |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
|
Client | NULL company_code_id OA's? | # of Records |
|---|---|---|
Script not needed for below clients | ||
Howard | No | 0 |
Eagleclaw | No | 0 |
AEC | No | 0 |
HKN | No | 0 |
Dugan | No | 0 |
King | No | 0 |
Legacy | Yes | 24 |
Tallgrass | Yes | 104 |
VEF | Yes | 376 |
Ineos | No | 0 |
Jaybee | No | 0 |
Killam | No | 0 |
Lucero | No | 0 |
Rosewood | No | 0 |
Raisa | No | 0 |