[GNC] Fidelity NetBenefits DirectConnect Reports "No Transactions" but contents imports fine

[Matt Corallo]

After a bit of brute force attempts, I finally figured out the correct settings[1] for Fidelity 
NetBenefits (a very large 401k provider in the US) OFX DirectConnect access, and AQOFX_LOG_COMM 
shows receipt of a valid OFX response with transactions. However, after the reply comes in, GNUCash 
gives a generic "The Online Banking import returned no transactions for the selected time period". 
Strangely, the reply as shown in /tmp/ofx.log *does* have transactions in it, and if I copy/paste 
the response into a .ofx file GNUCash happily imports the relevant transactions correctly.

A sample OFX response follows (with non-public information replaced with $*).

<OFX><SIGNONMSGSRSV1> <SONRS> 
<STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20220123211901.176[-5:EST]<LANGUAGE>ENG<FI><ORG>nbofx.fidelity.com<FID>8288</FI></SONRS></SIGNONMSGSRSV1><INVSTMTMSGSRSV1> 
<INVSTMTTRNRS><TRNUID>$UUID 
<STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><INVSTMTRS><DTASOF>20220123191901.546[-5:EST]<CURDEF>USD<INVACCTFROM><BROKERID>nbofx.fidelity.com<ACCTID>$ACCOUNT_ID</INVACCTFROM> 
<INVTRANLIST><DTSTART>20211201000000.000[-5:EST]<DTEND>20220121000000.000[-5:EST]<BUYMF><INVBUY><INVTRAN><FITID>20220114OFVH011<DTTRADE>20220114070000.000[-5:EST]<MEMO>CONTRIBUTION;VANGUARD 
INST INDEX OFVH;as of 
01/14/2022</INVTRAN><SECID><UNIQUEID>OFVH<UNIQUEIDTYPE>CUSIP</SECID><UNITS>$BUY_QUANTITY<UNITPRICE>397.2<TOTAL>$BUY_PRICE<SUBACCTSEC>OTHER<SUBACCTFUND>OTHER</INVBUY><BUYTYPE>BUY 
    </BUYMF><REINVEST> 
<INVTRAN><FITID>20211229OFVH021<DTTRADE>20211229070000.000[-5:EST]<MEMO>DIVIDEND;VANGUARD INST INDEX 
OFVH;as of 
12/29/2021</INVTRAN><SECID><UNIQUEID>OFVH<UNIQUEIDTYPE>CUSIP</SECID><INCOMETYPE>DIV<TOTAL>$AMOUNT<SUBACCTSEC>OTHER<UNITS>$SHARE_UNITS<UNITPRICE>408.02 
    </REINVEST></INVTRANLIST> 
<INVPOSLIST><POSMF><INVPOS><SECID><UNIQUEID>OFVH<UNIQUEIDTYPE>CUSIP</SECID><HELDINACCT>OTHER<POSTYPE>LONG<UNITS>$CURRENT_BALANCE<UNITPRICE>374.6800000<MKTVAL>$ACCOUNT_VALUE 
   <DTPRICEASOF>20220121160000.000[-5:EST]   <MEMO>Market close as of 01/21/2022;VANGUARD INST 
INDEX</INVPOS></POSMF></INVPOSLIST> 
<INVBAL><AVAILCASH>0<MARGINBALANCE>0<SHORTBALANCE>0<BALLIST><BAL><NAME>MarketValue<DESC>MarketValue<BALTYPE>DOLLAR<VALUE>$ACCOUNT_VALUE<DTASOF>20220123191901.546[-5:EST]</BAL><BAL><NAME>VestedValue<DESC>VestedValue<BALTYPE>DOLLAR<VALUE>$ACCOUNT_VALUE<DTASOF>20220123191901.546[-5:EST]</BAL><BAL><NAME>TotalAssetsValue<DESC>TotalAssetsValue<BALTYPE>DOLLAR<VALUE>$ACCOUNT_VALUE<DTASOF>20220123191901.546[-5:EST]</BAL></BALLIST></INVBAL></INVSTMTRS></INVSTMTTRNRS></INVSTMTMSGSRSV1> 
<SECLISTMSGSRSV1><SECLIST><MFINFO><SECINFO><SECID><UNIQUEID>OFVH<UNIQUEIDTYPE>CUSIP</SECID><SECNAME>VANGUARD 
INST INDEX<FIID>OFVH<UNITPRICE>374.6800000<DTASOF>20220121160000.000[-5:EST]<MEMO>Market close as of 
01/21/2022;VANGUARD INST INDEX</SECINFO><MFTYPE>OTHER</MFINFO></SECLIST></SECLISTMSGSRSV1></OFX>


Matt


[1] Settings Provided here for posterity:
     Broker ID: nbofx.fidelity.com,
     FID: 8288
     Org: nbofx.fidelity.com
     URL: https://nbofx.fidelity.com/netbenefits/ofx/download
     HTTP UA (may be unnecessary): ofxtools
     Send Empty Bank Id
     Account Type: Investment Account

     Watch the reply log - Fidelity likes to say "Invalid date range", try at least a month of data 
and only up to the previous business day instead of today.