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)

Test

BusinessDays

YourBank

MyBank

Enabling Grouped Bills & Remittance Emails (Intacct)

Vendor Approvals

Payment Methods (Intacct)

J.P.Morgan

J.P. Morgan

Welcome

Getting Started

Pre-Onboarding Checklist (NetSuite)

Installation and Set-up

Post-Onboarding Checklist (NetSuite)

Configuration

Vendor Bank Details

Temp

Vendor Payables

Information Reporting

Account Transfers (NetSuite)

Positive Pay (NetSuite)

Remittance Advice (NetSuite)

Employee Expense Reports (NetSuite)

Features

FAQ (NetSuite)

NACHA 2021 FAQ

Failed Bills

Supported Versions (NetSuite)

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

Fund Transfers (Intacct)

Positive Pay (Intacct)

Remittance Advice (Intacct)

FAQ (Intacct)

Sandbox Checklist (Intacct)

Release Notes (Intacct)

Intacct

Pre-Onboarding Checklist (BC365)

Installation

Post-Onboarding Checklist (BC365)

Remittance Advice (BC365)

Untitled

Sandbox Checklist (BC365)

FAQ (BC365)

Release Notes (BC365)

Business Central 365

Pre-Onboarding Checklist (Xero)

Post-Onboarding Checklist (Xero)

Plugin Setup

Access Bank Feeds in Xero

Bank Feeds

FAQ (Xero)

Failed Payment Notifications

Account Transfers Requirements

ACH Cutoff Times

ACH Requirements

BACS Requirements

CPA Requirements

Check Requirements

FedWire Requirements

Supported Countries for International Payments

International Wire Requirements

SEPA Requirements

SUA Requirements

International Wire Auto FX

AU Wire Requirements

AU EFT Requirement

NZ EFT Requirements

NZ Wire Requirements

SG Wire Requirements

SG EFT Requirements

ZA EFT Requirements

ZA Wire Requirements

UK FPS Requirements

Payment Requirements

Term Glossary

Sandbox to Production

Feature Requests

Contact Us

Partner Center

Support