Skip to Content
author's profile photo Former Member
Former Member

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!

Liviu

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 08, 2008 at 04:31 PM

    Could you send the formatted search SQL for me to look

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Well, it is a Bill Of Materials "Template" type...

      Go to Production, Bill of Materials, select a product, quantity 1, select the BOM Type as Template and add two other items underneath it, each with quantities of 1.

      Save.

      Go to BP Catalogs, select one BP and add some names for these three items. Check the box to use BP Catalogs for that BP.

      Go to sales orders, add the query above to the free text column, set it as per the scenarios to trigger automatically on Item Code.

      Start two sales orders for this BP and for a regular one.

      Load the BOM item and observe the formatted search results.

      Repeat for the second scenario (where the formatted search triggers on the item description).

      Hope this helps.

      Thank you!

      Liviu

  • author's profile photo Former Member
    Former Member
    Posted on Apr 09, 2008 at 05:13 PM

    I tried to set the Auto Refresh on Total (LC) column and it seemed to work for both BP Catalog and Non BP Catalog Items.

    Please check and let me know

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.