Trying to create simple baq for employee check detail

Yahoo Archive
1
I was impatient.
Thanx


Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska@...>



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

Jumped the gun on this one. I said I was okay. But im not.

Heres what I got.

Selected tables
PREmpMas
PRChkDtl

Table Relations

Each prempmas(parent) empid (keyid) prchkdtl (child)

Field relations

Company company
Emplink emplink

Sure enough the query just hangs. Did a selection for checks dated >= 07/01/2013 as to narrow down and test results
As a refresher im simply trying to create an executive format for payroll check register. (i.e. employee xxx check # xxxx amount $ xxxxx

Its quite obvious that im linking soething wrong. Whats bothering me is ive done baq with a heck of a lot more tables then this and had no problems linking. This on on the other hand is driving me insane.

Thanks for any help.

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska@...>



[Non-text portions of this message have been removed]
3
Start simpler...Just use one of the tables to get the data >=07/01/2013...Then, once you have that data verify the values for a couple of records for the fields that you want to link (Company and emplink).
Try another BAQ with the second table data >=07/01/2013 and company = value from first BAQ and emplink = value from first BAQ - see if you hang or not...

Also, look at the data dictionary for the two tables to see what are the key indexes...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Trzaska, Mark
Sent: Wednesday, July 24, 2013 9:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: trying to create simple baq for employee check detail



Well,

Jumped the gun on this one. I said I was okay. But im not.

Heres what I got.

Selected tables
PREmpMas
PRChkDtl

Table Relations

Each prempmas(parent) empid (keyid) prchkdtl (child)

Field relations

Company company
Emplink emplink

Sure enough the query just hangs. Did a selection for checks dated >= 07/01/2013 as to narrow down and test results
As a refresher im simply trying to create an executive format for payroll check register. (i.e. employee xxx check # xxxx amount $ xxxxx

Its quite obvious that im linking soething wrong. Whats bothering me is ive done baq with a heck of a lot more tables then this and had no problems linking. This on on the other hand is driving me insane.

Thanks for any help.

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com>>

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



[Non-text portions of this message have been removed]
4
I was able to get the BAQ to work just the way you have it set up (both in Vantage 8.03.409A and Epicor 9.05.702) although it did seem a little slow. You might want to try adding the PRCheck table (PREmpMas>PRCheck>PRChkDtl making sure to use EmpLink instead of EmpID) to see if that helps performance. I think it follows more of a "natural" path and may be more efficient.

Sue

--- In vantage@yahoogroups.com, "Trzaska, Mark" <mtrzaska@...> wrote:
>
> Well,
>
> Jumped the gun on this one. I said I was okay. But im not.
>
> Heres what I got.
>
> Selected tables
> PREmpMas
> PRChkDtl
>
> Table Relations
>
> Each prempmas(parent) empid (keyid) prchkdtl (child)
>
> Field relations
>
> Company company
> Emplink emplink
>
> Sure enough the query just hangs. Did a selection for checks dated >= 07/01/2013 as to narrow down and test results
> As a refresher im simply trying to create an executive format for payroll check register. (i.e. employee xxx check # xxxx amount $ xxxxx
>
> Its quite obvious that im linking soething wrong. Whats bothering me is ive done baq with a heck of a lot more tables then this and had no problems linking. This on on the other hand is driving me insane.
>
> Thanks for any help.
>
> Mark Trzaska
> Administrator
> Stanley Machining & Tool Corp.
> 425 Maple Avenue
> Carpentersville, IL 60110
> Phone (847) 426-4560
> Fax (847) 426-6951
> e-mail Mtrzaska@...<mailto:Mtrzaska@...>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Lol . Question; when you were able to duplicate it did it take 1 minute, 5 minutes. Im waiting maybe 2 minutes then just killing it. Just wondering if I'm impatient or it just takes that long.

Thanx


Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska@...>



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