Simple BAQ assistance

The problem is that we bill on production and when it is shipped (physically) there is another, $0 invoice, created. Also the same lot has 2 different everything--sales orders, lot numbers (the physical has a # after it), PO numbers... and they aren't linked by any common field that I can find. I did however figure out a way to at least arrange the data that is useful enough for the project. Thanks....

--- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@...> wrote:
>
> I would think using the Invoice Header, Invoice Detail and Ship Header and Ship Detail should get you the information (your lots are on the shipments - correct?)
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jb_in_wi
> Sent: Wednesday, December 19, 2012 8:32 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Simple BAQ assistance
>
>
>
> I'm not a programmer, but can do simple BAQ's, or so I thought. I'm trying to run a BAQ that will tell me what invoice is associated with each lot number, but I haven't been able to find the correct way to link the tables they are in...anyone have a suggestion--or better yet, an answer? Would be appreciated.
> 9.04.506c
>
>
>
> [Non-text portions of this message have been removed]
>
I'm not a programmer, but can do simple BAQ's, or so I thought. I'm trying to run a BAQ that will tell me what invoice is associated with each lot number, but I haven't been able to find the correct way to link the tables they are in...anyone have a suggestion--or better yet, an answer? Would be appreciated.
9.04.506c
I would think using the Invoice Header, Invoice Detail and Ship Header and Ship Detail should get you the information (your lots are on the shipments - correct?)

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jb_in_wi
Sent: Wednesday, December 19, 2012 8:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Simple BAQ assistance



I'm not a programmer, but can do simple BAQ's, or so I thought. I'm trying to run a BAQ that will tell me what invoice is associated with each lot number, but I haven't been able to find the correct way to link the tables they are in...anyone have a suggestion--or better yet, an answer? Would be appreciated.
9.04.506c



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

We've done something similar here.

I'll send you screenshots of the BAQ to your email.



Regards,



Chris Wineinger

ERP Specialist

Interior Systems, Inc. <http://www.isiamerica.com/>

241 N Broadway Ste 600

Milwaukee, WI 53202

Office # 414.224.0957 X2051

Direct# 414.847.0701

Cell # 414.840.6594





[Non-text portions of this message have been removed]
It was jb_in_wi who posted the question, so please reply to him.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Wineinger
Sent: Wednesday, December 19, 2012 1:40 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Simple BAQ assistance



Karen,

We've done something similar here.

I'll send you screenshots of the BAQ to your email.

Regards,

Chris Wineinger

ERP Specialist

Interior Systems, Inc. <http://www.isiamerica.com/>

241 N Broadway Ste 600

Milwaukee, WI 53202

Office # 414.224.0957 X2051

Direct# 414.847.0701

Cell # 414.840.6594

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



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