Skip to main content
Skip table of contents

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: -->

CODE
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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.