Add field on Purchase order confirmation report in Dynamics AX 2012
There is requirement to add field on PO lines and same for the confirmation report in Microsoft Dynamics AX. It’s not the straight away to add field on the SSRS report. It requires to add field on other objects (table/view/query).
On PurchPurchaseOrder report it uses the PurchLineALLVersions view to get the details of the PO on the PurchPurchaseOrderDP. So follow the below steps to add field on PurchLineAllVersions view.
- Add field on the PurchLine Table
- Add field on the PurchLineHistory Table
- Now, Refresh or Restore the queries used for PurchLineArchivedVersions and PurchLineNotArchivedVersions as this have dynamics field property to “Yes” our new fields should be added automatically on this queries and Verify the field is added on the query.
- Now, Restore the views PurchLineArchivedVersions and PurchLineNotArchivedVersions.
- Add field on PurchLineAllVersion, here you have to add field manually as the dynamics field property is set.
- That’s it, now use the field on the PurchPurchaseOrderDP to have on report. You also have to add field on tmp table.
This helped you..!! Then comment below..:)
Hi Darshan,
ReplyDeleteI followed the same technique to add a field into PurchLine which I want to use for PO confirmation. When I am changing the value of this field and again confirm it, this field value in previous confirmation is lost. It remains only in new confirmation journal line. Not getting how to retain the previous value in previously confirmed PO journal line.
in my case, all the modification that i made are work on Proforma PO. but when the user "confirm" the PO the modification are 'Blank'.
ReplyDelete