Update: I checked in the PreviousTransactionLineLink and NextTransactionLineLink tables, because I do see the Journal Entries when I click the "Related Records" tab in the Revenue Arrangement. But I don't find any records with such a link type (Unbilled Receivable Adjustment)... Where can I find this linkage? It has to be…

Thank you, @Patrick Fresnosa-Oracle Is there a way I can follow and see the status of the enhancement?

@Patrick Fresnosa-Oracle It makes perfect sense and thank you for clarifying. Still, I do not see the Expense account anywhere in the ODBC tables.... Please see the attached screenshot. In my Bill, 992 is the id of the Prepaid Account. But I need the Expense account id (1147 in my case). The expense account is shown in the…

Thanks, @Patrick Fresnosa-Oracle for your research. We are using Non-inventory items. I also tried "Authorize Return" with Refund. Credit Memo cancels out nicely the Invoice: Invoice: Debit - AR Credit - Deferred Revenue Credit Memo: Debit - Deferred Revenue Credit - AR So far so good. But the Return Authorization creates…

@Mikko De La Fuente-Oracle Unfortunately, no, Mikko. There is no "Deferral Account" field in my expense accounts. In the ODBC I also see the deferralacct field has nulls in the account table. It has to come from somewhere else...

Yes, exactly - I want to create a negative Invoice to offset the incorrect Invoices. And Credit Memo does this - it creates journal entry that is the exact opposite of the incorrect invoice. But it doesn't "free" the Sales Order for issuing another, correct invoice. Also, CM creates a negative RA, that I don't need. So,…

All Revenue Plans are created from Sales Orders. Sometimes we need to correct Invoices and to issue new ones instead. And sometimes we need to do this after several months, after some Reclassification Journal Entries are created and after the previous periods are closed. We don't want to change the Revenue Plans, but…

Someone, please help! @Kristoffer Viray-Oracle

It says "Default" under "Target Account": (Select Default to post amortized expenses to the expense account specified on the bill or item record) So it takes "expense account specified on the bill or item record"... So there should be this account specified in bill somewhere.... We do see it in the UI. But where is it in…

I am not saying it is incorrect. It actually does make sense: in the GL it want the bill to post to the Prepaid account if there is an amortization schedule (and that's what I do see in the transactionline and in the transactionaccountingline tables in the ODBC), but in the lines of the bill, it is Ok to show the expense…

Thank you, Mikko!

Sounds like it. How can I see the details of this case (659538)? I tried to search SuiteAnswers, but it is probably in some other place...

@Mikko De La Fuente-Oracle Thanks, Mikko. Yes, it is feasible, but it is the fourth script that I am paying for just to bring me a field "AS-IS", just because it is not exposed: amortization schedule source_id source_type and now parentexpensealloc These are just fields you need to expose, no scripts needed... For example,…

Thanks, @User_DN411 Understood, I'll add everything manually :( As for DW - I guess it will not work for my scenario since I schedule my queries to run automatically via Power BI in Microsoft cloud so TBA will probably won't work Thank you

@Mikko De La Fuente-Oracle How? Mikko, how can I "see if it can access transactions" I understand that you mean check in the "UI". I do have an Admin role and I can check everything in the UI. I just don't know how to give a permission to TRANSACTIONLINE and TRANSACTION tables. What EXACTLY do I need to add? What…

@Mikko De La Fuente-Oracle How exactly can I "check if it has access on transaction"? This is exactly my question. I have an Admin role and also created a custom role especially for netsuite2.com analytic datasource. But I have no idea HOW to give this role all the permissions. I have read your article and also many other…

@User_DN411 I read it. DWI role not relevant because it uses two-factor authentication. How do I get permission to transaction table?

I see, thanks, @Mikko De La Fuente-Oracle One more question: Can I create 2 ODBC connections - one is old Netsuite.com and the other is Netsuite2.com for the same user? I understand the new Netsuite2.com requires some special role, not Admin. I already have an Admin role with which I work in the old Netsuite.com…

@Mikko De La Fuente-Oracle I've read the two links and they don't say how a Journal Entry is known to be a "Created from revenue recognition schedule" There is a very specific logic in the UI of Netsuite that knows somehow to show this text: "Created from revenue recognition schedule". What is this logic? On what…

@Mikko De La Fuente-Oracle Thanks Mikko, that's the first thing I did - select * from OA_TABLES where table_name like '%ALLOC%' select * from OA_COLUMNS where COLUMN_name like '%WEIGHT%' I didn't get any results. I forgot to mention that for this customer I work with the old version of ODBC (Netsuite.com) and not with…

Thanks, Mikko. But the Netsuite itself shows "created from Revenue recognition Schedule" at the top (the text I marked it with the green line). How does Netsuite know to show this text? There probably some indication or join to some table or some other logic that knows when to show this text. What is this logic?

I don't trust memo. It can be changed manually. Or one can just write "Rev Rec Destination" in some other journal entry. So in order to EXACTLY determine that a Journal Entry was created from revenue recognition schedule / revenue plan - where do I have to look? What table and what field? I need an exact answer, please.…

Yes, the old Netsuite.com has the access to these fields! I have several customers that I've successfully built BI models based on these fields using the legacy data source. But for my new customers I do not need the access to the old schema, I just want the new one (Netsuite2.com) to let me use these fields as in previous…

@Mikko De La Fuente-Oracle @Patrick Fresnosa-Oracle Hi friends, I've just opened an idea in SuiteIdeas - so they make these fields exposed. Please vote for it. Also, please share with other developers. Here is the link for voting:…

Thanks Mikko for this check. I am wondering (as well as many other developers) - why on earth these fields are not exposed in Netsuite2.com??? I've already filed an idea to expose another field - amortization schedule in the journal entry lines. It was also available in Netsuite.com but not in Netsuite2.com. It seems so…

Some one on reddit explained me that in 'revenueelement' there is a "sourcetype" and "sourceid" sublist fields. When the sourcetype is 'TRANSACTION', the sourceid is the lineuniquekey on the transactionline of the source. (https://www.reddit.com/r/Netsuite/comments/ttnvlg/connection_between_revenue_arrangement_line_to/)…

So there is a direct ONE-TO-ONE connection!!!! And what is it EXACTLY? Since I cannot rely on the same line sequences, then what fields do have the EXACT connection? Even if they are not exposed in the Netsuite2.com I need to know what they are. What are the connecting fields? Thanks!

Thanks Mikko. So as I understand from your answer, there is no direct "per line" connection between RA and SO? But wait, why then in Netsuite2.com I did have a PERFECT line-to-line connection: "source_id" field in Revenue_Elements table corresponded to unique_key field in the TRANSACTION_LINES of Sales Order. I understand…

@Patrick Fresnosa-Oracle @Mikko De La Fuente-Oracle I think I've found a partial answer: In the transactionline table there is a "revenueelement" field that has RevenueElement id. This is what I was mainly looking for. But I still have a part of my question left: how is a LINE of Revenue Arrangement connected to a LINE of…

Thanks, @Patrick Fresnosa-Oracle But the Saved Search doesn't help me. I really need this as an SQL statement. What is the join? What are the fields and tables (in the ODBC) that connect the SO/RA line to the Revenue Element?