| | Unable to select an invoice in Cash Receipts Entry |
| Description | - Unable to select an invoice
- Message: "Invoice already being paid"
- Message: "The invoice balance was exceeded"
- The invoice balance is zero or incorrect
- Open invoice not showing in cash receipts
- The invoice is missing from cash receipts
|
| Cause | - The invoice has a zero balance
- The invoice already belongs to another Cash Receipts Entry. For example, in another deposit or in another batch
- Someone selected the invoice for payment earlier. Later, they deleted or cleared the entry, or a power outage or crash interrupted the process
- The invoice has a short key. This short key prevents users from selecting the invoice
|
| Resolution | ▼ Check the invoice balance - Open Accounts Receivable, go to Main, then Customer Maintenance.
- Enter or select the Customer No., then click the Invoices tab.
- Find the invoice and check the Invoice Balance column.
- the invoice shows a balance: the Payments Today field is incorrect. Go to the next step to reset the field
- there's no balance: review the transactions posted to that invoice in the bottom grid
▼ Fix the Payments Today Field (Sage 100 2021 and Later) - Make sure all users exit Cash Receipts Entry and AP from AR Clearing Entry.
- In Sage 100 Launcher, click File, then select Run.
- Type *UTL in the Program field and click Proceed.
 TIP: Role Security must be set for Tasks/Accounts Receivable/Miscellaneous/AR Open Invoice Payments Today Utility - Highlight "A/R Open Invoice Payments Today Utility" and click OK.
- Click Proceed when prompted about recalculating the Payments Today field.
▼ If the Utility Doesn’t Work - Try reinitializing the cash receipts files. How to reinitialize Accounts Receivable Cash Receipts Entry files
-
Or manually edit the Payments Today field for the invoice: - Go to Library Master, then Utilities, then Data File Display and Maintenance
- Browse to ..\MAS90\MAS_xxx\ARxxx\AR_OpenInvoice.m4t (xxx = company code)
- Click Key Scan, find and select the invoice that causes the error
- Click Edit, choose PaymentsToday$,
- In the Change/Value field, change to 0, and click OK
- Close the window and retry paying the invoice in Cash Receipts Entry
▼ Fix for Sage 100 version 2020 and Earlier - Have all users exit the Accounts Receivable and Sales Order modules.
- On Sage 100 Desktop, click File, then Run.
- You need Admin access to see this menu. If you can't see these options, contact your Sage 100 Administrator.
 NOTE: The Permission is in Library Master, Main menu, Role Maintenance, Security Events, Library Master, and Enable File Run.- In the Program field, enter ARWAR4 and click OK.
- You need role permission to access this field. contact your Sage 100 Administrator if needed.
- NOTE: Check permission in Library Master, Main menu, Role Maintenance, Tasks, Accounts Receivable, "A/R Open Invoice Payments Today Utilities."
- Click Yes when prompted to clear and recalculate the Payments Today field. The prompt is: "Warning: This utility will clear and recalculate the Payments Today field in the AR_OpenInvoice file. Do you want to proceed?"
- Click Yes again when the correction is complete. The prompt is: "AR_OpenInvoice Payments Today amounts corrected."
- Go back to Cash Receipts Entry and try paying the invoice again.
[BCB:155:Chat 100 US:ECB] |
|