Aaron
10/21/2025, 11:06 AMCeligo AI
10/21/2025, 11:06 AMAI generated answer (using internal Slack threads):Statistical Journals and Standard (Normal) Journals in NetSuite do not have a common document number sequence. They each have their own sequences. This is because they are treated as different types of transactions within the system. However, they do share the same form, much like Customer, Prospect, Lead forms. You can distinguish between the two types of journals by checking if dynamic allocation is turned on, as this is only available for Statistical Journal Entries. You can then set the custom form accordingly via workflow or scripting. When it comes to ensuring unique document numbers, especially when override of auto-generated numbers is allowed, one approach is to create a custom record with a custom field to act as your auto-increment counter. Then, you can have a script that increments that counter. In the case of a client having multiple subsidiaries with different fiscal calendars, the auto advance numbering creates a sequence by fiscal year, but the year comes from the transaction, which can cause duplication. To avoid this, you can set up a prefix for transaction numbers at the subsidiary level. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
10/21/2025, 11:06 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.77545166
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.77343756
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.77331543
Celigo AI
10/21/2025, 11:06 AM