Support #11424

[SCP ID :##5674##] : To Generate Report For CRM User

Added by Zahir Abd Latif almost 4 years ago. Updated over 3 years ago.

Status:Work Completed-End life cycleStart date:February 16, 2021
Priority:NormalDue date:February 19, 2021
Assignee:Zahir Abd Latif% Done:

100%

Category:-Spent time:-
Target version:-

Description

Hi,
Kindly attend below request:-

CRM user request monthly Ebiz data for each type of transaction Eg: Auto Credit/ Auto Debit.

For the format can refer to the file attached. This report will be generated on the 1st day of each month.

*Other 2 files cannot be uploaded because it exceeds the maximum allowed file size (5 MB)s = refer SCP email

16/02/2021
Email: CRM file output to include option to change date

Assalamualaikum Najmi,

Based on our conversation yesterday regarding on scp 5674 – To generate report for CRM user, seeking your kind help to add option to manually change date of report extraction
In the program. This is in order to generate report for the past few month.

Thank you,
Mohamad Khairul Firas

800_IBG.xlsx (3.22 MB) Zahir Abd Latif, December 08, 2020 16:02

700_IBG.xlsx (49.1 KB) Zahir Abd Latif, December 08, 2020 16:02

All AG Organisation.xlsx (13.5 KB) Zahir Abd Latif, December 08, 2020 16:02

All_eBiz_Organizations.xlsx (503 KB) Zahir Abd Latif, December 08, 2020 16:02

setting.png (29.1 KB) Najmi Pasarudin, February 03, 2021 12:17

settingproperties CRM.jpg (208 KB) Nurul Athira Abdul Rahim, February 03, 2021 15:44

CRM report.jpg (139 KB) Nurul Athira Abdul Rahim, February 03, 2021 15:44

setting.png - new setting 18/02/2021 (33.7 KB) Najmi Pasarudin, February 18, 2021 18:01

History

#1 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin
  • Start date changed from December 08, 2020 to January 18, 2021

#2 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress

#3 Updated by Najmi Pasarudin over 3 years ago

  • % Done changed from 0 to 20

#4 Updated by Najmi Pasarudin over 3 years ago

  • Due date set to February 02, 2021

#5 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • % Done changed from 20 to 90

#6 Updated by Najmi Pasarudin over 3 years ago

  • File setting.png added
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim
  1. Access 10.10.55.226 or sacda 951
  2. Update setting /batch/BSN/BatchJobSIT/setting.properties according screenshot attached
  3. Check /batch/BSN/BatchFilesSIT/CRMReport

#7 Updated by Nurul Athira Abdul Rahim over 3 years ago

Tested and passed

1. Update date and time at /batch/BSN/BatchJobSIT/setting.properties
2. View report at CMRReport

#8 Updated by Najmi Pasarudin over 3 years ago

  • Description updated (diff)

#9 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • Due date changed from February 02, 2021 to February 19, 2021
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin
  • Start date changed from January 18, 2021 to January 16, 2021

#10 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • Start date changed from January 16, 2021 to February 16, 2021

#11 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • Status changed from System Integration Test to Development / Work In Progress

#12 Updated by Najmi Pasarudin over 3 years ago

  • File setting.png added

Update setting file to generate multiple reports based on month(s) prior.
Update attachment setting.png

#13 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim
Updates:
  1. Add parameter crmMonth
  2. If set to crmMonth=6, will generate reports for the previous 6 months
  3. Update report name to include year and month

#14 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Internal Testing to Development / Work In Progress
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

#15 Updated by Najmi Pasarudin over 3 years ago

  • File deleted (setting.png)

#16 Updated by Najmi Pasarudin over 3 years ago

#17 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Development / Work In Progress to Pending Prod Deployment

#18 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Pending Prod Deployment to Pending Review
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim

Deployed to production on 23/02/2021

#19 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • Status changed from Pending Review to Work Completed-End life cycle
  • Assignee changed from Nurul Athira Abdul Rahim to Zahir Abd Latif
  • % Done changed from 90 to 100

Also available in: Atom PDF