News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Showing Raw Materials ...

Finance | Project Operations, Human Resources, ...

Suggested answer

Showing Raw Materials with different as of date in the Report

(0) Share

Report

Report

Posted on by Shabir Ahmad

3,024

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

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Junaid Idrees 12,746 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans