Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Data is not coming for two fields in Budget plan work sheet in Ax 2012 R3

(0) ShareShare
ReportReport
Posted on by 1,737
I am using budget plan worksheet to see the data in to excel add-in. After clicking on wroksheet button in budget plan, data is exported in to excel all fields data is coming except two fields. Those are description fields of Ledger dimension like we have project and vendor dimensions as segments for ledger dimension.
 
Vendor ID and project id is coming in to excel, but description of vendor id and project id is not coming.
 
Please help me on this whether i missed any setup in template.
 
 
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Data is not coming for two fields in Budget plan work sheet in Ax 2012 R3
    Hi,
    Did this answer solve your problem? If so, you can mark the thread as verified so that other users of the forum can view it.
    Best regards,
    Kevin
  • Verified answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Data is not coming for two fields in Budget plan work sheet in Ax 2012 R3
    Hi,
    These two fields are not exported, are they virtual fields? If so, you must first add them to the staging table, and if you don't, the data can't be exported to staging, so these two fields are not included in the exported file. For more details, refer to this link, although this was posted on the FO forum, I think users of the AX application can also refer to it: Solved: Data entity virtual fields are not exported (dynamics.com).
    If they're not a virtual field, are they added to the Grid? If not, you need to personalize the grid, add these two fields before exporting. For more details, refer to this link, although this was posted on the FO forum, I think users of the AX application can also refer to it: Some custom data entity fields not shown in while data export in excel from form and if i directly data entity export from data management the specific fields are shown successfully (dynamics.com).
    Best regards,
    Kevin

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,187 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,966 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans