News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Error while bank accou...

Microsoft Dynamics 365 | Integration, Dataverse...

Unanswered

Error while bank account contains XXXXX-1234, 1234 consume as new segment

(1) Share

Report

Report

Posted on by CU20100628-0

2

Entity name

Customer payment journal line

Entity public name

CustomerPaymentJournalLine

Error details

Working fine except selecting the ‘Bank’ in the field 'AccountType'. It throws the error as ‘Field validation failed on Table. The Accounttype Bank is not valid.’

If bank account is XXXXXXX-2345

2345 is considering as new segment, while it is one field value

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Jonas "Jones" Melgaard 1,983 on at

Like (0)

Report

Error while bank account contains XXXXX-1234, 1234 consume as new segment

Hi,

I think you’ve switched some fields around.
The AccountType always needs to be Customer (i.e., we are paying the debt of that customer).
The OffsetAccountType can either be Bank or Ledger.

As a rule of thumb, entities will always work the same way as a form. So, if it's throwing an error, try performing the action manually from the client to see what’s causing the issue.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans