Check Number Limitations (Intacct)

check number limitations 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 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 below steps navigate to accounts payable > bills 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 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 after saving the view,