Modifying the Items Object to show Quantity Available. (QTY Available, Quantity on Hand, Quantities)


You would like the Items Object to also show the QTY on Hand.


    1. Go to SmartFill | Objects.
    2. Double-click on the Items Object to open the Object Maintenance window.
    3. Next to the Table Name, click the blue expansion arrow to open the SmartFill Object Secondary Tables window.
    4. Click on the [+] button next to Secondary Tables.

    1. In the SmartFill Tables window, locate and highlight the IV_Item_MSTR_QTYS table. Click Select.
    2. In the SmartFill Object Link window you will see two Field Lists. This is where you will make the link between the two tables.
    3. Highlight ‘Item Number’ in both lists and click the Link button.

    1. Next, be sure you click OK to save the changes.
    2. In the Object Maintenance window, click on the Filters button.
    3. On the first line, enter the following information in:
      • Table Name: IV_Item_MSTR_QTYS
      • Table Field: Record Type
      • Operation: Equals
      • Value: 1

    4. Then, click OK to save changes in the Object Filters window.
    5. In the Lookup Fields area of the Object Maintenance window, click the Table drop down arrow on an empty line and select Calculated Field.
    6. Then, click the drop down for Field Name and select New Calculated Field.
    7. The Object Calculated Field window will open where you will fill in the following:
      • Give the Calculated Field a name, such as QTY Available
      • Choose a Display Name, such as QTY Available.
      • Set the Datatype as Number.
      • Select ‘Number (no decimals)’ for the Format As field.
    8. Enter the following for the first line:
      • Type: Table Field
      • Table Name: IV_Item_MSTR_QTYS
      • Field Name: QTY on Hand
      • Operation: Subtraction
    9. Enter the following for the second line:
      • Type: Table Field
      • Table Name: IV_Item_MSTR_QTYS
      • Field Name: QTY Allocated

    10. Then, press OK to save the changes.
    11. Be sure to mark the Display checkbox next to the newly created Calculated Field. You can also add in the QTY on Hand, which is shown below.

    1. When you are finished, be sure you save all changes.
    2. Finally, close and reopen any Dynamics GP windows that were open so that SmartFill can refresh.

If you have questions or any issues with this setup, please reach out to our Support team!

Related Content

How to Maximize Your Investment in Microsoft Dynamics GP

You’ve invested a lot into Microsoft Dynamics GP, and it serves you well, but did you know it likely can do so much more for you? Even if you’ve been using GP for years, it’s possible you don’t know how much more GP can do for you. Want to improve the bottom line? It might be time to invest in your own investment and get more ROI out of the rich system features that might be right under your nose.