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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
Add date modified to native NetSuite fields for ODBC export to FiveTran
Our company is using a data extraction tool/provider called FiveTran and it appears they way FiveTran bills is based off of "MAR's" (Monthly Active Records) and have consistently seen 33% of our usage occur during the last day of the month. Per FiveTran, this is due to the following two NetSuite tables do not have a date column. This data column is needed for a delta load, as without it, the full table is load every month to ensure completeness.
bomrevisioncomponentmember
itemgroupmember
Here is the feedback from FiveTran (the data extraction tool/companay)
We have investigated the issue and found that these tables from NetSuite do not include any date column. Consequently, it is not possible to load these tables incrementally. We classify such tables as "reimport tables," meaning that every time(In every sync job), we need to reimport all the records in the table to ensure data consistency, unlike other tables. Without a date column, there is no way to extract data from the point where the previous import ended. Therefore, we charge for the full set of records in the table once a month, irrespective of importing these tables in every