I am trying to customize the MES Handheld screen under inventory adjustment. I currently already have 1 customization that I have added so that the user can see OnhandQty. They have now requested to have the allocated qty for the current part also added so they do not miscalculate the qty. This field is currently unavailable from the current tables, so what would the be the best way to access this information? The tables do not seem to have any UD fields so copying it via BPM would not work, and I can not seem to get the Foreign Key View to work.

Popular White Paper On This Topic

You can hook up a getbyid onto an event such as the on leave for the part number control or on field change for the field connected to the part number control. You can probably use the part tracker adapter and there may be a few others that have the information you need. The getbyid will get much more than you need but in one of the tables will be the values you are looking for. inside of the part tracker may be a more focused method that gets the qty for the warehouse or bin of interest, not in a system at the moment to review the methods.

Slight chance the search method on the adapter will return the information you need, advantage on the search is the E9 wizard will build just about all for you. The wizard will also help with connecting to the adapter BO, you will need to take the rest of the way though.

I have just realized that I need the Demand field, not the allocated field as we currently do not use this feature. This is not in any of the adapters that I have checked. I also do not know much coding so straight out writing the code for the first idea is a bit far fetched with my current skill set.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.