Importing PO Excel template to AX

Hi Kranthi

I want to import excel template to Ax, before that the customer wants the excel template like they want only one excel template which should include some fields from PurchTable,PurchLine and InventDim tables to fill the data.

so i created one temp table with including some mandatory fields and extra fields from those table to get one excel template.

is it possible to do like this,if possible please suggest me how to do further to import POs and PO line.

Thanks

Praveen