1. Home
  2. Point-Of-Sale Software
  3. Modify Quote Detailed Report

Modify Quote Detailed Report

I would like to add the Supplier as a Field for filters when running a quote (detailed) report. I opened this report saved it as a custom - quote report and modified it so that it would have Supplier as a selectable filter. I am now able to select Supplier and change the Filter Value to my desired Company. But when I try to run the report I get this error.

(-2147217900) invalid column name "SupplierID"

I have modified a few reports already with satisfactory results. So I'm sure that I can do this. Just would like to know what I am missing. Any help would be appreciated.

Thanks, Neil

Reply to
nt8378
Loading thread data ...

You've used "SupplierID" in a context in which it is invalid.

Open your report in a text editor and search for "SupplierID". You probably need to change it to "Item.SupplierID" or "SupplierList.SupplierID". Also, I don't remember and haven't checked, butI don't think that SupplierID is a valid DrillDown field, so if you've used it there it's probably your problem...

Glenn Adams Tiber Creek C> I would like to add the Supplier as a Field for filters when running a quote

Reply to
Glenn Adams [MVP - Retail Mgmt]

Glenn,

Yes I didn't have Item in front of Supplier (Item.Supplier). After putting that there It works great. Thanks for the advice.

Neil

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Reply to
nt8378

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.