web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Adding custom fields from Item Card to Sales Line

(1) ShareShare
ReportReport
Posted on by 311
Hello!
 
I have added two custom fields to my Item table, and subsequently added them to the Item Card page. This is the table extension:
 
It is very simple and basic, but it works.
 
Now, these fields should follow the Items, and therefore I want to display them in the Sales Line table beside with the items, so that I can then make a report extension to the Sales Invoice report, and show the same fields in the report. As of now, I am not able to access these fields if I try to extend the Sales Invoice report, and I suspect it is because thet are not included in the Sales Line table.
 
How would I go about to show the fields and the values connected to the Item in the Sales Line?
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    95,329 Super User 2025 Season 2 on at
    For this requirement, there are generally two solutions.
    1. Create the same fields in the Sales Line table. When validating Item No., transfer the value to the new fields.
    2. Use Flowfield to re-obtain the value every time the page is opened. More details: https://yzhums.com/5802/
     
    Both methods can get values from the report.
     
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Shrey Chauhan Profile Picture
    284 on at
    Hello Christian,

    Step-1 : Do the "schemaUpdateMode": "ForceSync" in your launch.json file to solve the error for publishing and creating package.
    Step-2 : Create the same field with same Object ID in the Sales Line Table to flow the data from item to sales line.
    Step-3 : Link this two field with Sales Line Item No. so that the fields get the values.
    Step-4 : In your report just call this two fields under your Sales Line Dataitem.

    Hope this solution help you.
    May other experts give you better solutions

    Thank You,
    Shrey Chauhan 

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans