2022 Release 1

This release went live on the evening of February 18, 2022.

Projects

Track federal grant information for your projects

You can now track CFDA (Catalog of Federal Domestic Assistance) grant information for your projects. See the CFDA and other related parameters for the following project functions:

Cash management

Credit card reconciliation in bank feeds

In previous releases, only bank accounts were supported when using bank feeds via the API. With this release, credit card accounts are supported as well. You can provide a financial entity (FINANCIALENTITY) to identify your connected credit card account, then reconcile your account via the API. You can use online bank feeds from Sage Cloud Services, or you can manually create a bank feed that provides your own XML transaction records.

When creating XML transactions for a credit card account, you can specify either charge or payment as the transaction type. Alternatively, you can specify withdrawal or deposit for a bank account. For more information, see the TRANSACTIONTYPE parameter here:

In addition, a read operation on a bank feed object now provides the name of the financial entity (FINANCIALENTITYNAME), whereas in the past, only the financial entity ID was included. There is also a new parameter that indicates the account type (FINANCIALACCOUNTTYPE), either Bank or Credit card.

Construction

Specify primary documents for workflows

In construction, users might need to associate specific documents with any resulting downstream transactions. Likewise, the downstream transactions should link back to the originating document. Now when you create or update a purchasing transaction definition in the API, you can set the PRIMARYDOC parameter to true so that the transaction is identified as a primary document. Then, all documents created from the transaction definition, whether automatically or manually, will contain a link to that primary document. Once you enable PRIMARYDOC for a purchasing transaction definition, you can’t disable the option.

When reading a downstream transaction, your response might include something like the following, where two transaction items point back to a primary doc:

<PRIMARYDOCKEY>51</PRIMARYDOCKEY>
<PRIMARYDOCLINEKEY>169</PRIMARYDOCLINEKEY>

See the PRIMARYDOC parameter for the following:

Purchasing and Order Entry

Override calculated VAT

When importing or updating Purchasing and Order Entry transactions in VAT-enabled companies, you may need to override the calculated VAT amount to match a tax invoice or for other reasons. There are two ways to use the new linesubtotals object within order entry and purchasing transactions to override the calculated VAT:

  • If you provide a new tax detail ID, the VAT amount for the line subtotal will be calculated using the percentage value set in the tax detail.
  • If you provide a new tax detail ID and a new VAT amount, the new amount will be applied to the line subtotal.

See the linesubtotals object for the following:

Accounts Payable

No required fields when creating draft bills

You can now create a draft bill (ACTION set to DRAFT) without providing the minimum fields that are required when posting a bill. You must provide values for those fields before a draft bill can be posted. This change only applies to the create APBILL request and not to the legacy create_bill request.

Contracts

Support for renewal forecast

To support the renewal forecast feature, the system can create CONTRACTDETAIL, CONTRACTBILLINGSCHEDULE, and CONTRACTREVENUESCHEDULE objects with a new STATE value of Renewal forecast.

Objects in this state cannot be modified. If you have existing integrations that involve these objects, you might see unexpected data after February 18, 2022.

To ensure that your integrations affect only the data you want, exclude objects in this state, for example:

<query>
    <object>CONTRACTDETAIL</object>
    <select>
        <field>RECORDNO</field>
        <field>STATE</field>
    </select>
    <filter>
        <notequalto>
            <field>STATE</field>
            <value>Renewal forecast</value>
        </notequalto>
    </filter>
</query>

Miscellaneous

Get query response in CSV or JSON

A new returnformat option for query requests lets you specify the format that will be used in the response, either XML (default), CSV, or JSON. For example, this request would return the list of vendors that are owed more than $100 as plain-text CSV:

<query>
    <object>VENDOR</object>
    <select>
        <field>RECORDNO</field>
        <field>TOTALDUE</field>
    </select>
    <filter>
        <greaterthan>
            <field>TOTALDUE</field>
            <value>100</value>
        </greaterthan>
    </filter>
    <options>
        <returnformat>csv</returnformat>
    </options>
</query>

See Response data format on the Query page for more information and sample responses.

In this release, temporary fields related to assets will appear in responses from several API functions. In particular:

  • An inspect call on the GLENTRY object returns an ASSETID parameter.
  • A read call on the GLBATCH object returns ASSETID, ASSETNAME, and ASSETDIMKEY parameters.

These parameters are not supported in any operations and will be removed in a future release.

Provide feedback