-
PreviousTransactionLineLink.nextline
Here's the query and output of my Netsuite suiteQL query Query: SELECT * FROM PreviousTransactionLineLink ptll WHERE ptll.nextdoc = 5012317 Result: [ { "discount": "F", "foreignamount": null, "lastmodifieddate": "2021-08-26 15:43:14", "linktype": "DropShip", "nextdate": "2021-08-26 00:00:00", "nextdoc": 5012317,…
-
AE: Customize Item Receipt Form
On the Item Receipt form, under Items & Expenses subtab, Items, how can I add another line item for the total calculations of the column RATE and QUANTITY?
-
AMORTIZATION_SCHED_LINES and TRANSACTION_LINE_BOOK_MAP in Netsuite2.com
Hello, AMORTIZATION_SCHED_LINES and TRANSACTION_LINE_BOOK_MAP were available in netsuite.com datasource. What are the corresponding tablenames in Netsuite2.com Thanks, Saqib
-
transactionline uniquekey and duplicate associations with multiple account acctnumbers
Hi, REST API issue. When I do an sql query like this - (ac.acctnumber = 123456): { "q": "SELECT * FROM transaction t, transactionline tl , account ac WHERE t.id = tl.transaction and tl.uniquekey = 111222 and ac.acctnumber = 123456" } I get just one record (as expected) but when I do this: When I do an sql query like this -…
-
rest api - How do we query transactionlines table to obtain transaction credit and debit amounts
Transaction_lines https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2021_2/odbc/record/transaction_lines.html this says: Important: Credit and debit amounts are not exposed as columns in the Transaction Lines table. However, you can query this table to obtain transaction credit and debit amounts. Q: How do…
-
How to Manage updated transaction and transactionline records with rest api?
Hi, Do you have any suggestions how we could manage updated transaction and transactionline records with rest api? - first we can just get new records by id in a master results table - however we would also want to get records that have been recently updated? some may be new records and some might be older. Q: Do you have…
-
How can we know the balance due on an AP record in the transactionline table?
Hi, Using the REST web services api... GOAL: We need to know the balance due on an AP record in the transactionline table. We can calculate it based on the balance due for an AP Transaction. FOR ODBC : Based on the ODBC table structure it appears that the AP Invoice and the applied transactions (AP Checks and AP Credits)…