SOL-0032026
Applying for a New Bank Format
If your bank statement format or EFT output format is not in the Peresoft format list, you can apply for it to be developed. All new formats are made available to all users once developed.
Solution Sheet
Invoices Stuck on Pending Status - Cannot Allocate Payment
Several invoices are stuck at Pending status and cannot be allocated. This is usually caused by an incorrect value in the SWPOSTED field in the CBBTSD table.
If invoices are stuck at Pending status and cannot be allocated in Cashbook, follow these steps:
- Run the Data Integrity Check and select the following options:
- Fix Minor Errors
- Check and Fix for Check Batches in Application Options
- Check if the invoice still reflects a Pending status after the integrity check.
- If it does, in the company database check the CBBTSD (Cashbook Batch Sub Detail) table and locate the affected batch.
- Check the SWPOSTED field:
- If the batch is posted, this field should contain 1.
- If the batch is unposted, this field should contain 0.
- If the value is 0 for a posted batch, Cashbook is treating it as unposted and the sub-detail line will be stuck as Pending. Correct the SWPOSTED value to 1 and recheck the allocation.