Add field on Purchase order confirmation report

Add field on Purchase order confirmation report

There is requirement to add field on PO lines and same for the confirmation report. It’s not the straight away to add field on the report. It requires to add field on other objects (table/view/query).

On PurchPurchaseOrderreport it uses the PurchLineALLVersionsview to get the details of the PO on the PurchPurchaseOrderDP. So follow the below steps to add field on PurchLineAllVersions view.

1. Add field on the PurchLine Table
2.  Add field on the PurchLineHistory Table
3. 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.
4. Now, Restore the views PurchLineArchivedVersions and  PurchLineNotArchivedVersions( if you want add field on the views)
5. Add field on PurchLineAllVersion, here you have to add field manually as the dynamics field property is set.
6. That’s it, now use the field on the PurchPurchaseOrderDP to have on report. You also have to add field on tmp table.