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.

  • 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 633 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 419 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 236 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans