Tax and Reg -Form 341 Report Issue: No Results Due to Unclosed Process Control Dates
🤔 Problem
The client encountered an issue where the tax Form 341 report showed no results. The Cognos Form 341 report pulls data from the OK Tax Transactions table, not directly from the Tax Results screen. OK Tax Transactions are populated when you run the CPC process Format OK Taxes. Upon reviewing the OK Tax Transaction Table, there were no results.
🌱 Solution
In order for the Format OK Tax process to pick up records, the corresponding asset Process Control Dates must be CLOSED. In this case, the client did not close the dates.
Confirm Process Completion
Run all required processes in the following order:
Close Asset Process Control Dates for the relevant assets/companies after all Asset processes have been run.
Run Format OK Taxes in Company Process Control for the corresponding account date.
If the process is not completed or run out of order, data may not be available for reporting.
Check for Data in OK Tax Transactions
Query the OK Tax Transactions table for the target accounting date and companies.
If no records exist, the report will not display data.