Skip to main content
Avalara Help Center

Can I Use Entity/Use Codes in Sage 100 Sales Tax?

Overview

You want to know if you can use entity/use codesHoverTT.png in Sage 100.

Environment

Sage 100

Resolution

  • Sage 100 doesn't automatically have entity/use code fields available, but custom user defined fields can be created in the Sage 100.
    • Only someone familiar with this process should make these changes.
    • Additionally, it is possible that your system may have other customizations that are dormant.
    • When the entity/use code customization is activated, all other customizations must also be applied. This can break your workflow depending on what other customizations are active in this process.
    • If you want to use entity/use codes to change exemption behavior in Sage Sales Tax for Sage 100 Powered by AvaTax, you first need to add the AvaTax Customer Type field. It is a user-defined field (UDF) that you add using the Custom Office module. For more information about available entity/use codes, see exemption reason matrices. If the Custom Office module isn't installed and registered, contact your Sage 100 partner. Check the modules and registration tabs in the Library Master Setup System Configuration menu to see if Custom Office is listed.
  • Add the AvaTax Customer Type Field for Entity/Use
    • Follow these steps to create and define the AvaTax Customer Type field:
    • On the Custom Office Main menu, click User Defined Field and Table Maintenance. 
    • Expand the Accounts Receivable module.
    • Click the A/R Customer Master table and click Edit Fields to access the User-Defined Fields window.
    • Click the Add?Option on the right side of the window. 
    • In the A/R Customer: Add Field window, type the following information: 
      • For Field Name, type AVA_CUST_TYPE.
      • For Description, type AVA Cust Type.
    • Next to Source, click Manual Entry.
    • Click OK.
    • In the A/R Customer Master : Add Field window, follow these steps:
      • Next to Control Type, click Multi-Line.
      • Next to Data Type, click String.
      • In the Maximum Length field, type 10.
      • Click Caption and in the field next to it, type Ava Cust Type.
    • Click OK. 
    • In the Customizer dialogue, click OK. The user-defined fields are updated and the User Defined Field and Table
      Maintenance window appears. 
    • Repeat steps 1 through 10 above to add the same User Defined Field to Accounts Receivable Module ? A/R
      Invoice Header Table.
    • Repeat steps 1 through 4 above to add the same User Defined Field to Sales Order Module ? SO Sales Order
      Header Table. 
      • In the SO Sales Order Header window type the following information:
        • For Field Name, type AVA_CUST_TYPE (the system adds a unique identifier to the name).
        • For Description, type AVA Cust Type.
      • Next to Source, click Business Object.
      • In the Business Object drop-down menu, select SO_SalesOrder_Bus.
      • In the Data Source drop-down menu, select CustomerNo.
      • In the Column drop-down menu, select UDF_AVA_CUST_TYPE.
      • Click OK.
      • Repeat steps 8 through 10.
    • Repeat steps 1 through 4 above to add the same User Defined Field to Sales Order Module ? SO Invoice
      Header.
      • In the Sales Order Module ? SO Invoice Header window type the following information:
        • For Field Name, type AVA_CUST_TYPE (the system adds a unique identifier to the name).
        • For Description, type AVA Cust Type.
        • Next to Source, click Business Object.
        •  In the Business Object drop-down menu, select SO_Invoice_Bus.
        • In the Data Source drop-down menu, select CustomerNo.
        • In the Column drop-down menu, select UDF_AVA_CUST_TYPE.
        • Click OK.
        • Repeat steps 8 through 10.
      • Close the User-Defined Field and Table Maintenance window.
  • Draw the AvaTax Customer Type field
    • Now that you added the AvaTax Customer Type fields, you need to draw them on any of the following forms using the
      corresponding entry from the table dropdown list:
      • AR Customer Maintenance ? PMAIN
      • SO Sales Order Entry ? PHEADER
      • SO Sales Order Invoice Entry ? PHEADER
      • AR Invoice Data Entry ? PHEADER
      • SO Shipping Data Entry ? PSHIPPING
  • The instructions below show how to add the AvaTax Customer Type field to the AR Customer Maintenance form. Follow
    these steps to add a field box:
    • *Note* For other windows the selection are different and the recommended selections are noted next to the window names.
    • On the Custom Office Main menu, click Customizer Selection.
    • Click the Accounts Receivable module to expand it.
    • Expand the Customer Maintenance folder.
    • Click the PMAIN button to open the Customizer Panel Selection window.
    • In the Customizer Panel Selection window, click Create a New Customized Form.
    • Next to User and Company, click both All checkboxes.
    • Click OK to open the Customizer toolbar and the Customize: AR_CUSTOMER.M4L ? PMAIN [Main Folder]
      window.
    • In the Customizer toolbar in the Add an Item section, click the Add Field button.
    • In the lower right hand corner of the Customize: AR_CUSTOMER window, place the cursor in the empty space.
      Click and drag to form a rectangle. The User-Defined Field Selection window appears when the mouse button is
      released.
    • In the Field Selection window, under AR_Customer _bus, click the MAIN folder.
    • Highlight UDF_AVA_CUST_TYPE and click Select.
    • A new gray box appears on the Customize: AR_CUSTOMER window. Click the new gray box to open the Multi-
      Line Definition [UDF_AVA_CUST_TYPE] window.
    • In the Options tab, set the Width to 10 and the Height to 1.00. A preview of the box is displayed at the bottom of
      the window.
    • Click OK.
    • Now you need to add a Field Name Label. In the Customizer Toolbar in the Add an Item section, click the Add
      Text button.
    • Place the cursor to the left of the new gray outline box just added. Click and drag to form a rectangle. The Text
      Definition window appears when the mouse button is released.
    • On the Main tab of the Text Definition window in the Text field, type AvaTax Customer Type.
    • On the Options tab of the Text Definition window, set the Width to 17 and the Height to 1.00. Preview the text
      at the bottom of the window.
    • Click OK. The new text appears in the Customize: AR_CUSTOMER window. If necessary, reposition both the text
      and the field box by clicking and dragging.
    • In the Customizer toolbar menu, click Panel > Preview to preview the panel changes.
    • In the Customizer toolbar menu, click Panel > Save and then OK.
    • Repeat steps 1-21 for each form you want to add the AvaTax Customer Type field.
    • When you finish adding the fields to all of the forms that you want to use them in, go to the Custom Office
      Utilitiesmenu and click Update Customized Panels to Current Level utility. Leave default selections of all
      Modules, Tasks, Companies, and Users as they are, and click OK.
    • Click the Rebuild Customizer Log, and click OK.
  •