Open Forum

Expand all | Collapse all

Qty Total in Picking Ticket

  • 1.  Qty Total in Picking Ticket

    Posted 21 days ago

    Hello,

    How Adding a QTY Total field in the SOP Picking Ticket Form?



    ------------------------------
    Angel Cintron
    BI Developer
    PAN AMERICAN GRAIN
    bellevue
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Qty Total in Picking Ticket

    GPUG ALL STAR
    Posted 14 days ago
    It's not uncommon to want a control total at the end of the report, especially if all products are of the same unit of measure, i.e., Each, Case, etc. What you need to do is modify the report with Report Writer (print the Standard report to screen then click on Modify) and add the Quantity field from the sopIndividualPickTicketTemp table and drag it to the SOP Number section (F1) on the report. Double-click on it to access the Report Field Options window and change the Display Type to Sum.

    Exit Report Writer, grant security access to the modified report and print again to confirm you have the results you want.

    ------------------------------
    Mariano Gomez Bent, MVP, Dynamics Credentialed Professional
    Director of Technology
    Mekorma
    ROSWELL GA
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role