I’m working in Dynamics AX 2009. I have a project to display the number of days a vendor is late in supplying goods. The PurchTable form contains most of the fields I require. Therefore, I have created my required form by duplicating the PurchTable form.
I need to move the StringEdit control ‘PurchLine_ItemId’ located on the PurchTable’s form in [Group:Line], [Tab:TabLine], [TabPage:TabLineOverview], [Grid:LineSpec] (the 2nd gridview) to the main TabHeaderOverview grid at the top of the form.
I also want to move the ‘Delivery date’, and ‘Confirmed’ date fields from the form’s ‘DeliveryGroup’ to the top-most Overview grid as well.
However, when I move the ‘PurchLine_ItemId’ field, which appears with the name “Item number” into the Overview grid, it no longer is populated with the item number. I’m fairly certain the same thing will happen when I attempt to move the 2-date fields.
Can someone please suggest what steps I need to take so that the ‘PurchLine_ItemId’ field populates as it does in the PurchTable’s form in [Grid:LineSpec]?
Do I need to write a display method, or why does the ItemId field suddenly stop populating. Any suggestions for this control as well as moving the 2-date controls, would be much appreciated. Thank you in advance.
First question, what happens when you have diferent lines with different delivery dates each? Second question: Why do you need to move the itemId fields?, this field belongs to the line and not to the header.
Hello Harish, before I duplicated the PurchTable form I did create a simple form containing the following fields: ‘Vendor account’, ‘Vendor Name’, ‘Purchase order’, ‘Item number’, ‘Total Price of Quantity Received’, ‘Delivery date’, ‘Confirmed date’, ‘Received Date’ and I will need to add one more field to display the number of
“Days Late”, which will reflect the difference between InventTrans.DatePhysical - PurchLine.DeliveryDate. The field ‘Total Price of Qty Received’ is a DataMethod, where I attempt to acquire the ‘Qty’ from InventTrans where InventTrans.ItemId equals PurchLine.ItemId and InventTrans.TransType equals the enum of “3”. Then I pass this quantity to PurchLine.calcLineAmount like the following code snippet:
Display AmountCur total_Price_Qty(PurchLine _purchLine)
select Qty from InventTrans where InventTrans.ItemId == _purchLine.ItemId && InventTrans.TransType == 3;
qty = Qty;
I would be satisfied using my created form if I knew how & which tables to query in order to populate these fields like the PurchTable form has them populated.
How can I determine which tables to query? Are there existing queries in the AOT which the PurchTable form utilizes to populate its fields?