JCT_current when pulling in via ODBC always has an error until I remove the following fields, please fix this:
Commitment_CO
AP_Payment_ID
Bank_Account
Check
Deposit_ID
Deposit_Date
Deposit_Adjustment
Retainage
Debit_Account_2
Credit_Account_2
by: Erin A. | over a year ago | 8 Reports and Inquiries
Comments
I have narrowed it down, it is only the Check field that causes the table not to pull in. Can you fix it please so we can bring all via ODBC into excel to work with the data as it is easier and quicker in quite a few instances to setup an ODBC table and filter and total data or report on it (an example is reporting on jc cost code divisions with contract, billing, fields included since they do not total properly in the jc cost code group cost code headers or populate in the jc cost code contract and billing fields in that table, they are only able to be brought in with contract item derived and the issue is that only one item can be attached to each cost code and that the multiple items do not total in the group cost code totals for contract and billing fields).
Also please fix:
PR_Current_Time "End" field causes table to not pull in via ODBC in 16.1 but worked in 15.1
PRM_Master_Company_Tax fields "Percent" and "Limit" causes table not to pull in via ODBC in 16.1 but worked in 15.1
PRX_TAX_TAX field "Limit" causes table not to pull in
via ODBC in 16.1 but worked in 15.1
PRS_System_Fringe field "Limit" causes table not to pull in via ODBC in 16.1 but worked in 15.1