Hi,
I experienced this sort of thing once when I had a left join in the BAQ. I
entered a criteria into the left joined table and it brought back multiple
values (different from the criteria I entered).
I changed the left to an inner and it worked as I expected.
Are you able to provide a screenshot or more detail regarding the tables and
joins or an export of the BAQ that you've done so I can look at it?
Sean
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
clive.1972
Sent: Monday, March 23, 2009 8:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Unable to create a BAQ/Crystal Report successfully
using the table CASHBHED
I'll wait until tomorrow just incase a kind soul here can help, then I'll
log a support call with Epicor and report back.
Thanks.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"clive.1972" <clive.1972@...> wrote:
Behalf
I experienced this sort of thing once when I had a left join in the BAQ. I
entered a criteria into the left joined table and it brought back multiple
values (different from the criteria I entered).
I changed the left to an inner and it worked as I expected.
Are you able to provide a screenshot or more detail regarding the tables and
joins or an export of the BAQ that you've done so I can look at it?
Sean
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
clive.1972
Sent: Monday, March 23, 2009 8:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Unable to create a BAQ/Crystal Report successfully
using the table CASHBHED
I'll wait until tomorrow just incase a kind soul here can help, then I'll
log a support call with Epicor and report back.
Thanks.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"clive.1972" <clive.1972@...> wrote:
>'3110', and I've an option on BANKSLIP where I've entered the number 7.
> Well, the best I can show you is the XML output from a BAQ Report.
>
> I've filtered on the field BANKACCTID, which in this case uses the value
>!...
> As you can see below the returned XML brings back two different records
>263 is for a totaly different bank account than BANKACCTID 3110 !.
> <BAQReportResult xmlns="http://www.epicor.com/Mfg/100">
> <CashBHed.BankAcctID>3110</CashBHed.BankAcctID>
> <CashBHed.Bankslip>7</CashBHed.Bankslip>
> <CashBHed.CashBookNum>263</CashBHed.CashBookNum>
> <CashBHed.ClosingBalance>24793.76</CashBHed.ClosingBalance>
> <CashBHed.ClosingDate>2008-08-11</CashBHed.ClosingDate>
> <CashBHed.OpeningBalance>16790</CashBHed.OpeningBalance>
> <CashBHed.OpeningDate>2008-06-30</CashBHed.OpeningDate>
> <CashBHed.Posted>true</CashBHed.Posted>
> <CashBHed.GroupID>3110</CashBHed.GroupID>
> <CashBHed.FiscalPeriod>8</CashBHed.FiscalPeriod>
> <CashBHed.FiscalYear>2008</CashBHed.FiscalYear>
> <CashBHed.Description>LM110808</CashBHed.Description>
> <CashBHed.CurrencyCode>BASE</CashBHed.CurrencyCode>
> <CashBHed.Company>MSL68296</CashBHed.Company>
> </BAQReportResult>
> - <BAQReportResult xmlns="http://www.epicor.com/Mfg/100">
> <CashBHed.BankAcctID>3110</CashBHed.BankAcctID>
> <CashBHed.Bankslip>7</CashBHed.Bankslip>
> <CashBHed.CashBookNum>530</CashBHed.CashBookNum>
> <CashBHed.ClosingBalance>10818.5</CashBHed.ClosingBalance>
> <CashBHed.ClosingDate>2009-02-27</CashBHed.ClosingDate>
> <CashBHed.OpeningBalance>11049.74</CashBHed.OpeningBalance>
> <CashBHed.OpeningDate>2009-02-10</CashBHed.OpeningDate>
> <CashBHed.Posted>true</CashBHed.Posted>
> <CashBHed.GroupID>3110</CashBHed.GroupID>
> <CashBHed.FiscalPeriod>3</CashBHed.FiscalPeriod>
> <CashBHed.FiscalYear>2009</CashBHed.FiscalYear>
> <CashBHed.Description>LM270209</CashBHed.Description>
> <CashBHed.CurrencyCode>BASE</CashBHed.CurrencyCode>
> <CashBHed.Company>MSL68296</CashBHed.Company>
> </BAQReportResult>
>
> ... why the heck is it doing this as the first record with the CASHBOOKNUM
>"Christopher Ryhal" <chris.ryhal@> wrote:
> Aaaargh !.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> >[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Sounds like a joining issue with your tables to me or maybe will have to
> > modify the GroupBy information. Would be interested in seeing in
> > action.
> >
> >
> >
> > Christopher Ryhal
> >
> > Senior Microsoft Consultant
> >
> > Perpetual Technologies, Inc
> >
> > chris.ryhal@ <mailto:chris.ryhal@>
> >
> > http://www.perptech.com
> >
> > Office: (317) 824-0393
> >
> > Mobile: (317) 364-2134
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Behalf
> > Of clive.1972[Non-text portions of this message have been removed]
> > Sent: Friday, March 20, 2009 10:39 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Unable to create a BAQ/Crystal Report successfully
> > using the table CASHBHED
> >
> >
> >
> > I'm in the process of attempting to create my own Crystal Report to act
> > as a compliment to the reports provided by the program/screen 'Bank
> > Reconciliation' (Vantage 8.03.406a).
> >
> > Attempt No1 was using a BAQ against the table CASHBHED, then creating a
> > BAQ Report that had a Filter on the field BANKACCTID, and as you cannot
> > filter on it I created an Option against the field BANKSLIP. Now
> > whenever I ran this it allways pulled back ALL records where the
> > BANKSLIP number was the same even though it should be filtered by
> > BANKACCTID :(
> >
> > Attempt No2 was just a Crystal Report (XI) that used parameters against
> > the table CASHBHED, with the parameters attached to the two fields
> > above, and once again the damned thing pulled all records that matched
> > the BANKSLIP field !.
> >
> > I'm at a loss at to why this is happending ?. We do have multiple
> > records in CASHBHED that have the same BANKSLIP number as we have many
> > bank accounts in Vantage, however, I'm also filtering by BANKACCTID so I
> > should only ever get one record but this is not the case.
> >
> > Can anyone help ?.
> >
> > Thanks :)
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>