Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Purchase Order Line items Report

Posted on by Microsoft Employee

Hi There,

I am looking for a report which can give me purchase order line items for a given date range.

Is there any such report in AX ?

Thanks

Denis

Categories:
  • Romal R. Date Profile Picture
    Romal R. Date 5 on at
    RE: Purchase Order Line items Report

    Fantastic! Worked for me as well, thanks!!

  • michmichmich Profile Picture
    michmichmich 15 on at
    RE: Purchase Order Line items Report

    Perfect. Thanks! I've now got what I need!

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,643 on at
    RE: Purchase Order Line items Report

    Hi Mich,

    What you mentioned above is inquiry form and not report. If you want to look at report, then use "Open purchase order lines by item report" instead of just "open purchase order lines". Once you do that, you will see option to schedule the report. Please know that the report only gives you "open" status only unlike the inquiry screen where you can remove filters. report doesn't let you take off the filter.

  • michmichmich Profile Picture
    michmichmich 15 on at
    RE: Purchase Order Line items Report

    Thanks Satish,

    The issue I'm having is that the "Open purchase order lines" form doesn't appear to have the same functionality!

    I want all open orders per line item...any workaround for this?

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,643 on at
    RE: Purchase Order Line items Report

    Hi Mich,

    Any report can be scheduled. To schedule, go to report section where you specify filter criteria, there is an option "run in the background", out there click on batch processing to yes, assign batch group. You need to setup recurrence as well (this determines that when that report should be run. Once you do all this and setup batch, you should be all good.

  • michmichmich Profile Picture
    michmichmich 15 on at
    RE: Purchase Order Line items Report

    Hi Ludwig,

    Is that a report that can be scheduled? I need data from that report daily.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Purchase Order Line items Report

    Thanks Mahmoud

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Purchase Order Line items Report

    It works ! thanks a lot Adineh you are awesome.

    Regards

  • Verified answer
    Adineh Negahdari Profile Picture
    Adineh Negahdari 807 on at
    RE: Purchase Order Line items Report

    Hello

    There are two columns, “status” and “line status”.

    You can add them by personlizing and remove filters by crtl+G. or by pressing crtl+f3, you  manage all filters, no matter the column are there or not. Remove two’open order’ from filter lines.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Purchase Order Line items Report

    Hello Denis Das,

    Have you tried making use of the reports that Mahmoud Hakim nicely shared above?

    If they don't work out for you, please have a look at the purchcube.

    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

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,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans