web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

I am trying to sort items on the SOP Packing Slip form by Item Short Name. I enter the parameters and it sorts but puts each line item on a separate page. How can I get it to sort on a single page?

(0) ShareShare
ReportReport
Posted on by 440

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    65,271 on at

    H0576.RW-Sorting-Definition.png"270" width="415" src="/api/data/v9.1/msdyn_richtextfiles(22034600-62BC-4DFD-A08E-F0539B8051B2)/msdyn_imageblob/$value?size=full" border="0" />

    Please let me know if this doesn't work for you.

    Kind regards,

    Leslie

  • Brian Girard Profile Picture
    440 on at

    I set it up like you did but it is still putting individual line items on separate pages.

  • Suggested answer
    Community Member Profile Picture
    on at

    The separate page option of reports is controlled by Reset Report and  Page Break checkboxes of footers in  the Section Options (Tools>> Section Options in report layout).

    The packaging slip report has Reset Report option checked on for Footer Back Order. However, turning it off will lead to items in different invoices in  a batch being printed on the same page. How do you want print items packaging slips ? You can  try changing section options to control pages printed for the packaging slips.

  • Brian Girard Profile Picture
    440 on at

    so basically if i have an order with 5 items on it, when i print the packing slip i want those 5 items sorted by item short name on that packing slip only and so on for each order in the batch.

  • L Vail Profile Picture
    65,271 on at

    I was only printing the packing slips one at a time. I have not tried batch printing yet. I'll give that a shot. The problem I'm seeing is the temp table and the section break. Curiously, what is being accomplished by printing in Short Description order?

  • Community Member Profile Picture
    on at

    Hi Brian,

    Can you confirm that all items have same delivery method and ship to address? If the delivery method or ship to address  are different, items in same order are printed on separate pages.

    Can you also check if items are printed on separate pages even you print the original packaging slip report. You can do it by removing the permission to modified report.  

  • L Vail Profile Picture
    65,271 on at

    Good point Rubal,

  • Brian Girard Profile Picture
    440 on at

    Leslie,

    The reason for sorting is for order picking reasons (to sort the items based on their location on the shelf).  We do not use the picking ticket form as it just creates more paper to print.  Gotta be green these days!!

    Rubal,

    Yes I can confirm that we only use one delivery address and one shipping method per order, this is not changed on the line item level.  When I print the Packing Slip form normally with no sort parameters the order prints on one page, t he items are just sorted based on the order they were entered.

  • Community Member Profile Picture
    on at

    I just tested again adding table Item master and sorting data with item short description. This did not affect the paging of the report. You may want to look into other modifications, if any, to find the problem.

    If you want you can email me the report package file at ruby AT saci.com . I will try to find problem.

  • L Vail Profile Picture
    65,271 on at

    Interesting,

    I need to go look at my test way more carefully to see how it fooled me. I wonder if you could modify the Picking Ticket to look like at invoice/Packing Slip. Then you could put the Item Short Description information in the Bin Number field and print the Picking Ticket sorted by bin number form as your invoice/packing slip.

    Ok, I'm not going crazy. I repeated my test. I printed the packing slip and you can see I have a single sheet with each of the items in Item Short Name order. I put the Line Item Sequence on the report so you can see the items did not print in sequence order. Isn't this what you are looking for? This is 3 pages because it is a long invoice.

    Kind regards,

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans