Hi Everyone - I feel this is a real basic one (isn...
# suiteql
s
Hi Everyone - I feel this is a real basic one (isn't it always) but where does line level tax amounts/code/rates live in SuiteQL? The scheme lists several fields, but using any of them gives the "Reason: REMOVED - Field is removed" error message. Is there another table that lists line level tax break down?
b
Ever figure this out? I also just ran into the error
REMOVED - Field is removed
I'm wondering if it is permissions related? SQL:
Copy code
SELECT 
    T1.id, 
    MAX(T4.shipmethod) as shipmethod
FROM transaction T1 
INNER JOIN customer T2 ON T1.entity = T2.id 
INNER JOIN cashrefundshippingaddress T3 ON T1.shippingaddress = T3.recordowner 
INNER JOIN transactionline T4 ON T1.id = T4.transaction
INNER JOIN transaction T5 ON T4.createdfrom = T5.id
INNER JOIN customeraddressbook T6 ON T1.shippingaddress = T6.addressbookaddress 
WHERE 
    T1.type = 'ItemShip' 
    AND T1.status IN ('A', 'B')
    AND T4.mainline = 'T'
GROUP BY T1.id
Error:
Copy code
Invalid search query. Detailed unprocessed description follows. Search error occurred: Field 'shipmethod' for record 'transactionLine' was not found. Reason: REMOVED - Field is removed\n.