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