Modify Quote Detailed Report

Jun 07, 2006 2 Replies
N

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



Vote
Twitter Facebook LinkedIn
G

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

Vote
Twitter Facebook LinkedIn
N

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:

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required