I'm attempting to build a report of shipped/invoiced orders that pulls data from Value Entries or Item Ledger Entries posted in Navision 2015. I am basing my report on one of these tables, rather than Invoices, in order to pull info about the product Lot used to fulfill the order. To bring in customer information and item information, I have linked the primary table (either Item Ledger Entries or Value Entries) to the Customer, Item, and Sales Invoice Header tables.
The Table Builder works correctly and the report looks normal in Design mode; however, when I run the report, I get the #VALUE! error…and when I debug I get the error "Invoking the web service failed with the following message: There is an error in the XML document (1, ######)". The XML document referenced in the debug error message varies, depending on the report columns included. I've tried changing around the columns, and get a different XML error every time, including: (1, 309317); (1, 272195); (1, 286769); (1, 272185); (1, 192698); (1, 122935); and (1, 178860).
I have been using Jet Express successfully for several months; these errors only started to occur recently.
I appreciate any help or guidance that anyone can offer. Thank you!!
Multiple XML Document Errors using Table Builder for NAV