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.

As part of the bank plugin onboarding process, either you or someone from your organization has supplied a check number range. When processing a Check Print payment, the next sequential check number is retrieved from the designated range and communicated back to Intacct. It's important to note that Intacct does not permit the override of the Document Number field once it has been populated with the alphanumeric Reference ID. Consequently, the check number is filled in under the Bank tab within a custom field named Transaction ID on the bill.

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. 

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 below steps:

Select the columns you wish to see on the custom view. Be sure to select 

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.

Voiding & Repaying Bills (Intacct)

Check Number Limitations (Intacct)

YourBank

MyBank

Enabling Grouped Bills & Remittance Emails (Intacct)

Payment Methods (Intacct)

Welcome

Untitled

Pre-Onboarding Checklist (NetSuite)

Installation and Set-up

Post-Onboarding Checklist (NetSuite)

Vendor Bank Details

Temp

Vendor Payables

Information Reporting

Account-to-Account Transfers (NetSuite)

Remittance Advice (NetSuite)

Employee Expense Reports (NetSuite)

Positive Pay (NetSuite)

Supported Versions (NetSuite)

FAQ (NetSuite)

NACHA 2021 FAQ

Failed Bills

Managing Security Tokens (NetSuite)

Troubleshooting

Sandbox Checklist (NetSuite)

Release Notes (NetSuite)

Entity Bank Detail Release Notes

Release Notes

Netsuite

Pre-Onboarding Checklist (Intacct)

Post-Onboarding Checklist (Intacct)

Plugin Configuration

Bill Payments (Intacct)

Balances & Transactions

Account-to-Account Transfers (Intacct)

Positive Pay (Intacct)

Remittance Advice (Intacct)

Features

FAQ (Intacct)

Intacct Functionality Overview

International Wire Payments

Sandbox Testing (Intacct)

Release Notes (Intacct)

Intacct

Pre-Onboarding Checklist (BC365)

Installation

Post-Onboarding Checklist (BC365)

Configuration

Remittance Advice (BC365)

Sandbox Checklist (BC365)

FAQ (BC365)

Release Notes (BC365)

Business Central 365

Cutoff Times

Account Transfers Requirements

ACH Requirements

Check Requirements

FedWire Requirements

International Payment Requirements

Supported Countries for International Payments

Payment Requirements

EASI Link Release Site Guide

Switching From One ERP to Another

Term Glossary

Feature Requests

Contact Us

Support