Saqib Ali Blue Ribbon

Thanks @Mikko De La Fuente-Oracle . How do I identify manual journal entries from the non-manual journal entries in the transaction table?

Hi @Erick Dela Rosa-Oracle , Thanks for following up. I have opened a ticket re: the missing data in amortizationScheduleRecurrence . I will keep you posted here. Thanks, Saqib

Hi @Erick Dela Rosa-Oracle , I checked amortizationScheduleRecurrence, but it is only returning data up until Dec 31st, 2021. Nothing beyond. Please advise. Thanks, Saqib

Hi Erick. Thanks for the response. We have been analyzing the amortizationschedule table. However it only has information about the amortizations. What we are looking for is amortization per accounting period as line items. Which is what the amortization_sched_lines provided. Please advise. Thanks, Saqib

Hello @Mikko De La Fuente-Oracle . This is a terrible work around. We shouldn't have to parse a date into text to implement a simple WHERE clause in a NETSUITE SQL.

Hello @Mikko De La Fuente-Oracle , I tried the following: select to_char(lastmodifieddate) from transaction where to_char(lastmodifieddate) > '2022-01-12 18:50:50' But it is not producing the desired results. It is return all the older data as well. Please advise.

Hi @Mikko De La Fuente-Oracle , 1) No, it is a very small number of rows; 2) We have used id in the WHERE clause in the past. That works fine. This is the first time we were using lastmodifieddate. 3) I have also tried the following, but it produces the same error: select lastmodifieddate from transaction where…

Hello @Mikko De La Fuente-Oracle , When I specify transactions, I get the following error msg: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Base table:transactions not found.[10129]

Thanks @Eric Cooper . I was able to find the fields in the amortizationschedule table.

Thanks @Pauline Joy Cac-Oracle