Transactions still to be matched (010)

Browse code 010 (BrowseCode::TransactionsToBeMatched, “Nog af te letteren boekingen”): transaction lines on accounts with matching, such as suspense accounts, that are not matched yet.

Twinfield documentation: Browse data.

• equal('fin.trs.line.matchstatus', 'available'): lines that can still be matched; Twinfield proposes this criterion. The values of the match status are notmatchable, available, proposed and matched (see List browse fields).
• fin.trs.line.openbasevaluesigned: the amount that is still open, in the base currency.
• between('fin.trs.head.yearperiod', '2000/00', …): all years up to the last one. Status is not a criterion in 010.

Criteria: period, general ledger account, day book, number, match status and regime. See browse-definitions/010.xml and the browse data guide. For open items of customers and suppliers use 100 and 200.

Fields

All fields of the browse definition (browse-definitions/010.xml), with the label for a Dutch user, the data type and the values of a field with a fixed list (browsefields.xml). A field that is not visible is meant as criterion: asking for it as column can give a server error. Twinfield does not apply the proposed values: send every criterion you need.

Field	Label	Type	Visible	Criterion
fin.trs.head.yearperiod	Periode	string	yes	between (proposed $DEFAULT$ … $DEFAULT$)
fin.trs.line.dim1	Grootboek	string	yes	between
fin.trs.line.dim1name	Naam	string	yes
fin.trs.head.code	Dagboek	string	yes	equal
fin.trs.head.shortname	Naam	string	yes
fin.trs.head.number	Boekst.nr.	decimal	yes	between
fin.trs.head.curcode	Valuta	string	no
fin.trs.line.valuesigned	Bedrag	value	no
fin.trs.line.basevaluesigned	Euro	value	yes
fin.trs.line.openbasevaluesigned	Openstaand bedrag	value	yes
fin.trs.line.matchstatus	Betaalstatus	special: notmatchable, available, proposed, matched	yes	equal (proposed available)
fin.trs.head.status	Status	special: draft, temporary, final, inuse, normal	no
fin.trs.head.browseregime	Regime	special: Generic, Commercial, Economic, Fiscal	yes	equal

Code

$twinfield = Example::twinfield();

$year = (int) ($argv[1] ?? Example::lastYear($twinfield));

$result = $twinfield->browse(BrowseCode::TransactionsToBeMatched)
    ->columns(
        'fin.trs.line.dim1',
        'fin.trs.head.code',
        'fin.trs.head.number',
        'fin.trs.line.basevaluesigned',
        'fin.trs.line.openbasevaluesigned',
        'fin.trs.line.matchstatus',
    )
    ->between('fin.trs.head.yearperiod', '2000/00', sprintf('%d/55', $year))
    ->equal('fin.trs.line.matchstatus', 'available')
    ->get();

echo count($result), ' line(s) still to be matched up to ', $year, PHP_EOL;

foreach ($result as $index => $row) {
    echo sprintf(
        '[%d/%d] %s %s %d: %s, open %s (%s)',
        $index + 1,
        count($result),
        $row->string('fin.trs.line.dim1'),
        $row->string('fin.trs.head.code'),
        $row->int('fin.trs.head.number'),
        $row->amount('fin.trs.line.basevaluesigned'),
        $row->amount('fin.trs.line.openbasevaluesigned'),
        $row->displayName('fin.trs.line.matchstatus') ?? $row->string('fin.trs.line.matchstatus'),
    ), PHP_EOL;
}

Run

php examples/browse-data/010-transactions-to-be-matched/example.php         # up to the last year
php examples/browse-data/010-transactions-to-be-matched/example.php 2024    # up to 2024

Add TWINFIELD_DEBUG=1 to see the SOAP requests and responses.

120 line(s) still to be matched up to 2025
[1/120] 17018 ACTIVA 202200008: -135983.00, open -135983.00 (Beschikbaar)
[2/120] 17018 ACTIVA 202200010: -135983.00, open -135983.00 (Beschikbaar)
[3/120] 17018 ACTIVA 202200011: 135983.00, open 135983.00 (Beschikbaar)
[4/120] 17018 ACTIVA 202200012: -122200.00, open -122200.00 (Beschikbaar)
…
[120/120] 16615 VRK_PIN 202200001: -17.36, open -17.36 (Beschikbaar)

XML

What the SDK sends to Twinfield and what Twinfield sends back, for a call like the one in this example. The responses come from the tests, with example data.

Compose the browse request and send it

Twinfield documentation: Browse data: Compose the browse request and send it.

$twinfield->browse(BrowseCode::TransactionsToBeMatched)
    ->columns(
        'fin.trs.line.dim1',
        'fin.trs.head.code',
        'fin.trs.head.number',
        'fin.trs.line.basevaluesigned',
        'fin.trs.line.openbasevaluesigned',
        'fin.trs.line.matchstatus',
    )
    ->between('fin.trs.head.yearperiod', '2000/00', '2026/55')
    ->equal('fin.trs.line.matchstatus', 'available')
    ->get();

The SDK sends this XML as xmlRequest of ProcessXmlString to processxml.asmx:

<columns code="010" optimize="true">
  <column>
    <field>fin.trs.line.dim1</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.head.code</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.head.number</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.line.basevaluesigned</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.line.openbasevaluesigned</field>
    <visible>true</visible>
  </column>
  <column>
    <field>fin.trs.line.matchstatus</field>
    <visible>true</visible>
    <operator>equal</operator>
    <from>available</from>
  </column>
  <column>
    <field>fin.trs.head.yearperiod</field>
    <operator>between</operator>
    <from>2000/00</from>
    <to>2026/55</to>
  </column>
</columns>

Twinfield answers with this XML in ProcessXmlStringResult:

<browse result="1" first="1" last="2" total="2">
  <th>
    <td label="" hideforuser="false" type="String">fin.trs.line.dim1</td>
    <td label="" hideforuser="false" type="String">fin.trs.head.code</td>
    <td label="" hideforuser="false" type="Decimal">fin.trs.head.number</td>
    <td label="" hideforuser="false" type="Value">fin.trs.line.basevaluesigned</td>
    <td label="" hideforuser="false" type="Value">fin.trs.line.openbasevaluesigned</td>
    <td label="" hideforuser="false" type="String">fin.trs.line.matchstatus</td>
  </th>
  <tr>
    <td>1300</td>
    <td>VRK</td>
    <td>202600002</td>
    <td>242.00</td>
    <td>242.00</td>
    <td name="Beschikbaar">available</td>
    <key>
      <office>1000</office>
      <code>VRK</code>
      <number>202600002</number>
      <line>1</line>
    </key>
  </tr>
  <tr>
    <td>1600</td>
    <td>INK</td>
    <td>202600003</td>
    <td>-60.50</td>
    <td>-60.50</td>
    <td name="Beschikbaar">available</td>
    <key>
      <office>1000</office>
      <code>INK</code>
      <number>202600003</number>
      <line>1</line>
    </key>
  </tr>
</browse>

Source

View examples/browse-data/010-transactions-to-be-matched/example.php on GitHub.