formula to show the amount credit and amount debit...
# ask-stanley-ai
n
formula to show the amount credit and amount debit in one column in the saved search
c
AI 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. ******
Slack 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
Please provide your feedback on this answer.
n
need one formula for both
formula to give me the sum of amount debit and amount credit