Skip to main content

Importing purchase orders using DIXF

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.


Comments

Post a Comment

Popular posts from this blog

Number sequence with existing module and new module

Number sequence customization in Dynamics 365 Create a number sequence in a standard module Step 1: Create new EDT Step 2: Add a new code block to the loadModule in the NumberSeqModuleXXX class Step 3: Add a new static method to the parameters table of the module to get the number sequence reference Using Extension [ExtensionOf(classStr(NumberSeqModuleCustomer))] final class NumberSeqModuleCustTest_Extension { protected void loadModule() { NumberSeqDatatype datatype = NumberSeqDatatype::construct(); next loadModule(); datatype.parmDatatypeId(extendedTypeNum(TestId)); datatype.parmReferenceHelp(literalStr(‘Test ID’)); datatype.parmWizardIsContinuous(false); datatype.parmWizardIsManual(NoYes::No); datatype.parmWizardIsChangeDownAllowed(NoYes::No); datatype.parmWizardIsChangeUpAllowed(NoYes::No); datatype.parmSortField(1); datatype.addParameterType(NumberSeqParameterType::DataArea, true, false); this.create(datatype); } } [ExtensionOf(tableStr(CustParameters...
Post a Comment
Read more

[D365/AX7] How to: Create and Use number sequence

[D365/AX7] How to: Create number sequence Posted on January 7, 2018 Updated on January 11, 2018 Number sequences are used to generate readable, unique identifiers for master data records and transaction records that require identifiers. A master data record or transaction record that requires an identifier is referred to as a reference. On this example, we are going to create a new number sequence for customer group. Create a new class that extends the NumberSeqModuleCustomer class and then create the method loadModule_Extension and add the following code: class NumberSeqModuleCustomer_CFS extends NumberSeqModuleCustomer {         public void loadModule_Extension()         {                 NumberSeqDatatype datatype = NumberSeqDatatype::construct();          ...
Post a Comment
Read more

Batch Multi threading D365FO AX7

Batch Multi threading D365FO AX7 Normally, when we schedule our RunBaseBatch class as a batch job, it will create single task. Which will responsible to execute complete process in single thread. But, As you know like AX-2009 and AX-2012. In D365FO We can add multiple AOS server in single batch group and they can process the multiple task simultaneously.  In this demo I will show, How to create multi threading Batch job. following are the steps Step-1 Create a table for demo purpose in our demo we keep table name is  SLD_DemoTable . Step-2 create a class with name  SLD_DemoBusinessLogic  and write your business logic in this class. In demo I write only insert records in table and show you guys how it works. Reference Code class   SLD_DemoBusinessLogic {      public   void  processInit( VendTable  _vend)     {          SLD_DemoTable  ...
Post a Comment
Read more