User Tools

Site Tools


gl_-_bank_reconciliation

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
gl_-_bank_reconciliation [2019/08/26 13:40 (5 years ago)] – [OFX file Format] craiggl_-_bank_reconciliation [2019/08/26 13:42 (5 years ago)] (current) – [OFX file Format] craig
Line 43: Line 43:
     NEWFILEUID:NONE     NEWFILEUID:NONE
          
-    <OFX>\+    <OFX>
     <SIGNONMSGSRSV1>     <SIGNONMSGSRSV1>
-    <SONRS>\ +    <SONRS> 
-    <STATUS>\ +    <STATUS> 
-    <CODE>0\ +    <CODE>
-    <SEVERITY>INFO\ +    <SEVERITY>INFO 
-    <MESSAGE>OK\ +    <MESSAGE>OK 
-    </STATUS>\ +    </STATUS> 
-    <DTSERVER>20060404160753[-5:EST]\ +    <DTSERVER>20060404160753[-5:EST] 
-    <USERKEY>--NoUserKey--\ +    <USERKEY>--NoUserKey-- 
-    <LANGUAGE>ENG\ +    <LANGUAGE>ENG 
-    <INTU.BID>00002\ +    <INTU.BID>00002 
-    </SONRS>\ +    </SONRS> 
-    </SIGNONMSGSRSV1>\ +    </SIGNONMSGSRSV1> 
-    <BANKMSGSRSV1>\ +    <BANKMSGSRSV1> 
-    <STMTTRNRS>\ +    <STMTTRNRS> 
-    <TRNUID>QWEB - 200604041607537951\ +    <TRNUID>QWEB - 200604041607537951 
-    <STATUS>\ +    <STATUS> 
-    <CODE>0\ +    <CODE>
-    <SEVERITY>INFO\ +    <SEVERITY>INFO 
-    <MESSAGE>OK\''+    <MESSAGE>OK''
 </code> </code>
   * Here is a sample line out of the QFX file form CIBC   * Here is a sample line out of the QFX file form CIBC
Line 75: Line 75:
 === OFX files missing line breaks === === OFX files missing line breaks ===
 Some exports are missing the line breaks at the end of each tag. It looks like  Some exports are missing the line breaks at the end of each tag. It looks like 
-''<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>OK</STATUS>''+<code><OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>OK</STATUS></code>
 instead of instead of
-''  <OFX>+<code> 
 +  <OFX>
     <SIGNONMSGSRSV1>     <SIGNONMSGSRSV1>
     <SONRS>     <SONRS>
Line 84: Line 85:
     <SEVERITY>INFO     <SEVERITY>INFO
     <MESSAGE>OK     <MESSAGE>OK
-    </STATUS>''+    </STATUS> 
 +</code>    
 Here is how they can fix the file format. They can use the qfx for ofx file format.  Here is how they can fix the file format. They can use the qfx for ofx file format. 
  
gl_-_bank_reconciliation.txt · Last modified: 2019/08/26 13:42 (5 years ago) by craig