Nada Ahmed
08/29/2024, 5:48 PMCeligo AI
08/29/2024, 5:48 PMAI generated answer (using internal Slack threads):To show the amount credit and amount debit in one column in the saved search, you can add the Amount (debit) in one column and Amount (credit) in another column. This can be done by selecting the appropriate fields when setting up your saved search. Here is a step-by-step guide: 1. Navigate to the Saved Search creation page. 2. In the Criteria tab, select the necessary filters for your search. 3. In the Results tab, click on the 'New Field' button. 4. In the pop-up window, select 'Formula (Numeric)' as the type. 5. In the formula field, enter the formula to calculate the debit or credit amount. For example, you can use
{amount.debit}
for debit and {amount.credit}
for credit.
6. Repeat steps 3-5 to add another column for the other amount (debit if you added credit first, or vice versa).
7. Save your search.
Please note that the actual field names may vary depending on your NetSuite setup. Also, this will show the debit and credit amounts in separate columns. If you want to combine them into one column, you would need to create a formula that adds or subtracts the two amounts as appropriate.
******
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
08/29/2024, 5:48 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.851251662
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.842899084
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.834052205
Celigo AI
08/29/2024, 5:48 PMNada Ahmed
08/29/2024, 5:49 PMNada Ahmed
08/29/2024, 5:50 PM