UnitPrice vs DocUintPrice

Look at the currency exchange rate on the invc header.




On Jul 18, 2011, at 11:28 AM, "Mordechai" <mseal@...> wrote:

> We have seen this issue and at times the value is not $0 but actually a different value.
> We believe (but could not re-create it) that it is caused during the push or pull wizard from a quote and that the user changes the prices from the quoted value to the new order value.
> We have opened an case for this, but will little time to prove and recreate this, guess is will close on me…
>
> Motty
>
> --- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
> >
> > In Epicor 9.05, DocUnitPrice & UnitPrice work exactly as Linda
> > describes, differing only by currency. I did see some zeros for one of
> > them when our exchange rates got messed up, so I'd look there for a
> > problem. Note that the rate type is set when the order is created, and
> > fixing the default rate type in your company configuration only affects
> > new orders, so it won't clean up a problem with an old order.
> >
> >
> >
> > Brian.
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of Linda Lowney
> > Sent: Monday, July 18, 2011 11:05 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Re: UnitPrice vs DocUintPrice
> >
> >
> >
> >
> >
> > Hi Bruce,
> >
> >
> >
> > Oh, I have never seen that. We are still on 8.03 so maybe it is a new
> > "feature" of 9.
> >
> >
> >
> >
> >
> > Regards,
> >
> > Linda
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of cooner_55421
> > Sent: Monday, July 18, 2011 11:01 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: UnitPrice vs DocUintPrice
> >
> >
> >
> >
> >
> > Hi Linda,
> >
> > I don't think it is the currency.
> >
> > When they are off - one value will be zero.
> > So records look like this:
> > UnitPrice, DocUnitPrice
> > 0.00, 12.00
> > 1.59, 0.00
> > 0.68, 0.00
> >
> > When I check downstream, invoices are using the unitprice in totals.
> > Examples I have checked, this seems correct.
> >
> > But, we have trouble because reports and dashboards are using both
> > DocUnitPrice or UnitPrice. Confuses end users.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> , "Linda Lowney" <llowney@> wrote:
> >
> > >
> > > Hi Bruce,
> > >
> > >
> > >
> > > Did you check the customer's currency. The DocUnitPrice is in the
> > > currency of the customer, the UnitPrice is in your base currency.
> > >
> > >
> > >
> > > Linda
> > >
> > >
> > >
> > > 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 cooner_55421
> > > Sent: Friday, July 15, 2011 5:40 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] UnitPrice vs DocUintPrice
> > >
> > >
> > >
> > >
> > >
> > > Hi,
> > >
> > > Just wondering if any of you have seen cases where the UnitPrice does
> > > not match the DocUnitPrice in the OrderDtl table? E9 9.04.506.
> > >
> > > I'm seeing a few mismatches.
> > >
> > > I was told by tech support that they have heard of them getting out of
> >
> > > sync if an order is changed several times.
> > >
> > > And, that if they do get out of sync in teh OrderDtl table - UnitPrice
> >
> > > is the value I should rely on.
> > > UnitPrice is supposed to be used in subsequent processing of Shipments
> > &
> > > Invoicing.
> > >
> > > Thanks,
> > >
> > > Bruce
> > >
> > >
> > >
> > >
> > >
> > > [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]
Hi Bruce,



Did you check the customer's currency. The DocUnitPrice is in the
currency of the customer, the UnitPrice is in your base currency.



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cooner_55421
Sent: Friday, July 15, 2011 5:40 PM
To: vantage@yahoogroups.com
Subject: [Vantage] UnitPrice vs DocUintPrice





Hi,

Just wondering if any of you have seen cases where the UnitPrice does
not match the DocUnitPrice in the OrderDtl table? E9 9.04.506.

I'm seeing a few mismatches.

I was told by tech support that they have heard of them getting out of
sync if an order is changed several times.

And, that if they do get out of sync in teh OrderDtl table - UnitPrice
is the value I should rely on.
UnitPrice is supposed to be used in subsequent processing of Shipments &
Invoicing.

Thanks,

Bruce





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



Oh, I have never seen that. We are still on 8.03 so maybe it is a new “feature” of 9.





Regards,

Linda

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cooner_55421
Sent: Monday, July 18, 2011 11:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: UnitPrice vs DocUintPrice





Hi Linda,

I don't think it is the currency.

When they are off - one value will be zero.
So records look like this:
UnitPrice, DocUnitPrice
0.00, 12.00
1.59, 0.00
0.68, 0.00

When I check downstream, invoices are using the unitprice in totals.
Examples I have checked, this seems correct.

But, we have trouble because reports and dashboards are using both DocUnitPrice or UnitPrice. Confuses end users.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Linda Lowney" <llowney@...> wrote:
>
> Hi Bruce,
>
>
>
> Did you check the customer's currency. The DocUnitPrice is in the
> currency of the customer, the UnitPrice is in your base currency.
>
>
>
> Linda
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
> Of cooner_55421
> Sent: Friday, July 15, 2011 5:40 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] UnitPrice vs DocUintPrice
>
>
>
>
>
> Hi,
>
> Just wondering if any of you have seen cases where the UnitPrice does
> not match the DocUnitPrice in the OrderDtl table? E9 9.04.506.
>
> I'm seeing a few mismatches.
>
> I was told by tech support that they have heard of them getting out of
> sync if an order is changed several times.
>
> And, that if they do get out of sync in teh OrderDtl table - UnitPrice
> is the value I should rely on.
> UnitPrice is supposed to be used in subsequent processing of Shipments &
> Invoicing.
>
> Thanks,
>
> Bruce
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
In Epicor 9.05, DocUnitPrice & UnitPrice work exactly as Linda
describes, differing only by currency. I did see some zeros for one of
them when our exchange rates got messed up, so I'd look there for a
problem. Note that the rate type is set when the order is created, and
fixing the default rate type in your company configuration only affects
new orders, so it won't clean up a problem with an old order.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Linda Lowney
Sent: Monday, July 18, 2011 11:05 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: UnitPrice vs DocUintPrice





Hi Bruce,



Oh, I have never seen that. We are still on 8.03 so maybe it is a new
"feature" of 9.





Regards,

Linda

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of cooner_55421
Sent: Monday, July 18, 2011 11:01 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: UnitPrice vs DocUintPrice





Hi Linda,

I don't think it is the currency.

When they are off - one value will be zero.
So records look like this:
UnitPrice, DocUnitPrice
0.00, 12.00
1.59, 0.00
0.68, 0.00

When I check downstream, invoices are using the unitprice in totals.
Examples I have checked, this seems correct.

But, we have trouble because reports and dashboards are using both
DocUnitPrice or UnitPrice. Confuses end users.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , "Linda Lowney" <llowney@...> wrote:

>
> Hi Bruce,
>
>
>
> Did you check the customer's currency. The DocUnitPrice is in the
> currency of the customer, the UnitPrice is in your base currency.
>
>
>
> Linda
>
>
>
> 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 cooner_55421
> Sent: Friday, July 15, 2011 5:40 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] UnitPrice vs DocUintPrice
>
>
>
>
>
> Hi,
>
> Just wondering if any of you have seen cases where the UnitPrice does
> not match the DocUnitPrice in the OrderDtl table? E9 9.04.506.
>
> I'm seeing a few mismatches.
>
> I was told by tech support that they have heard of them getting out of

> sync if an order is changed several times.
>
> And, that if they do get out of sync in teh OrderDtl table - UnitPrice

> is the value I should rely on.
> UnitPrice is supposed to be used in subsequent processing of Shipments
&
> Invoicing.
>
> Thanks,
>
> Bruce
>
>
>
>
>
> [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]
We have seen this issue and at times the value is not $0 but actually a different value.
We believe (but could not re-create it) that it is caused during the push or pull wizard from a quote and that the user changes the prices from the quoted value to the new order value.
We have opened an case for this, but will little time to prove and recreate this, guess is will close on meÂ…

Motty


--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> In Epicor 9.05, DocUnitPrice & UnitPrice work exactly as Linda
> describes, differing only by currency. I did see some zeros for one of
> them when our exchange rates got messed up, so I'd look there for a
> problem. Note that the rate type is set when the order is created, and
> fixing the default rate type in your company configuration only affects
> new orders, so it won't clean up a problem with an old order.
>
>
>
> Brian.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Linda Lowney
> Sent: Monday, July 18, 2011 11:05 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: UnitPrice vs DocUintPrice
>
>
>
>
>
> Hi Bruce,
>
>
>
> Oh, I have never seen that. We are still on 8.03 so maybe it is a new
> "feature" of 9.
>
>
>
>
>
> Regards,
>
> Linda
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of cooner_55421
> Sent: Monday, July 18, 2011 11:01 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: UnitPrice vs DocUintPrice
>
>
>
>
>
> Hi Linda,
>
> I don't think it is the currency.
>
> When they are off - one value will be zero.
> So records look like this:
> UnitPrice, DocUnitPrice
> 0.00, 12.00
> 1.59, 0.00
> 0.68, 0.00
>
> When I check downstream, invoices are using the unitprice in totals.
> Examples I have checked, this seems correct.
>
> But, we have trouble because reports and dashboards are using both
> DocUnitPrice or UnitPrice. Confuses end users.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> , "Linda Lowney" <llowney@> wrote:
>
> >
> > Hi Bruce,
> >
> >
> >
> > Did you check the customer's currency. The DocUnitPrice is in the
> > currency of the customer, the UnitPrice is in your base currency.
> >
> >
> >
> > Linda
> >
> >
> >
> > 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 cooner_55421
> > Sent: Friday, July 15, 2011 5:40 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] UnitPrice vs DocUintPrice
> >
> >
> >
> >
> >
> > Hi,
> >
> > Just wondering if any of you have seen cases where the UnitPrice does
> > not match the DocUnitPrice in the OrderDtl table? E9 9.04.506.
> >
> > I'm seeing a few mismatches.
> >
> > I was told by tech support that they have heard of them getting out of
>
> > sync if an order is changed several times.
> >
> > And, that if they do get out of sync in teh OrderDtl table - UnitPrice
>
> > is the value I should rely on.
> > UnitPrice is supposed to be used in subsequent processing of Shipments
> &
> > Invoicing.
> >
> > Thanks,
> >
> > Bruce
> >
> >
> >
> >
> >
> > [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]
>