The character limit issue in BACS(UK) Lloyds file

(2) Share

Report

Posted on by CU12050152-0

225

In BACS(UK) Lloyds file electronic reporting format the Vend Name is configured to Maximum Length of 18 characters but when the file is generated in payment journal, the Vendor Name column automatically creates empty space up to 30 characters. Client is getting issue when uploading the BACS file with the bank.

Please find attached the relevant config of Vendor Name in electronic Reporting and the BACS file generated.

Can you give suggestion how it can be restricted to 18 characters without leaving spaces

Categories:

Dynamics 365 Finance

file.csv

Vend Name in Elec...

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Abhilash Warrier 5,402 Super User 2025 Season 2 on at

Like (0)

Report
Modify the Electronic Reporting (ER) Format:

Open the ER configuration for the BACS file in Dynamics 365.

Locate the mapping for the Vendor Name field.

Use a formula to trim the Vendor Name to 18 characters. For example, you can use the LEFT() function to limit the length of the field to 18 characters.

If this helped, please mark it as "Verified" for others facing the same issue.
Keep in mind that it is possible to mark more than one answer as verified.

Was this reply helpful? Yes No
CU12050152-0 225 on at

Like (0)

Report

Hi Abilash,

Thank you,

In ER config can you guide me where we can use the formula, i could not find the provision in it. Or do you mean in the file generated must we use a formula to trim it. Can you please eloborate

Regards

Prasad

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (2)

Report

Hi,
I believe the empty character issue is related to the vendor bank account name and ZeroCode, as indicated in your screenshot. Please verify that the vendor bank account has a value entered for the Name field, and then try generating the payment file again.

In general, empty characters in the file are often tied to field values that are either missing or misaligned based on the file’s expected structure, including field order and length.

Was this reply helpful? Yes No