Sage 100

I am trying to modify the Bill of Materials Picking Sheet for version 4.10. I created a checkbox UDF for the CI_Item File (because I can't on the IM1 file) to check on if the item should not be printed on the BOM Pick Sheet. I can add the CI_Item file to the Report and it runs without error. As soon as I add a selection parameter to not include the item if that checkbox is selected on, I receive the following error: Failed to Open a Rowset. Column not found: UDF_BOM_NO_PRINT. I have the CI_Item file linked as an equal join from the BM_24 Component to CI_Item Item Code. Anyone know what I am doing wrong?

Have you verified database in the report?

Have you tried a left-outer join? If there is nothing in the checkbox, it will error with an equal join.

Oh yes I have verified the database and it updated just fine.

If I do the left outer join I get the error ""Cannot determine the queries necessary to get the data for this report. Details: query cannot be built for this report.

Did you try resetting the SQL QUery?

Is the UDF in your selection criteria? Could you simply suppress the appropriate section if it is selected instead of having it in the record selection?

Beth - thanks for the Reset on the SQL Query - I forgot about looking at that. That is the tip that makes this work!! Merry Christmas to me -- and you too!! :)

YAY! Used to see that on the PO form a lot, IIRC.