Re[2]: Display decimal change in One World
Forgot configuration:
Xe SP13,
Enterprise : NT4/SP5 , MS-SQL7SP2
=============================
data have been entered?
=====================
1) First we ran Update Decimals UBE (Dec=2), and tested everything in DEV
environment with separated Data Dictionary. We made some tests and
have decided that system works with decimals>0
2) then there where written custom program (VBasic) which does following:
Goes through F98711 (Table columns), and for every line, which has <Table
name> (TDOBNM), <DD Alias> (TDOBND) and <SQLColumn>
(TDSQLC) looks to F9210 linked with F98711 by
F98711.FRDTAI=F9210.FRDTAI and checks if this <DD Alias> is in Class
(FRCLASS) "QTYINV". If Alias is in our class, proper Column in
Database table is updated (multiplied by 100 in our case).
Totally where about 230 tables and 1300 field which where updated.
Looks like this step was also successful.
IMHO, this algorithm is quite straightforward and should return correct
results (at least in theory
)
The one problem you can get is when your current quantities are
longer then 13 digits. In this case after conversion you'll get
quantity longer than 15 which is out of limits for QTYINV class.
Generally, if you don't need to convert Base Unit of Measures (Kgs to Tonns, for instance)
for existing items/transactions, game is
over, and you can repeat everything in Production. (After looooong testing, of course
3) The biggest fun begins when you decide to convert Base Unit of measures
for a just few thousands items.
In this case you can't uniquely identify tables/fields which needed to
be updated, because you also have to update Prices, Costs, and something
else.
Now is getting dark, and consultants are still thinking what fields
should be converted ....
sorry for my english which is far from ideal, but hope this can help.
Regards
Yaroslav
--------------------------
--------------------------