How to Display the Quantity Available per Site in the SmartFill Make a Selection Window

Subject:
The steps here describe how to display the Quantity Available per Site in the SmartFill Make a Selection window.

Resolution:
These are the steps to follow:

1. 1. Go to Microsoft Dynamics GP | Tools | Setup | SmartFill | Objects.
   2. Select the Items Object, and then click the Edit Object button. Here is a screenshot of a sample Items object:

      

1. 1. Click the Table Name field expansion button.
   2. In the SmartFill Object Secondary Tables window, click the Add Secondary Table button.
   3. In the SmartFill Tables window, find and select the IV_Item_MSTR_QTYS table, and then click Select.
   4. In the SmartFill Object Link window:
      1. Select the Item Number under the IV_Item_MSTR table.
      2. Select the Item Number under the IV_Item_MSTR_QTYS table.
      3. Click Link.
   5. In the SmartFill Object Secondary Tables window, click OK.
   6. In the SmartFill Object window, in the Lookup Fields section and on the next available row:
      1. Select Calculated Field in the Table column.
      2. Select New Calculated Field in the Field name column.
   7. In the SmartFill Object Calculated Fields window:
      1. Type Quantity Available in the Calculated Field Name field.
      2. Type Quantity Available in the Display Name field.
      3. Select Number for Datatype.
      4. Select Number (no decimals) for the Format As field.
      5. In the first Type field, select Table Field.
      6. In the first Table Name field, select IV_Item_MSTR_QTYS.
      7. In the first Field Name, select QTY On Hand.
      8. In the first Operation field, select Subtraction.
      9. In the second Type field, select Table Field.
      10. In the second Table Name field, select IV_Item_MSTR_QTYS.
      11. In the second Field Name, QTY Allocated.
      12. Click OK. Here is a screenshot of what the Calculated Field looks like:

          

       

   8. In the SmartFill Object Maintenance Details window, mark the Display checkbox for the Quantity Available Lookup Field. Then add the Location Code field form the IV_Item_MSTR_QTYS table. Here is a screenshot of what the Items Object looks like after adding the Quantity Available field:

      

1. Click Save.

Note: If you would like only the Site IDs where the Quantity Available is greater than zero to be displayed, you can modify the Repository record for the specific Window and Field. For example: