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 :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Data Entity for Projec...
Finance | Project Operations, Human Resources, ...
Answered

Data Entity for Project Budget Revision in D365FO

(0) ShareShare
ReportReport
Posted on by Sam D. 152

Hi Community

I need to know what should we do to import the Revision Amount through creation of Data Entity or Excel Addins of Project Budget Revision , As I know the Revision Amount field stored in Temp table, but I need to import the Revision Amount in a bulk for multiple Project Id 

Path: Project Management and Accounting --> All Projects --> select any Project Id --> Go to Action Pane --> Plan (Project Budget) --> Go to Action Pane --> New Revision --> give the Revision Amountof the particular Project budget.

Please provide me the solution.

Thanks

Sam D.

I have the same question (0)
  • Verified answer
    GirishS Profile Picture
    GirishS 27,833 Moderator on at

    Hi Sam,

    I gone through the code - TmpProjBudgetRevisionLine - This table is used in the "ProjBudgetRevisionManager" class - createBudgetLines method - In the argument they have TmpProjBudgetRevisionLine  and insert into ProjBudgetLine table. So you need to find any entity related to ProjBudget and use it.

    Another option will be on the top right of the form you will be having office button - Click on that button it will show you all the available entities that can be used in the new revision form.

    Thanks,

    Girish S.

  • Sam D. Profile Picture
    Sam D. 152 on at

    Hi Girish S,

    Thank you for reply, But In the requirement, I have to import the Revision Amount field in a bulk , but this field is stored in TmpProjBudgetRevisionLine  table which is InMem type, for InMem type table system not allow to create data entity and in ProjBudget entity the field of temp table is not importing, can you please let me know is there any another way to import the field of temp table in a bulk way

    Sam D.

  • Sam D. Profile Picture
    Sam D. 152 on at

    Hi Girish ,

    According to the system when we give the Revision amount of ProjBudget after giving the workflow submit and then the amount comes to ProjBudgetLine table so we cannot directly create data entity of any table to import IncrementalChange field of TmpProjBudgetRevisionLine   table (which is InMem) .

  • GirishS Profile Picture
    GirishS 27,833 Moderator on at

    Yes, you cannot create entity for the in-memory table - But I can see the only option in record from TmpProjBudgetRevisionLine  is inserted into ProjBudgetLine. This is the only suggestion I have.

    I don't think there is any other way other than this.

    Have you seen the open in excel and export to excel option under the office button? Is that office visible in New revision form?

    Thanks,

    Girish S.

  • Sam D. Profile Picture
    Sam D. 152 on at

    Hi Girish ,

    Yes I tried through excel, in which field the value is inserting , I changed that field value , and after publish that value not populated in the table nor in form field level.

    Thanks

    Sam D.

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,833 Moderator on at

    I think you need to build an entity with ProjBudgetLine as a DataSource.

    Refer to the below thread.

    https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/382550/entity-to-create-project-budgets-and-budget-lines

    Thanks,

    Girish S.

  • Sam D. Profile Picture
    Sam D. 152 on at

    Hi Girish,

    Thank you for suggestion, I tried this one also, but not working, I insert the record in the field and import through data entity the updated field is not reflecting according the changes, So the data entity of Primary DS (ProjBudgetLine) would not able to import the field related to ProjBudgetRevision.

    Thank you

    Saumya D

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 590 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 349

#3
Diego Mancassola Profile Picture

Diego Mancassola 263

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans