Bug #509
BCA-DDA-UAT-C028
| Status: | Closed - End of life cycle | Start date: | October 05, 2010 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | October 27, 2010 | |
| Assignee: |  Sarinah Darsy | % Done: | 100% | |
| Category: | - | Spent time: | 8.00 hours | |
| Target version: | - |
Description
Daily & Monthly Consolidated Transaction Report:
1) Demand Draft with Foreign Currency KWD is not reflected in report (Text and CSV Format)
2) In Text Format: Alignment for no. of rec and amt column
3) In CSV Format:
- For Banker’s Cheque Application row: Shown invalid format for no. of rec. field
- For Demand Draft Application row: values are shown in invalid format
Note: Ensure to reflect the changes to Monthly Conso Trx Rpt as well.(Refer to sample screen attached for further details)History
#1
Updated by Sarinah Darsy almost 14 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 80
1) Demand Draft with Foreign Currency KWD is not reflected in report (Text and CSV Format) - need to check at the STG Server maybe there are no data at database table coz here there are Foreign Currency KWD in report.
2) In Text Format: Alignment for no. of rec and amt column - Done which the added the number of transaction type size
3) In CSV Format:
- For Banker’s Cheque Application row: Shown invalid format for no. of rec. field
- For Demand Draft Application row: values are shown in invalid format - Done
#2
Updated by Sarinah Darsy almost 14 years ago
1) Demand Draft with Foreign Currency KWD is not reflected in report (Text and CSV Format) - need to check at the STG Server maybe there are no data at database table coz here there are Foreign Currency KWD in report.
- Asked user (database admin - tahir) to get the data at database staging, and the result shows there is no currency of KWD listed in database. below is the results printed at staging database:
TO_CURRENCY
-----------
AUD
BHD
MYR
USD
XAU
So,it is not the coding issues.
#3
Updated by Sarinah Darsy almost 14 years ago
- Status changed from Development / Work In Progress to Work Completed-End life cycle
- % Done changed from 80 to 100
Done with modified the getCurrencyList() method query.
#4
Updated by Hafizudin MD almost 14 years ago
tested by hafiz
status ok
#5
Updated by Latipah Abdul Rashid almost 14 years ago
- Due date changed from October 07, 2010 to October 27, 2010
- Status changed from Work Completed-End life cycle to Development / Work In Progress
- % Done changed from 100 to 90
Chooi emailed:
Hi Darsy,
The reports are available for retrieval now. Thanks.
However, the Daily & Monthly Consolidated Transaction Report (csv & txt format) need further amendments:
- Only show the No. of Record for Demand Draft & Banker's Chq Application & may leave BLANK for all the values (amount).
#6
Updated by Sarinah Darsy almost 14 years ago
- Status changed from Development / Work In Progress to Work Completed-End life cycle
- Assignee changed from Sarinah Darsy to Hafizudin MD
- % Done changed from 90 to 100
Hafiz please retest this one. You can test it by login to BVMC as:
Username: ibReport01
password: report01
then click kt 'Content' tab > IB Report menu
and choose:
Report Type: Consolidated Transaction IB
check data for DAILY and MONTHLY
any enquiry please let me know.
Thanks.
#7
Updated by Hafizudin MD almost 14 years ago
- File MonthlyConsolidatedTransactionReport_MONTHLY_201009.csv
added - File MonthlyConsolidatedTransactionReport_MONTHLY_201009.txt added
tested by hafiz
status ok
#8
Updated by Hafizudin MD almost 14 years ago
- Assignee changed from Hafizudin MD to Sarinah Darsy
Assigned to darsy
#9
Updated by Sarinah Darsy almost 14 years ago
- Status changed from Work Completed-End life cycle to User Acceptance Test
Migrated to Staging server.
#10
Updated by Latipah Abdul Rashid almost 14 years ago
- Status changed from User Acceptance Test to Closed - End of life cycle
Issue closed by Chooi So Fun on 3/11/2010