Sage Intacct AR Cash Receipt Details to Bullhorn Invoice Payment

First published on: 05/14/2025/5:45 pm

Workflow Summary

• The workflow scans Sage Intacct at configurable intervals to retrieve newly created AR Payments / Cash Receipts.
• It processes payments by posting corresponding invoice and credit payments back to Bullhorn One, but only for transactions originally generated from Bullhorn.

Workflow Description 

At configurable intervals, this workflow queries Sage Intacct to retrieve all new AR Payments / Cash Receipts recorded since the previous execution. For each payment retrieved, the workflow executes the following process:

1. Retrieve Payment Details: The workflow extracts the full details of each payment, including the list of paid AR Invoices and any allocated credits applied as part of the transaction.
2. Process Paid Invoices: For each invoice associated with the payment:
   • The workflow checks whether the invoice originated from Bullhorn One.
   • If it does, the payment is posted back to Bullhorn as an invoice payment.
   • If the invoice was not generated by Bullhorn, it is ignored.
3. Process Applied Credits: Similarly, for each credit memo applied in the payment:
   • The workflow verifies whether the credit exists in Bullhorn One.
   • If it does, the payment is applied to the corresponding Bullhorn credit.
   • If the credit is not from Bullhorn, it is skipped.

Workflow Diagram

Mapping 

Create Bullhorn Invoice Payment

Create Bullhorn Credit Payment

Assumptions

• Invoice Number Mapping: Document sequencing for AR Invoices in Sage Intacct must be disabled to allow the Bullhorn One Invoice Statement number to be directly mapped to the Sage Intacct AR Invoice number.
  • If this direct mapping is not feasible, the Bullhorn Invoice Number and ID must be stored in custom fields within Sage Intacct.
  • In this case, the workflow must be minimally adjusted to use these custom fields when identifying and matching invoices and credits within Bullhorn One.

Previous