Problem:
Trying to export Positive Pay in Business Central and get error “Amount must have a value in Positive Pay Detail: Data Exch. Entry No.=60, Entry No.=3. It cannot be zero or empty.”
Before I share the solution, a bit of background. If you look at your Check Ledger Entries, you will most likely find that you have void check entries with 0.00 (zero) for the amount. Other voided check entries, although voided, still have an amount (not zero). The 0.00 amount voids are created by a check run that includes at least one payment that requires multiple check stubs to list all the invoices paid. This extra stub creates a voided check with 0.00 amount. This is what is causing the error.
Solution:
Go to the Data Exchange Definition assigned to the Positive Pay Export Format for this bank account. In Field Mapping for the detail record, find Field ID “7” (Amount) and select “Optional”.
You will no longer receive this error running positive pay using this definition.