Make relation between Mainaccount ID and BankAccountNumber (AX2012 R2)

(0) Share

Report

Posted on by FrankRaij

Hello,

I want to make a relation between the mainaccountnumber of a bankaccount and the bankaccountnumber.

When I look in the Bank account screen (Cash and bank management - common - Bank accounts / see screenshot) I see the bankaccountnumber (BankAccountTable-AccountNum) and the mainaccount (BankAccountTable - Ledgerdimension autoidentification) but I don't see the Mainaccountid in the bankaccounttable.

How can I make the connection between the Mainaccount ID and BankAccountNumber? Below a screenshot.

Thanks!

Frank

*This post is locked for comments

All responses (3)

Answers (0)

FrankRaij 50 on at

Like (1)

Report

RE: Make relation between Mainaccount ID and BankAccountNumber (AX2012 R2)

Thanks!
FrankRaij 50 on at

Like (0)

Report

RE: Make relation between Mainaccount ID and BankAccountNumber (AX2012 R2)

Hi Nikolaos,

Thanks.

A connection between tables in the AX database. I have checked the BANKACCOUNTTABLE and I don't see a RefRecId field.
Suggested answer

nmaenpaa 101,158 Moderator on at

Like (1)

Report

RE: Make relation between Mainaccount ID and BankAccountNumber (AX2012 R2)

What do you mean by making a connection? The connection already exists in the system.

However the main account id is not stored in the bank account table, instead a RefRecId that represents it is.