Hi!
I am currently having an issue with a BAQ, we are currently implementing Epicor and I created a BAQ that was working and returning all data, and we had to do a refresh and not it returns 0 rows but syntax is okay.
Does anybody know how to fix it? I don’t want to create the BAQ again.
Thanks,
Sofia
What does this mean? You restored the database from a copy? (That’s how I use that term.) And you exported and reimported the BAQ?
Also, welcome to the group - I think. Usually there’s a banner on your first post. I don’t see one but I think this is the first one you’ve made.
Are you new to Epicor? Just curious and want to offer sympathy lol. It’s quite the learning curve.
I am sure lots of folks on here can help. But we need to see that BAQ. We can’t tell why it doesn’t work without seeing the query. The SQL is nice, but a few screenshots speak volumes.
Hi Jason! Thanks! Yes, new to Epicor, working on implementing it in the company I work for. As far as the refresh, yes before we go live we have our test environment, and we refresh that one and copy all the information we have in our Pilot environment.
I did export the BAQ before the refresh and re-imported it after.
I mean this in a nice way, but get used to making BAQs a lot! I have been using Epicor for 8 years and I still make at least 1 BAQ every single day. No harm in starting over on one.
So, you have a lot of inner joins there (the 
join).
Your BAQ is saying, “Only give me parts that have an approved manufacturer AND a part class.” (Both true, not either/or.) Is that what you want?
Also, what is the criteria on the Part table?
Jason,
Thanks for your response, I was out for a couple weeks. I did figure out what was going on, I was trying to get the Qualified Manufacturer, but that information did not come over after the refresh, so after uploading those, it worked.
Thanks!!
