Custom Fields not accessible in form methods

(0) Share

Report

Posted on by Mohamed Ahmed Hassan

169

Dear Champions;

Hope all of you are doing good, i am new to D365 Development, I am creating extension of PurchParmtable and adding a new date Field.

Firstly i want to add validation on the field that's already done and working, Now i want to add one more condition on the same field but the issue is

once i tried to access the field in my method, i am able to access all the default fields but my custom field is not accessible even i set the option

Auto declaration to yes.

Could Someone please let me know what's i am doing wrong and why i am not able to access the field..

Thanks and Best Regards.

I have the same question (0)

All responses (10)

Answers (1)

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Please tell us whether the table extension adding the field is in the same model as your class. If not, make sure that there is a reference between them.

Do you get a compilation if you write the field name manually (instead of depending on IntelliSense)?

Auto Declaration is used for form controls, not table fields, therefore it shouldn't be applicable to you at all - unless you forgot to tell us something. You should validate the value of the table field, not of a form control. Please show us your code.

Was this reply helpful? Yes No
Mohamed Ahmed Hassan 169 on at

Like (0)

Report

Hi Martin;

Thanks for your Reponses, Here is my code and I am also adding a screenshot for the table extension.

[FormControlEventHandler(formControlStr(PurchEditLines, OK), FormControlEventType::Clicked)]
public static void OK_OnClicked(FormControl sender, FormControlEventArgs e)
{

boolean ret;

FormDataSource      fds = sender.formRun().dataSource("PurchParmTable");
PurchParmTable      mypurchTable = fds.cursor();
FormRun             fr = sender.formRun();
FormControl         fc = fr.design(0).controlName("DeliveryDate");
VendTable vendTable;
Select vendTable where vendtable.accountnum == mypurchTable.OrderAccount;
if(vendTable.vendGroup =='20' || vendTable.vendGroup =='10')
{
info(strFmt("%1", (fc.valueStr()==null)));
if(fc.valueStr()==null)
{
//ret = checkFailed("Delivery Date must be filled in");
warning(strFmt("Delivery Date must be filled in"));
fds.refresh();
fds.research(true);

ret = false;
}
else
{

ret = true;
}
}

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report
Hi Mohamed,

When you paste coding, can you use the rich formatting and choose: Insert > Code? In that way, it would be better to read it.

[FormControlEventHandler(formControlStr(PurchEditLines, OK), FormControlEventType::Clicked)] public static void OK_OnClicked(FormControl sender, FormControlEventArgs e) { boolean ret; FormDataSource fds = sender.formRun().dataSource("PurchParmTable"); PurchParmTable mypurchTable = fds.cursor(); FormRun fr = sender.formRun(); FormControl fc = fr.design(0).controlName("DeliveryDate"); VendTable vendTable; Select vendTable where vendtable.accountnum == mypurchTable.OrderAccount; if(vendTable.vendGroup =='20' || vendTable.vendGroup =='10') { info(strFmt("%1", (fc.valueStr()==null))); if(fc.valueStr()==null) { //ret = checkFailed("Delivery Date must be filled in"); warning(strFmt("Delivery Date must be filled in")); fds.refresh(); fds.research(true); ret = false; } else { ret = true; } } }

You shared your coding without further explaining your issue. Can you tell if you have build errors or what else might be not working? What is it exactly what you want to achieve?

Was this reply helpful? Yes No
Mohamed Ahmed Hassan 169 on at

Like (0)

Report
Hi Andre;

Sorry not to follow the code formatting,

if(fc.valueStr()==null) { //ret = checkFailed("Delivery Date must be filled in"); warning(strFmt("Delivery Date must be filled in")); fds.refresh(); fds.research(true); ret = false; } else { ret = true; }

In the Else statement, what i want to do is if the date is inserted in the table(PurchParmTable) i want to write and update statement to update the same

field i.e. Delivery Date in purchline Table.

Now the issue is i want to access the field like mypurchTable.DeliveryDate but the field is not accessible in the mehtod.

Thanks and Regards

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report
The key problem of your code is that it's at a wrong place. But let's pretend that you're doing the right thing and let me show you how you would in that case.

You said your tried to access the field, but your code never does that. What you tried instead to was getting a control called "DeliveryDate" by hard-coded names. (Please always use formControlStr() instead of a control name as text). That's a different thing than a table field.

Let me rewrite your code to actually use your field.

[FormControlEventHandler(formControlStr(PurchEditLines, OK), FormControlEventType::Clicked)] public static void OK_OnClicked(FormControl sender, FormControlEventArgs e) { // This is not perfect, but let's improve it later FormDataSource fds = sender.formRun().dataSource("PurchParmTable"); PurchParmTable myParmTable = fds.cursor(); // Check DeliveryDate first. Don't waste resources to call the query below // if you don't need the result. if (!myParmTable.DeliveryDate) { VendTable vendTable; select firstOnly RecId from vendTable where vendTable.Accountnum == mypurchTable.OrderAccount && (vendTable.vendGroup == '20' || vendTable.vendGroup == '10'); if (vendTable.RecId) { warning("Delivery Date must be filled in"); } } }
x

Note that I removed 'ret' variable, because it's never read. The method doesn't return any value.

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

If you want to update a field on PurchLine from PurchParmLine, you're at a completely wrong place. This is a clicked method of a form, not the posting logic nor the logic copying data between those tables. You seem to forget that there is existing code that can help you and that you must respect.

Please go to PurchLine table and check if there isn't a method initializing from PurchParmLine. If not, I can find the right method for you tomorrow.

Was this reply helpful? Yes No
Mohamed Ahmed Hassan 169 on at

Like (0)

Report

Thanks Martin for your response, I am also checking and waiting for your response as well.

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Can you explain your business scenario, please?

It's strange that you want to update PurchLine from PurchParmLine. PurchParmLine table represents purch lines selected for posting, therefore you normally intialize PurchParmLine from PurchLine and not the other way around.

Note that order lines can be updated on posting (e.g. the status may change the Invoiced), but that's not directly from PurchParmLine.

Was this reply helpful? Yes No
Mohamed Ahmed Hassan 169 on at

Like (0)

Report

Hi Martin;

Really sorry to bother you, There is one field in PO Line Details(Please see the attached image), I want the users to select the delivery date during the time PO Receiving and want to update the PO Line Delivery Date Automatically. Also want to validate the field if the field is empty user will get a notification msg.

Thanks

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Thank you for these details.

The class posting product receipts is called PurchPackingSlipJournalPost. If you want to update PurchLine just before posting, updateSourceLineBeforePosting() looks like the right method.

Was this reply helpful? Yes No