In the help file, in the tools user guide, there are some BAQ case studies. Like @dcamlin mentioned, BOM queries are some of the most complicated ones that you can do. However, there is a guide that walks you through step by step making one. I would definitely work through each of those case studies and you’ll be on your way learning how to do BAQs.
When you get off book, knowing which tables to use takes some experience. Here is where field help is your friend, because you can see (mostly) where epicor is getting it’s data from.
I will pre-emptively call out that ECO tables are temp tables, and shouldn’t be used for BOM reports. Use the PartMtl, PartOP, PartRev etc. to get that data.
If you get stuck, feel free to come back and ask questions, there are lots of people willing to help.
You asked for tips for using the forum, we have template for just that that I’ve inserted below. But I think you’ve already got the idea.
To help the community provide the best answer, could you include as much of the information below as you can? Your question appears to be lacking some much needed context
- Epicor Version
- Deployment Type (Cloud, On Prem, 3rd Party Cloud etc)
- The business problem you’re trying to solve
- What you’ve already tried
- Is this a Kinetic UX (Web) or Epicor Classic issue?
- Is it related to a Method Directive, Data Directive, Function, BAQ, UBAQ, Configurator, etc.?
- Any screenshots, error messages, or logs.
- Any code you’ve written (or borrowed , make sure it is property formatted)
```
code here
``` - Steps to reproduce the issue
For tips on how to ask questions effectively, check out this guide:
Tips for Asking Questions on the Forum
