Incorrect Unit Price in P4210

[deniko]

Hello everyone,

Could anyone please advise me on the following problem?

When I enter sales order and the transaction UM is not equal to primary UM (in my case primary and pricing UM are the same) I get incorrect Unit Price in P410 and F4211

Here is an example

Item=TC10119
Primary UM=Pricing UM=BX

P41002: 1 PA of TC10119 = 0.05 BX

P4106: 1 BX of TC10119 costs 399.6000 USD

I enter sales order (2 rows)
<font class="small">Code:</font><hr /><pre>
---------------------------------------------------------
quantity | item | UOM | Unit Price | Extended Price
---------------------------------------------------------
1.0000 | TC10119 | BX | 399.6000 | 399.6000
1.0000 | TC10119 | PA | 399.6000 | 19.98
---------------------------------------------------------
</pre><hr />

I enter quantity (UORG), item (LITM) and UOM (UOM) manually
Unit Price (UPRC) and Extended Price (AEXP) are calculated automatically in Edit Line

Note that UORG*UPRC != AEXP for the second row. UPRC is incorrect, AEXP is correct.

In inventory everything will be issued correctly, all the amounts in finance will also be correct (as the quantity and the extended price are correct). However, P4210 and all the printed documents output (those that contain unit price information) is confusing.

Also if for the second line I manually enter the correct unit price (19.9800), AEXP will be recalculated to 1.00 (19.9800 * 0.05, rounded to 2 digits)

Additional info.
In p41001, System Constants, Sales Price Retrieval UOM (UMB1) = 2 (Pricing UOM), I also tried with UMB1=1 (had to enter price in PA in P4106 for this), and it worked the same way.

P4210 is not modified

In DD UPRC display decimals was changed to 4

JD Edwards EnterpriseOne
Application Release E812
Tools Release 8.96.8

Any ideas?

Denis

 

[Devo]

This is how JDE does its pricing. Your Pricing UOM in BX, so it brings in the unit price defined in the F4106 based on BX, Your order is based on a transaction UOM of PA so when it calculates the extended Price, it takes into account the UOM Conversion between BX and PA (in this case it appears to be 20 PA = 1 BX). Your Net result on the invoice should still be correct.

 

[Devo]

On another note, your primary UOM should always be the lowest UOM that your would transact in. In your example, your primary UOM for TC10119 should be PA.

 

[deniko]

[ QUOTE ]
This is how JDE does its pricing.

[/ QUOTE ]

Hi Devo,

Thanks, I see. It seems to be kind of confusing though.