Import from Excel code showing data in Table but not in Form in AX 2012

(0) Share

Report

Posted on by premK6969

190

Hi there, I got a requirement to import data from excel to AX 2012 Purchase Components. Navigate to Accounts Payable > All Purchase Orders > Double click on any Open Order > Expand Components tab. I had written logic using this link. The data is populating in the table but not showing in Form. After a lot of analysis I found that by creating a record from UI PurchLineRefRecId is generating and because of that we can see the record in the Form but from importing from excel the record is inserting in Backend Table but the record not showing in Form and PurchLineRefRecId is also not generating. Actually I had created a button on the PurchTable form and added my import from Excel logic in Clicked() method.

My requirement is :

1. Import Purch Components for particular PurchLine from excel.

2. The data should appear on the Form as well.

Please let me know if i need to modify anything. Thanks in advance.

Thanks & Regards,

Prem

All responses (3)

Answers (0)

premK6969 190 on at

Like (0)

Report

RE: Import from Excel code showing data in Table but not in Form in AX 2012

Can you please let me know how it can be solved in whatever post you like.
André Arnaud de Cal... 291,684 Super User 2024 Season 2 on at

Like (0)

Report

RE: Import from Excel code showing data in Table but not in Form in AX 2012

Hi Prem,

You had another question where some other fields and the PurchLineRefRecId were not filled correctly: community.dynamics.com/.../after-importing-from-excel-purchid-and-purchlinenumber-not-updating-in-ax-2012

I do think this question is a duplicate of your previous. Please continue with the initial question. This question will be locked.
premK6969 190 on at

Like (0)

Report

RE: Import from Excel code showing data in Table but not in Form in AX 2012

Required Table to update in backend is : PurchLineIngredient Table. This table is interlinked with PurchLine table.