My Stuff
We'd love to hear your thoughts on the Latest updates in the NetSuite Support Community (UI/UX edition) – December 2025. Your feedback is important to us—please let us know what you think or any suggestions you may have in the comments!
Comments
-
https://community.oracle.com/netsuite/english/discussion/comment/16882739#Comment_16882739 Hmmm … I'm not positive that is why. We use Avalara Avatax and it does populate "TRANSACTION_TAX_DETAIL" in the old NetSuite.com data source. It seems odd that it wouldn't also do the same for "transactionTaxDetail" in NetSuite2.com.…
-
I have confirmed this is expected behavior, albeit still weird to me. I just flip for my reporting.
-
The amount is the same. It is just the sign that is reversed. Then also when what appears as credit in the UI report shows up in the debitforeignamount column of the query results from transactionLine. Is that standard behavior too? Seems wrong, but I'm not an accounting person so maybe there is a rhyme and reason I just…
-
I have resolved this using MS SQL data type money. For Quantity I am still using decimal, but haven't run into an issue there yet.
-
Hello - I haven't had a chance to try and recreate the query using the suggested tables yet, but they do look promising. Once I have it recreated, should be this week, I'll post the actual query for others. Thanks.
-
Did you ever find the equivalent of posting_account_activity for NetSuite2.com? I know you can see available tables in the Records Catalog, but so far I haven't been able to find anything like it. Why get rid of something so useful in what is supposed to be the better data source?