2 Replies Latest reply on Aug 3, 2011 2:59 PM by dansan500

    How Can I create a report that I can get Excel sheet with Total Qty

    dansan500

      Title

      How Can I create a report that I can get Excel sheet with Total Qty

      Post

      I have an inventory:

      I have several record entrys for the same part# with different conditions like this:

      Part #    Condition   Qty

        2343         2           10

        2343         2           10

                                     20

        2343         4           10

        2343         4             5

                                     15

      Same part, two different conditions, How can I get a speadsheet export that shows

        2343         2            20      < just one line item with total qty

        2343         4            15      < just one line item with total qty

      I can create a report and by using sorts can create this but I can't save to Excel sheet