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 / 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. 150

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,827 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. 150 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. 150 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,827 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. 150 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,827 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. 150 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

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans