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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Excel add in error Given Key was not present in the Dictionary

(0) ShareShare
ReportReport
Posted on by

hi,

i'm using the excel add-in feature and trying to query the Posted_Sales_InvoiceSalesInvLines and when i do i'm getting the following error

An error occurred while retrieving the row count of entity Posted_Sales_InvoiceSalesInvLines. Error details: The given key was not present in the dictionary.  

this query was working before and it suddenly stopped working.  i don't have any issues querying the Posted_Sales Invoice table but once i try the posted sales invoice lines i get the error above. 

please advise what could be the issue.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans