Downloaded stock transaction has wrong category (security)

travelbird2's Avatar

travelbird2

07 Apr, 2020 04:55 PM

When I download a stock dividend transaction the category(security) is wrong. The stock is Royal Caribbean (RCL) with a CUSIP of V7780T103. In the Edit Security dialog box the Security ID: was blank even though I have put the CUSIP in before. I re-entered the CUSIP, deleted the downloaded transaction, then re-downloaded the transaction but it continues to have the wrong category (security). I have had this problem for the last three quarters.

Moneydance version 2019.4 (1904), Windows 10, Version 2004, build 19852.1001

Here is the transaction details:

0.acctid: 5573f0ac-0a8f-462d-b1b2-43ea3014e79a
0.desc: ROYAL CARIBBEAN CRUISE F
0.id: c6663dd9-909b-4c8d-bb8e-c21ea511d7f2
0.invest.splittype: sec
0.obj_type:
0.pamt: 0
0.samt: 0
1.acctid: ba331b56-d0ca-4d1f-87eb-e2434230bac7
1.desc: ROYAL CARIBBEAN CRUISE F
1.id: 618b5fe7-46ad-4f24-b009-f28299eb38ef
1.invest.splittype: inc
1.obj_type:
1.pamt: ****
1.samt: -****
acctid: 284ea494-b658-47a8-b2a7-c7a2dd85645e
chk:
desc: ROYAL CARIBBEAN CRUISE F
dt: 20200406
dtentered: 1586276572033
id: 87e54c18-382a-428d-b3d2-a4a0702866a6
invest.txntype: div
memo: ROYAL CARIBBEAN CRUISE F
obj_type: txn
ol.match-status: y
ol.match-type: 0
ol.orig-memo: ROYAL CARIBBEAN CRUISE F
ol.orig-payee: ROYAL CARIBBEAN CRUISE F
ol.orig-txn: {
  "invst.subaccttype" = "CASH"
  "invst.subaccfund" = "CASH"
  "dtinit-int" = "20200406"
  "invst.txntype" = "miscinc"
  "invst.taxexempt" = "0"
  "orig_data" = "<INCOME>
<INVTRAN>
<FITID>160480882020040612000020200406165830171218787
<DTTRADE>20200406120000
<MEMO>ROYAL CARIBBEAN CRUISE F
</INVTRAN>
<SECID>
<UNIQUEID>V7780T103
<UNIQUEIDTYPE>CUSIP
</SECID>
<INCOMETYPE>DIV
<TOTAL>****
<SUBACCTSEC>CASH
<SUBACCTFUND>CASH
</INCOME>
"
  "fitxnid" = "160480882020040612000020200406165830171218787"
  "invst.ofxtxntype" = "INCOME"
  "fi_id" = "ofx:Intuit:8888"
  "invst.securityidtype" = "CUSIP-broken"
  "invst.securityid" = "V7780T103"
  "memo" = "ROYAL CARIBBEAN CRUISE F"
  "invst.withholding" = "0"
  "invst.totalamt" = "****"
  "invst.inctype" = "DIV"
}

ol_fi_id: ofx:Intuit:8888
ol_fitid_1: 160480882020040612000020200406165830171218787
oldid: -1
reinvest: false
td: 20200406
ts: 1586276572033
xfer_type: xfrtp_dividend

  1. 1 Posted by travelbird2 on 09 Apr, 2020 03:13 PM

    travelbird2's Avatar

    Found this python script to reset the CUSIP for the security that had a mismatched CUSIP.

    https://github.com/finitemobius/moneydance-py
    The issue is now resolved.

  2. travelbird2 closed this discussion on 09 Apr, 2020 03:13 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac