Skip to Content
Former Member
Apr 08, 2008 at 04:28 PM

Formatted Search on Order Grid with Bill of Materials templates


This is for 2005A SP01 PL45 (latest patch as of now).

We have a few formatted searches on the order details that trigger automatically when the item code changes.

These queries work fine if the items are not part of a bill of materials.

The queries trigger ok when we use the regular item codes for regular customers when monitoring the item code column.

However, if you have a BP Catalog customer with a BOM then only the last row of the bill of materials fires and the rest of them do not.

I tried bypassing this problem by making the queries monitor the Item Description.

This still worked for stand alone items, but didn't work for bill of materials in either of the case.

Bottom line:

A. Formatted searched fire ok on either item code or item description if items are not part of a bill of materials.

B. When they are part of a BOM, then

- if we monitor the item code then they trigger ok for regular customers but only trigger on the last row if using BP Catalog codes;

- if we monitor the item description then they do not trigger at all for either of the customers.

Any suggestion on how to handle formatted searches for Bill of Material Templates with BP Catalogs?

Thank you!