How to Add a Field from Another Table to a SmartFill Object

Describes the steps to display the Customer Balance field to show in the Make a Selection window when using SmartFill.


  1. Go to Microsoft Dynamics GP | Tools | Setup | Smartfill | Objects.
  2. Open the Customer Object.
  3. Click the blue arrow to the right of the Table Name field to open the SmartFill Object Secondary Tables window.
  4. Under Secondary Tables, click + to add a new table.
  5. Make the following selections:
    Product: Microsoft Dynamics GP
    Series: Sale
  6. In the Tables list, select the RM_CUSTOMER_MSTR_SUM.
  7. Click Select.
  8. From the Fields (left side), select Customer Number.
  9. From the Fields (right side), select Customer Number.

  1. Click Link.
  2. Click OK.
  3. In the Lookup Fields area, select RM_Customer_MSTR_SUM as the table.
  4. Under Field Name, select Customer Balance.

  1. If you would like to search on this value, check the Search box.
  2. Check the Display box.
  3. Click Save.
  4. Close the remaining window.

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.