BAQ Question Blank Title 98269

Yahoo Archive
1
Hi All,
Â
I had the Same Issue, TO Resolve this Export the BAQ in to a CSV File format using Business Activity Quer Export Process ,that how ir retrieves the whole Data..Â
Â
SOme times After the Export you see that all the coloumns are not alligned properly & the Test Breaks into multiple lines, To Resolve this Use the Text Limitation for the Description Field in the BAQ to display only 50 charecters.
Â
Hope this Helps.
Â
Thanks,
Doma Reddy.


--- On Tue, 3/29/11, Chris Thompson <chriselectrix@...> wrote:


From: Chris Thompson <chriselectrix@...>
Subject: Re: [Vantage] BAQ Question
To: vantage@yahoogroups.com
Date: Tuesday, March 29, 2011, 8:06 AM


Â



We are on 9.04.505C and progress 10.1c.

Any help would be massively appreciated as its annoying (especially since there
appears to be nothing wrong with the BAQ).

________________________________
From: "effgroups@..." <effgroups@...>
To: vantage@yahoogroups.com
Sent: Tue, 29 March, 2011 13:59:21
Subject: Re: [Vantage] BAQ Question

I have the same issue with a BAQ to retrieve all quotesmtl linked to the sales
order.

I guess if the dataset gets too big it crashes.

If anyone has a idea how to prevent this it will be greatly appreciated.

We are on epicor 9.04.507A and progress 10.1c.

Ephraim Feldman
Programmer / Analyst
Axis Lighting

-----Original Message-----
From: Chris Thompson <chriselectrix@...>
Sender: vantage@yahoogroups.com
Date: Tue, 29 Mar 2011 13:36:10
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Question

Hi All

I have created a BAQ which works beautifully. It shows all JobMtl.PartNum
required for each parent job (JobMtl.JobNum) and displays if there any jobs or
purchase orders for these 'sub-assemblies'.

for each JobMtl no-lock where JobMtl.JobNum = '011746' , each Part no-lockÂ
where (JobMtl.Company = Part.Company and JobMtl.PartNum = Part.PartNum ) ,Â
each PartWhse no-lock outer-join where (Part.Company = PartWhse.Company and
Part.PartNum = PartWhse.PartNum ) , each JobHead no-lock whereÂ
ISNULL(JobHead.JobComplete)Or (JobHead.JobComplete = FALSE And JobHead.JobNum <
'a' ) , each JobOper no-lock where JobOper.OpComplete = FALSE outer-join andÂ

(JobHead.Company = JobOper.Company and JobHead.JobNum = JobOper.JobNum ) , each

PODetail no-lock where PODetail.OpenLine = TRUE , each POHeader no-lockÂ
where POHeader.OpenOrder = TRUE outer-join and (PODetail.Company =
POHeader.Company and PODetail.PONUM = POHeader.PONum ) , each Vendor no-lock
outer-join where (POHeader.Company = Vendor.Company and POHeader.VendorNum =
Vendor.VendorNum )outer-join and (Part.Company = JobHead.Company and
Part.PartNum = JobHead.PartNum )outer-join and (Part.Company = PODetail.Company

and Part.PartNum = PODetail.PartNum ).

However, if I filter the BAQ as above (JobMtl.JobNum='011746') it works
perfectly and returns the results in a reasonable time.

If I leave the criteria off, the BAQ crashes.

I know there is a lot of information that needs to be retrieved, but it should
still work shouldnt it?

  Â

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.%c2%a0

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]











[Non-text portions of this message have been removed]
2
Hi All

I have the following BAQ setup which works well.

However it only shows Jobs for parts on order lines.

I want it to show all jobs even if they arent on orders (i.e. could be sub
assembly parts that dont get sold but do go into things).

for each OrderHed no-lock where OrderHed.OpenOrder = TrueÂ
OrderHed.RequestDate <= add-interval (now, 7, 'days') , each OrderDtl no-lockÂ
where (OrderHed.Company = OrderDtl.Company and OrderHed.OrderNum =
OrderDtl.OrderNum ) , each Part no-lock where (OrderDtl.Company =
Part.Company and OrderDtl.PartNum = Part.PartNum ) , each PartWhse no-lockÂ
where (Part.Company = PartWhse.Company and Part.PartNum = PartWhse.PartNum ) ,Â
each JobHead no-lock where JobHead.JobComplete = FALSE And JobHead.JobNum <
'U' , first JobOper no-lock where JobOper.OpComplete = FALSE andÂ
(JobHead.Company = JobOper.Company and JobHead.JobNum = JobOper.JobNum ) , each
Customer no-lock , each JobMtl no-lock where (Part.Company = JobHead.Company
and Part.PartNum = JobHead.PartNum ) and (OrderHed.Company = Customer.Company
and OrderHed.CustNum = Customer.CustNum ) and (JobHead.Company = JobMtl.Company
and JobHead.JobNum = JobMtl.JobNum ) by OrderHed.RequestDate .

Any suggestions?

Thanks,




[Non-text portions of this message have been removed]
3
Unfortunately I am not the greatest at reading SQL code. As for the fix is you need an outer join to OrderHed.

Looking through the code you may need to start over with JobHead and then work your way back to OrderHed. You are building the entire query from OrderHed currently and to get this to show up correctly it needs to start from JobHead and then have the outer join to OrderHed where needed.

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and experienced industry experts.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Wednesday, March 02, 2011 10:12 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Question



Hi All

I have the following BAQ setup which works well.

However it only shows Jobs for parts on order lines.

I want it to show all jobs even if they arent on orders (i.e. could be sub
assembly parts that dont get sold but do go into things).

for each OrderHed no-lock where OrderHed.OpenOrder = True
OrderHed.RequestDate <= add-interval (now, 7, 'days') , each OrderDtl no-lock
where (OrderHed.Company = OrderDtl.Company and OrderHed.OrderNum =
OrderDtl.OrderNum ) , each Part no-lock where (OrderDtl.Company =
Part.Company and OrderDtl.PartNum = Part.PartNum ) , each PartWhse no-lock
where (Part.Company = PartWhse.Company and Part.PartNum = PartWhse.PartNum ) ,
each JobHead no-lock where JobHead.JobComplete = FALSE And JobHead.JobNum <
'U' , first JobOper no-lock where JobOper.OpComplete = FALSE and
(JobHead.Company = JobOper.Company and JobHead.JobNum = JobOper.JobNum ) , each
Customer no-lock , each JobMtl no-lock where (Part.Company = JobHead.Company
and Part.PartNum = JobHead.PartNum ) and (OrderHed.Company = Customer.Company
and OrderHed.CustNum = Customer.CustNum ) and (JobHead.Company = JobMtl.Company
and JobHead.JobNum = JobMtl.JobNum ) by OrderHed.RequestDate .

Any suggestions?

Thanks,

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
4
Hi All

I have created a BAQ which works beautifully. It shows all JobMtl.PartNum
required for each parent job (JobMtl.JobNum) and displays if there any jobs or
purchase orders for these 'sub-assemblies'.

for each JobMtl no-lock where JobMtl.JobNum = '011746' , each Part no-lockÂ
where (JobMtl.Company = Part.Company and JobMtl.PartNum = Part.PartNum ) ,Â
each PartWhse no-lock outer-join where (Part.Company = PartWhse.Company and
Part.PartNum = PartWhse.PartNum ) , each JobHead no-lock whereÂ
ISNULL(JobHead.JobComplete)Or (JobHead.JobComplete = FALSE And JobHead.JobNum <
'a' ) , each JobOper no-lock where JobOper.OpComplete = FALSE outer-join andÂ
(JobHead.Company = JobOper.Company and JobHead.JobNum = JobOper.JobNum ) , each
PODetail no-lock where PODetail.OpenLine = TRUE , each POHeader no-lockÂ
where POHeader.OpenOrder = TRUE outer-join and (PODetail.Company =
POHeader.Company and PODetail.PONUM = POHeader.PONum ) , each Vendor no-lock
outer-join where (POHeader.Company = Vendor.Company and POHeader.VendorNum =
Vendor.VendorNum )outer-join and (Part.Company = JobHead.Company and
Part.PartNum = JobHead.PartNum )outer-join and (Part.Company = PODetail.Company
and Part.PartNum = PODetail.PartNum ).

However, if I filter the BAQ as above (JobMtl.JobNum='011746') it works
perfectly and returns the results in a reasonable time.

If I leave the criteria off, the BAQ crashes.

I know there is a lot of information that needs to be retrieved, but it should
still work shouldnt it?




[Non-text portions of this message have been removed]
5
I have the same issue with a BAQ to retrieve all quotesmtl linked to the sales order.

I guess if the dataset gets too big it crashes.

If anyone has a idea how to prevent this it will be greatly appreciated.

We are on epicor 9.04.507A and progress 10.1c.


Ephraim Feldman
Programmer / Analyst
Axis Lighting

-----Original Message-----
From: Chris Thompson <chriselectrix@...>
Sender: vantage@yahoogroups.com
Date: Tue, 29 Mar 2011 13:36:10
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Question

Hi All

I have created a BAQ which works beautifully. It shows all JobMtl.PartNum
required for each parent job (JobMtl.JobNum) and displays if there any jobs or
purchase orders for these 'sub-assemblies'.

for each JobMtl no-lock� where� JobMtl.JobNum = '011746'� ,� each Part no-lock�
where� (JobMtl.Company = Part.Company and JobMtl.PartNum = Part.PartNum ) ,�
each PartWhse no-lock outer-join where� (Part.Company = PartWhse.Company and
Part.PartNum = PartWhse.PartNum ) ,� each JobHead no-lock� where�
ISNULL(JobHead.JobComplete)Or (JobHead.JobComplete = FALSE And JobHead.JobNum <
'a' ) ,� each JobOper no-lock� where� JobOper.OpComplete = FALSE outer-join and�
(JobHead.Company = JobOper.Company and JobHead.JobNum = JobOper.JobNum ) ,� each
PODetail no-lock� where� PODetail.OpenLine = TRUE� ,� each POHeader no-lock�
where� POHeader.OpenOrder = TRUE outer-join and� (PODetail.Company =
POHeader.Company and PODetail.PONUM = POHeader.PONum ) ,� each Vendor no-lock
outer-join where� (POHeader.Company = Vendor.Company and POHeader.VendorNum =
Vendor.VendorNum )outer-join and� (Part.Company = JobHead.Company and
Part.PartNum = JobHead.PartNum )outer-join and� (Part.Company = PODetail.Company
and Part.PartNum = PODetail.PartNum ).

However, if I filter the BAQ as above (JobMtl.JobNum='011746') it works
perfectly and returns the results in a reasonable time.

If I leave the criteria off, the BAQ crashes.

I know there is a lot of information that needs to be retrieved, but it should
still work shouldnt it?




[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
6
We are on 9.04.505C and progress 10.1c.

Any help would be massively appreciated as its annoying (especially since there
appears to be nothing wrong with the BAQ).




________________________________
From: "effgroups@..." <effgroups@...>
To: vantage@yahoogroups.com
Sent: Tue, 29 March, 2011 13:59:21
Subject: Re: [Vantage] BAQ Question

I have the same issue with a BAQ to retrieve all quotesmtl linked to the sales
order.


I guess if the dataset gets too big it crashes.

If anyone has a idea how to prevent this it will be greatly appreciated.

We are on epicor 9.04.507A and progress 10.1c.


Ephraim Feldman
Programmer / Analyst
Axis Lighting

-----Original Message-----
From: Chris Thompson <chriselectrix@...>
Sender: vantage@yahoogroups.com
Date: Tue, 29 Mar 2011 13:36:10
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Question

Hi All

I have created a BAQ which works beautifully. It shows all JobMtl.PartNum
required for each parent job (JobMtl.JobNum) and displays if there any jobs or
purchase orders for these 'sub-assemblies'.

for each JobMtl no-lock where JobMtl.JobNum = '011746' , each Part no-lockÂ
where (JobMtl.Company = Part.Company and JobMtl.PartNum = Part.PartNum ) ,Â
each PartWhse no-lock outer-join where (Part.Company = PartWhse.Company and
Part.PartNum = PartWhse.PartNum ) , each JobHead no-lock whereÂ
ISNULL(JobHead.JobComplete)Or (JobHead.JobComplete = FALSE And JobHead.JobNum <
'a' ) , each JobOper no-lock where JobOper.OpComplete = FALSE outer-join andÂ

(JobHead.Company = JobOper.Company and JobHead.JobNum = JobOper.JobNum ) , each

PODetail no-lock where PODetail.OpenLine = TRUE , each POHeader no-lockÂ
where POHeader.OpenOrder = TRUE outer-join and (PODetail.Company =
POHeader.Company and PODetail.PONUM = POHeader.PONum ) , each Vendor no-lock
outer-join where (POHeader.Company = Vendor.Company and POHeader.VendorNum =
Vendor.VendorNum )outer-join and (Part.Company = JobHead.Company and
Part.PartNum = JobHead.PartNum )outer-join and (Part.Company = PODetail.Company

and Part.PartNum = PODetail.PartNum ).

However, if I filter the BAQ as above (JobMtl.JobNum='011746') it works
perfectly and returns the results in a reasonable time.

If I leave the criteria off, the BAQ crashes.

I know there is a lot of information that needs to be retrieved, but it should
still work shouldnt it?


  Â

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.%c2%a0

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links






[Non-text portions of this message have been removed]