---
title: Check Number Limitations (Intacct)
slug: svb/check-number-limitations-intacct
docTags: qsTTpmTCpLZnj3pL4Rz_Z
createdAt: 2024-01-03T19:56:44.541Z
---

There is a limitation with Sage Intacct where the **Document Number** field on a bill cannot be overwritten once it has been populated.

When a payment is processed through the bank plugin, the **Document Number** of the bill is populated with an alphanumeric **Reference ID**. This field is usually where you would expect to find the Check Number.

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/4iKTWISgrgWUMmFEmNwa-_image.png" size="80" width="2384" height="614" position="center" caption="See Reference ID appearing as "EFT: #404f7398-ceed-46b5-8d03-50a9c823a3f2"" showCaption="true"}

As part of the bank plugin onboarding, your organization supplied a Check Number range.

When you process a Check Print payment, the plugin automatically retrieves the next sequential Check Number from this range and sends it to Intacct.

Intacct's restriction prevents the plugin from overriding the standard **Document Number **field once it's populated with the alphanumeric **Reference ID**. Therefore, the actual check number is recorded in a different location: it is saved under the Bank tab in a custom field named **Transaction ID **on the bill.

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/88c3yFxLAbDZn3lcghykQ_image.png" size="80" width="2384" height="740" position="center" caption="See Transaction ID field under your Bank tab on the Bill" showCaption="true"}

Because the alphanumeric Reference ID is populated instead of the Check Number, you may discover that during reconciliation, you can only see the Reference ID on the Intacct side and the actual Check Number on the bank side. 

***

## Workaround

To help with reconciliation, you can create a custom view in Intacct to display the corresponding Check Number for each alphanumeric Reference ID.

To create this report, please follow the steps below:

::::WorkflowBlock
:::WorkflowBlockItem
### Navigate to Bills

Navigate to **Accounts Payable -> Bills**. 

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/aqOVh42ljwh8LCT69NPfs_image.png" size="80" width="1780" height="966" position="center" caption="Click on "Bills" under the Accounts Payable Menu" showCaption="true"}
:::

:::WorkflowBlockItem
### Create New View

Then, click **Manage Views -> Create new view**. 

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/2VMDhdsSw6L-PXyEyYkTe_image.png" size="70" width="1140" height="424" position="center" caption="Click "Create new view"" showCaption="true"}

Select the columns you wish to see on the custom view. Be sure to select **Transaction ID, Payment Method, **and **Reference ID**. 

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/jv5ohxOKddbrbDF31Btzd_image.png" size="28" width="360" height="155" position="center" caption="Select Reference ID, Transaction ID, and Payment Method. The order that these items appear in may differ." showCaption="true"}

Next, click **Save**.
:::

:::WorkflowBlockItem
### Filter for CHECK

After saving the view, you can filter for **CHECK** under the Payment Method column to isolate bills that have been paid through Check Print via your bank plugin.

::Image[After saving the view, 
]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/0hApgvX4tcMWoK7hO7fnN_my-bank-check-numbers.png" size="80" width="2752" height="1112" position="center" caption="A Custom "My Bank Check Numbers" View" showCaption="true"}
:::
::::