Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How line items in Purc...
Microsoft Dynamics GP (Archived)

How line items in Purchase Orders get printed, Alphabetically or sequentially

(0) ShareShare
ReportReport
Posted on by Syrus 4,156

We are using GP 2010 and I have observerd something which is kind of odd and strange

When we create a PO, all line items entered ( 1,2,3.......) are in order and look fine but when we print the POs; these line items get sorted alphabetically and are not in sequece like 3 may get printed first then 1, then may be 2.

Is that the default way or something is wrong with the appliation ? I have also checked SQL table and everything is in order and in sequence.

We also use Forms Pritner for POs and SOs

Please throw some light

Regards,

 

 

*This post is locked for comments

  • Syrus Profile Picture
    Syrus 4,156 on at
    RE: How line items in Purchase Orders get printed, Alphabetically or sequentially

    Hi Richard,

    We are using Crystal. I treid to look for the function but could not find. It you could guide me that would be super.

    Thanks for all your help.

    Regards,

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: How line items in Purchase Orders get printed, Alphabetically or sequentially

    In forms printer, whether you are using Crystal or SSRS reports for your PO, you can control the sort order very easily.  Do you know which tool is being used and how to edit those reports?  It is a function of the report program to sort the items on the PO Form

  • Syrus Profile Picture
    Syrus 4,156 on at
    RE: How line items in Purchase Orders get printed, Alphabetically or sequentially

    Hi Leslie,

    Yes, we are using Forms Printer and actually tried to tweek the PO but it did not work. I am thinking the same way as it could be sort order.

    I am going to be in touch the ISV to see if this can fixed or a know issue.

    Thank you very much for the kind attention. it always helps.

    Regards,

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: How line items in Purchase Orders get printed, Alphabetically or sequentially

    SYED,

    You said you are using Forms Printer, what report is it printing?  That report is likely sorted perhaps in a way you do not want. If it's Forms Printer it could be printer reports that are not native to dynamics gp, and it most likely is.

    Kind regards,

    Leslie

  • Syrus Profile Picture
    Syrus 4,156 on at
    RE: How line items in Purchase Orders get printed, Alphabetically or sequentially

    Hi Richard,

    Thank you very much for the kind reply. We are using Forms Printer to print  reports

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: How line items in Purchase Orders get printed, Alphabetically or sequentially

    Oh Boy...I remember doing this for a client about 12 years ago and cannot remember exactly what I did.  I think in the Report Writer some options have to be set or a sort order specified to change the standard report to alphabetical.  Are you running a customized PO Document?

  • Syrus Profile Picture
    Syrus 4,156 on at
    RE: How line items in Purchase Orders get printed, Alphabetically or sequentially

    Hi Leslie,

    thank you very much.

    that is my assumption but when we print our POs, the line items are list alphbhetically and I am trying to find a way to print these as entered.

    Regards,

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: How line items in Purchase Orders get printed, Alphabetically or sequentially

    Hi Syed,

    I'm just using regular Report Writer reports and my PO items print in the order they were entered.

    Leslie

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans