Sage Company – Departments In Sage Intacct

Keywords: Transactions, Sequences, Sage

Credit:–  Sage Photo By: FP

Struggling to Keep Your Books in Order? 📊📅

Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.

👉 Click Here for a Free Consultation!

About the Departments list

Use the Departments list to view a list of the departments in your company. You can sort and filter the department list to see just the group of departments you want.

To find your departments:

  • Go to Reports > Setup > Dimensions > Departments.
  • Select
  • Add
  • next to Departments to add a new department, or select Edit or View next to an existing department.

If you have long department lists in external data files, you can upload them in CSV format by selecting Company > Setup > Import data. You can find more information on uploading CSV files in Prepare CSV files upload data and Importing departments.

For users in a multi-entity shared company: Departments are common (that is, accessible) to all entities. Departments are also a filter object used to restrict user access.

Add or edit a department

All you need to create a department is to assign an ID and name for it.

  • Enter a department ID and Name.
    After you create a department, the ID can’t be changed.
  • If the department belongs to a hierarchy of departments, select its Parent location.
  • Optionally, select the department Manager (useful for routing purchasing approvals).

Make a department inactive

If you no longer use a dimension value that’s associated with past transactions and records, you can make that dimension value inactive so that you don’t see it on any future lists or transactions.

  • Go to Reports > Setup > Dimensions and select the specific dimension.
  • In the list page, find the dimension value, and select Edit.
    The dimension information page appears.
  • In the Status field, change the status to Inactive.

To view inactive dimensions on reports and lists:

  • Select the Include inactive checkbox at the top of the report or list page.

Don’t see Include inactive on your page?

To include data from inactive dimensions on financial reports, you can use dimension groups for filtering.

Delete a department

You delete department records from the Departments list.

You can delete a dimension value if it hasn’t been associated with a transaction or record. For example, if you create New York as a value for Location and use it in a transaction line item, you can no longer delete New York from the Location list of values.

  • Go to Reports > Setup > Dimensions and select the specific dimension.
  • Find the dimension values you want to delete.

Don’t see Include inactive on your page?

  • Select the Delete checkbox at the end of the row for each dimension value you want to delete, and select Delete.

Document sequences for auto-numbering IDs

You can use document sequencing to generate new IDs automatically for common transactions and records, such as new customers, vendors, invoices, and more. For example, you can create a document sequence for invoices. This sequence automatically creates a new ID, such as “INV-0100” and increments the number each time a new invoice is entered. You can save time by using document sequences. Instead of having users enter unique IDs for new customers, vendors, and other records, you can have Intacct automatically generate the next sequence.

To view the Document sequence list, go to Company > Setup > Settings > Document sequence. From the Document sequence list, you can add a new sequence, or edit or view an existing sequence.

You can create numeric sequences for many different types of records or transactions, such as for customers, vendors, purchase requisitions, and adjustments. Usually, you update the application configuration page or transaction definition to identify the specific sequence to use for a record or transaction. For example, if you create a sequence for invoices, update the Configure Accounts Receivable page to identify the document sequence. Administrators typically configure applications.

After you’ve configured your application, use caution when changing or deleting document sequences.

Best practice for numeric sequences

Intacct recommends against adding leading zeros as part of an ID sequence. IDs with leading zeros can cause errors when you import information into your company from Excel because Excel removes the leading zero. Use a character as a prefix to your ID; for example, C0001 for a customer ID.

Import Workaround: If you must use leading zeros in IDs, convert the column of ID numbers to text format in Excel before importing the file content. Excel will not remove the leading zeros when you save the file. Remember to convert the column of ID numbers to text format every time you use a template to import information that requires IDs.

Where can I use alpha sequences?

Alpha sequences are currently only available for use with Accounts Payable, Accounts Receivable, Cash Management, and French companies. You can currently create alpha sequences for use with bank and credit card reconciliation matching in Cash Management, and for vendor and customer reconciliations in Accounts Payable, Accounts Receivable, and French companies.

To use alpha sequences, update the application configuration page or transaction definition to identify the alpha sequence to use for a record or transaction. For example, if you create a sequence for bank or credit card reconciliation, update Cash Management to use the alpha sequence. Administrators typically configure applications.

Add a document sequence

  • Go to Company > Setup > Settings and select
  • Add
  • next to Document sequences.
  • Enter the required fields, and any other information that you want to include in your sequence.
    The required fields are:
  • Sequence ID
    Cannot be changed after save.
  • Sequence name
  • Sequence status
  • Sequence type
    Cannot be changed after save.
  • Primary sequence
    Cannot be changed after save.
  • Next primary sequence
    Automatically generated, but can be edited.
  • Select Save.

Fiscal year rollover

Fiscal year rollover for document sequences helps you manage your alpha and numeric sequences with easy year-end transitions, improved organization, and enhanced transaction matching. Fiscal year rollover is only available for use with Contracts, Fixed Assets Management, and General Ledger at this time. Much like an alpha sequence, your Intacct application must be configured to use a fiscal year rollover document sequence.

To use fiscal year rollover:

  • Create a new document sequence.
  • Enter information for the required fields.
  • Select the Enable sequence fiscal year rollover checkbox.
    When selected, the fiscal year end for your company is displayed, and the day the rollover was enabled for this sequence.
  • Select how you want the fiscal year to be appended to your document sequence:
  • None: When selected, the fiscal year will not appear in your document sequence.
  • Prefix: When selected, the fiscal year is added as the Rollover prefix to your document sequence, followed by an editable Separator field.
  • Suffix: When selected, the fiscal year is added as the Rollover suffix to your document sequence, preceded by an editable Separator field.
  • Save your changes.

When fiscal year rollover is enabled, the next 10 years of document sequences with corresponding fiscal years are displayed. The year field is not editable.

Edit a document sequence

  • Go to Company > Setup > Settings > Document sequences.
  • Select Edit next to the document sequence that you want to change.
  • Update the information that you want to include in your sequence.
    The following fields cannot be edited:
  • Sequence ID
  • Sequence type
  • Primary sequence
  • Select Save.

Delete a document sequence

You delete a document sequence from the Document sequence list. Use caution when deleting sequences. If you delete a sequence that’s in use, users cannot create any documents using this sequence and they receive an error message.

Intacct recommends that you tightly control user permissions for this function using Company > Admin > Users > Subscriptions > Permissions.

  • Find the record that you want to remove and select Delete.
    Depending on your user preferences, the system may prompt you to confirm the deletion.

Turn off auto-sequencing

Auto-sequences for new IDs are assigned in the application configuration page for each Intacct application. Administrators can edit the sequences. When you turn off auto-sequencing, existing IDs remain.

The following steps are an example of how to turn off document sequencing in Accounts Receivable. These steps can be used in other Intacct applications to turn off document sequences there as well.

  • Go to Accounts Receivable > Setup > Configuration.
  • Some applications, such as Customization Services, Platform Services, and Web Services, do not have configuration options .Scroll down to Document sequencing.
  • Delete the assigned document sequence under Invoices and leave the dropdown field empty to turn off auto-numbering.
  • Save your changes.

Check out our Free Additional Articles