web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to fetch data ?

Small and medium business | Business Central, N...

Answered

How to fetch data ?

(0) Share

Report

Report

Posted on by happysingh0009

160

Hi

I want to copy data from customer (standard) Table t newly created table. I want to do this using ACTION button. please help me.

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Suggested answer

JAngle 133 on at

Like (1)

Report

Is this a one time thing? Is it a recurring activity? If it’s the latter you will need to factor that in. Are all the fields the same? If not you can just declare each field you require in the below repeat until loop. Code like this would get you there:

Customer.findset;

repeat

Newtable.fieldname := Customer.fieldname;

Newtable.insert;

until custome.next =0;

Was this reply helpful? Yes No
happysingh0009 160 on at

Like (0)

Report

1. Please create a table and page (when we click on the page action button-> named update, it should pull the data of all customers and balances) to display all the customers and their balances, net change, and we can filter the balances based on the date filter.

above is the exact statement i got from my professor.

Was this reply helpful? Yes No
Verified answer

happysingh0009 160 on at

Like (0)

Report

Thanks. its working :)

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 2,132

#2

Khushbu Rajvi. 675 Super User 2025 Season 2

#3

YUN ZHU 665 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans