web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

Report data could not be loaded due to the following error: (-2147217900) Invalid column name 'Vouchers'

(0) ShareShare
ReportReport
Posted on by 60

I keep getting this error for most reports and I am unsure how to get rid of it.

*This post is locked for comments

I have the same question (0)
  • Reef Corporate Profile Picture
    60 on at
    RE: Report data could not be loaded due to the following error: (-2147217900) Invalid column name 'Vouchers'

    Ok this has happened on most standard reports such as customer list.

    How do I open the report to delete the vouchers column?

    I am not sure what is happening at HQ level but we get the same error for all of our computers in store.

    We are running Store Operations Manager 2.0.0128.  I am unable to find out when the last update was - is there a way I can check?

  • Suggested answer
    Antonijo Todorovik Profile Picture
    4,025 on at
    RE: Report data could not be loaded due to the following error: (-2147217900) Invalid column name 'Vouchers'

    Hi there.

    Or the report is not standard (someone edited it and added columns, changed the query or similar) or you have updated RMS with a new version and the reports are for older version.

    Before You go on checking each report tha gives you this error, can you please advise on any recent RMS updates aplied? Is this happening on store level or HQ? If store, is it happening in all stores?? To be able to help you we need more data...

    Kind regard, A.

  • Suggested answer
    raelhefn Profile Picture
    on at
    RE: Report data could not be loaded due to the following error: (-2147217900) Invalid column name 'Vouchers'

    You have a field in this report not defined in your database so you need to open this report check where is this invalid column 'Vouchers' delete this column or check this field in report query.

    if this is standard report please send report name

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans