Hi, we are trying to move out of the netsuite1 to ...
# suiteanalytics
n
Hi, we are trying to move out of the netsuite1 to netsuite2 data source, we would like to make sure that netsuite2 data is sound and rectify data discrepancies. 1. 'Amount' fields in transactionline table of netsuite1 and netsuite2 are not tallying. Both of the following query (sample below) does not yield the same results Select amount, net_amount from netsuite.transaction_lines where transaction_id = '12345' And Select netamount from netsuite2.transactionline where transaction = '12345' 2. *"do_restock" f*ield is not available in the netsuite2.transactionline while it is available in the netsuite.transaction_lines
👀 1