Friday, November 23, 2012

TTUM Posting ( Salary Credit posting) in finacle


In Finacle when we have large no of transactions (Debit & Credit), we have option to post transaction  through TTUM, provided the list is made in text format or converted to text format in the sequence as follows 

( A text line of 181 character, only for SB and CD accounts)

 1. Account No: 0- 16, 16 digits (Left Justified) 

 2. Currency: 17-19, 3 digits (e.g.,INR Left Justified) 
 3. SOL ID: 20-27, 8 digits(Left Justified) 
 4. Transaction Type: 28-28, 1 digit (D for Debit or C for Credit) 
 5. Amount: 29-45 14,2 digit (14 nos before decimal, Right Justified) 
 6. Particular: 46-75, 30 
 7. Blank space: 76-181 At point 181 put a dot. 


The customer need to give Account no, Amount and Transaction Type in excel, Branch need to convert the excel file in required text format ). Copy this text file in C:\FINACLEUPLOAD, run FILETR and then TTUM



Menu : TTUM 
Transaction Type: BI
Upload file name  : Please enter . prn file
Action : T (Trial Posting) if Trail posting becomes successful  , then go for E/P (Entry/Posting ) 
Transaction Remark : Reference of the Transaction 
Rename input file after upload : if Y it will rename the file after upload , by default N

Sample Excel File is attached click here
You have to save the excel file as type Formatted Text file with extension .prn

16 comments:

  1. Is TTUM creater is available. If yes plz post the same

    ReplyDelete
  2. We are unable to see the sample excel file, since it doesn't open..... plz help.....

    ReplyDelete
  3. PLease upload the excel again Thanks

    ReplyDelete
  4. The link for sample file ask to upload our file first. Can you put direct link to open

    ReplyDelete
  5. please dont uplod//...

    ReplyDelete
  6. Please post downloadable link to prn file

    ReplyDelete
  7. Please Sir, provide us the sample excel sheet
    We would be very grateful, if you could help us with this sample sheet :)

    ReplyDelete
  8. This comment has been removed by the author.

    ReplyDelete
  9. How do we handle value date in TTUM?

    ReplyDelete
  10. https://www.facebook.com/download/807581555969363/salaryaug.xls

    https://www.facebook.com/download/1511449609112027/salaryaug.prn

    Please download the excel format and prn format as per the link mentioned above

    ReplyDelete
  11. How can we post loan installment using TTUM? Any help?

    ReplyDelete
  12. Simple format
    Column A acc num
    Column B d or c
    Column C remarks
    Column D optional (additional remarks)
    Column E amt
    Save as .csv format and upload in ttum

    ReplyDelete
  13. can u plz mail me one sample excel file . tarakkolkata1234@gmail.com

    ReplyDelete
  14. TTUM menu seen option is invalid or it is not available for user

    ReplyDelete
  15. how do I view the document posted using HTTUM? Kindly help.

    ReplyDelete

Posts Category wise :

      CBS Manual – Finacle Menus/ Commands for your ready reference

 

·         Huge Collection of 938 Finacle Menus

·         286 Selective Finacle Menu options

·         Category wise Commonly used Finacle Menus

·         Finacle Menu options/ Commands for Bank Auditors

·         Frequently used Function keys in Finacle

 

      Customer ID & Account Opening related Menu Options / Commands

 

·         Customer ID creation and Verification in Finacle by using CUMM menu

·         Customer ID creation in finacle in short by using CUMM menu

·         Changing Customer ID of a Customer

·         Account Opening (Savings/Current) in Finacle using menu option OAAC

·         Account opening in Finacle – in short

·         Frequently asked questions related to Customer ID  and Account Opening

 

      Demand Draft / Pay Order related Menu Options / Commands

 

·         Issuing a Demand Draft using Finacle Menu options TM

·         Issuing Multiple Demand Draft / PO using Finacle menu option TM

·         Printing Demand Draft / PO using menu option DDPRNT

·         Cancellation of Demand Draft  in Finacle using menu option DDC

·         Marking a Demand Draft Lost and issuing Duplicate DD

·         Inquiry and Reports finacle Menu related to Demand Draft

 

      Miscellaneous Finacle Menu Options / Commands

 

·         Standing Instruction Maintenance using Finacle Menu Options SIM.

·         Creating a Memo Pad in Finacle Part - I.

·         Creating a Memo Pad in Finacle Part - II.

·         Deleting Memo Pad in Finacle

·         Mass Transaction Posting in Finacle using Finacle Menu option TTUM.

·         Freezing & Unfreezing of accounts in finacle using Finacle Menu AFSM

·         Passbook Printing in Finacle

·         Finacle Teller Cash account Maintenance using Finacle Menu GECM

·         Finacle Menu option TM  for Transaction Posting and Maintenance