Anybody has a method of getting the inventory as o...
# suiteqla
Alan Fitch
06/26/2022, 9:59 PMAnybody has a method of getting the inventory as of date?
t
tdietrich
06/26/2022, 11:17 PMThere's a query in this Suitelet that might help get you started: https://timdietrich.me/blog/netsuite-inventory-balance-history-suitelet/
s
S Feld
06/27/2022, 12:28 AMI usually use
select * from inventoryItemLocationsa
Alan Fitch
06/27/2022, 12:50 AMI need historic data.
s
S Feld
06/27/2022, 12:51 AMI have a query that I use (basically transactionline with inventory asset account filter and posting filter), I'll see if I can find it
S Feld
06/27/2022, 12:54 AM Copy code
SELECT tl.item, tl.quantity, t.tranid, t.createddate, t.lastmodifieddate
FROM transactionLine tl
JOIN TransactionAccountingLine tla
ON tla.TRANSACTION = tl.TRANSACTION
AND tla.TRANSACTIONLINE = tl.id
JOIN TRANSACTION t
ON t.id = tl.TRANSACTION
WHERE tl.item = ''
AND tla.account = {{asset account}}
AND tl.inventoryreportinglocation = {{location}}
AND tl.isclosed < > 'T'
AND tla.posting < > 'F'
AND t.trandate <= TO_DATE('{{date}}', 'YYYY-MM-DD')S Feld
06/27/2022, 12:54 AMYou'll wanna sum the qty
a
Alan Fitch
06/27/2022, 12:55 AMAh I see this should work.
7 Views