Bond Amortization and the Generic Transaction Interface

[dlevy]

I'm trying to import bond amortizations through the Generic Transaction Interface.

To verify the how to code it, I did a bond amortization through the FM UI and did a generic file export. The amortization created two transactions:

[symbol] [date] DIST-4 -100.00 0 0 # records as amortization
[symbol] [date] DIST-R 100.00 0 0 # records as return of capital

So, I followed these as models in formatting data exported from another portfolio management package. The DIST-R transaction imported correctly. The DIST-4 did not import at all.

My format string is SYMB,ED,TRAN,ANUM,BNUM,CNUM

Sample data:

544644QL4,20090701,DIST_4,-46.63,0,0
544644QL4,20090701,DIST_R,46.63,0,0

I note that the documentation for the generic file import (http://www.fundmanagersoftware.com/help ... neric.html)
does not document the DIST-4 transaction, but mentions only user-defined DIST-1 and DIST-2.

Should I be able to import a DIST-4 transaction?

Am I doing something else wrong?

With thanks,

David

[Mark]

Hi David,

That looks like a bug in the generic export. We used to have 4 user-defined distribution types, but the last 2 were changed to be used for accretion and amortization. Change DIST_4 to DIST_T, and then that should import properly. (DIST_3 should be DIST_A for accretion)

[dlevy]

Yes!

That works perfectly.

Thanks, Mark!

David