Knowledgebase Search

DF-FA-23318-Cash Journal - 1099 Detail Vendor Report returns Null error

Symptom:

After removing the filter ‘Vendor Issue 1099’ from the Cash Journal, the report returns the following error;
‘Cannot insert the value NULL into column ‘Player ID’, ‘tempdb.dbl#Tmp____00000000003F’;column does not allow nulls. INSERT fails. The statement has been terminated

Product Line:

Abila MIP Fund Accounting

DF-FA-23918-Current Year % Change column does not round to Whole Numbers

Symptom:

On the Statement of Revenue and Expenditures the ‘Current Year % Change’ column does not round to whole numbers when rounding is selected in the options tab.

Product Line:

Abila MIP Fund Accounting

DF-FA-23948- ‘Invalid column name’ error on Drilldown in Normal Trial

Symptom:

When running the Normal Trial Balance with GL code selected in ‘Items by Page, the drilldown options produces the error message ‘Invalid column name ‘PrintDetail’. Invalid object name ##DDFSL1_1408CDD0-0D64-4E1B-A106-48FA3DA53DEA’, cannot drop the table because it does not exist or you do not...

Product Line:

Abila MIP Fund Accounting

DF-FA-24151- ‘String or binary data would be truncated’ error when running Bank Rec report

Symptom:

When attempting to run the Bank Rec report, Combined Reconciliation, the error message ‘String or Binary data would be truncated. The statement has been terminated.’ displays.

Product Line:

Abila MIP Fund Accounting

DF-FA-24146-Cleared Checks not showing a ‘cleared date’ in Bank Rec report

Symptom:

Missing checks in a bank reconciliation are in cleared status (CL) but have no cleared date.

Product Line:

Abila MIP Fund Accounting

DF-FA-23281-Append to Excel files with file type xlsm Fails – File Format or Extension Not Valid

Symptom:

Software produces the following error:
Excel cannot open the file ‘XXXXX’ because the file format or file extension is not valid. Verify the file has not been corrupted and that the file extension matches the format of the file.

Product Line:

Abila MIP Fund Accounting

DF-FA-23786-Unable to Chart a statement of revenue and expenditure report with a Formula Custom Column

Symptom:

When attempting to Chart a Statement of Revenue and Expenditures report that contains a Custom Column the follow error message is displayed: Invalid column name ‘CC_Percent’.

Product Line:

Abila MIP Fund Accounting

DF-FA-23625-Sort on Items by Page Causing Different Data to display in Revenue and Expense report

Symptom:

In a Statement of Revenue and Expenditures Report if more than one segment in the item by pages is not tagged to Sort, it gives different results in the report.

Product Line:

Abila MIP Fund Accounting

DF-FA-23919-Exchange Rate Report Not Displaying Current Exchange Rate Correctly

Symptom:

The Current Exchange Rate column is displaying the incorrect rate on the Exchange Rate report.

Product Line:

Abila MIP Fund Accounting

DF-FA-23345-Export to Excel Fails When Headers/Footers Included

Symptom:

When exporting a Combining Statement of Revenue and Expenditures to Excel the following error displays: ‘COleDispatchException You may not have enough memory to export this report. You can reduce the size of the report by adding filters or decreasing the date range. You’ll be given the...

Product Line:

Abila MIP Fund Accounting

DF-FA-23707-Export to Excel – Data Line is Bolded When Headers & Footers Removed

Symptom:

One row of information is bolded in Excel after exporting a Combining Statement of Revenue and Expenditures with Headers and Footers removed.

Product Line:

Abila MIP Fund Accounting

DF-FA-23318-Cash Journal - 1099 Detail Vendor Report returns Null error

After removing the filter ‘Vendor Issue 1099’ from the Cash Journal, the report returns the following error;
‘Cannot insert the value NULL into column ‘Player ID’, ‘tempdb.dbl#Tmp____00000000003F’;column does not allow nulls. INSERT fails. The statement has been terminated

DF-FA-23918-Current Year % Change column does not round to Whole Numbers

On the Statement of Revenue and Expenditures the ‘Current Year % Change’ column does not round to whole numbers when rounding is selected in the options tab.

DF-FA-23948- ‘Invalid column name’ error on Drilldown in Normal Trial

DF-FA-24151- ‘String or binary data would be truncated’ error when running Bank Rec report

When attempting to run the Bank Rec report, Combined Reconciliation, the error message ‘String or Binary data would be truncated. The statement has been terminated.’ displays.

DF-FA-24146-Cleared Checks not showing a ‘cleared date’ in Bank Rec report

Missing checks in a bank reconciliation are in cleared status (CL) but have no cleared date.

DF-FA-23281-Append to Excel files with file type xlsm Fails – File Format or Extension Not Valid

Software produces the following error:
Excel cannot open the file ‘XXXXX’ because the file format or file extension is not valid. Verify the file has not been corrupted and that the file extension matches the format of the file.

DF-FA-23786-Unable to Chart a statement of revenue and expenditure report with a Formula Custom Column

When attempting to Chart a Statement of Revenue and Expenditures report that contains a Custom Column the follow error message is displayed: Invalid column name ‘CC_Percent’.

DF-FA-23625-Sort on Items by Page Causing Different Data to display in Revenue and Expense report

In a Statement of Revenue and Expenditures Report if more than one segment in the item by pages is not tagged to Sort, it gives different results in the report.

DF-FA-23919-Exchange Rate Report Not Displaying Current Exchange Rate Correctly

The Current Exchange Rate column is displaying the incorrect rate on the Exchange Rate report.

DF-FA-23345-Export to Excel Fails When Headers/Footers Included

When exporting a Combining Statement of Revenue and Expenditures to Excel the following error displays: ‘COleDispatchException You may not have enough memory to export this report. You can reduce the size of the report by adding filters or decreasing the date range. You’ll be given the...

DF-FA-23707-Export to Excel – Data Line is Bolded When Headers & Footers Removed

One row of information is bolded in Excel after exporting a Combining Statement of Revenue and Expenditures with Headers and Footers removed.

Abila

Solutions

Resources

Legal

Company

After removing the filter ‘Vendor Issue 1099’ from the Cash Journal, the report returns the following error; ‘Cannot insert the value NULL into column ‘Player ID’, ‘tempdb.dbl#Tmp____00000000003F’;column does not allow nulls. INSERT fails. The statement has been terminated

On the Statement of Revenue and Expenditures the ‘Current Year % Change’ column does not round to whole numbers when rounding is selected in the options tab.

When attempting to run the Bank Rec report, Combined Reconciliation, the error message ‘String or Binary data would be truncated. The statement has been terminated.’ displays.

Missing checks in a bank reconciliation are in cleared status (CL) but have no cleared date.

Software produces the following error: Excel cannot open the file ‘XXXXX’ because the file format or file extension is not valid. Verify the file has not been corrupted and that the file extension matches the format of the file.

When attempting to Chart a Statement of Revenue and Expenditures report that contains a Custom Column the follow error message is displayed: Invalid column name ‘CC_Percent’.

In a Statement of Revenue and Expenditures Report if more than one segment in the item by pages is not tagged to Sort, it gives different results in the report.

The Current Exchange Rate column is displaying the incorrect rate on the Exchange Rate report.

When exporting a Combining Statement of Revenue and Expenditures to Excel the following error displays: ‘COleDispatchException You may not have enough memory to export this report. You can reduce the size of the report by adding filters or decreasing the date range. You’ll be given the...

One row of information is bolded in Excel after exporting a Combining Statement of Revenue and Expenditures with Headers and Footers removed.

After removing the filter ‘Vendor Issue 1099’ from the Cash Journal, the report returns the following error;
‘Cannot insert the value NULL into column ‘Player ID’, ‘tempdb.dbl#Tmp____00000000003F’;column does not allow nulls. INSERT fails. The statement has been terminated

Software produces the following error:
Excel cannot open the file ‘XXXXX’ because the file format or file extension is not valid. Verify the file has not been corrupted and that the file extension matches the format of the file.