jejik-mt940 icon indicating copy to clipboard operation
jejik-mt940 copied to clipboard

Empty transaction data for ABNAMRO

Open martijnderidder opened this issue 1 year ago • 5 comments

We are using your package to read the MT940 file a client is uploading. The client uses ABNAMRO. The account statements, opening, closing balances can be read.

But when we read the transactions we get the correct amount of transactions, but the transaction data is quite empty. The sample response would be something like this:

0 => Jejik\MT940\Statement {#1645 ▼
    -number: "2201/1"
    -account: Jejik\MT940\Account {#1728 ▶}
    -openingBalance: Jejik\MT940\Balance {#1643 ▶}
    -closingBalance: Jejik\MT940\Balance {#1646 ▶}
    -transactions: array:10 [▼
      0 => Jejik\MT940\Transaction {#1709 ▼
        -contraAccount: null
        -amount: 426.27
        -description: """
          /TRTP/SEPA OVERBOEKING/IBAN/NL70TRIO0123456789/BIC/TRIONL2U/NAME/
          TEST MT940 NAME CLIENT/REMI/FACTUURNUMMER 12345678/EREF/2024011
          9225235TRIONL2UXXXE000030076
          """
        -valueDate: DateTime @1705618800 {#1639 …1}
        -bookDate: DateTime @1705618800 {#1636 …1}
        -code: null
        -ref: null
        -bankRef: null
        -supplementaryDetails: null
        -gvc: null
        -txText: null
        -primanota: null
        -extCode: null
        -eref: null
        -bic: null
        -iban: null
        -accountHolder: null
        -kref: null
        -mref: null
        -cred: null
        -svwz: null
        -purp: null
        -debt: null
        -coam: null
        -oamt: null
        -abwa: null
        -abwe: null
      }
      1 => Jejik\MT940\Transaction {#1697 ▶}
      2 => Jejik\MT940\Transaction {#1714 ▶}
      3 => Jejik\MT940\Transaction {#1708 ▶}
      4 => Jejik\MT940\Transaction {#1703 ▶}
      5 => Jejik\MT940\Transaction {#1695 ▶}
      6 => Jejik\MT940\Transaction {#1729 ▶}
      7 => Jejik\MT940\Transaction {#1738 ▶}
      8 => Jejik\MT940\Transaction {#1741 ▶}
      9 => Jejik\MT940\Transaction {#1744 ▶}
    ]
  }

Why is all the transaction data empty? When we use getIBAN for example it response with an empty string.

If you want to try it with a demo ABNAMRO file, you can use this string below. Its different than we use, but it also gives back a empty transaction data.

ABNANL2A
940
ABNANL2A
:20:ABN AMRO BANK NV
:25:123456789
:28:13501/1
:60F:C120511EUR5138,61
:61:1205120514C500,01N654NONREF
:86:/TRTP/SEPA OVERBOEKING/IBAN/FR12345678901234/BIC/GEFRADAM
/NAME/QASD JGRED/REMI/Dit zijn de omschrijvingsregels/EREF/NOTPRO
VIDED
:62F:C120514EUR5638,62

martijnderidder avatar Jan 23 '24 10:01 martijnderidder