Not really sure what channel to post this, but we had an interesting issue regarding an integration (FiveTran) and a bill with amortization. Our data team provided me with the transaction line data from the bill and even though 3 of the 6 lines had an amortization schedule it was saying the expense account was "P&L Expense" instead of "Prepaid Expense" I did my own testing and pulled it using SuiteQL and unsurprisingly NetSuite provided the correct data. 3 of the lines hit the P&L expense account and the 3 that had amortization hit the prepaid expense. FiveTran kept telling me it has to do with the sync and they only pull back from the last updated timestamp, but based on my testing bills with amortization schedules are immediately set correctly (P&L expense or prepaid expense) Also the last updated date was in Sept, when the bill was posted and approved in July. (so no one added amortization late) Did anyone ever here of some data issue occurring on the NetSuite side around September/October?

You are using ODBC for Fivetran-connection right? There are differences between SuiteQL and ODBC

Yes, but what's odd is they did a resync and it "fixed" itself but the last modified date that is attached to the record did not change. (Although maybe that change doesn't trigger it, but other records before June didn't have this issue)