E9 Report Blank Title 100402

Thanks for the suggestions, I got it to work :)




From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Len Hartka
Sent: Wednesday, May 11, 2011 12:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9 Report



Good Day Sylvia:

Epicor 9 has a PartQty file; but it may not exist in V8.


len.hartka@...<mailto:len.hartka%40sunautomation.com>

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of sh412cme
Sent: Wednesday, May 11, 2011 8:48 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] E9 Report

Good morning:
I am trying to create a BAQ which gives me the quantity on hand for a
part, the total of all sales orders against it, the ROP and then the
total quantity on order for that part from all vendors. I don't seem to
be able to find a field that gives me the total quantity on order for a
part in inventory.
Can someone point me in the correct direction?

thanks in advance.

Sylvia

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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



[Non-text portions of this message have been removed]
Good morning:
I am trying to create a BAQ which gives me the quantity on hand for a part, the total of all sales orders against it, the ROP and then the total quantity on order for that part from all vendors. I don't seem to be able to find a field that gives me the total quantity on order for a part in inventory.
Can someone point me in the correct direction?

thanks in advance.

Sylvia
I believe you'll need to just total up all the open OrderDtl's to get that.

On Wed, May 11, 2011 at 8:47 AM, sh412cme <shunts@...> wrote:

>
>
> Good morning:
> I am trying to create a BAQ which gives me the quantity on hand for a part,
> the total of all sales orders against it, the ROP and then the total
> quantity on order for that part from all vendors. I don't seem to be able to
> find a field that gives me the total quantity on order for a part in
> inventory.
> Can someone point me in the correct direction?
>
> thanks in advance.
>
> Sylvia
>
>
>


[Non-text portions of this message have been removed]
Good Day Sylvia:

Epicor 9 has a PartQty file; but it may not exist in V8.


len.hartka@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sh412cme
Sent: Wednesday, May 11, 2011 8:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E9 Report




Good morning:
I am trying to create a BAQ which gives me the quantity on hand for a
part, the total of all sales orders against it, the ROP and then the
total quantity on order for that part from all vendors. I don't seem to
be able to find a field that gives me the total quantity on order for a
part in inventory.
Can someone point me in the correct direction?

thanks in advance.

Sylvia






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


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