Payables 2.0 - Check Number Limitations (Intacct)

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, 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 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 navigate to bills navigate to accounts payable > bills create new view then, click manage views > create new view select the columns you wish to see on the custom view be sure to select transaction id, payment method, and reference id next, click save 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