Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Account number for transaction type Bank does not exist.

(0) ShareShare
ReportReport
Posted on by 592

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 16 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... 46,276 Super User 2025 Season 1 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 592 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 16,620 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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,187 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,966 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans