jhayczee09
09/17/2025, 3:50 AMCeligo AI
09/17/2025, 3:50 AMAI generated answer (using internal Slack threads):To display the correct vendor balance in a vendor saved search, you can follow these steps: 1. Create a Transaction Saved Search for vendor balances. You can add a running balance column after Amount Debit and Credit Columns. If you're having trouble finding a formula or a SuiteScript to add a running balance in the saved search, you can refer to this post by Marty Zigman / Prolecto: https://blog.prolecto.com/2015/05/26/solving-the-netsuite-cumulative-saved-search-tally-challenge/ 2. If you want to show certain vendors' current accounts payable balance on the vendor form, you can create a summary saved search that shows the correct value you are looking for. You can then use that saved search to source a custom field. Here's a good article on it: https://www.sikich.com/insight/how-to-create-a-netsuite-custom-field-from-saved-search-calculated-data/ 3. If you have multiple subsidiaries on a vendor and want to make a saved search showing the balance for each subsidiary of that vendor, you can try the vendor-subsidiary relationship saved search type. This should allow you to get the balance fields from each subsidiary, not just the primary supplier. ****** 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
09/17/2025, 3:51 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.841919
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840698123
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840209961
Celigo AI
09/17/2025, 3:51 AM