Showing posts with label DIXF. Show all posts
Showing posts with label DIXF. Show all posts

Tuesday, 9 August 2016

AX 2012 | Importing purchase orders using DIXF


In this post we will illustrate how to import purchase orders through data import export framework. we will use one excel file which contain purchase order header in first sheet and purchase order details in another sheet.


to import the purchase order please do the following steps:

1- Go to Data import export framework --> Setup --> Data import / export framework Parameters.



2- Click browse to select shared working directory then click Validate button then close the form.



3- Go to Data import export framework --> Setup --> Source Data format, Create new source name and make sure to chose File in the Type field then select the file format in my example i will use excel. 



4- Go to Data import export framework --> Common --> Processing Group, Create New Group then Click the Entities Button.



5- in the entities form select the Purchase Order Header Entity,select Excel in the Source data format, then Click the generate source file button.



6- In the wizard click next then Make sure to select the following fields:
CurrencyCode
InvoiceAccount
LanguageId
OrderAccount
PurchId
VendGroup
PurchName
PurchaseType
PurchStatus
DocumentState
DeliveryDate

Then click Generate sample file.



7- when the excel file is opened, change the sheet name to POH.



8- Select the second sheet in the Excel, Change the sheet name to POL then add the following field names:

CurrencyCode
VendAccount
VendGroup
PurchId
ShippingDateConfirmed
LineNumber
ItemId
Name
PurchQty
PurchUnit
PurchPrice
InventSiteId
InventLocationId
PurchaseType



09- Go back to POH sheet, enter the purchase order header details.



10- select the POL sheet, Enter the purchase order lines details. in this example i will add two lines



10- when you finish make sure to save the file in the shared folder that we specified in step 2.



11- Go back to the processing group --> entities---> Select the "Purchase order header" entity, specify  the Excel file path then from the sheet lookup select POH$, click generate source mapping button.



12- Click New, Select Purchase order line entity, select Excel from source,specify the Excel file path then from the sheet lookup select POL$, click generate source mapping button then close. 



13- To preview the Purchase header details select purchase order header entity then Click the Preview source file button.



14- To preview the Purchase lines details select purchase order line entity then Click the Preview source file button. 



15- Close the form

16- In the processing group select the group name then click the Get staging data button to copy the file data to staging table.



17- Click OK to create job.



18- Click Run in the staging data execution form.



19- Click OK. (sorry, i forget to capture the screenshoot. its looks exactly like the following screenshot but with different name   )

20- The records will be inserted in the staging.



21- In the processing group select the group name then click Copy Data to target button.

22- Select the Job ID that we created in step 17 then click OK.



23- Click Run to import data.



24- Click OK.



25- The data will be written to target.




26- To view the imported purchase order go to the all purchase order list form, you will found that the purchase order was imported successfully.



Labels

#veryusefulcode (1) AIF (8) AOT Maps (1) Args (1) Ax 2009 Reports (2) AX 2012 navigation (1) Ax 2012 Interview Questions (1) AX 7 (2) AX Architecture (1) Ax Backup (1) AX Workflow (2) AX2012 (1) AX2012 R2 (1) Ax2012R3 (1) AX2012R3 Dynamics Connector Step by Step Installation and Configuration (1) AX2012R3 EP Step by Step Installation and Configuration EP R3 (1) AX2012R3 HelpServer Step by Step Installation and Configuration (1) AX2012R3 Rapid Start Connector Step by Step Installation and Configuration (1) AX2012R3 Report Server and Analysis Server Step by Step Installation and Configuration (1) AX7 (1) Best practices (1) Blocking user to enter (1) Collection Classes (1) Container (1) D365FO (3) Data Migration Frame Work ax 2012R3 (1) Deleting duplicate Record from Table – Ax2012 (1) Delivery due date notification workflow in Ax 2012 (1) Development Steps EP (1) Dimensions (1) DIXF (1) DMF in Ax 2012 R3 (1) Dynamics Ax 2012 Interview Questions (1) DYNAMICS AX 2012 INTERVIEW QUESTIONS PART 2 (1) DYNAMICS AX 7 (1) EDT relation Migration Tool (1) EP AX 2012 (1) Ep Lookup (1) Error (1) Event Handler (1) F5 (1) File Handling (4) Filter on AX2012 Listpage (1) filtering (2) financial dimensions in AX 2012 (3) form (1) images (1) Installation and Configration (4) Installation and Configuration (11) Installation of Management Reporter 2012 for AX 2012 (1) Interaction class in ax 2012 (1) Interview Question (1) Interview Questions For Ax 2012 (1) Invent DIm (1) Jobs (2) license (1) List page and form menuitem enable code (1) Methods (1) microsoft Dynamics AX 365FO (1) Number Sequence Generation – AX 2012 (5) Number Sequence2012 (1) OLTP-OLAP (1) Passing Args (1) Passing form caller and menu item caller in ax 2012 (1) Passing Multiple Records Args (1) Posting in Ax 2012 (1) POSTING PURCHASE ORDER (1) Query (1) Query Filter Form (2) Query Ranges in X++ (1) Question and Answer (1) Report (1) Reports Controller class (1) RLS in ax 2009 (1) SALES ORDER IMPORT/EXPORT FRAMEWORK BY DMF (1) Security (1) security roles (1) Security Sysqueryrangeutil (1) Sharepoint 2016 (1) SQL SERVER (1) SSRS (2) SSRS Reports Controller class (2) Table collections & Virtual company (1) Time (1) TIPS AND TRICKS (1) Web service AIF (3) Web Services on IIS (AIF) Step by Step Installation and Configuration (1) workflow ax2012 (1) Workflow installation (1) Workflow Method (3) X++ (1)