Supplier Price List Query

Yahoo Archive
1
Thanks Rob, could be. I'm at a loss at how such a simple query can not display something as simple as the right number of decimals! Havent heard back from support in a few days so I guess they don't know either

--- On Thu, 10/30/08, Robert Brown <robertb_versa@...> wrote:

From: Robert Brown <robertb_versa@...>
Subject: Re: [Vantage] Supplier Price List Query
To: vantage@yahoogroups.com
Date: Thursday, October 30, 2008, 12:44 PM






VendPart.MinimumPri ce & VendPart.MiscAmt are 2 decimal precision (at db level) fields. That might be the issue.

VendPart.BaseUnitPr ice is 5 decimal precision.

I don't see any other fields in the base query that might be causing your issue.

Rob

--- On Thu, 10/30/08, Mark Wagner <mjfw2003@yahoo. com> wrote:

From: Mark Wagner <mjfw2003@yahoo. com>
Subject: Re: [Vantage] Supplier Price List Query
To: vantage@yahoogroups .com
Date: Thursday, October 30, 2008, 11:45 AM

Rob, its zSupPart01. No, it does not show as a calculated field

--- On Thu, 10/30/08, Robert Brown <robertb_versa@ yahoo.com> wrote:

From: Robert Brown <robertb_versa@ yahoo.com>
Subject: Re: [Vantage] Supplier Price List Query
To: vantage@yahoogroups .com
Date: Thursday, October 30, 2008, 11:32 AM

You're not saying specifically what z BAQ it is so I can't verify: Is the value field you refer to a calculated field (with a display mask limiting to .00)?

--- On Thu, 10/30/08, Mark Wagner <mjfw2003@yahoo. com> wrote:

From: Mark Wagner <mjfw2003@yahoo. com>
Subject: [Vantage] Supplier Price List Query
To: "Vantage User Group" <vantage@yahoogroup s .com>
Date: Thursday, October 30, 2008, 8:54 AM

I copied the BAQ supplier part query in order to create a dashboard that would display the supplier part, base price, minimum price, etc so we can view all supplier prices. The query is rounding to the nearest dollar and does not display anything < 1.00. A call into Epicor support has not helped yet. Does anyone have a BAQ that works or would know why it is rounding?

[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]
2
I copied the BAQ supplier part query in order to create a dashboard that would display the supplier part, base price, minimum price, etc so we can view all supplier prices. The query is rounding to the nearest dollar and does not display anything < 1.00. A call into Epicor support has not helped yet. Does anyone have a BAQ that works or would know why it is rounding?




[Non-text portions of this message have been removed]
3
You're not saying specifically what z BAQ it is so I can't verify: Is the value field you refer to a calculated field (with a display mask limiting to .00)?



--- On Thu, 10/30/08, Mark Wagner <mjfw2003@...> wrote:

From: Mark Wagner <mjfw2003@...>
Subject: [Vantage] Supplier Price List Query
To: "Vantage User Group" <vantage@yahoogroups.com>
Date: Thursday, October 30, 2008, 8:54 AM






I copied the BAQ supplier part query in order to create a dashboard that would display the supplier part, base price, minimum price, etc so we can view all supplier prices. The query is rounding to the nearest dollar and does not display anything < 1.00. A call into Epicor support has not helped yet. Does anyone have a BAQ that works or would know why it is rounding?

[Non-text portions of this message have been removed]
4
Rob, its zSupPart01. No, it does not show as a calculated field

--- On Thu, 10/30/08, Robert Brown <robertb_versa@...> wrote:

From: Robert Brown <robertb_versa@...>
Subject: Re: [Vantage] Supplier Price List Query
To: vantage@yahoogroups.com
Date: Thursday, October 30, 2008, 11:32 AM






You're not saying specifically what z BAQ it is so I can't verify: Is the value field you refer to a calculated field (with a display mask limiting to .00)?

--- On Thu, 10/30/08, Mark Wagner <mjfw2003@yahoo. com> wrote:

From: Mark Wagner <mjfw2003@yahoo. com>
Subject: [Vantage] Supplier Price List Query
To: "Vantage User Group" <vantage@yahoogroups .com>
Date: Thursday, October 30, 2008, 8:54 AM

I copied the BAQ supplier part query in order to create a dashboard that would display the supplier part, base price, minimum price, etc so we can view all supplier prices. The query is rounding to the nearest dollar and does not display anything < 1.00. A call into Epicor support has not helped yet. Does anyone have a BAQ that works or would know why it is rounding?

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


















[Non-text portions of this message have been removed]
5
VendPart.MinimumPrice & VendPart.MiscAmt are 2 decimal precision (at db level) fields. That might be the issue.

VendPart.BaseUnitPrice is 5 decimal precision.

I don't see any other fields in the base query that might be causing your issue.

Rob

--- On Thu, 10/30/08, Mark Wagner <mjfw2003@...> wrote:

From: Mark Wagner <mjfw2003@...>
Subject: Re: [Vantage] Supplier Price List Query
To: vantage@yahoogroups.com
Date: Thursday, October 30, 2008, 11:45 AM






Rob, its zSupPart01. No, it does not show as a calculated field

--- On Thu, 10/30/08, Robert Brown <robertb_versa@ yahoo.com> wrote:

From: Robert Brown <robertb_versa@ yahoo.com>
Subject: Re: [Vantage] Supplier Price List Query
To: vantage@yahoogroups .com
Date: Thursday, October 30, 2008, 11:32 AM

You're not saying specifically what z BAQ it is so I can't verify: Is the value field you refer to a calculated field (with a display mask limiting to .00)?

--- On Thu, 10/30/08, Mark Wagner <mjfw2003@yahoo. com> wrote:

From: Mark Wagner <mjfw2003@yahoo. com>
Subject: [Vantage] Supplier Price List Query
To: "Vantage User Group" <vantage@yahoogroup s .com>
Date: Thursday, October 30, 2008, 8:54 AM

I copied the BAQ supplier part query in order to create a dashboard that would display the supplier part, base price, minimum price, etc so we can view all supplier prices. The query is rounding to the nearest dollar and does not display anything < 1.00. A call into Epicor support has not helped yet. Does anyone have a BAQ that works or would know why it is rounding?

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

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