Customer profitability Report

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

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

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,

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

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

Hi all
I want to get the same information from ARCHIVE, Is It possible to use GET.CATEG.MONTH.ENTRIES?