Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Retrieving updated stock direct from the database
Hi,
I have a website that synchronises data from NetSuite by looking directly into the database. I have managed to do everything that I want to do apart from two things:
1) Retrieve inventory levels which have changed since a particular date. In the end I have to use the Inventory location map table to download all of the data and update anything that has changed - but that's not particularly efficient!
2) Retrieve the latitude and longitude from the Locations table. I have found all the fields in the database that I've needed, but these two aren't present on the table and I can't see a table which might store that information.
0