UDF for total qty on purchase order

I created a UDF to show total qty on purchase order.

Works fine for new orders, but it's showing 0 for existing orders.

Any way to update the existing purchase orders to show the total qty on the purchase order?

  • 0

    So you used the feature to create a Header numeric UDF where you can point the data source to "Total from PO_PurchaseOrderDetail" and then set column = Quantity Ordered ? Not the answer you're looking for but I'm fairly certain you have to script it because of its limited scope design. I would recommend scripting or other means regardless.

    Every time I've ever had this type of request to get Total Qty (to determine case qty, etc), it was always conditional with rqmt to evaluate for specific product lines only, certain vendors / customers only, etc, certain order types or statuses only, etc. You can't build that logic w/o script or mod. Furthermore if you add misc items to your PO, that qty will be included in your Total Qty as well (and maybe you don't want that).

  • 0 in reply to Alnoor

    In this case, all of the item types should be included in the total qty.  With that said, anyway to calculate the qty for existing orders?

  • 0 in reply to BShockley

    If you open an existing order, and flip the Tax Schedule to something else, then back, do the totals update?  If so, two imports (one to change, one to change back) should do it.

  • 0 in reply to Kevin M

    I already tried that trick, and it didn't work.  I also tried changing the qty of an existing item, and I even added a new item.  None of these things worked.

  • 0 in reply to BShockley

    Brian - With the feature you're using, you can't update existing orders. So you'll have to import (update) in the correct Total Qty for these into that Header UDF (at least it's it's on the Header). Or you can do a script.