web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Excel add for Trade agreements

(0) ShareShare
ReportReport
Posted on by 30

Hi Experts,

I have a requirement to export the trade agreements using the excel add-in for AX 2012 R2.
There after it would need to be imported with the changes.


Is this possible?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Parthasarathy K Profile Picture
    390 on at

    Hi NMCL,

    You can export trade agreement using DIEF and the the same can be imported back with the respective changes.

    excel add-in may now work in this area.

    Regards,

  • NMCL Profile Picture
    30 on at

    Hi Praveen,

    Thank you so much for your response.

    I was able to create a source document for the PriceDiscAdmTrans and PriceDiscTableListPage - this is what I would like to extract in ax and update from Excel.
    I select the fields I require, and the data is not refreshing.
    I am able to see the fields based on the data I am pulling through, but the data itself is not refreshing and reflecting - only headers.

    Could you guide me on where I may be going wrong?

  • Suggested answer
    Parthasarathy K Profile Picture
    390 on at

    Hi NMCL,

    Follow the below steps.

    -Go to data management

    -Select Export

    -Enter 'name'

    -Select target data format ' this should be excel'

    -Select entity name ' select the proper entity name here'

    -save

    3438.2.png

    - Now load the project

    - select target data format ' excel'

    - Respective entity name (as per my example i selected customer group)

    - Add enity

    - export

    - download file

    3438.2.png

    After getting the data. Edit as required

    Now create a import job (same steps but import job)

    Do the import (this should work) 

  • NMCL Profile Picture
    30 on at

    Thank you so much Praveen.

    It this export solution on AX 2012 or D365?

  • Suggested answer
    Parthasarathy K Profile Picture
    390 on at

    Hi NMCL,

    This is for D365.

    The steps may be different but the same is possible in AX 2012. 

    Check some videos on AX2012 DIEF it might help.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans