PO import excel to Ax

Dynamics 365 for Finance and Operations/AX Technical Forum
1

Hi all

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

2

pls. follow below links

http://dynamicspost.blogspot.ae/2012/01/purchase-order-using-x.html

http://ax2012xppdataimport.blogspot.ae/

http://ax2012xppdataimport.blogspot.ae/2013/12/microsoft-dynamics-ax-2012-xpp-purchase.html

https://community.dynamics.com/ax/b/ax2012exceldataimport/archive/2012/01/17/dynamics-ax-2012-purchase-orders-import-using-excel-add-in.aspx

3

dear pandu

I want this functionality in 2009 .

4

try the below links:

http://axhelper.blogspot.ae/2011/06/x-code-to-create-purchase-order-and.html

http://dynamicspost.blogspot.ae/2012/01/purchase-order-using-x.html