Using simple statement select * from SalesInvoiceLines and getting this error message: System.NullReferenceException: Object reference not set to an instance of an object. at ManagerServer.HttpHandlers.Businesses.Business.Reports.CustomReports.CustomReports2.Post() This error appears on desk…

The main issue with custom reports is that they are still work in progress and database schema is not documented. In this instance, SalesInvoiceLines table hasn’t been exposed in custom reports yet so it’s not possible to select from it.

Over 6 months ago, you mentioned that the custom report will be introduced and made available to users. I am reading on this forum that users are able to select from various tables, including the one I showed in my sql select. What is the status on this issue. I am a sql programmer (Oracle Financial…

There must be an issue with your system. I am unable to select any objects (customers / suppliers) from the server based applications. I am able to select data from the desktop environment.

Your answer does not explain the error on the system. There is a lot of talk but no actions. Many promises about the database schema and providing custom reports. Nothing happens for over 6 months. How do you explain the above error?

[image] Andreas: How do you explain the above error? I already did explain the error. SalesInvoiceLines table is not available in custom reports yet. [image] Andreas: I am unable to select any objects (customers / suppliers) from the server based applications. I am able to select data fr…

There is a problem with the server version on Ubuntu. The server version is Manager 16.2.83 on Ubuntu. The windows desktop version is 16.2.39. The SalesInvoiceLines exists on both systems. I have created many Sales Invoices. The error on the server forced me to install the desktop version to veri…

I don’t believe select * from SalesInvoiceLines works on desktop edition as you claim. select * from SalesInvoice should work though.

FWIW, here are a few queries that I’ve successfully run on Ubuntu (15.7.3 is what I have): Select Name from Customers Select * from Suppliers select CustomerName from SalesInvoices where Reference = “21” select * from SalesInvoices where CustomerName = “XYZ Bizname” ORDER BY IssueDate I’d be…

Queries that run on Mac OS X El Capitan, Manager 16.3.74 SELECT reference, issuedate, customername, balancedue FROM SalesInvoices WHERE balancedue>0 ORDER BY issuedate SELECT reference AS Invoice, issuedate AS Date, customername AS Customer, balancedue AS Balance FROM SalesInvoices ORDER BY issue…

Are WHERE queries supported yet? I need to pull all the orders within a specific duration, however, WHERE IssueDate > “01-07-2016” and similar queries are giving error. BETWEEN is also giving errors. Also, can I pull a report based on custom fields? I have ‘state’ as custom field in Customers. …

Error in select statement when setting up a custom report

Topic		Replies	Views
Some help with custom reports?	4	1124	October 8, 2017
SQL schema for creating custom reports	61	11758	March 5, 2018
Internal error when creating report	16	829	April 29, 2018
Queries in Custom Reports no longer work after update	9	1078	October 11, 2017
Custom Reports: receiving error when using SQL statement to retrieve data from custom fields	6	1137	March 26, 2017

Error in select statement when setting up a custom report

Related topics