Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Showing Raw Materials with different as of date in the Report

(0) ShareShare
ReportReport
Posted on by 3,110

Report1Picasof.png

Dear Experts,

As on date mean "till to date" in the report right?? Now i need a report which will show in the above image manner data for
For example in the above image Batch number "6RM00945" has item number "100000" not what is the qty of this item in this batch in the
above date ?? For example Batch number "6RM00945" and item number "100000" as of date 01.01.19 qty Raw materials as of the date
31.03.19 date qty again, in the same manner, please check the above image for more information. If any confusion i am here
Thanks in advance

Best Regards,
Shabir Ahmad

  • Suggested answer
    Junaid Idrees Profile Picture
    on at
    RE: Showing Raw Materials with different as of date in the Report

    This is aged inventory report that shows for How long each item of your inventory (Batch wise) typically spends in storage before it is sold or consumed and also the movement of your inventory Qty.

    Can you share the screen shot of Inventory aging parameter screen. What date do you select in as of date column?

    I believe the link shared by Ludwig will fulfill your purpose if you specify correct dates in data parameters.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Showing Raw Materials with different as of date in the Report

    Hello Shabir Ahmad,

    This looks like an inventory aging report.

    What might help here to get those data out of AX is the following report.

    Please see:

    organicax.com/.../

    Best regards,

    Ludwig

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March 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... 294,095 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans