Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Create InventTrans entity
Finance | Project Operations, Human Resources, ...
Answered

Create InventTrans entity

(0) ShareShare
ReportReport
Posted on by AstridMalanka 8

Hi,

I need to create an entity for inventtrans, I follow the video on youtube www.youtube.com/watch, that one developer posted here.

My issue is that I exported the entity in excel and didnt get the columns.

I think the problem is that we have the column in the entity but not on the staging table as they were added after the entity was created.

How do I add the columns on the staging table? Manually? there is a large number of columns.

thanks

Astrid

  • Verified answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,671 Moderator on at
    RE: Create InventTrans entity

    When you open entity in visual studio just right click on the entity and click regenerate staging table

  • AstridMalanka Profile Picture
    AstridMalanka 8 on at
    RE: Create InventTrans entity

    oh... that worked

    thanks

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Create InventTrans entity

    Select all fields in table designer by holding Shift and clicking the first and last field.

    Copy the fields to clipboard with Ctrl-c. Paste them to your staging table's field list with Ctrl-v.

    Works exactly like everywhere in Windows.

  • AstridMalanka Profile Picture
    AstridMalanka 8 on at
    RE: Create InventTrans entity

    Thanks, I am just not sure how to do that

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Create InventTrans entity

    You can regenerate staging table or copy paste fields from InventTrans.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,602 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,340 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans