Print Inventory Labels by Qty on Hand

SUGGESTED

I need to be able to print Inventory Labels by the Qty on Hand amount. How can I do this?

  • 0 in reply to BShockley

    I ended up finding a solution similar to the one you supplied online. I created a UDT and I am up and running. However, I want to note some things for future reference.

    1. I was running the ‘Inventory Label Printing’ option from the IM Reports Menu. We wanted to select all Inventory Items and print labels only for the items that have an On-Hand Quantity.
    2. The 'Inventory Label Printing' option uses a WRK file (IM_InventoryLabelsWRK). The WRK file did not include the QTY on Hand so I had to link the WRK to the CI_Item file, and I had to link the CI_Item file to the UDT. When I tried to link the ‘TotalQuantityOnHand’ field from the CI_Item table to the UDF in the UDT table they would not link together because the UDF is a string format where the ‘TotalQuantityOnHand’ is numeric. So, I created a numeric UDF for the UDT. I then linked the two together using a left outer join and the >= Link Type.
    3. When I printed the labels two things happened.
      1. The Item Numbers that did not have a ‘TotalQuantityOnHand’ value printed a single label for all items (Preview mode of course). I simply created a record selection formula to include items with greater than 0 QTY.
      2. The item numbers that did have a ‘TotalQuantityOnHand’ printed the labels twice. To get around this, I set the ‘Number of Labels Per Item’ in the entry screen to 0.

    After doing all of this, the labels are printing correctly.

    Thank you all for your help.

  • 0 in reply to TomTarget

    I was running the ‘Inventory Label Printing’ option from the IM Reports Menu. We wanted to select all Inventory Items and print labels only for the items that have an On-Hand Quantity. I have successfully figured out how to print the labels. Thanks.