BAQ Missing Data

Where are you using the BAQ? Dashboard, BAQ Report, etc.

There are a few tricks that can be used such as ENTRY(1,OrderHed.SalesRepList,"~~") but they cannot be used at the BAQ level to perform table joins - you'll have to tweak the Dashboard or BAQ Report a bit once you modify the BAQ.

NB

--- In vantage@yahoogroups.com, "jplehr" <jlehr@...> wrote:
>
> Vantage 8.03.408A
>
> I have a BAQ that is pulling information for booked orders by salesperson and is used monthly to see what sales has done and where they stand against each other and as a total.
>
> The BAQ has been working very well and been in use for a couple of years (modifications along the way). We have never split a order between salespeople. Recently we entered a order, which was split between two salespeople and the information disappeared from my BAQ. I say disappeared because it was listed when assigned to just one salesperson. As soon as the second salesperson was entered the information was not pulled into the BAQ at all.
>
> Can someone help me understand how to get the data into my BAQ. Below is the BAQ...
>
> for each OrderHed no-lock , each OrderDtl where (OrderHed.Company = OrderDtl.Company and OrderHed.OrderNum = OrderDtl.OrderNum) no-lock , each Customer where (OrderHed.Company = Customer.Company and OrderHed.CustNum = Customer.CustNum) no-lock , each ProdGrup outer-join where (OrderDtl.Company = ProdGrup.Company and OrderDtl.ProdCode = ProdGrup.ProdCode) no-lock , each SalesRep where (OrderHed.Company = SalesRep.Company and OrderHed.SalesRepList = SalesRep.SalesRepCode) no-lock .
>
> Thanks,
>
> Jeff
>
Vantage 8.03.408A

I have a BAQ that is pulling information for booked orders by salesperson and is used monthly to see what sales has done and where they stand against each other and as a total.

The BAQ has been working very well and been in use for a couple of years (modifications along the way). We have never split a order between salespeople. Recently we entered a order, which was split between two salespeople and the information disappeared from my BAQ. I say disappeared because it was listed when assigned to just one salesperson. As soon as the second salesperson was entered the information was not pulled into the BAQ at all.

Can someone help me understand how to get the data into my BAQ. Below is the BAQ...

for each OrderHed no-lock , each OrderDtl where (OrderHed.Company = OrderDtl.Company and OrderHed.OrderNum = OrderDtl.OrderNum) no-lock , each Customer where (OrderHed.Company = Customer.Company and OrderHed.CustNum = Customer.CustNum) no-lock , each ProdGrup outer-join where (OrderDtl.Company = ProdGrup.Company and OrderDtl.ProdCode = ProdGrup.ProdCode) no-lock , each SalesRep where (OrderHed.Company = SalesRep.Company and OrderHed.SalesRepList = SalesRep.SalesRepCode) no-lock .

Thanks,

Jeff
The problem is that OrderHed.SalesRepList now has something like this in it:
RepCode1~RepCode2
Which will of course not match any SalesRep.SalesRepCode.

There are only two solutions I can think of. First Is to drop the SalesRep table from your BAQ. The other ( I assume you want the sales rep name) is to create a BPM that will break apart the SalesRepList on creation and look up the information in the SalesRep rep table then drop the information into UD fields in the OrderHed.




________________________________
From: jplehr <jlehr@...>
To: vantage@yahoogroups.com
Sent: Mon, February 22, 2010 1:37:55 PM
Subject: [Vantage] BAQ Missing Data

Â
Vantage 8.03.408A

I have a BAQ that is pulling information for booked orders by salesperson and is used monthly to see what sales has done and where they stand against each other and as a total.

The BAQ has been working very well and been in use for a couple of years (modifications along the way). We have never split a order between salespeople. Recently we entered a order, which was split between two salespeople and the information disappeared from my BAQ. I say disappeared because it was listed when assigned to just one salesperson. As soon as the second salesperson was entered the information was not pulled into the BAQ at all.

Can someone help me understand how to get the data into my BAQ. Below is the BAQ...

for each OrderHed no-lock , each OrderDtl where (OrderHed.Company = OrderDtl.Company and OrderHed.OrderNum = OrderDtl.OrderNum) no-lock , each Customer where (OrderHed.Company = Customer.Company and OrderHed.CustNum = Customer.CustNum) no-lock , each ProdGrup outer-join where (OrderDtl.Company = ProdGrup.Company and OrderDtl.ProdCode = ProdGrup.ProdCode) no-lock , each SalesRep where (OrderHed.Company = SalesRep.Company and OrderHed.SalesRepLi st = SalesRep.SalesRepCo de) no-lock .

Thanks,

Jeff







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

The SalesRep.SalesRepCode and OrderHed.SalesRepList are not the same field; SalesRepList is an array with all your Sales Reps codes (in the Order), divided by a tilde. The fields were matching (and will match) as long as you only have one rep (because the array becomes a single element field w/o a tilde) in the Order. Once you have multiple elements in that field, then they don't match for a link between tables.

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705

[cid:image002.jpg@01CAB3C2.0BDCAF80]

Sabre Industries, Inc. ("Sabre") E-MAIL NOTICE - This transmission and any attachments may be confidential or subject to a legally recognized privilege and is intended only to be received and read by the proper party having a reason to send communications to or from Sabre. If you do not believe that you are the proper recipient of this message because of its address, contents and/or otherwise believe that this message was sent to you in error, you should not disclose, print, copy or disseminate the information contained in this message. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law and state laws.
The text in this communication does not reflect an intention by Sabre to conduct a transaction or make any agreement by electronic means. Only a document which bears a handwritten signature of an authorized signatory of Sabre shall be binding upon Sabre and such documents may be attached indicating a desire to conduct a transaction or make any agreement. Nothing contained in the text of this message shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions or any statutory adoptions or equivalents of the aforementioned acts and convention, and any other laws or regulations of any state or country related to electronic contracts, electronic signatures, or electronic records shall not apply to Sabre or the recipient.




[Non-text portions of this message have been removed]
You're going to have a problem. The OrderHed.SalesRepList is a combination
of up to 5 salespeople each separated by ~.

In the BAQ arena you can't separate these into their individual salespeople
and then join it to another table.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jplehr
Sent: Monday, February 22, 2010 1:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Missing Data





Vantage 8.03.408A

I have a BAQ that is pulling information for booked orders by salesperson
and is used monthly to see what sales has done and where they stand against
each other and as a total.

The BAQ has been working very well and been in use for a couple of years
(modifications along the way). We have never split a order between
salespeople. Recently we entered a order, which was split between two
salespeople and the information disappeared from my BAQ. I say disappeared
because it was listed when assigned to just one salesperson. As soon as the
second salesperson was entered the information was not pulled into the BAQ
at all.

Can someone help me understand how to get the data into my BAQ. Below is the
BAQ...

for each OrderHed no-lock , each OrderDtl where (OrderHed.Company =
OrderDtl.Company and OrderHed.OrderNum = OrderDtl.OrderNum) no-lock , each
Customer where (OrderHed.Company = Customer.Company and OrderHed.CustNum =
Customer.CustNum) no-lock , each ProdGrup outer-join where (OrderDtl.Company
= ProdGrup.Company and OrderDtl.ProdCode = ProdGrup.ProdCode) no-lock , each
SalesRep where (OrderHed.Company = SalesRep.Company and
OrderHed.SalesRepList = SalesRep.SalesRepCode) no-lock .

Thanks,

Jeff





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