Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / How to get reserved qu...
Finance forum
Unanswered

How to get reserved quantity from batch reservation for a batch order?

Posted on by 144
Hi,

I have a SSRS report, where I need to print the reserved qty lines for a batch order. 
Path : From Batch order > formula lines > inventory action pane > Batch reservation.
In this there is edit method for the control named "Reservation". This is a formdatasource method. 

I need to add this in a condition to get the reserved qty lines. What is the correct approach here?

As per the below Screenshot, I need to display 2nd and 3rd line which has "Reservation" value only. But as Reservation is a formdatasource method, I'm unable to add that in a if condition. 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,532 Super User 2024 Season 2 on at
    How to get reserved quantity from batch reservation for a batch order?
    Hi RSX,
     
    You can insert records in a temporary table and copy the logic of the form datasource method. Then after filling the details, you can remove the lines that don't have a value in the Reservation field on the temporary table.
  • RSX Profile Picture
    RSX 144 on at
    How to get reserved quantity from batch reservation for a batch order?
    It is a customization, and it is based on data provider class.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,532 Super User 2024 Season 2 on at
    How to get reserved quantity from batch reservation for a batch order?
    Hi,
     
    What exact SSRS report are you referring to? Is it a standard report or a customization? If it is a customization, is the report based on a query or data provider class?

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans