Skip to main content
Dynamics 365 Community / Forums / Finance forum / Account number for tra...
Finance forum
Suggested answer

Account number for transaction type Bank does not exist.

editSubscribe (0) ShareShare
ReportReport
Posted on by 550

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

  • 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... 3,384 Super User 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 550 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 13,021 Super User 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.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans