Question

Employee Property Codes and Employee Payments Using ISO20022

G
Rank
Userlevel 2
Badge +6

 

 

Hi,

I am trying to set up IFS Cloud 23r1 to Pay Employee Travel Expenses using the Payment Method ISO20022. It is not outputting the Sort Code in the XML file.

The Employee is set up with Property Codes to store the Bank Account under EMPPAYACC and Sort Code under EPSORTCODE. The Sort Code does not get output in the ISO20022 xml file created. The Account appears under  <IBAN> and if we add a BIC Code under BIC it appears under <BIC>.

 XML Extract for 0.01 Employee Payment:

<CdtTrfTxInf>
                <PmtId>
                    <EndToEndId>29/240508/1</EndToEndId>
                </PmtId>
                <Amt>
                    <InstdAmt Ccy="GBP">.01</InstdAmt>
                </Amt>
                <ChrgBr>SLEV</ChrgBr>
                <CdtrAgt>
                    <FinInstnId>
                        <BIC>BUKBGB22</BIC>
                    </FinInstnId>
                </CdtrAgt>
                <Cdtr>
                    <Nm>Lewis Millar</Nm>
                    <PstlAdr/>
                </Cdtr>
                <CdtrAcct>
                    <Id>
                        <IBAN>12345678</IBAN>
                    </Id>
                </CdtrAcct>
                <RmtInf>
                    <Ustrd>73</Ustrd>
                </RmtInf>
            </CdtTrfTxInf>
 

Bank Details have been set up to store the BIC Codes so we could add one to the Employee BIC Property Code.

 

Employee Paymnet Metod is set to use the EPSORTCODE for  “Get Employee Bank Code From”:

 

If I look at the output for a Supplier BACS file the Sort Code comes through under <MmbId>:

 <CdtTrfTxInf>
                <PmtId>
                    <InstrId>42/2024-04-03/1</InstrId>
                    <EndToEndId>42/2024-04-03/1</EndToEndId>
                </PmtId>
                <Amt>
                    <InstdAmt Ccy="GBP">.01</InstdAmt>
                </Amt>
                <CdtrAgt>
                    <FinInstnId>
                        <ClrSysMmbId>
                            <MmbId>123456</MmbId>
                        </ClrSysMmbId>
                        <PstlAdr>
                            <Ctry>GB</Ctry>
                        </PstlAdr>
                    </FinInstnId>
                </CdtrAgt>
                <Cdtr>
                    <Nm>Cam-Ken Joinery</Nm>
                </Cdtr>
                <CdtrAcct>
                    <Id>
                        <Othr>
                            <Id>12345678</Id>
                        </Othr>
                    </Id>
                    <Ccy>GBP</Ccy>
                </CdtrAcct>
                <RmtInf>
                    <Ustrd>DWTEST/1</Ustrd>
                </RmtInf>
            </CdtTrfTxInf>
 

Any idea why the Sort Code is coming out on the Supplier BACS xml file but not the Employee Travel Expense Payment BACS xml?

 

Thanks,

Graham

2 replies

G
Rank
Userlevel 2
Badge +6

ISO20022 Configuration if this matters:

 

G
Rank
Userlevel 2
Badge +6

IFS Support feedback:

 

I have received feedback from our UK consultant and it has been noted that, as per current understanding the standard functionality for employee payments does not support Sort Codes and this was also confirmed earlier by the RnD experts.

“Further it was mentioned that, there have been instances where the BACS payment file type (a flat file rather than XML) was transformed into a format acceptable by the bank using Transformers (implemented externally) and some cases where customers use the BACS payment file and employ third-party software to amend the payment file format to that required by the bank which is facilitated by some banks in the UK offered as a service.

Alternatively to above there is always the option of a customization/modification.”

and

“Upon reviewing the gathered information with our RnD experts, it has been confirmed that the Employee Payment Sort Code for Employee Expenses in UK is currently not supported for IFS Cloud. Despite the presence of fields like EMPPAYCODE (Employee Payment Sort Code) and EPSORTCODE (Bank Sort Code) in the Employee File > Properties, these have not been incorporated into our current employee payment formats.

Additionally although the Sort Code is generated for ISO20022 supplier payments, the HCM module does not currently support the <MmbId> tags as most users require the generic syntax and upon further review by RnD Product Management, it has been concluded that there are no immediate plans to enhance this feature in the near future either.

However given the requirements from previous customers, it has been suggested to explore customization option as a solution. In doing so I have reached out to a UK Consultant for more information and am awaiting their response, which may help you in this matter.”

Reply


Terms & ConditionsCookie settings