Tuesday, January 15, 2008

Kelly Mode

kanina.. puchaa... sobrang dameng issue :(
me issue sa workflow.. na route s iba ung project costing id...
tapos meron p s journals n sobrang weird ayus n xa.. valid for posting..
n ung status pero pag click mo ung Post button..
bumabalik ung status s Not valid for posting :( ..

kaya sobrang taranta replicate data s dev...

update data back end...

update ako isang line...
tapos bat parang tagal mag run :(

eto ung SQL ko:
UPDATE PS_JRNL_LN
SET POSTED_BASE_AMT = 100,
FOREIGN_AMT = 100
WHERE JOURNAL_LN = 1


anong male??
tae nyo naman kung nde nyo napansin..
update nya lahat ng journals sa table..
nakalimuta ko lagay..
journal id, busines unit at journal date..

tae! auto commit p naman gamet namen tools :(
ooo WTF!!!... dev naman xa..
at admin gamet ko acct kaya walang makakahalata :)


bigla ko tuloy naisip..
ung pang aasar ko s nagawa ni Kelly s PS_EX_TRANS :P
at least dev lang na galaw ko...

0 comments:

ad