Itgenoda035 Twinfield.GeneralLedgerIntercompanyV2 error

rvzv · 21 januari 2026 om 21:02

Bij GeneralLedgerIntercompany-tabel krijg ik onderstaande foutmelding.

Andere tabellen werkt probleemloos. Iemand een oplossing?

DataSource.Error:
OData:
Aanvraag mislukt:
De externe server heeft een fout geretourneerd:
(500) Interne serverfout.
(itgenoda035:
De Twinfield-server heeft een interne fout geretourneerd, meestal is dat een applicatiefout binnen Twinfield.
Neem contact op met de ondersteuning van Twinfield met de verzamelde oproepgegevens van het native platform of stel een vraag op de Invantive-forums met deze oproepgegevens.
https://api.accounting.twinfield.com/webservices/processxml.asmx
(itgenoda035, 03d1d70d-9d1b-499c-bf7e-d68c7545d0de))

Details:

DataSourceKind=OData
DataSourcePath=https://bridge-online.invantive.com/acme-twinfield/odata4/Twinfield.Twinfield.GeneralLedgerIntercompanyV2@tfd
Url=https://bridge-online.invantive.com/acme-twinfield/odata4/Twinfield.Twinfield.GeneralLedgerIntercompanyV2@tfd

forums · 22 januari 2026 om 06:52

Advies is om de hint op te volgen in de foutmelding:

Neem contact op met de ondersteuning van Twinfield met de verzamelde oproepgegevens van het native platform of stel een vraag op de Invantive-forums met deze oproepgegevens.

Instructies voor het verzamelen van aanroepgegevens zijn te vinden op:

rvzv · 22 januari 2026 om 18:52

De payload is:

{
  "Url": "https://api.accounting.twinfield.com/webservices/processxml.asmx",
  "Success": true,
  "CallDirection": 0,
  "Id": 2,
  "DateRegisteredUtc": "2026-01-22T18:35:32.1482984Z",
  "RequestBodyAsString": "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://www.w3.org/2003/05/soap-envelope\"> \n<soap:Header>\r\n  <Header xmlns=\"http://www.twinfield.com/\">\r\n    <CompanyCode>100</CompanyCode>\r\n    <AccessToken>removed</AccessToken>\r\n  </Header>\r\n</soap:Header>\n  <soap:Body>\n<ProcessXmlCompressed xmlns=\"http://www.twinfield.com/\">\n  <xmlRequest>eJzFl01uhDAMhfecAnEAfquuGO4SiJlaCglKnGnn9g1TMf1btSM9WGE75MPPCDt5uvrJmbjYkL8txoZTUeST03Qq6q4phizPv6zZzeSYmYweZral+FC+kNKlm2eeqK8+Qp9LLxx4NDSIjym6W/vO1fet/0CyaoHQrqQ8grOSZ6dRGf2LluIuPajE+WEkeSWyfXX3ZP3s3TK0dftU1XXaerOyXtzmeq7qpq/SffbIm2+fJkIhG5eRIFUPoiQGBEkrgWg3RY8qkyejhJ1F/QrYrigVYyAPSMuwpVLz0qA4yJzkuqJYLYoD1K8F6tehOED9OpR+F2UiBT5b0gjcqAKBkZ5WMFHTyDJ50iyYEgqgae6oAyqoKUye161bI3BsL5AZ7t5rzt7FtcHSkL30RmyxNHh+HZYGy4+CsL1Nyriz8y8ybMr8wTwo1/Ygboc6DHk684Ok3QpD9g6iM31z</xmlRequest>\n</ProcessXmlCompressed>\n\n  </soap:Body>\n</soap:Envelope>\n",
  "ResponseBodyAsString": "<?xml version=\"1.0\" encoding=\"utf-8\"?><soap:Envelope xmlns:soap=\"http://www.w3.org/2003/05/soap-envelope\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><soap:Body><soap:Fault><soap:Code><soap:Value>soap:Receiver</soap:Value></soap:Code><soap:Reason><soap:Text xml:lang=\"en\">Server was unable to process request. ---&gt; Invalid name character in 'http://www.twinfield.com/_Unexpected'.</soap:Text></soap:Reason><soap:Detail /></soap:Fault></soap:Body></soap:Envelope>",
  "StartUtc": "2026-01-22T18:35:31.747255Z",
  "EndUtc": "2026-01-22T18:35:32.1474822Z",
  "TableFullQualifiedName": "Twinfield.Twinfield.GeneralLedgerIntercompany",
  "ResponseStatus": "InternalServerError",
  "PartitionCode": "100",
  "DataContainerId": "https://api.accounting.twinfield.com/removed",
  "RemoteCorrelationIds": "ray: 9c2126d39a4075de-CDG",
  "RequestContents": "Automatic decompression: All\nMaximum automatic redirections: 50\nMaximum response headers length: 64\nProtocol version: 1.1\nTimeout: 602.000 ms\nContinue Timeout: 350 ms\nRead/write Timeout: 300.000 ms\nSend chunked: False\nRequest header Content-Length: 2513\nRequest header Content-Type: text/xml; charset=utf-8\nRequest header User-Agent: Wget/1.19.3 (linux-gnu)\n",
  "ResponseContents": "<?xml version=\"1.0\" encoding=\"utf-8\"?><soap:Envelope xmlns:soap=\"http://www.w3.org/2003/05/soap-envelope\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><soap:Body><soap:Fault><soap:Code><soap:Value>soap:Receiver</soap:Value></soap:Code><soap:Reason><soap:Text xml:lang=\"en\">Server was unable to process request. ---&gt; Invalid name character in 'http://www.twinfield.com/_Unexpected'.</soap:Text></soap:Reason><soap:Detail /></soap:Fault></soap:Body></soap:Envelope>",
  "RequestHttpHeaders": "User-Agent=Wget/1.19.3 (linux-gnu),Content-Length=2513,Content-Type=text/xml; charset=utf-8",
  "ResponseHttpHeaders": "Date=Thu, 22 Jan 2026 18:35:32 GMT,Transfer-Encoding=chunked,Connection=keep-alive,Access-Control-Expose-Headers=Request-Context,Cache-Control=private,Content-Security-Policy=default-src 'self' https://twfcdnwktaae.azureedge.net https://twfloginbanner.azureedge.net https://dc.services.visualstudio.com https://dc.applicationinsights.microsoft.com https://twinfield.my.salesforce.com https://az416426.vo.msecnd.net https://www.youtube.com https://*.salesforce.com https://ui.twinfield.com https://api.accounting.twinfield.com https://ava-europe.wolterskluwer.io/api/create-chat https://cdn.eu.pendo.io https://data.eu.pendo.io https://app.eu.pendo.io https://login.wolterskluwer.eu/ 'unsafe-inline' data:,content-security-policy-report-only=default-src 'self' https://twfcdnwktaae.azureedge.net https://twfloginbanner.azureedge.net https://dc.services.visualstudio.com https://dc.applicationinsights.microsoft.com https://twinfield.my.salesforce.com https://az416426.vo.msecnd.net https://www.youtube.com https://*.salesforce.com https://ui.twinfield.com https://api.accounting.twinfield.com https://ava-europe.wolterskluwer.io/api/create-chat https://cdn.eu.pendo.io https://data.eu.pendo.io https://app.eu.pendo.io https://login.wolterskluwer.eu/ 'unsafe-inline' data:; script-src 'self' https://twfcdnwktaae.azureedge.net https://twfloginbanner.azureedge.net https://dc.services.visualstudio.com https://dc.applicationinsights.microsoft.com https://twinfield.my.salesforce.com https://az416426.vo.msecnd.net https://www.youtube.com https://*.salesforce.com https://ui.twinfield.com https://api.accounting.twinfield.com https://ava-europe.wolterskluwer.io/api/create-chat https://cdn.eu.pendo.io https://data.eu.pendo.io https://app.eu.pendo.io https://login.wolterskluwer.eu/ 'unsafe-inline' data:; report-uri https://eastus-swscsp.azurewebsites.net/reporting/twinfield/reportOnly,Referrer-Policy=no-referrer,request-context=appId=cid-v1:7ff7ea34-8541-42a8-8bcb-96a62e24c44a,Server=cloudflare,X-AspNet-Version=4.0.30319,x-content-security-policy=default-src 'self' https://twfcdnwktaae.azureedge.net https://twfloginbanner.azureedge.net https://dc.services.visualstudio.com https://dc.applicationinsights.microsoft.com https://twinfield.my.salesforce.com https://az416426.vo.msecnd.net https://www.youtube.com https://*.salesforce.com https://ui.twinfield.com https://api.accounting.twinfield.com https://ava-europe.wolterskluwer.io/api/create-chat https://cdn.eu.pendo.io https://data.eu.pendo.io https://app.eu.pendo.io https://login.wolterskluwer.eu/ 'unsafe-inline' data:,X-Content-Type-Options=nosniff,x-envoy-upstream-service-time=324,X-Powered-By=ASP.NET,x-ratelimit-clientid-limit=1000,x-ratelimit-clientid-remaining=851,x-ratelimit-credited=3,x-ratelimit-limit=500,x-ratelimit-remaining=351,X-XSS-Protection=1; mode=block,cf-cache-status=DYNAMIC,Strict-Transport-Security=max-age=31536000,CF-RAY=9c2126d39a4075de-CDG,Content-Type=application/soap+xml; charset=utf-8"
}

De XML payload met het bericht is na uitpakken zoals beschreven in Zlib_compress en zlib_decompress SQL-functies :

    <columns xmlns="" code="031">
      <column>
        <field>fin.trs.head.office</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.officename</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.year</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.period</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.yearperiod</field>
        <visible>true</visible>
        <operator>between</operator>
<from>2024/00</from>
<to>2026/01</to>

      </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.head.status</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.date</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.curcode</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.relationname</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.inpdate</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.username</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1type</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim2</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim2name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim2type</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim3</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim3name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim3type</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.valuesigned</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.basevaluesigned</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.repvaluesigned</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.debitcredit</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.vatcode</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.vatbasevaluesigned</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.description</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.invnumber</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group1</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group1name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group2</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group2name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group3</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group3name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.destination.officename</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.destination.dim1</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.destination.dim1name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.destination.dim2name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.destination.dim3name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.regime</field>
        <visible>true</visible>
      </column>
    </columns>

forums · 29 januari 2026 om 08:06

Deze vraag is automatisch gesloten na 1 week inactiviteit. Het laatste gegeven antwoord is gemarkeerd als oplossing.

Gelieve een nieuwe vraag te stellen via een apart topic als het probleem opnieuw optreedt. Gelieve in de nieuwe vraag een link naar dit topic op te nemen door de URL er van in de tekst te plakken.

rvzv · 11 februari 2026 om 08:37

Onderstaand het antwoord van Twinfield om een aanpassing te doen

Het volgende stukje code moet aangepast worden in je XML:

fin.trs.head.yearperiod → visible → true → false

Topic		Antwoorden	Weergaven
Twinfield database ververst niet: itgentfr091 op TimeAndExpensesDetails Vragen invantive-cloud , twinfield	13	658	11 april 2024
Foutmelding Twinfield laden in Power BI Vragen invantive-cloud , power-bi , twinfield	6	167	12 juni 2024
Twinfield itgentfr092: Toegang geweigerd. Company ontbreekt in request header (NLLEEG) Vragen invantive-cloud , twinfield	9	47	27 april 2025
Itgentfr091 bij 'create or replace table' twinfield.banktransactions Vragen invantive-cloud , power-bi , twinfield	16	443	27 november 2024
Itgenjuy027 foutmelding bij het opvragen van InvoicesLastTwoYearsAll Vragen teamleader-focus , invantive-cloud , power-bi	16	29	5 november 2025

Itgenoda035 Twinfield.GeneralLedgerIntercompanyV2 error

Gerelateerde topics