Closed

Invoice_tracking(JAVA related)

This project received 22 bids from talented freelancers with an average bid price of ₹577 INR / hour.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
₹400-₹750 INR / hour
Total Bids
22
Project Description

Complete invoice tracking, which means when payment is done we get corresponding response
message as XML from the third party tool which we use.
With the help of response where we paid certain amount using Debit/Credit card
If total amount paid for month of January 2014 is $10,000 [INVOICE_TOTAL_AMOUNT] from Invoice table and the amount paid now by customer by selecting partial payment radio button and edited amount for each dealer_Id or CFD Number is about $5000 [PAYMENT_MADE_TODAY] from Invoice_Tracking table. Initially [OUTSTANDING_BALANCE] from Invoice_Tracking table will be $0. After the payment is done successfully then the [OUTSTANDING_BALANCE] will be changed to $5000 (which means subtraction of INVOICE_TOTAL_AMOUNT and PAYMENT_MADE_TODAY).
In Invoice_Tracking table PAYMENT_MADE_TODAY is same as TRANSACTION_AMOUNT (from
Payment_Request table)

INVOICE_SEQ_ID will get from Invoice table for that particular INVOICE_TOTAL_AMOUNT.
PAYMENT_RESPONSE_SEQ_ID will get from the Payment_Response table for that particular
transaction
OUTSTANDING_BALANCE will be stored into Invoice_Tracking by doing calculation, see above for description CREATE_DATE is the system date when the records are saved into Invoice_Tracking CREATE_USER_ID is the system user_Id who logged into application, will get from LoggedInUser.
getUserId(), same we stored for both payment_request and payment_response tables.
(for each dealer_Id will have their own InvoiceNumber for each BillingPeriod)
All records to be saved into Invoice_Tracking table
Response from the Third party will be like this for both success and declined transaction
From the complete response I have taken only CTR section anyhow the complete response is in
XML format which will be stored in Payment_Response table as CLOB

Error CTR_SECTION
=========== TRANSACTION RECORD ==========
SOC DEMO0059
abc street
San Francisco, CA 90001
United States
TYPE: Purchase
ACCT: Unknown [url removed, login to view] -
CARD NUMBER : ############1881
DATE/TIME : 09 Aug 13 17:16:23
REFERENCE # : M
AUTHOR. # :
TRANS. REF. : FA146798

Transaction not completed

Please retain this copy for your records.
=========================================
Success CTR_SECTION
=========== TRANSACTION RECORD ==========
SOC DEMO0059
abc street
San Francisco, CA 90001
United States
TYPE: Purchase
ACCT: Visa $ [url removed, login to view] USD
CARD NUMBER : ############1881
DATE/TIME : 09 Aug 13 18:08:13
REFERENCE # : 000194 M
AUTHOR. # : ET143815
TRANS. REF. : FA146798
Approved - Thank You 100

SIGNATURE
------------------------------------
Please retain this copy for your records.
Cardholder will pay above amount to card
issuer pursuant to cardholder agreement.
=========================================

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online