Topic: Credit Card Transaction from AMEX USing OFX
Hi guys
this is vineet sharma.
i m working on a project where i supposed to download all the expenses against an employee credit card, for that i did code (http://www.ofxhome.com/ofxforum/viewtopic.php?id=47461]) and i m also having the Expense detail. but the problem is that i am not able to filter response against the Employee, the response having record against the bank account only
this is my Request format
================================================
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>
20140630184035<USERID>
My User Name<USERPASS>
password <LANGUAGE>
ENG
<FI>
<ORG>
AMEX<FID>3101</FI>
<APPID>
QWIN
<APPVER>1700
</SONRQ>
</SIGNONMSGSRQV1>
<CREDITCARDMSGSRQV1>
<CCSTMTTRNRQ>
<TRNUID>
2d3e98138e80bf176240c950cbf04730<CCSTMTRQ>
<CCACCTFROM>
<ACCTID>3************5</CCACCTFROM>
<INCTRAN>
<DTSTART>
20140616160507<DTEND>
20140617160507<INCLUDE>Y
</INCTRAN>
</CCSTMTRQ>
</CCSTMTTRNRQ>
</CREDITCARDMSGSRQV1>
</OFX>
====================================
and the Response is
===========================================================
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>
0<SEVERITY>
INFO<MESSAGE>Login successful</STATUS>
<DTSERVER>
20140630074901.879[-7:MST]<LANGUAGE>
ENG<FI>
<ORG>
AMEX<FID>3101</FI><ORIGIN.ID>
FMPWeb<CUSTOMER.TYPE>
BCM<START.TIME>20140630074901</SONRS>
</SIGNONMSGSRSV1>
<CREDITCARDMSGSRSV1>
<CCSTMTTRNRS>
<TRNUID>
****************************<STATUS>
<CODE>
0<SEVERITY>INFO</STATUS><CCSTMTRS>
<CURDEF>
USD<CCACCTFROM>
<ACCTID>3**************5
</CCACCTFROM><BANKTRANLIST>
<DTSTART>
20140616050000.000[-7:MST]<DTEND>
20140617050000.000[-7:MST]<STMTTRN>
<TRNTYPE>
DEBIT<DTPOSTED>
20140609000000.000[-7:MST]<TRNAMT>
-395<FITID>
320***************74<REFNUM>
320**************74<NAME>
LIONESS LEARNING 520000 <MEMO>00042742 MGMT/CONSULTING/PR</STMTTRN>
<STMTTRN>
<TRNTYPE>
DEBIT<DTPOSTED>
20140616000000.000[-7:MST]<TRNAMT>
-269.97<FITID>
320***************74<REFNUM>
320**************74<NAME>
GODADDY.COM (480)505-88<MEMO>700507157 (480)505-8855</STMTTRN>
</BANKTRANLIST><LEDGERBAL>
<BALAMT>
-9975.89<DTASOF>20140630050000.000[-7:MST]</LEDGERBAL><CYCLECUT.INDICATOR>
false<PURGE.INDICATOR>
false<INTL.INDICATOR>false</CCSTMTRS>
</CCSTMTTRNRS>
</CREDITCARDMSGSRSV1>
</OFX>
at the same if i download the transaction statement from AMEX directly the same ofx is generated but as a quickbook format i am getting employee name concatenated in the MEMO text
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>
0<SEVERITY>
INFO<MESSAGE>Login successful</STATUS>
<DTSERVER>
20140630235349.788[-7:MST]<LANGUAGE>
ENG<FI>
<ORG>
AMEX<FID>3106</FI>
<ORIGIN.ID>FMPWeb
<INTU.BID>3106<START.TIME>
20140630235349
<INTU.USERID>UserName</SONRS>
</SIGNONMSGSRSV1>
<CREDITCARDMSGSRSV1>
<CCSTMTTRNRS>
<TRNUID>
0<STATUS>
<CODE>
0<SEVERITY>INFO</STATUS><CCSTMTRS>
<CURDEF>
USD<CCACCTFROM>
<ACCTID>
37**********2<DOWNLOAD.FLAG>
true<DOWNLOAD.TYPE>
downloadDates<AMEX.BASICACCT>
37***********2<AMEX.ROLE>
B<AMEX.UNIVID>2d3e98138e80bf176240c950cbf04730</CCACCTFROM><BANKTRANLIST>
<DTSTART>
20140604050000.000[-7:MST]<DTEND>
20140630050000.000[-7:MST]<STMTTRN>
<TRNTYPE>
DEBIT<DTPOSTED>
20140604000000.000[-7:MST]<TRNAMT>
-99<FITID>
320********60<REFNUM>
320*********960<NAME>
LOGMEIN 888-326-264
<MEMO> Employee Name-11045-VTYCBEDB6AB SOFTWARE</STMTTRN>
</BANKTRANLIST><LEDGERBAL>
<BALAMT>
-1****.21<DTASOF>20140630050000.000[-7:MST]</LEDGERBAL><CYCLECUT.INDICATOR>
false<PURGE.INDICATOR>
false<INTL.INDICATOR>false</CCSTMTRS>
</CCSTMTTRNRS>
</CREDITCARDMSGSRSV1>
</OFX>
so please guys any one can give me any guidance how can i get it