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 / Small and medium business | Business Central, N... / TRANSFERING DATA FROM ...
Small and medium business | Business Central, N...
Suggested Answer

TRANSFERING DATA FROM A FLOW FIELD

(0) ShareShare
ReportReport
Posted on by Kiptoo 45

Hello,

I want to link up Sales order ad purchase order so I can calculate profits.

I however have a challenge fetching the Purchase order amount which I want to transfer it to my sales header table as it is a flow field already (Amount Including VAT field).I had an option of having it as a lookup field from sales header but it cant work any workaround? I will appreciate very much 

I have the same question (0)
  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,788 Moderator on at

    Hello Kiptoo,

    not sure what you want to achieve but you can create two field one is lookup for PO No. from Purchase header And other one you can have a open PO Amount field after that you can write some code on Onvalidate on PO no. field so that it copy amount from purchase header amount field to PO amount.

    apart from above customization we have another functionality Drop Shipment through which we can have a link of PO.

    let me know if it’s full fill your requirement.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 98,421 Super User 2026 Season 1 on at

    Hi, sorry I don't really understand your needs. But if you want to get the value from the FlowField, you can use the following method.

    CALCFIELDS Function (Record)

    https://docs.microsoft.com/en-us/dynamics-nav/calcfields-function--record-

    SETAUTOCALCFIELDS Function (Record)

    https://docs.microsoft.com/en-us/dynamics-nav/setautocalcfields-function--record-

    Hope this will help.

    Thanks.

    ZHU

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 February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,857 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,047 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
Liquid error: parsing "/blogs/post/?postid=%27nvOpzp;%20AND%201=1%20OR%20(%3C%27%22%3EiKO))," - Too many )'s.