this is bank account trans form
Hi sachin mittal,
Use DefaultDimensionView to get the business unit. DefaultDimensionView contains field named "Name" where you can add "Business unit" as a range.
You can use DefaultDimension field in the view to use as relation.
Thanks,
Girish S.
Can you help with exact code it would be really really helpfull
Can you tell me the navigation of the form.
Form name is AOT > BankAccountTrans itself then , financial dimension tab
I guess BankAccountTrans table is related to the form you are asking. If yes then below code helps you.
DefaultDimensionView dimensionView; BankAccountTrans accountTrans; while select * from accountTrans join dimensionView where accountTrans.DefaultDimension == dimensionView.DefaultDimension && dimensionView.Name == "BusinessUnit" { info(strfmt("%1,%2,%3",accountTrans.AccountId,accountTrans.Voucher,dimensionView.DisplayValue)); }
here display value is not found in accounttrans buffer . can you please help
DisplayValue field is in DefaultDimensionView that is dimensionView buffer not in accountTrans buffer.
I have written the code wrongly. I have edited the code. Please check.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 683 Most Valuable Professional
André Arnaud de Cal... 563 Super User 2025 Season 2
Sohaib Cheema 398 User Group Leader