Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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.