Dynamics Community Forum Thread Details

I wonder, is there a way to have a reqdExctnDt for each payment in the XML export for vendor payments in Switzerland (SWISS SEPACT).

Right now we have only one Requested execution date Date which is used for the whole Export, all payments will be made on this date. We would need a solution in which we can have for example 100 payments and each has an individual reqdExctnDt in one file.

More Info: SEPA XML in a Nutshell

There are 4 mandatory parts to the SEPA Credit Transfer Format (PAIN.001) and the SEPA Direct Debits (PAIN.008) XML file.

The definition of the file – here you state the file type and the version
The GroupHeader block:
- This is identified by the tag <GrpHdr>
- Here you tell the bank high level information about the file such as the date / time the file was created, the number of transactions and the total value of those transactions
- There should only be 1 GroupHeader block
The PaymentInformation block:
- This is identified by the tag <PmtInf>
- Here you give the bank details of the batch, information such as the debit account (SEPA Credit Transfers) or credit account (SEPA Direct Debits), the value/execution date.
- Your essentially defining how you would like the payments/collections within the batch to be processed
- A file can contain multiple PaymentInformation blocks
The Transaction Information block:
- Depending on the type of file and version, this identified by the tag:
  - < CreditTransferTransaction> for SEPA Credit Transfers (PAIN.001.001.03)
  - <DirectDebitTransactionInformation> for SEPA Direct Debits (PAIN.008.001.02)
- Here you define the details of the particular transaction. For:
  - Credit Transfer – Payment Files
    - The Supplier/Creditor, the amount, Remittance information
  - Direct Debit – Collection Files
    - The customer/debtor, the amount, remittance information, mandate information
- Each PaymentInformation block must contain corresponding Transaction Information block(s)
- A file can contain multiple Transaction Information blocks

Is it possible in Business Central to create more than one PaymentInformation block in a single export ?

Thank you for your help!

Example of XML Structure:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<Document xmlns="">www.six-interbank-clearing.com/.../pain.001.001.03.ch.02.xsd">
<CstmrCdtTrfInitn>
    <GrpHdr>
      <MsgId>8D00003</MsgId>
      <CreDtTm>2021-11-30T10:32:10</CreDtTm>
      <NbOfTxs>1</NbOfTxs>
      <CtrlSum>562.07</CtrlSum>
      <InitgPty>
        <Nm>CRONUS CH</Nm>
        <Id>
          <OrgId>
            <Othr>
              <Id>CHE-777.777.777MWST</Id>
            </Othr>
          </OrgId>
        </Id>
      </InitgPty>
    </GrpHdr>
    <PmtInf>
      <PmtInfId>8D00003/1</PmtInfId>
      <PmtMtd>TRF</PmtMtd>
      <BtchBookg>false</BtchBookg>
      <NbOfTxs>1</NbOfTxs>
      <ReqdExctnDt>2021-11-30</ReqdExctnDt>
      <Dbtr>
        <Nm>CRONUS CH</Nm>
      </Dbtr>
      <DbtrAcct>
        <Id>
          <IBAN>CH77778812929018208382</IBAN>
        </Id>
      </DbtrAcct>
      <DbtrAgt>
        <FinInstnId>
          <BIC>55454</BIC>
        </FinInstnId>
      </DbtrAgt>
      <ChrgBr>SLEV</ChrgBr>
      <CdtTrfTxInf>
        <PmtId>
          <InstrId>8D00003/1</InstrId>
          <EndToEndId>8D00003/1</EndToEndId>
        </PmtId>
        <Amt>
          <InstdAmt Ccy="USD">562.07</InstdAmt>
        </Amt>
        <CdtrAgt>
          <FinInstnId>
            <BIC>55454</BIC>
            <PstlAdr>
              <StrtNm>Mid River Square</StrtNm>
              <TwnNm>Boston / MA</TwnNm>
            </PstlAdr>
          </FinInstnId>
        </CdtrAgt>
        <Cdtr>
          <Nm>Windsor Ltd.</Nm>
          <PstlAdr>
            <StrtNm>Industrial Estate</StrtNm>
            <PstCd>US-45700</PstCd>
            <TwnNm>Boston</TwnNm>
            <Ctry>US</Ctry>
          </PstlAdr>
        </Cdtr>
        <CdtrAcct>
          <Id>
            <Othr>
              <Id>33-555-0.3</Id>
            </Othr>
          </Id>
        </CdtrAcct>
        <RmtInf>
          <Ustrd>Zahlung von Rechnung 5616 an Kreditor 100021</Ustrd>
        </RmtInf>
      </CdtTrfTxInf>
    </PmtInf>
</CstmrCdtTrfInitn>
</Document>

Community site session details

Swiss SEPA Bank Export "Requested execution date "

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates