×
Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…
Customer profitability Report
- Pranav
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 31
- Thank you received: 1
12 years 3 months ago #12476
by Pranav
Customer profitability Report was created by Pranav
Dear Friends,
I'm looking for Customer profitability report, where you can view total income earned from particular customer by PL category wise for defined period.
If you have developed such report, request you to share.
Else, how can we extract record efficiently from CATEG.ENTRY.DETAIL for particular customer by PL category wise for defined period.
Regards,
Pranav
I'm looking for Customer profitability report, where you can view total income earned from particular customer by PL category wise for defined period.
If you have developed such report, request you to share.
Else, how can we extract record efficiently from CATEG.ENTRY.DETAIL for particular customer by PL category wise for defined period.
Regards,
Pranav
Please Log in or Create an account to join the conversation.
- faisal
- Offline
- New Member
Less
More
- Posts: 18
- Thank you received: 4
12 years 2 months ago #12936
by faisal
Replied by faisal on topic Customer profitability Report
Hi,
Please use routine 'GET.CATEG.MONTH.ENTRIES' to get all the entries posted to a specific PL Category. No need to perform select on CATEG.ENTRY.DETAIL or CATEG.ENTRY.
CALL GET.CATEG.MONTH.ENTRIES(FROM.DATE,TO.DATE,CATEG.ID,YR.ENTRY.FILE)
For consolidated entries use CATEG.ENTRY.DETAIL.XREF table, it contains all IDs of CATEG.ENTRY.DETAIL.
Thanks
Please use routine 'GET.CATEG.MONTH.ENTRIES' to get all the entries posted to a specific PL Category. No need to perform select on CATEG.ENTRY.DETAIL or CATEG.ENTRY.
CALL GET.CATEG.MONTH.ENTRIES(FROM.DATE,TO.DATE,CATEG.ID,YR.ENTRY.FILE)
For consolidated entries use CATEG.ENTRY.DETAIL.XREF table, it contains all IDs of CATEG.ENTRY.DETAIL.
Thanks
Please Log in or Create an account to join the conversation.
- nirmal.mcc
- Offline
- Junior Member
Less
More
- Posts: 23
- Thank you received: 3
12 years 2 months ago #12937
by nirmal.mcc
Replied by nirmal.mcc on topic Customer profitability Report
Hi Pranav,
Answering to your query, we can create one local enquiry which should have 4 selection criteria, CUSTOMER.ID, DATE.FROM , DATE.TO, PL.CATEGORY. This will select CATEG.ENTRY and its detail file and print it as a report using ENQUIRY.REPORT application.
To check the same manually from jbase you can check the below command to cross check the result.
LIST FBNK.CATEG.ENTRY WITH CUSTOMER.ID EQ <<CUSTOMER.ID>> AND BOOKING.DATE GE <<START.RANGE>> AND BOOKING.DATE LE <<END.RANGE>> TOTAL AMOUNT.LCY BOOKING.DATE BY.DSND BOOKING.DATE
EXAMPLE RESULT:
@ID.................... AMOUNT.LCY......... BOOKING.DATE
160893101636793.110001 -85.2 20120103
160893101636795.080001 -583.33 20120103
160893101636795.090001 -583.34 20120103
160893101636796.110001 -134.94 20120103
160893101636799.050001 97.16 20120103
160893101636799.110001 240.19 20120103
160893101636799.120001 -485.78 20120103
160893101636799.150001 -170.41 20120103
160893101636878.010001 365612.67 20120103
160893101636878.010002 -365754.83 20120103
160893101636880.070001 3132.93 20120103
160893101636880.070002 -3413.73 20120103
160893101636880.120001 244958.69 20120103
160893101636880.120002 -244745.40 20120103
160893101636881.060001 18972.67 20120103
160893101636881.060002 -18890.76 20120103
160893101636881.120001 375586.36 20120103
160893101636881.120002 -375724.77 20120103
160893101637472.110001 -327.19 20120103
===================
*** -204702.77
The same list is applicable for detail file also. There are some core enquiries available for CATEG.ENTRY too like CATEG.ENT.BOOK etc., you can use the same and modify the report as per your requirement.
Hope this helps.
Regards,
Answering to your query, we can create one local enquiry which should have 4 selection criteria, CUSTOMER.ID, DATE.FROM , DATE.TO, PL.CATEGORY. This will select CATEG.ENTRY and its detail file and print it as a report using ENQUIRY.REPORT application.
To check the same manually from jbase you can check the below command to cross check the result.
LIST FBNK.CATEG.ENTRY WITH CUSTOMER.ID EQ <<CUSTOMER.ID>> AND BOOKING.DATE GE <<START.RANGE>> AND BOOKING.DATE LE <<END.RANGE>> TOTAL AMOUNT.LCY BOOKING.DATE BY.DSND BOOKING.DATE
EXAMPLE RESULT:
@ID.................... AMOUNT.LCY......... BOOKING.DATE
160893101636793.110001 -85.2 20120103
160893101636795.080001 -583.33 20120103
160893101636795.090001 -583.34 20120103
160893101636796.110001 -134.94 20120103
160893101636799.050001 97.16 20120103
160893101636799.110001 240.19 20120103
160893101636799.120001 -485.78 20120103
160893101636799.150001 -170.41 20120103
160893101636878.010001 365612.67 20120103
160893101636878.010002 -365754.83 20120103
160893101636880.070001 3132.93 20120103
160893101636880.070002 -3413.73 20120103
160893101636880.120001 244958.69 20120103
160893101636880.120002 -244745.40 20120103
160893101636881.060001 18972.67 20120103
160893101636881.060002 -18890.76 20120103
160893101636881.120001 375586.36 20120103
160893101636881.120002 -375724.77 20120103
160893101637472.110001 -327.19 20120103
===================
*** -204702.77
The same list is applicable for detail file also. There are some core enquiries available for CATEG.ENTRY too like CATEG.ENT.BOOK etc., you can use the same and modify the report as per your requirement.
Hope this helps.
Regards,
Please Log in or Create an account to join the conversation.
- Pranav
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 31
- Thank you received: 1
12 years 1 month ago #12966
by Pranav
Replied by Pranav on topic Customer profitability Report
Hi Faisal,
As per your suggestion, if we used GET.CATEG.MONTH.ENTRIES, how we can filter income booked of particular customer. As per the given parameter we can extract the record based on PL Category wise only but I'm looking all income booked for particular customer for given time period.
I'm trying to make report like below.
eg. customer.id 444 From 20120101 to 20120630
Category Income
1001 (OD) 2,34,567.00
21055 LD 55,567.00
21053 LD 60,789.00
52009 Fee 15,000.00
52080 Service Chg 45,000.00
Expecting your help.
Regards,
Pranav
As per your suggestion, if we used GET.CATEG.MONTH.ENTRIES, how we can filter income booked of particular customer. As per the given parameter we can extract the record based on PL Category wise only but I'm looking all income booked for particular customer for given time period.
I'm trying to make report like below.
eg. customer.id 444 From 20120101 to 20120630
Category Income
1001 (OD) 2,34,567.00
21055 LD 55,567.00
21053 LD 60,789.00
52009 Fee 15,000.00
52080 Service Chg 45,000.00
Expecting your help.
Regards,
Pranav
Please Log in or Create an account to join the conversation.
- faisal
- Offline
- New Member
Less
More
- Posts: 18
- Thank you received: 4
12 years 1 month ago #12967
by faisal
Replied by faisal on topic Customer profitability Report
Hi,
CUSTOMER.ID is available in CATEG.ENTRY file you will have to sort entries manually in your routine.
Also there is an enquiry available in the system MB.LIAB, you can get most of the details as per your requirement through this enquiry like LD details, account details, OD limits etc.
For the PL categories, you can develop a local template where you will mention all the PL categories like u mentioned 52009 (Fee) etc and process thorough your routine.
Thanks
CUSTOMER.ID is available in CATEG.ENTRY file you will have to sort entries manually in your routine.
Also there is an enquiry available in the system MB.LIAB, you can get most of the details as per your requirement through this enquiry like LD details, account details, OD limits etc.
For the PL categories, you can develop a local template where you will mention all the PL categories like u mentioned 52009 (Fee) etc and process thorough your routine.
Thanks
Please Log in or Create an account to join the conversation.
- DMACHINE
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 0
1 year 1 week ago #24327
by DMACHINE
Replied by DMACHINE on topic Customer profitability Report
Hi all
I want to get the same information from ARCHIVE, Is It possible to use GET.CATEG.MONTH.ENTRIES?
I want to get the same information from ARCHIVE, Is It possible to use GET.CATEG.MONTH.ENTRIES?
Please Log in or Create an account to join the conversation.
Time to create page: 0.090 seconds