formula to show the correct balance for example if the account type is an expense the amount should be debit - credit and if the account type is revenue the amount should be credit - debit

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the balance of an account in NetSuite is calculated based on the transactions posted to that account. The 'Amount' is the transaction amount that is being posted to the account, while the 'Balance' is the running balance of the account. To validate the running balance, you can open the Register by clicking on the GL number from a transaction, or drill down to view from the beginning of time for the company. If you want to filter the balance sheet to see either only debits or only credits, you can use a saved search and filter by account number. This can be done with a transaction search. As for the formula to show the correct balance, it would depend on the account type. If the account type is an expense, the amount should be debit - credit. If the account type is revenue, the amount should be credit - debit. For creating a Contra Revenue account (an Income account with a normal debit balance instead of a normal credit balance), it seems that you can just use it that way, implying that you would record transactions as debits instead of credits. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******