Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Account number for tra...
Finance | Project Operations, Human Resources, ...
Suggested answer

Account number for transaction type Bank does not exist.

(0) ShareShare
ReportReport
Posted on by Voltes 590

Hi,

I'm creating customer payment journal through code X , currently I have error when post the journal (by code) of saying like this : 

Account number for transaction type Bank does not exist. Validation was performed on ledger account  with record ID 5637328577.;Posting results for journal batch number P-000000421 Posting has been canceled.

I suspect this is because of the offset account whereby I'm using Bank for the Offset account type.

The value / field assignment by code for the offset account it self is like this : 

ledgerJournalTrans.OffsetAccountType        =  CustPaymModeTable::find(ledgerJournalTrans.PaymMode).AccountType
ledgerjournaltrans.OffsetCompany            =  curExt();
ledgerjournalTrans.OffsetLedgerDimension    =  CustPaymModeTable::find(ledgerJournalTrans.PaymMode).PaymentLedgerDimension;

and the setup of the Method of payment it self is like this : 

pastedimage1681222644873v1.png_2D00_640x480.png

Anyone know what is wrong ? When Account type is bank, there is no setup for account but to choose the bank account, And in that bank account, I did setup the main account ->
pastedimage1681224069092v1.png

Thanks

  • CU02050725-0 Profile Picture
    CU02050725-0 14 on at
    Account number for transaction type Bank does not exist.
    It's best not to try to solve the problem yourself. Contact support to get started. I myself recently dealt with integrations with open banking providers, I found https://dashdevs.com/blog/integrations-with-open-banking-providers/ answers here. But in fact, it's better to immediately ask someone who knows about this topic. I spent so much time on this. I would do everything differently for my friend right now!
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,027 Super User 2024 Season 2 on at
    RE: Account number for transaction type Bank does not exist.

    Can you manually create the same payment journal?  If so, then something in your code is missing.  

  • Voltes Profile Picture
    Voltes 590 on at
    RE: Account number for transaction type Bank does not exist.

    Hi,

    The GL account is setup in Account Structures and its Active

    pastedimage1681224244238v1.png

    Thanks

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,452 Most Valuable Professional on at
    RE: Account number for transaction type Bank does not exist.

    Hi,

    The GL account assigned to bank account may not be valid. Need to check the account structures.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,986 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,623 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans