x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 105 subscribers
  • Views 1035 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
92
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
963
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
RoadRacer

How to get BOM "Where Used" value to appear on corresponding CI_Item inquiry screen?

SOLVED
Posted By

I have a request from our buyers to have the BOM "Where Used" values for items in CI_Items appear on their corresponding I/M Item Inquiry screens. We have BOMs configured in Bill of Materials for items we are going to assemble as kits. All of the component parts are procurement type "Buy." So, the buyers would like to be able to see which kit(s) a component is used in when looking at the Item Inquiry screen for that component.

When I try to add this to the Addtional panel in Customizer, I cannot navigate to the BOM files. Is there a way to accomplish this? Thank you.

Doug

  • +1
    verified answer

    You'd need an enhancement or script for this.  You can link fields only when the other table has one unique value per item.

  • +1
    verified answer

    Your problem in the in the Item Inquiry screen you can display a single value in a column for BOMs so if the item is in multiple BOMs you would not be able to display them all, just one. 

  • 0

    I think the best way to handle this would be to use a button script and have it get a handle to the BM_BillWhereUsedInquiry_UI class then use its Process method and pass the current item code as the first argument.  This will open the task with the item already selected.

    The other option would be to create a UDF capable of holding a lot of characters, such as 4096, add it to a new custom panel and use a script to use the BM_WhereUsedCommon class and its FindWhereUsed method but this is trickier as you have to read the providex file channel returned by the fourth argument.  If you can successfully parse it, you could then display the values in the UDF.

*Community Hub is the new name for Sage City