Supplier GL groups

Use supplier GL groups to categorize suppliers to post transactions to specific GL accounts based on these categories.

If you want to categorize suppliers for reporting, for example to view the Supplier aging report by Supplier category, see Supplier types.

About supplier GL groups

You can create supplier GL groups that are specific to your business. Then you assign a supplier GL group to each supplier record. Finally, you can map the supplier GL group to GL accounts on transaction definitions.

For example, say you have different suppliers who supply hardware. You could have one supplier GL group called Hardware. If you wanted to track data in more detail, you could create more supplier GL groups, such as Mainframe, Minicomputer, and so on. In this example, if you buy a part from a Mainframe supplier, the purchase transaction could post to a different GL account than the one for a Minicomputer supplier from whom you purchased the same part. You could also filter list views by these supplier GL groups.

View a supplier GL group

  1. Go to Purchasing > Setup > Suppliers > GL groups.

  2. Records designated as Inactive do not appear in the list by default. To view these records, select Filters at the top of the list and select Remove next to the Status filter to remove it.

  3. When you access the list from the top level, you initially only see records created at the top level. To see records created within entities, select Filters and then select Include entity records. Select Apply to update the filter.

  4. Select More actionsView at the end of the row to display a specific vendor GL group.

  1. Go to Purchasing > Setup > Suppliers > GL groups.

  2. To view inactive GL groups, select the Include inactive checkbox.
  3. If you accessed this page from the top level of a multi-entity shared environment, select the Include private checkbox to view the GL groups that were created at the entity level.
  4. Select View next to the supplier GL group.

Add a supplier GL group

  1. Go to Purchasing > Setup > Suppliers and select Add (circle) next to GL groups.

  2. In the Name field, enter the name for the GL group.
  3. Use the Status dropdown list to indicate whether the GL group is active or inactive.
  4. Select Save.

Deactivate a supplier GL group

You can deactivate a supplier GL group (change the status to Inactive), which prevents it from appearing in any supplier GL group selection lists but Sage Intacct retains the supplier GL group for historical purposes.

  1. Go to Purchasing > Setup > Suppliers > GL groups.

  2. Find the supplier GL group to deactivate.

  3. Select Edit at the end of the row.

  4. Select Inactive in the Status field and then select Save.
  1. Go to Purchasing > Setup > Suppliers > GL groups.

  2. Select Edit next to the applicable supplier GL group.

  3. Select Inactive in the Status field and th select Save.

Delete a supplier GL group

You can delete a supplier GL group if it has not been used by any transactions or if it has not been assigned to any suppliers. This removes the supplier GL group from the system.

  1. Go to Purchasing > Setup > Suppliers > GL groups.

  2. Find the supplier GL group to delete.

  3. Select More actions > Delete at the end of the row.

    Depending on your user preferences, to confirm the delete select OK.

  1. Go to Purchasing > Setup > Suppliers > GL groups.

  2. Find the supplier GL group to delete, select the checkbox at the end of the row, and select Delete at the top of the page.

    Depending on your user preferences, to confirm the delete select OK.

Assign a supplier GL group to a supplier

  1. Go to Purchasing > All > Suppliers.

  2. Find the supplier in the list.

    The Supplier Information page appears.

  3. Select Edit at the end of the row.

  4. Select the Additional information tab.
  5. In the Supplier details section, use the GL group dropdown to select the applicable supplier GL group.

  6. Select Save.

  1. Go to Purchasing > All > Suppliers.

  2. Find the supplier in the list and select Edit.

    The Supplier Information page appears.

  3. Select the Additional information tab.
  4. In the Supplier details section, use the GL group dropdown to select the applicable supplier GL group.

  5. Select Save.

Map supplier GL groups to GL accounts on transaction definitions

You must have the appropriate permissions to edit transaction definitions. You can map supplier GL groups to GL accounts on transaction definitions that post to either AP or the GL, for example, a PO purchase invoice.

  1. Go to Purchasing > Setup > More > Transaction definitions.

  2. Find the transaction definition.
  3. Select Edit at the end of the row.
  4. Select the Posting configuration tab.
  5. Supplier GL groups selection lists

    The Item GL group, Warehouse, and Supplier GL group together form the criteria set for the account mapping. For example, you could have the Products item GL group, Warehouse 13, and Mainframe supplier GL group mapped to a GL account and offset account, and the Products item GL group, Warehouse 13, and Minicomputer supplier GL group mapped to a different GL account and offset account.

  6. Select Save.

  1. Go to Purchasing > Setup > More > Transaction definitions.

  2. Find the transaction definition and select Edit next to it.
  3. Select the Posting configuration tab.
  4. Supplier GL groups selection lists

    The Item GL group, Warehouse, and Supplier GL group together form the criteria set for the account mapping. For example, you could have the Products item GL group, Warehouse 13, and Mainframe supplier GL group mapped to a GL account and offset account, and the Products item GL group, Warehouse 13, and Minicomputer supplier GL group mapped to a different GL account and offset account.

  5. Select Save.

Learn more about transaction definitions.

Field descriptions

The following table describes each item in the SupplierGL group information page.

SupplierGL group information page field descriptions
Field Description

Name

Name of the supplier GL group. You cannot change the name after you save the group.

Status

The default status is Active. If you are no longer using this supplier GL group and do not want it to appear in dropdown lists, choose Inactive. You can still view inactive supplier GL groups by selecting the Include inactive checkbox in the Supplier GL Groups list.

What does "Not owned" mean?

In a multi-entity company, shared records such as customers, suppliers, and other items can be edited only at the top level of a company. Some journal transactions, for example, recurring journal entries created at the top level, are also owned at the top and can't be edited from within an entity.

If you display the list of shared records (customer, supplier, or entry) within an entity, you can see the shared records in the list. However, these will be listed as Not owned by the entity and the Edit option won't appear. Move to the top level, which owns the record, to make any changes.