Invalid number of columns error when exporting YTD Budget Report to Excel in specific scenario

Owned by Knowledge Assistant
Jan 31, 2023
1 min read



Description of Issue

Error when exporting YTD Budget Report to Excel with the following setup:

  • All MY LTD Accounts

  • First Account in the Output has carryforward BUC, any subsequent account does not

  • Report Sequence includes Object (totaled)

  • Run for Current Year (any Period)

  • Carryforward set to 'Totals (GAAP)'

  • Print Journal Detail selected

  • Include Budget Entries unchecked

Error: 

Munis (glytdbud)
spoffice_officeExport: Invalid number of columns for data element: 1. Make sure each column is populated for this row.



Context

YTD Budget Report



Cause




Resolution

The work ticket MUN-454986 is currently open with Development. This work ticket is low priority and will likely be addressed in a future version.



Additional Information

No error occurs if:

  • Exporting to PDF or Display

  • First account in the Output does not have carryforward BUC

  • Remove Totals from Object Report Sequence

  • Change Carryforward setting to 'Current Year Only'

  • Select Include Budget Entries on Additional Options tab