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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / ax tables in excel pub...
Microsoft Dynamics AX (Archived)

ax tables in excel publishing option

(0) ShareShare
ReportReport
Posted on by Yasir Shahzad 1,635

Dear Experts,

                  i am having a problem..i m trying to upload data through excel publishing option..but unfortunately i m unable to find the exact tables of ax in publishing options in sales order line.... like  

SalesStatus
InventSiteId InventLocationId
InventColorId InventSizeId

any body knows how to find these exact names of these tables in excel publishing options?

thanks in advance

Best Regards

Yasir shahzad

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,030 Super User 2025 Season 2 on at

    Hi Yasir,

    The SalesStatus should be available. The item dimension fields are in a sub table called InventDim. The sales line has a reference to an existing record in the field InventDimId.

    Can you tell about the business requirement you are fulfilling? Are you able to use Data Import Export Framework instead? This has support for the item dimensions on line level.

  • Yasir Shahzad Profile Picture
    Yasir Shahzad 1,635 on at

    Andre thanks for your reply...actually i m creating a template to upload data of Sales Line..i have find all other tables according to my business requirement...but only above mentioned fields are not finding....i just give you an example...in DMF we use "ShippingDateRequested" but when we upload data through this field know as

    "Requested ship date"....i just want to know that what is the exact names  of above mentioned fields in excel....hope you understand my problem...

    Regards

  • Verified answer
    Yasir Shahzad Profile Picture
    Yasir Shahzad 1,635 on at

    i found it...its a little bit tricky...when you do generate source mapping...and validate then see the "View Target Mapping" every field will b linked with related field...then you just put your cursor on that field...it will automatically show the label...which will be the exact name of publishing field in excel....see the pic....

    excel-publishing-table.png

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans