I want to export the Sales orders data as xml. I went through the I100 Integration Scenarios 2022 R2 training guide also. But i could not find a way to export as xml. Can you please give me a guide to accomplish this task? Thank you.
Solved
How to use XML data provider?
Best answer by sweta68
For exporting scenario you need to follow below steps.
- Create Data Provider and select Data provider as XML data Provider.
- Attach sample XML file.
- Go to Schema tab and Click on Fill Schema Objects.
- Go to Export scenarios screen and create new one export scenario with the screen Sales Orders(SO301000) and newly created data Provider.
- In Mapping tab you can give mappings for fields from relevant table.(i.e. Order Summary, Details etc.)
- Go to Export by scenario, Select your export scenario and click on Prepare and Export.
Let me know if it is clear to you.
Regards,
Sweta
Hi
You need to create a data provider using XML Provider as provider type. Attached is a sample xml file for export and do the Fill Schema objects. In Export Scenario you can use the same data provider and export your sales orders in the format provided by the xml file that you have added in the data provider.
You can find the attached sample xml file just containing Sales Order number field.
Hope this helps!
Regards,
Sweta
Thank you
For exporting scenario you need to follow below steps.
- Create Data Provider and select Data provider as XML data Provider.
- Attach sample XML file.
- Go to Schema tab and Click on Fill Schema Objects.
- Go to Export scenarios screen and create new one export scenario with the screen Sales Orders(SO301000) and newly created data Provider.
- In Mapping tab you can give mappings for fields from relevant table.(i.e. Order Summary, Details etc.)
- Go to Export by scenario, Select your export scenario and click on Prepare and Export.
Let me know if it is clear to you.
Regards,
Sweta
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.