Hi
On released product details, the Financial dimensions can drop down to select value.
Now, I want to create a field in a table, and layout this field to a new form.
How can I make this field to lookup "BankAccount" values, and select it.
Best Regards,
JustZM
Hi Sumit Loya
Thank you very much!
It works.
Best Regards,
JustZM
Hi,
If I understand your requirement correctly, you would like to create a field for a single financial dimension "BankAccount". I am assuming on a standard table. You can do following:
1. Create an extension of the required table
2. Create new string field with "DimensionValue" as ExtendedDataType
3. On the form, add field and for the same form control create OnLookup event handler code as shown below:
FormStringControl ctrl = _formControl as FormStringControl;
Args args;
FormRun formRun;
DimensionAttribute dimensionAttribute;
select dimensionAttribute
where dimensionAttribute.Name == 'NameOfYourFinancialDimension';
args = new Args();
args.record(dimensionAttribute);
args.caller(_formControl);
args.name(formstr(DimensionLookup));
formRun = classfactory.formRunClass(args);
formRun.init();
ctrl.performFormLookup(formRun);
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156