Because during 3-4 days ago, In EUP has a big problem comes from interface file that keep listed of billing are lost when send it to GCMS and coz of my unlucky, process team requests me to take care this problem, just only want to kid me - -" and then, we found that many thoundsand thoundsand dollar are lost coz a lot of billing are lost to send to GCMS in UK and next day, It's a priority 2 that high risk to business .... T_T
The root cause of problem after investigated with CoE, We found 1 standard program that use to created billing doc and then created accounting doc will commit all accounting doc after successfully created last accounting doc and normally company 0801 or tesco lotus in UK have a lot of created billing every day at 6:30 and first accounting doc started to create at 20:50 and last accounting doc finish created at 22:30 then call commit command to commit all data to database.
But schedule job run 1 problem program at 21:15 to download billing data into text file and GCMS continue to use this file later. At 21:50, whenever accounting document start to created but in this time, we can't select this data coz wait to commit into database. So, This day will interface another billing data that not include all billing that created in today - -".
The problem again is, In the next day, Program start to interface data again but will start to get billing data from holderfield that keep data come from combine date and time of last selected accounting document in yesterday. The problem is this value are happen after first accouting document of company 0801 created. It's mean all billing data between first created accounting document and accounting doc that entry date and time are less than holderfileld aren't interface to GCMS ..... ALL OF THIS BILLING HAVE A VALUE MORE THAN XXXXX$ that coming to be a very big problem that need to resolve it as fast as we can. T_T
Now, The solution to prevent lost billing by change standard program may be stop and let me clone new program for use to fixed lost billing data by down load data into text file and comment logic that related to YSI92. Nobody know about this have to change a lot of things T_T ... but now everything are complete. Just only to wait solution to resolve this probelm by create new 2 program, First for update downloaded billing into customize table and another is report inconsistncy data between last download and not download. - -"
Very sad to say ... still to change 2 program, this on and another one and 1 ticket wait to investigate - -" ... I HAVE YFDUML00 wa, shit and have a lot of problem. Borring when have a lot of job to do and everyone told only "Hurry na ja" - -"
Today. Takumi japaness restaurant are good whenever i paid it arround 530BTH for this dinner with my friend ^^
edit @ 31 May 2008 15:01:37 by Jusz't