From the appendix of my book on Advanced Pricing:
Changing the Number of Decimals on Unit Price Fields
You probably are aware that the software comes delivered with 4 decimals on
all unit price fields. Some clients need to change the number of decimals
to 6 or even 7 to accommodate high volume/low unit price industries such as
Refined Fuels, Chemicals, and Grain.
JDE has a process in the software designed to help you change the number of
decimals.
The major difference between World and OneWorld is that only World has a
conversion routine to go into all the Master files and History files and
convert the data. OneWorld does not have this, which means you really need
to decide how many decimals you need before a lot of data is keyed into the
system.
The process is essentially the same as the process for changing decimals on
all quantity fields.
The list of fields to be converted includes all unit cost fields as well:
#APA
#ARC
#UCS
#UC1
#UC2
#UPC
#VA
#VAM
ACRD
ACST
AMC3
CSAX
CSTA
CSTL
CSTX
CST1
CST2
CST3
CW
CW01
CW02
CW03
CW04
CW04
CW05
CW06
CW07
CW08
CW09
CW10
CW11
CW12
CW13
CW14
FRC
FUC
FUP
FVR
FVTR
KUCS
LCST
LPRC
NCST
NPRC
OCST
OVLP
PAMT
PRIC
PRRC
RBTF
RERI
STDC
STDI
STD1
UNCS
UP
UPAS
UPAX
UPRC
XPRC
Additional Price fields that should be evaluated to see if they might need
to be converted, include:
AILP AsIfListPrice F42565
ARCOW ReceivedUnitCost P43230
BDCF BasedOnCostForeign F4575
BDCS BasedOnCost F4575
BURC UnitRateBestCost F5311
CSL StandardCostRollup F30026
CURQ UnitRateQuotedCost F5311
ESUNC EstUnitCost F31171
ESUNP EstUnitPay F31171
FUPC AmtPricePerUnitFor F1721
PRIF UnitPricePerPrimaryForeign F4812
PRRCE1 UnitCost P4310
SAPRRC SAAmountUnit F4311BF
UCSTR AmountUnitCostReceived P4312
Here are the steps to follow in converting the data items to a different
number of decimals.
1. Setup a data item category in the Data Dictionary called UNTAMT which
will
2. Assign all the above data items to a user defined category code table,
say 40/D6.
3. Run the Data Item Category Update – in the processing options identify
the UDC which holds the data items, and the Data Item Category, UNTAMT.
4. In World only, run the Data Item Conversion, program P40CVT.
For more documentation on OneWorld see the System Administration Manual,
Data Dictionary Administration, Updating Display Decimals section. This
documentation explains how to convert Quantity Decimals. The same steps
apply to Unit Price/Cost Decimals.
Make sure you do a full backup before doing any of these steps. Neither JDE
nor Klee Associates, Inc., can guarantee the above list of fields is 100%
complete or that the process will work flawlessly. Do this in a Test
environment, and test thoroughly before doing it in Production.
