Should the field `lastquantityavailablechange` exi...
# suiteqla
Aaron Lozier
06/22/2021, 4:57 PMShould the field
lastquantityavailablechangeItemt
tdietrich
06/22/2021, 5:11 PMI've never seen that field exposed via SuiteQL.
tdietrich
06/22/2021, 5:12 PMHere are the quantity-related fields that I normally see in the Item table via SuiteQL.
a
Aaron Lozier
06/22/2021, 5:15 PMHmm. So do you have any suggestions on how I might be able to get a list of Item ID's whose total quantity available has been modified as of a given date?
Aaron Lozier
06/22/2021, 5:16 PM(Using SuiteQL)
t
tdietrich
06/22/2021, 6:29 PMNot easily. There's some potentially helpful code in this though: https://timdietrich.me/blog/netsuite-inventory-balance-history-suitelet/
🏆 1
a
Aaron Lozier
06/22/2021, 7:20 PMThat's really helpful actually
Aaron Lozier
06/22/2021, 8:32 PMSo I am not sure if I am oversimplifying, but it seems if I just wanted to get a list of inventory item id's whose inventory may have changed since a certain date, I believe I could get that with this query:
Copy code
SELECT TransactionLine.Item
FROM TransactionLine
WHERE TransactionLine.IsInventoryAffecting = 'T'
AND TransactionLine.LineLastModifiedDate > TO_DATE('2021-06-16 16:00:00', 'YYYY-MM-DD hh24:mi:ss')t
tdietrich
06/22/2021, 9:30 PMInteresting. Yeah, I don't see why that wouldn't work.
a
Aaron Lozier
06/22/2021, 9:31 PMAwesome! And just figured I could join with InventoryItemLocations to get the latest qty available. I think I'm all set. Thank you again! Couldn't have done it without your extremely valuable blog
t
tdietrich
06/22/2021, 9:32 PMGlad I could help! Let me know if it really does work. I love simple solutions to what initially appear to be complex problems.
a
Aaron Lozier
06/23/2021, 2:10 PMSeems to work based on my tests so far