Bulk Updating Customer Records for Dunning

Ron Danenberg โ€ข 03:41

๐Ÿšจ Problem: Managing Dunning letter settings for multiple customers one by one can be incredibly time-consuming and tedious. โŒ› This is especially true when you have to individually check options like “Allow letters to be emailed,” “Allow letters to be printed,” and “Do not send letters to customer email” for each customer.


๐Ÿš€ Solution: Bulk Update Feature

NetSuite offers a bulk update feature within the Dunning module to streamline this process and save you a ton of time. โฑ๏ธ Let’s dive into how you can use this feature effectively!

  1. Accessing the Bulk Update:
    • Navigate to Setup > Dunning > Bulk Update Customer Records. ๐Ÿ“‚
  2. Subsidiary Selection:
    • Select the relevant subsidiary for the bulk update. This is crucial for OneWorld accounts to ensure updates apply correctly. ๐ŸŒ
  3. Setting the Options:
    • Allow letters to be emailed: Enables the system to send Dunning letters via email. ๐Ÿ“ง Make sure to check this box if you prefer emailing Dunning letters.
    • Allow letters to be printed: If you donโ€™t intend to send physical Dunning letters, uncheck this box. โœ‰๏ธ
    • Do not send letters to customer email: Ensures Dunning emails are sent only to specified recipients and not to the main customer email. ๐Ÿšซ๐Ÿ“ง
  4. Bulk Update Process:
    • Important: NetSuite recommends performing the bulk update outside of normal business hours to avoid conflicts with other users. โฐ
    • When you click Update, you will receive a prompt asking for confirmation. Once confirmed, the bulk update process will begin and cannot be reversed. ๐Ÿ”„
  5. Handling OneWorld Accounts:
    • In OneWorld accounts, bulk updates apply to all customer records with Dunning procedures associated with the selected subsidiary. ๐ŸŒ
    • Only one bulk update can be performed at a time per subsidiary. ๐Ÿ”„
  6. Completion and Notification:
    • After clicking Update, you will receive an email notification when the process is complete, detailing the number of records updated. ๐Ÿ“งโœ…
    • If any records were not updated due to validation errors, the email will provide details. ๐Ÿ› ๏ธ

By using the bulk update feature, you can efficiently manage Dunning settings for multiple customers, ensuring a streamlined process and saving valuable time. โฑ๏ธ


๐Ÿ”ง Additional Tips:

  • Save Searches: Use saved searches with specific criteria to limit the customers displayed in the list, avoiding errors and ensuring accurate assignments. ๐Ÿ”

For more advanced workflows and fully integrated solutions, check out Kolleno.