Finance | Project Operations, Human Resources, ...

Account number for transaction type Bank does not exist.

(0) Share

Report

Posted on by Voltes

596

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 ->

Thanks

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (0)

Report

Hi,

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

Was this reply helpful? Yes No
Voltes 596 on at

Like (0)

Report

Hi,

The GL account is setup in Account Structures and its Active

Thanks

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
CU02050725-0 20 on at

Like (0)

Report

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!

Was this reply helpful? Yes No