Payables and Receivables in Sage Intacct

πŸ“˜

Sage Intacct support in the Routable API is currently in beta.

Please contact Routable's Developer Experience team or your Routable Customer Success Manager if you'd like to participate in our beta rollout.

Sage Intacct is a very powerful platform, and consequently, it can require a great deal of additional data to perform its tasks, particularly as it applies to Payables and Receivables in the Routable API. In this article, we'll go through the extra data that Routable needs to link these transactions to Intacct.

The Payable / Receivable's ledger object

In Sage Intacct integrations, the ledger object in the main body of a Create a Payable or Create a Receivable call is not used. All Intacct-specific information is tracked on a per line-item basis.

Line Items

πŸ“˜

Where do I get this information?

Most Intacct-specific fields, such as class and department, are passed in the format { "id": "some_id" }. Only the customer and vendor fields do not conform to this format.

To obtain the IDs to pass for these fields, use the List Accounting Software Objects endpoint. We recommend caching these values for your most commonly-used objects.

The Line Items contained within a Payable or Receivable have specialized fields for Intacct integration. They are passed in the ledger object on each LineItem. The individual fields that are required may vary depending on your Intacct configuration. They include:

  • account is the account in your Chart of Accounts in Intacct to track the line item against.
  • class is an object containing the ID of a class for the individual line item in Intacct, such as "Furniture" or "Hardware".
  • contract references the ID of a Contract in Intacct to track the line item against.
  • customer allows you to enter a reference to a customer to track this line item against. This is not an object ID.
  • department is an object containing the ID of a department in Intacct, such as "Engineering" or "Sales".
  • employee references the Employee in Intacct to track the item against.
  • item tracks the line item against an inventory item in Intaact.
  • location is an object containing the ID of an Intacct location - perhaps a store number or a warehouse.
  • project is an object containing the ID of an Intacct project or opportunity.
  • task is an object containing the ID of a Task in Sage Intacct.
  • vendor allows you to enter a reference to a vendor to track this line item against. This is not an object ID.
  • warehouse is an object containing the ID of a Warehouse in Sage Intacct.