Having Trouble Exporting BAQ from E9 into E10

Epicor ERP 10
,
1

I am working with a coworker in another state that has a dashboard that i need. Problem is our offices have different Epicor versions. When he goes to export the specific BAQ, nothing happens. It doesn’t ask him where to save it, or anything at all. Is there a way to export in E9 that im not aware of?

He sent me his Query Phrase but i cant decipher it enough to know what criteria or relations he may have as well as the updateable settings he has chosen. Ill include this at the bottom of the post if anyone is THAT good with BAQ (i know youre out there). Ill also attach his Phrase build.

And finally, From E9 to E10, where has RevDtl gone from the BAQ table list? its in the bottom of his build but not on my E10 system.

Thank you in advanced and let me know if you need any further information.

a
a.png1960×1308 271 KB

Req BAQ from Denison.txt (558 Bytes)

2

To Export A BAQ in E9. Open the BAQ and from the Action Menu select Export BAQ

image
image.png863×664 21.2 KB

You are prompted to Export to File. Enter file path
image

Then click Export
image

3

right that’s what i instructed him to do but when he clicks export baq in the actions dropdown hes presented with nothing. hes tried on the system account as well as his own.

4

Is that C: drive in the “Export to File” location with respect to the client machine or the app server?

5

The Client. The file showed up on my desktop.

1 Like
6

Just an FYI. I don’t find the RevDtl in E9.05.607b either. Not sure what table that is.

7

That’s the RcvDtl

Receiving Detail. Contains the detail line items of a vendor’s packing slip.
DELETE: Not allowed if Invoiced = Yes.

1 Like
8

Oops, I was going off @Joe_Tahan description ‘RevDtl’ . RcvDtl is available in both E9 and E10.
Thanks

9

yeah … I should have replied to @Joe_Tahan

1 Like
10

Appreciate the update! ill add that into the baq. was a little hard to read that screenshot text!

Any idea as to what conditions or relations need to be met from the text attached to the original post?

11

You mean the table relationships?

Looks fairly straightforward

for each ReqHead no-lock , 
each ReqDetail no-lock 
where 
  (ReqHead.Company = ReqDetail.Company 
   and ReqHead.ReqNum = ReqDetail.ReqNum ) ,
each Vendor no-lock where 
(ReqDetail.Company = Vendor.Company 
 and ReqDetail.VendorNum = Vendor.VendorNum ) , 
each PODetail no-lock,
each RcvDtl no-lock 
outer-join where 
  (PODetail.Company = RcvDtl.Company
 and PODetail.PONUM = RcvDtl.PONum 
 and PODetail.POLine = RcvDtl.POLine ) 
outer-join where 
 (ReqDetail.Company = PODetail.Company 
 and ReqDetail.PONUM = PODetail.PONUM 
 and ReqDetail.POLine = PODetail.POLine ).