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...
Suggested answer

Modifying Posted Sales Shipment Report- Temporary lines not showing data.

(1) ShareShare
ReportReport
Posted on by 140
Hello, I have created report extension for adding a new column into sales shipment lines.
 
Firstly, the column in added to sales shipment lines and the data is getting populated on the page after I have used EventSubscriber method to fetch the data.
Now, the same columns needs to be added into report.
 
When I looked at the structure of the report. Two dataItem is there
1.  dataitem(/Sales Shipment Line/; /Sales Shipment Line/){}
2.  dataitem(SalesShptLine; /Integer/)
 
The second one is a temporary sales lines.
All the data on the report line are getting populated from SalesShptLine.
 
I am not able to figure out a way to add the column there and fetch the correct data for those lines. Please help !
 
Following is the manipulation that i tried to do is as follows:(Not sure if it is right or not, due to this code i can see the column names into word report XML Mapping section)
 
 
  • Suggested answer
    Dustin Wolf Profile Picture
    30 on at
    Modifying Posted Sales Shipment Report- Temporary lines not showing data.
    What is the report number you are trying to extend?  The visibility of the TempSalesLine may not be accessible from extensions.
    if you use the TempSalesLine2, it wont work because you are not populating that record. So it will be blank.
     
    I have run into issues extending some reports.  Accessibility of protected fields on the reports are a major problem.
    if the tempsalesline is unavailable, the best course of action would probably be to copy the report to a custom range and make the modifications where you need them.
    then use that custom report in the Report Selection for the Shipment
     
     
    Dustin Wolf, MS
    Senior Developer
    Accent Software, Inc.

     

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,238 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans