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 :
Small and medium business | Business Central, N...
Unanswered

How to insert a record in a page whose source table is temporary?

(0) ShareShare
ReportReport
Posted on by 625

Hi All,

I have a requirement that whenever a Sales Quote is created : For a particular value in Code in "Dimension" Table a new Code value(which is the largest value code + 1) should be inserted in the "Dimension Value" table.

pastedimage1575567978971v1.png

So after creating a Sales Quote  For the Dimension = Project, In the 'Dimension Value' table new Code value(P00001+ 1 = P00002) should be inserted :

pastedimage1575568059235v2.png

Till here i have sucessfully completed , i need help in the last part of this requirement : 

This newly inserted code should be automatically added in the Sales Quote created.

When you go to Sales Quote > Quote > Dimensions

pastedimage1575568624733v3.png

An Edit Dimension Set Entries page opens up : 

pastedimage1575568892013v4.png

I want this page to automatically updated with the new Dimension Code created mentioned above like in the below screenshot : 

pastedimage1575569020458v5.png

This above image, i have manually selected to show how it should look like. 

I tried to insert in the pages table, but its not geting inserted,  the problem is  the table for this above page is  : Dimension Set Entry. The source table of this page is temporary.

So can anyone please help me how this page can be automatically populated with the new code as soon the Sales Quote is created?

Thanks in Advance.

I have the same question (0)
  • Andy Sather Profile Picture
    Microsoft Employee on at

    Hello - Do you have Dimensions assigned to the Customer card?  When I add these to my Customer they automatically populate once I created the Sales Quote.

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!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,850 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,084 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans