I have read up on where to run the ABC Codes Listing Report from the ABC Code Maintenance, but I still do not know how to run it. Can anyone help?
Not sure I have heard of that specific report, but what I have done is pull all the ABC Codes into the ABC Module, go to List, and right click at the top and send it to excel.
Hi Chris - I’m actually trying to run a report to see what parts have what ABC code already set. I’m new to this company and some parts have a code and some do not. Not sure who ran the calculate ABC either
Ah ok. Not sure of a report that does that, but you can write a BAQ!
Use the PartWhse table, make the SystemABC criteria <> empty constant
and that will give you your list of ABC Codes that exist on every part
oh cool. I’m going to try that! Thanks for that suggestions!
it gave me the warning about the limited to 10,000 parts. Would there be another criteria I need to help with this?
The reason you are getting a warning about 10k results is because you are running the BAQ in the designer. If you make a dashboard or report out of the BAQ, you will get the full resultset.
Another thing you can do is to go to the Query Execution Settings (under the Actions menu in E10) and set “RemoveTestRowLimit” to True
1 Like
Hi Jason - I’m very inexperienced with BAQ’s and I don’t think I have access to that, or can’t see it.
The report is Calculate ABC Code. You can run it without update. It will give you the existing code and proposed new code.
If you go the BAQ route, you might want to include the Manual ABC code field. The report won’t update an ABC code on the part if the “Manual ABC Code” is checked.
2 Likes
Hi Jenn - thanks for the info and it worked! Thanks again!
1 Like