qb_check_duplicate
Prevent duplicate transactions by checking if a transaction with the same date and amount already exists within a tolerance window.
Instructions
Checks whether a transaction with this date+amount already exists somewhere in the company file, within a tolerance window (banks don't always post the two sides of a transfer/payment on the exact same date). Use this before posting anything, to avoid double-entry -- especially for payments/transfers, where the same real-world event can get recorded from either side of a linked account.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| date | Yes | ||
| amount | Yes | ||
| account | No | ||
| txn_types | No | ||
| date_tolerance_days | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |