My Stuff
Please note that on Friday, September 19, 2025, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 4 hours. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Comments
-
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. What I find curious, is I can't even see transactionTaxDetail in the schema using…
-
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?