Is there a way of looking at the SalesRecord OVERRIDE_PRODUCT_NOMINAL and OVERRIDE_PRODUCT_TAX object via ODBC? I know you don’t support ODBC, but it would be helpful to see them there. Strange that you CAN see the Override for the product tax but not the nominal.
Guest
As the ODBC is set up for the Report Designer, anything variable not visible is unable to be reported.
For example, as a charity we can't distinguish on a report between customers and donors as the donor flag is not visible to ODBC and hence the report designer - we can only pre-filter the customer list to one of the other, report on that and then merge the two reports - madness.