ANS-0265 · CSV IMPORT & DATA MIGRATION
Why Do Direct Debit Transactions Not Appear in NetSuite’s Invoice Payment Processing Screen?
Discover why customer transactions may not appear for invoice payment processing after a CSV import and how to resolve the issue.
Short answer
When the 'Direct Debit' checkbox is set via CSV import, it may not activate correctly. Manually toggling the field on the customer record or performing a targeted mass update can resolve this, ensuring transactions appear in the Invoice Payment Processing screen.
Scenario
When the 'Direct Debit' checkbox on a customer record is enabled through a CSV import, the change may not fully take effect. Consequently, transactions for these customers may not appear in the 'Invoice Payment Processing' screen, preventing them from being processed.
Solution
If a customer's transactions are not appearing in the 'Invoice Payment Processing' screen after a CSV import, manually correct the 'Direct Debit' field on the customer record. Uncheck the 'Direct Debit' field, re-check it, and then save the record. This action typically activates the field's functionality, allowing the customer's transactions to appear for processing.
For situations involving a large number of customers, a mass update can be considered. It is important to note that standard mass updates for fields located on subtabs, such as the 'Direct Debit' checkbox found on the 'Bank Payment Details (Debit)' subtab, may require custom scripting or specific configurations to ensure the update takes full effect. When attempting a mass update:
In the search criteria, search for customers with the 'Direct Debit' box checked.
The 'Action' on the mass update should be to check the 'Direct Debit' box.
This process aims to re-trigger the field's functionality across multiple records, ensuring all relevant customer transactions are displayed in the 'Invoice Payment Processing' screen.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support
