Manual Process

h1. EAccount Adjustment

h2. Steps

1. Format excel file to correct format

!eAccount_1.png!

2. Make sure amount format Not  comma(,) thousand  and 2 decimal

3. upload file to src-ecos

4. put the script /script/EAdjustment.sh

upward / downward

eg. upward :

#/usr/java/jdk/bin/java -classpath $CP eAccountUpwardAdjustment eacct_adj_list_TPM_03_01_2022_AutoPay_wani_up.xls 

eg. downward:

#/usr/java/jdk/bin/java -classpath $CP eAccountDownwardAdjustment eacct_adj_list_TPM_03_01_2022_AutoPay_wani_down.xls 

5. run script  /script/EAdjustment.sh

6. check db record in transaction table:

select * from TRANSACTION_032022 where TRX_CODE  = '2300' and TRX_DATE = '2022-03-03' and USER_ID = 'System'

7. compile record to new excel file.

8. check sum value is same :

select SUM(TRX_AMT_LOCAL) from TRANSACTION_032022 where TRX_CODE  = '2300' and TRX_DATE = '2022-03-03' and USER_ID = 'System'

!eAccount_2.png!

!eAccount_3.png!

9. check exception file at path:

/usr/ecosway/batches/src-ecos/eAccountAdjustment/

!eAccount_4.png!