Method Master Report

We’re on Kinetic 2025.1, which we recently migrated to. Are you only allowed to run the Method Master Report on a single part now? I know they took away the list view :frowning: . To remedy that, i created a BAQ to look at recently created mfg. parts with approved Revs. I wanted to pull these parts in using the search function in the Method master report (using BAQ search). But when i try to pull in the list of parts after checking then all to be selected, it will not pull in those parts.

You can select multiple parts. Use the check box to select the parts you want. Or type them into the part filter box.

If i type them into the part filter box, then i don’t get to choose the revision. We have multiple revisions on some parts.
If i use the standard search box, then yes, i could select multiple parts but i would have to scroll down the search list and find each part and select it. We have 1000’s of parts, so that is not suitable.
If i do a search for apart and bring it in, then do another search for the next part, then it will overide the 1st part i chose.

My work around was that i created a searchable BAQ as show above. It shows all the parts and approved revs i need. I am able to select them all but it does nothing. It doesn’t bring these parts in.

My biggest complain with Kinetics is they took away the List view. As cost accountant, i look and analyze parts in mass, so the list view was perfect to paste insert the part and revision i wanted to look at and run indended Bill of Operations (Routing) on them. The same goes for Costed BOM. The costed BOM, i could paste insert list of parts into the part filter box, but it brings in the unapproved revisions for some of the parts.

2 Likes

Gah! I missed the rev part of that. Yeah, anytime Epicor needs more than one field in the search I give up. I would love to see the solution too! I tried using the PartRev and ECORev tables, with the same result. it pulls in the filter records as ‘undefined’. :thinking:


Here I replicated your approach and you can see that the ReportParams are being set to undefined~undefined~undefined, instead of the three part/revs I choose from my BAQ.

The issue seems to be passing values to the filter from the BAQ Search. I don’t have a solution, but perhaps this helps someone else.

I am thinking if we can get values into the various areas where it says undefined here, we might get a good result.

1 Like

I can understand all the other fields it lists as undefined, but why ProdQty? Hmmm…

When I pass in parts from my BAQ search, I can see them in searchResult. Now how to get these into the undefined lists…

Just curious, are you analyzing this in application studios? I don’t have access but it looks like programming codes behind the scene.

Yes, also using dev mode (F12) in the browser. There is a post here somewhere with information on how to use it. Like Ctrl+Alt+8 to turn on debug, and Ctrl+Alt+V to see the dataviews.

1 Like

I’m not strong on the search architecture (seems over-engineered) but…

You can paste a list of PartNums into the search chip selector (right-click-paste)

Not sure how it’ll pick the RevNums in that case. probably all revs matching the search-show validationFilter

Regarding BAQ search: there is an event on the App that contains a search-show followed by search-value-set actions which set the 5 ReportParams from actionResult (why not from searchResult? :man_shrugging: )

I believe the problem with the BAQ search may be that the field names in the setters don’t align with those the BAQ due to Table_FieldName format in BAQ columns

For example, if you copy/override the event and change the search-value-set from actionResult.PartNum to actionResult.Part_PartNum, you get the list rather than undefined in ReportParams

However, now standard search is broken so I suspect BAQ search is meant to work without this change but :man_shrugging: - refer to first sentence :backhand_index_pointing_up:

Furthermore, this is a Part.PartNum search type. Seems revnum is inconsistent when pasting but somehow consistent when picking from basic search. not really sure how it could be consistent when you have many approved revs in a part and your search only validates by PartNum. Shouldn’t this report have a multikey search? Like maybe a selector for Part one for Rev like JobTrav has JobNum/AsmSeq. :man_shrugging:

I know, clear as mud, but at least you now know partly why you’re getting ‘undefined’ and perhaps those with more search knowledge can explain BAQ multikey search & validation further.

I’d probably add a new search chip selector (or two) to the app and copy/tweak events to make it work for BAQ searching, leaving the built-in search as is. Good luck.

EDIT: there is some sort of multikey BAQ column mapping in search-value-set but it may be broken. See: Search-value-set when using BAQ search type - #17 by hmwillett

2 Likes

When I paste insert a list of parts (around 5 parts) into the search, I get an error for Method Master Report:

The BOM cost report atleast let me paste insert and run the report but returns Costed BOM for unapproved Revs. for some of the parts.

I’ve never seen this screen before, but I read over the post and tried to follow and replicate.

Yeah, wow, this is pretty useless unless you have a single part (or the ones you need just happen to be at the top of the list!).

I’m on 2024.2. I think it’s the same issues as you see on 2025.x.

Some broad thoughts though:

  1. You can filter the grid, e.g. on “Approved = true” or “Part begins with 94” etc.
    a. Maybe you can drill to what you need within a few scrolls and then select the needed items.
  2. The first pic shows I cannot filter by (Part) description. But…
  3. If you “download” some (all) of the records, you can then filter on description - for the records that have been downloaded.
  4. You can change the “options” for how many to download at once.
  5. [Edit] Also, you can personalize the columns of the search and maybe there is one in there that will help you filter to what you need.

2 Likes

If you dig in, I think you’ll find there are some Revs with blank AltMethod which causes that ReportParm to have fewer list items than the others.

The way they are setting the ReportParams from actionResult doesn’t handle this well.

It could probably be handled with a new search chip selector and some event mods, but what they have is very loose for multi-select and even looser for paste insert.