8.03.408B - BAQ - Calculated Field

system · February 9, 2011, 3:57am

Hi

On 9.04.505C, PartWhse.AllocQty is ALWAYS Zero.

Why is this?

I am trying to write a BAQ which will display any Sales Orders where the
OnHandQty is less than the the required qty of a particular part for an order.

In summary I want a BAQ which will show all open orders wherer they are waiting
for parts being made before they can be shipped/closed.

Any help would be appreciated.

________________________________
From: mattcald_73 <matt@...>
To: vantage@yahoogroups.com
Sent: Tue, 5 October, 2010 15:41:29
Subject: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Â
Do you need what is available in each bin? If not, you can pull both values from
PartWhse. AllocQty and OnhandQty are both found there.

Definitions:
AllocQty - A summary of the outstanding quantities for order open sales releases
that are being filled from stock and of the open job material requirements that
are to be issued from stock (JobMtl.Buyit = No) for this Part within a specific
warehouse. NOTE: This value is the TOTAL of the allocation demands. Calculated
as the sum of SalesAllocQty + SalesReservedQty + SalesPickingQty +
SalesPickedQty + JobAllocQty + JobReservedQty. Note, JobUnFirmAllocQty is not
included. The system calculates Available as OnhandQty - AllocQty.

OnhandQty - A summary of PartBin.OnHandQty for the warehouse where the bin is a
nettable bin (WhseBin.NonNettable = NO). Maintained via the PartBin write
trigger.

system · October 5, 2010, 10:27am

I'm creating a query that shows the "real" available on hand quantity.
We were told by support that in order to get the actual on hand qty you
need to Total up the PartBin.OnHandQty and subtract from that
PartWhse.AllocQty. I want to do this on a calculated field in a query.
I've tried many versions of this and none work properly. For example...
Total (PartBin.OnHandQty - PartWhse.AllocQty) will run but the numbers
don't add up when we check the qty with Vantage. If I try modifying
this code I'll get a sytax error... for example... (Total
(PartBin.OnHandQty)) - PartWhse.AllocQty or ((Total (PartBin.OnHandQty))
- PartWhse.AllocQty) both of these give me a sytax error. Does anyone
have any ideas what I may be doing wrong. Any help would be greatly
appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

system · October 5, 2010, 10:28am

Oddly I am just emailing support about the same thing.

If anyone has any ideas it'd be appreciated.

________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Tue, 5 October, 2010 15:27:20
Subject: [Vantage] 8.03.408B - BAQ - Calculated Field

Â
I'm creating a query that shows the "real" available on hand quantity.
We were told by support that in order to get the actual on hand qty you
need to Total up the PartBin.OnHandQty and subtract from that
PartWhse.AllocQty. I want to do this on a calculated field in a query.
I've tried many versions of this and none work properly. For example...
Total (PartBin.OnHandQty - PartWhse.AllocQty) will run but the numbers
don't add up when we check the qty with Vantage. If I try modifying
this code I'll get a sytax error... for example... (Total
(PartBin.OnHandQty)) - PartWhse.AllocQty or ((Total (PartBin.OnHandQty))
- PartWhse.AllocQty) both of these give me a sytax error. Does anyone
have any ideas what I may be doing wrong. Any help would be greatly
appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

system · October 5, 2010, 10:37am

Have you tried

PartQty.OnHandQty-PartQty.DemandQty ?

________________________________
From: Chris Thompson <chriselectrix@...>
To: vantage@yahoogroups.com
Sent: Tue, 5 October, 2010 15:28:54
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

Â
Oddly I am just emailing support about the same thing.

If anyone has any ideas it'd be appreciated.

________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Tue, 5 October, 2010 15:27:20
Subject: [Vantage] 8.03.408B - BAQ - Calculated Field

Â
I'm creating a query that shows the "real" available on hand quantity.
We were told by support that in order to get the actual on hand qty you
need to Total up the PartBin.OnHandQty and subtract from that
PartWhse.AllocQty. I want to do this on a calculated field in a query.
I've tried many versions of this and none work properly. For example...
Total (PartBin.OnHandQty - PartWhse.AllocQty) will run but the numbers
don't add up when we check the qty with Vantage. If I try modifying
this code I'll get a sytax error... for example... (Total
(PartBin.OnHandQty)) - PartWhse.AllocQty or ((Total (PartBin.OnHandQty))
- PartWhse.AllocQty) both of these give me a sytax error. Does anyone
have any ideas what I may be doing wrong. Any help would be greatly
appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

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

system · October 5, 2010, 10:41am

Are you saying there is a PartQty table? I don't see that in my list of available tables.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Tuesday, October 05, 2010 10:37 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

Have you tried

PartQty.OnHandQty-PartQty.DemandQty ?

________________________________
From: Chris Thompson <chriselectrix@... <mailto:chriselectrix%40ymail.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:28:54
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

Oddly I am just emailing support about the same thing.

If anyone has any ideas it'd be appreciated.

________________________________
From: Blake Clemens <blake.clemens@... <mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:27:20
Subject: [Vantage] 8.03.408B - BAQ - Calculated Field

I'm creating a query that shows the "real" available on hand quantity.
We were told by support that in order to get the actual on hand qty you
need to Total up the PartBin.OnHandQty and subtract from that
PartWhse.AllocQty. I want to do this on a calculated field in a query.
I've tried many versions of this and none work properly. For example...
Total (PartBin.OnHandQty - PartWhse.AllocQty) will run but the numbers
don't add up when we check the qty with Vantage. If I try modifying
this code I'll get a sytax error... for example... (Total
(PartBin.OnHandQty)) - PartWhse.AllocQty or ((Total (PartBin.OnHandQty))
- PartWhse.AllocQty) both of these give me a sytax error. Does anyone
have any ideas what I may be doing wrong. Any help would be greatly
appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

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

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

system · October 5, 2010, 10:41am

Do you need what is available in each bin? If not, you can pull both values from PartWhse. AllocQty and OnhandQty are both found there.

Definitions:
AllocQty - A summary of the outstanding quantities for order open sales releases that are being filled from stock and of the open job material requirements that are to be issued from stock (JobMtl.Buyit = No) for this Part within a specific warehouse. NOTE: This value is the TOTAL of the allocation demands. Calculated as the sum of SalesAllocQty + SalesReservedQty + SalesPickingQty + SalesPickedQty + JobAllocQty + JobReservedQty. Note, JobUnFirmAllocQty is not included. The system calculates Available as OnhandQty - AllocQty.

OnhandQty - A summary of PartBin.OnHandQty for the warehouse where the bin is a nettable bin (WhseBin.NonNettable = NO). Maintained via the PartBin write trigger.

system · October 5, 2010, 11:11am

On hand qty is the field that I was using, but for some reason does not work correctly, very often shows the wrong qty.

I called support and they could not explain why this was not working and they told me that other way that I gave you originally to get total OH.

Maybe it's a data issue not a programming issue? If it's working for others?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mattcald_73
Sent: Tuesday, October 05, 2010 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Do you need what is available in each bin? If not, you can pull both values from PartWhse. AllocQty and OnhandQty are both found there.

Definitions:
AllocQty - A summary of the outstanding quantities for order open sales releases that are being filled from stock and of the open job material requirements that are to be issued from stock (JobMtl.Buyit = No) for this Part within a specific warehouse. NOTE: This value is the TOTAL of the allocation demands. Calculated as the sum of SalesAllocQty + SalesReservedQty + SalesPickingQty + SalesPickedQty + JobAllocQty + JobReservedQty. Note, JobUnFirmAllocQty is not included. The system calculates Available as OnhandQty - AllocQty.

OnhandQty - A summary of PartBin.OnHandQty for the warehouse where the bin is a nettable bin (WhseBin.NonNettable = NO). Maintained via the PartBin write trigger.

system · October 5, 2010, 11:33am

There is in E9 - not sure about your version

________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Tue, 5 October, 2010 15:41:13
Subject: RE: [Vantage] 8.03.408B - BAQ - Calculated Field

Â
Are you saying there is a PartQty table? I don't see that in my list of
available tables.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Thompson
Sent: Tuesday, October 05, 2010 10:37 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

Have you tried

PartQty.OnHandQty-PartQty.DemandQty ?

________________________________
From: Chris Thompson <chriselectrix@... <mailto:chriselectrix%40ymail.com>

To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:28:54
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

Oddly I am just emailing support about the same thing.

If anyone has any ideas it'd be appreciated.

________________________________
From: Blake Clemens <blake.clemens@... <mailto:blake.clemens%40d-m-c.com>

To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:27:20
Subject: [Vantage] 8.03.408B - BAQ - Calculated Field

I'm creating a query that shows the "real" available on hand quantity.
We were told by support that in order to get the actual on hand qty you
need to Total up the PartBin.OnHandQty and subtract from that
PartWhse.AllocQty. I want to do this on a calculated field in a query.
I've tried many versions of this and none work properly. For example...
Total (PartBin.OnHandQty - PartWhse.AllocQty) will run but the numbers
don't add up when we check the qty with Vantage. If I try modifying
this code I'll get a sytax error... for example... (Total
(PartBin.OnHandQty)) - PartWhse.AllocQty or ((Total (PartBin.OnHandQty))
- PartWhse.AllocQty) both of these give me a sytax error. Does anyone
have any ideas what I may be doing wrong. Any help would be greatly
appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

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

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

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

system · October 5, 2010, 11:34am

We have used an OnHandQty field before which also gave the wrong figure when
compared to the onhandqty that you can see throughout Epicor. 90% were right but
the odd one was wrong.

________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Tue, 5 October, 2010 16:10:58
Subject: RE: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Â
On hand qty is the field that I was using, but for some reason does not work
correctly, very often shows the wrong qty.

I called support and they could not explain why this was not working and they
told me that other way that I gave you originally to get total OH.

Maybe it's a data issue not a programming issue? If it's working for others?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
mattcald_73
Sent: Tuesday, October 05, 2010 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Do you need what is available in each bin? If not, you can pull both values from
PartWhse. AllocQty and OnhandQty are both found there.

Definitions:
AllocQty - A summary of the outstanding quantities for order open sales releases
that are being filled from stock and of the open job material requirements that
are to be issued from stock (JobMtl.Buyit = No) for this Part within a specific
warehouse. NOTE: This value is the TOTAL of the allocation demands. Calculated
as the sum of SalesAllocQty + SalesReservedQty + SalesPickingQty +
SalesPickedQty + JobAllocQty + JobReservedQty. Note, JobUnFirmAllocQty is not
included. The system calculates Available as OnhandQty - AllocQty.

OnhandQty - A summary of PartBin.OnHandQty for the warehouse where the bin is a
nettable bin (WhseBin.NonNettable = NO). Maintained via the PartBin write
trigger.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Chris
Thompson <chriselectrix@...> wrote:

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

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

system · October 5, 2010, 12:08pm

I've never seen OH off (but that certainly doesn't mean it can't happen).
Allocations can slowly get trashed over time & there is a utility you can routinely run (weekly or even monthly probably OK) to clean things up.
If same exists for some OH problem, appreciate a heads up (thx).
Rob

--- Original Message ---
From:"Chris Thompson" <chriselectrix@...>
Sent:Tue 10/5/10 11:34 am
To:vantage@yahoogroups.com
Subj:Re: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

We have used an OnHandQty field before which also gave the wrong figure when
compared to the onhandqty that you can see throughout Epicor. 90% were right but
the odd one was wrong.

________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Tue, 5 October, 2010 16:10:58
Subject: RE: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Â
On hand qty is the field that I was using, but for some reason does not work
correctly, very often shows the wrong qty.

I called support and they could not explain why this was not working and they
told me that other way that I gave you originally to get total OH.

Maybe it's a data issue not a programming issue? If it's working for others?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
mattcald_73
Sent: Tuesday, October 05, 2010 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Do you need what is available in each bin? If not, you can pull both values from
PartWhse. AllocQty and OnhandQty are both found there.

Definitions:
AllocQty - A summary of the outstanding quantities for order open sales releases
that are being filled from stock and of the open job material requirements that
are to be issued from stock (JobMtl.Buyit = No) for this Part within a specific
warehouse. NOTE: This value is the TOTAL of the allocation demands. Calculated
as the sum of SalesAllocQty + SalesReservedQty + SalesPickingQty +
SalesPickedQty + JobAllocQty + JobReservedQty. Note, JobUnFirmAllocQty is not
included. The system calculates Available as OnhandQty - AllocQty.

OnhandQty - A summary of PartBin.OnHandQty for the warehouse where the bin is a
nettable bin (WhseBin.NonNettable = NO). Maintained via the PartBin write
trigger.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Chris
Thompson <chriselectrix@...> wrote:

system · October 5, 2010, 12:13pm

What is the name of this utility?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of robertb_versa@...
Sent: Tuesday, October 05, 2010 12:08 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

I've never seen OH off (but that certainly doesn't mean it can't happen).
Allocations can slowly get trashed over time & there is a utility you can routinely run (weekly or even monthly probably OK) to clean things up.
If same exists for some OH problem, appreciate a heads up (thx).
Rob

--- Original Message ---
From:"Chris Thompson" <chriselectrix@... <mailto:chriselectrix%40ymail.com> >
Sent:Tue 10/5/10 11:34 am
To:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subj:Re: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

We have used an OnHandQty field before which also gave the wrong figure when
compared to the onhandqty that you can see throughout Epicor. 90% were right but
the odd one was wrong.

________________________________
From: Blake Clemens <blake.clemens@... <mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 16:10:58
Subject: RE: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

On hand qty is the field that I was using, but for some reason does not work
correctly, very often shows the wrong qty.

I called support and they could not explain why this was not working and they
told me that other way that I gave you originally to get total OH.

Maybe it's a data issue not a programming issue? If it's working for others?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of
mattcald_73
Sent: Tuesday, October 05, 2010 10:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Do you need what is available in each bin? If not, you can pull both values from
PartWhse. AllocQty and OnhandQty are both found there.

Definitions:
AllocQty - A summary of the outstanding quantities for order open sales releases
that are being filled from stock and of the open job material requirements that
are to be issued from stock (JobMtl.Buyit = No) for this Part within a specific
warehouse. NOTE: This value is the TOTAL of the allocation demands. Calculated
as the sum of SalesAllocQty + SalesReservedQty + SalesPickingQty +
SalesPickedQty + JobAllocQty + JobReservedQty. Note, JobUnFirmAllocQty is not
included. The system calculates Available as OnhandQty - AllocQty.

OnhandQty - A summary of PartBin.OnHandQty for the warehouse where the bin is a
nettable bin (WhseBin.NonNettable = NO). Maintained via the PartBin write
trigger.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , Chris
Thompson <chriselectrix@...> wrote:

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

system · October 5, 2010, 12:29pm

Good Day:

Please see attached.
Is an Inventory report - BAQ

len.hartka@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Tuesday, October 05, 2010 11:33 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

There is in E9 - not sure about your version

________________________________
From: Blake Clemens <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:41:13
Subject: RE: [Vantage] 8.03.408B - BAQ - Calculated Field

Are you saying there is a PartQty table? I don't see that in my list of
available tables.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Chris Thompson
Sent: Tuesday, October 05, 2010 10:37 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

Have you tried

PartQty.OnHandQty-PartQty.DemandQty ?

________________________________
From: Chris Thompson <chriselectrix@...
<mailto:chriselectrix%40ymail.com> <mailto:chriselectrix%40ymail.com>

To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:28:54
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

Oddly I am just emailing support about the same thing.

If anyone has any ideas it'd be appreciated.

________________________________
From: Blake Clemens <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com> <mailto:blake.clemens%40d-m-c.com>

To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:27:20
Subject: [Vantage] 8.03.408B - BAQ - Calculated Field

I'm creating a query that shows the "real" available on hand quantity.
We were told by support that in order to get the actual on hand qty you
need to Total up the PartBin.OnHandQty and subtract from that
PartWhse.AllocQty. I want to do this on a calculated field in a query.
I've tried many versions of this and none work properly. For example...
Total (PartBin.OnHandQty - PartWhse.AllocQty) will run but the numbers
don't add up when we check the qty with Vantage. If I try modifying
this code I'll get a sytax error... for example... (Total
(PartBin.OnHandQty)) - PartWhse.AllocQty or ((Total (PartBin.OnHandQty))
- PartWhse.AllocQty) both of these give me a sytax error. Does anyone
have any ideas what I may be doing wrong. Any help would be greatly
appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

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

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

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

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]

system · October 5, 2010, 12:35pm

Nothing attached. Can you email me directly... blake.clemens@...

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Len Hartka
Sent: Tuesday, October 05, 2010 12:28 PM
To: vantage@yahoogroups.com
Cc: IT Department
Subject: RE: [Vantage] 8.03.408B - BAQ - Calculated Field

Good Day:

Please see attached.
Is an Inventory report - BAQ

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 Chris Thompson
Sent: Tuesday, October 05, 2010 11:33 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

There is in E9 - not sure about your version

________________________________
From: Blake Clemens <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:41:13
Subject: RE: [Vantage] 8.03.408B - BAQ - Calculated Field

Are you saying there is a PartQty table? I don't see that in my list of
available tables.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Chris Thompson
Sent: Tuesday, October 05, 2010 10:37 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

Have you tried

PartQty.OnHandQty-PartQty.DemandQty ?

________________________________
From: Chris Thompson <chriselectrix@...
<mailto:chriselectrix%40ymail.com>
<mailto:chriselectrix%40ymail.com> <mailto:chriselectrix%40ymail.com>

To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:28:54
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

Oddly I am just emailing support about the same thing.

If anyone has any ideas it'd be appreciated.

________________________________
From: Blake Clemens <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com> <mailto:blake.clemens%40d-m-c.com>

To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:27:20
Subject: [Vantage] 8.03.408B - BAQ - Calculated Field

I'm creating a query that shows the "real" available on hand quantity.
We were told by support that in order to get the actual on hand qty you
need to Total up the PartBin.OnHandQty and subtract from that
PartWhse.AllocQty. I want to do this on a calculated field in a query.
I've tried many versions of this and none work properly. For example...
Total (PartBin.OnHandQty - PartWhse.AllocQty) will run but the numbers
don't add up when we check the qty with Vantage. If I try modifying
this code I'll get a sytax error... for example... (Total
(PartBin.OnHandQty)) - PartWhse.AllocQty or ((Total (PartBin.OnHandQty))
- PartWhse.AllocQty) both of these give me a sytax error. Does anyone
have any ideas what I may be doing wrong. Any help would be greatly
appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

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

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

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

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]

system · October 5, 2010, 3:10pm

Good Day Blake:

Sorry, I forgot this list strip attachments.

Imbedded in email, but on second thought, I
do not think it is what you are after.
I thought you could just not find
the QOH.

len.hartka@... <mailto:len.hartka@...>

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Blake Clemens
Sent: Tuesday, October 05, 2010 12:35 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 8.03.408B - BAQ - Calculated Field

Nothing attached. Can you email me directly... blake.clemens@...
<mailto:blake.clemens%40d-m-c.com>

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Len Hartka
Sent: Tuesday, October 05, 2010 12:28 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Cc: IT Department
Subject: RE: [Vantage] 8.03.408B - BAQ - Calculated Field

Good Day:

Please see attached.
Is an Inventory report - BAQ

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

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Chris Thompson
Sent: Tuesday, October 05, 2010 11:33 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

There is in E9 - not sure about your version

________________________________
From: Blake Clemens <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:41:13
Subject: RE: [Vantage] 8.03.408B - BAQ - Calculated Field

Are you saying there is a PartQty table? I don't see that in my list of
available tables.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Chris Thompson
Sent: Tuesday, October 05, 2010 10:37 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

Have you tried

PartQty.OnHandQty-PartQty.DemandQty ?

________________________________
From: Chris Thompson <chriselectrix@...
<mailto:chriselectrix%40ymail.com>
<mailto:chriselectrix%40ymail.com>
<mailto:chriselectrix%40ymail.com> <mailto:chriselectrix%40ymail.com>

To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:28:54
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

Oddly I am just emailing support about the same thing.

If anyone has any ideas it'd be appreciated.

________________________________
From: Blake Clemens <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com> <mailto:blake.clemens%40d-m-c.com>

To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:27:20
Subject: [Vantage] 8.03.408B - BAQ - Calculated Field

I'm creating a query that shows the "real" available on hand quantity.
We were told by support that in order to get the actual on hand qty you
need to Total up the PartBin.OnHandQty and subtract from that
PartWhse.AllocQty. I want to do this on a calculated field in a query.
I've tried many versions of this and none work properly. For example...
Total (PartBin.OnHandQty - PartWhse.AllocQty) will run but the numbers
don't add up when we check the qty with Vantage. If I try modifying
this code I'll get a sytax error... for example... (Total
(PartBin.OnHandQty)) - PartWhse.AllocQty or ((Total (PartBin.OnHandQty))
- PartWhse.AllocQty) both of these give me a sytax error. Does anyone
have any ideas what I may be doing wrong. Any help would be greatly
appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

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

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

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

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]

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]

system · October 5, 2010, 5:01pm

Wish I could from memory (but can't tomorrow as I'm having spinal fusion surgery so it may be a while until I can confirm.)
My understanding is that it is a routinely used utitlity so perhaps someone out there can share (???n).
Rob

--- Original Message ---
From:"Blake Clemens" <blake.clemens@...>
Sent:Tue 10/5/10 12:14 pm
To:<vantage@yahoogroups.com>
Subj:RE: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

What is the name of this utility?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of robertb_versa@...
Sent: Tuesday, October 05, 2010 12:08 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

I've never seen OH off (but that certainly doesn't mean it can't happen).
Allocations can slowly get trashed over time & there is a utility you can routinely run (weekly or even monthly probably OK) to clean things up.
If same exists for some OH problem, appreciate a heads up (thx).
Rob

--- Original Message ---
From:"Chris Thompson" <chriselectrix@... <mailto:chriselectrix%40ymail.com> >
Sent:Tue 10/5/10 11:34 am
To:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subj:Re: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

We have used an OnHandQty field before which also gave the wrong figure when
compared to the onhandqty that you can see throughout Epicor. 90% were right but
the odd one was wrong.

________________________________
From: Blake Clemens <blake.clemens@... <mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 16:10:58
Subject: RE: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

On hand qty is the field that I was using, but for some reason does not work
correctly, very often shows the wrong qty.

I called support and they could not explain why this was not working and they
told me that other way that I gave you originally to get total OH.

Maybe it's a data issue not a programming issue? If it's working for others?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of
mattcald_73
Sent: Tuesday, October 05, 2010 10:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Do you need what is available in each bin? If not, you can pull both values from
PartWhse. AllocQty and OnhandQty are both found there.

Definitions:
AllocQty - A summary of the outstanding quantities for order open sales releases
that are being filled from stock and of the open job material requirements that
are to be issued from stock (JobMtl.Buyit = No) for this Part within a specific
warehouse. NOTE: This value is the TOTAL of the allocation demands. Calculated
as the sum of SalesAllocQty + SalesReservedQty + SalesPickingQty +
SalesPickedQty + JobAllocQty + JobReservedQty. Note, JobUnFirmAllocQty is not
included. The system calculates Available as OnhandQty - AllocQty.

OnhandQty - A summary of PartBin.OnHandQty for the warehouse where the bin is a
nettable bin (WhseBin.NonNettable = NO). Maintained via the Part

system · October 5, 2010, 5:16pm

Support's job is to to lead you to the allocations recalc/correction utility (particularly for a known problem like this that cropped up YEARS ago.)
I'd give them a call.

--- Original Message ---
From:"Blake Clemens" <blake.clemens@...>
Sent:Tue 10/5/10 12:14 pm
To:<vantage@yahoogroups.com>
Subj:RE: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

What is the name of this utility?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of robertb_versa@...
Sent: Tuesday, October 05, 2010 12:08 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

I've never seen OH off (but that certainly doesn't mean it can't happen).
Allocations can slowly get trashed over time & there is a utility you can routinely run (weekly or even monthly probably OK) to clean things up.
If same exists for some OH problem, appreciate a heads up (thx).
Rob

--- Original Message ---
From:"Chris Thompson" <chriselectrix@... <mailto:chriselectrix%40ymail.com> >
Sent:Tue 10/5/10 11:34 am
To:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subj:Re: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

We have used an OnHandQty field before which also gave the wrong figure when
compared to the onhandqty that you can see throughout Epicor. 90% were right but
the odd one was wrong.

________________________________
From: Blake Clemens <blake.clemens@... <mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 16:10:58
Subject: RE: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

On hand qty is the field that I was using, but for some reason does not work
correctly, very often shows the wrong qty.

I called support and they could not explain why this was not working and they
told me that other way that I gave you originally to get total OH.

Maybe it's a data issue not a programming issue? If it's working for others?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of
mattcald_73
Sent: Tuesday, October 05, 2010 10:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Do you need what is available in each bin? If not, you can pull both values from
PartWhse. AllocQty and OnhandQty are both found there.

Definitions:
AllocQty - A summary of the outstanding quantities for order open sales releases
that are being filled from stock and of the open job material requirements that
are to be issued from stock (JobMtl.Buyit = No) for this Part within a specific
warehouse. NOTE: This value is the TOTAL of the allocation demands. Calculated
as the sum of SalesAllocQty + SalesReservedQty + SalesPickingQty +
SalesPickedQty + JobAllocQty + JobReservedQty. Note, JobUnFirmAllocQty is not
included. The system calculates Available as OnhandQty - AllocQty.

OnhandQty - A summary of PartBin.OnHandQty for the warehouse where the bin is a
nettable bin (WhseBin.NonNettable = NO). Maintained via the Part

system · October 5, 2010, 6:09pm

Good Day:

OK, I give up.

They strip out images pasted into the email also.

The only thing I was adding was that we use PartWhse:OnHandQty;
but on second look you already had that I think.

len.hartka@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Len Hartka
Sent: Tuesday, October 05, 2010 3:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 8.03.408B - BAQ - Calculated Field

Good Day Blake:

Sorry, I forgot this list strip attachments.

Imbedded in email, but on second thought, I
do not think it is what you are after.
I thought you could just not find
the QOH.

len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto: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 Blake Clemens
Sent: Tuesday, October 05, 2010 12:35 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] 8.03.408B - BAQ - Calculated Field

Nothing attached. Can you email me directly... blake.clemens@...
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com>

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Len Hartka
Sent: Tuesday, October 05, 2010 12:28 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Cc: IT Department
Subject: RE: [Vantage] 8.03.408B - BAQ - Calculated Field

Good Day:

Please see attached.
Is an Inventory report - BAQ

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

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Chris Thompson
Sent: Tuesday, October 05, 2010 11:33 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

There is in E9 - not sure about your version

________________________________
From: Blake Clemens <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:41:13
Subject: RE: [Vantage] 8.03.408B - BAQ - Calculated Field

Are you saying there is a PartQty table? I don't see that in my list of
available tables.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Chris Thompson
Sent: Tuesday, October 05, 2010 10:37 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

Have you tried

PartQty.OnHandQty-PartQty.DemandQty ?

________________________________
From: Chris Thompson <chriselectrix@...
<mailto:chriselectrix%40ymail.com>
<mailto:chriselectrix%40ymail.com>
<mailto:chriselectrix%40ymail.com>
<mailto:chriselectrix%40ymail.com> <mailto:chriselectrix%40ymail.com>

To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:28:54
Subject: Re: [Vantage] 8.03.408B - BAQ - Calculated Field

Oddly I am just emailing support about the same thing.

If anyone has any ideas it'd be appreciated.

________________________________
From: Blake Clemens <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com> <mailto:blake.clemens%40d-m-c.com>

To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Tue, 5 October, 2010 15:27:20
Subject: [Vantage] 8.03.408B - BAQ - Calculated Field

I'm creating a query that shows the "real" available on hand quantity.
We were told by support that in order to get the actual on hand qty you
need to Total up the PartBin.OnHandQty and subtract from that
PartWhse.AllocQty. I want to do this on a calculated field in a query.
I've tried many versions of this and none work properly. For example...
Total (PartBin.OnHandQty - PartWhse.AllocQty) will run but the numbers
don't add up when we check the qty with Vantage. If I try modifying
this code I'll get a sytax error... for example... (Total
(PartBin.OnHandQty)) - PartWhse.AllocQty or ((Total (PartBin.OnHandQty))
- PartWhse.AllocQty) both of these give me a sytax error. Does anyone
have any ideas what I may be doing wrong. Any help would be greatly
appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

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

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

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

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]

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]

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]

system · October 19, 2010, 4:06pm

Someone mentioned on here that there should be some kind of utility provided by support that fixes the PartWhse.OnHandQty. Does anyone have the name of this utility? I just spoke to support and they were not aware of anything.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mattcald_73
Sent: Tuesday, October 05, 2010 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Do you need what is available in each bin? If not, you can pull both values from PartWhse. AllocQty and OnhandQty are both found there.

Definitions:
AllocQty - A summary of the outstanding quantities for order open sales releases that are being filled from stock and of the open job material requirements that are to be issued from stock (JobMtl.Buyit = No) for this Part within a specific warehouse. NOTE: This value is the TOTAL of the allocation demands. Calculated as the sum of SalesAllocQty + SalesReservedQty + SalesPickingQty + SalesPickedQty + JobAllocQty + JobReservedQty. Note, JobUnFirmAllocQty is not included. The system calculates Available as OnhandQty - AllocQty.

OnhandQty - A summary of PartBin.OnHandQty for the warehouse where the bin is a nettable bin (WhseBin.NonNettable = NO). Maintained via the PartBin write trigger.

system · October 19, 2010, 4:30pm

Conversion programs 5030 and 6430 cleans this up. Run the Vantage Admin Tool, logon as a System Manager user, and click on Database Conversions.

These are just various Progress Programs that are designed to deal with various database issues. It manipulates the Vantage database directly.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Blake Clemens
Sent: Tuesday, October 19, 2010 4:06 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Someone mentioned on here that there should be some kind of utility provided by support that fixes the PartWhse.OnHandQty. Does anyone have the name of this utility? I just spoke to support and they were not aware of anything.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mattcald_73
Sent: Tuesday, October 05, 2010 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Do you need what is available in each bin? If not, you can pull both values from PartWhse. AllocQty and OnhandQty are both found there.

Definitions:
AllocQty - A summary of the outstanding quantities for order open sales releases that are being filled from stock and of the open job material requirements that are to be issued from stock (JobMtl.Buyit = No) for this Part within a specific warehouse. NOTE: This value is the TOTAL of the allocation demands. Calculated as the sum of SalesAllocQty + SalesReservedQty + SalesPickingQty + SalesPickedQty + JobAllocQty + JobReservedQty. Note, JobUnFirmAllocQty is not included. The system calculates Available as OnhandQty - AllocQty.

OnhandQty - A summary of PartBin.OnHandQty for the warehouse where the bin is a nettable bin (WhseBin.NonNettable = NO). Maintained via the PartBin write trigger.

system · October 19, 2010, 4:41pm

I think what you want is conversion program 6430 which you run from the Admin
Tools on your server.Â This just adjusts the quantities at an instance in time.Â
You need to run it regularly to keep them in balance.Â I wish Epicor would fix
the problem once and for all.

________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Tue, October 19, 2010 4:05:46 PM
Subject: RE: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Â
Someone mentioned on here that there should be some kind of utility provided by
support that fixes the PartWhse.OnHandQty. Does anyone have the name of this
utility? I just spoke to support and they were not aware of anything.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
mattcald_73
Sent: Tuesday, October 05, 2010 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: 8.03.408B - BAQ - Calculated Field

Do you need what is available in each bin? If not, you can pull both values from
PartWhse. AllocQty and OnhandQty are both found there.

Definitions:
AllocQty - A summary of the outstanding quantities for order open sales releases
that are being filled from stock and of the open job material requirements that
are to be issued from stock (JobMtl.Buyit = No) for this Part within a specific
warehouse. NOTE: This value is the TOTAL of the allocation demands. Calculated
as the sum of SalesAllocQty + SalesReservedQty + SalesPickingQty +
SalesPickedQty + JobAllocQty + JobReservedQty. Note, JobUnFirmAllocQty is not
included. The system calculates Available as OnhandQty - AllocQty.

OnhandQty - A summary of PartBin.OnHandQty for the warehouse where the bin is a
nettable bin (WhseBin.NonNettable = NO). Maintained via the PartBin write
trigger.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Chris
Thompson <chriselectrix@...> wrote:

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

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