Thanks! Just FYI: NS ACS team helped us create a Custom Script in NS to upload this through CSV. Yayy!!

Thanks @Tiru Chembeti If I understand correctly, the SuiteAnswer explains how a script can be created to upload events with values. Based on the script example provided in the same SuiteAnswers, do we have to provide the value of each multiple event in script? Is there another Business User friendly way like uploading a…

Hi, We went to a different route of manual steps for this kind of Contract Mod: 1) Updated the End Date (Waterfall End Date) on SO and RA Record 2) Closed the SO 3) Update RA and Rev Plans to show new Rev Plans based on Billed portion 4) Upload an adjustment JE in order to adjust the rev rec Hope this helps!

Thanks! The joining field/link between Sales Order and Revenue Element could be Sales Order Number. Can we specify the joining field/link on the custom source/destination fields anywhere? Please note that the custom checkbox on Sales Order is at header level and custom destination field is at Revenue Element (line level of…

Hi, Sorry. But even after updating the Custom field not to Store any value, the formula didn't work. PFA the screenshots for your reference. Thanks!

Thanks @Kristoffer Viray-Oracle But when I tried the above syntax , I am still getting the error: CASE WHEN {custbody_so_flag.id} = 'T' THEN 0.20 ELSE 1 END Some more info: This formula is being applied on another Custom Transaction Line field (Decimal) . Screenshot attached for reference.

Thanks!

Thanks Micah! I received a response from NS Customer Supp team and they also mentioned that this is related to existing NS Defect 661370 : Reclassification Journal Entries > Secondary Book > The exchange rate must be greater than 0. Reclassification failed for the following revenue arrangements: xxxxx Is there a place…

Thanks!

That is correct @Patrick Fresnosa-Oracle ! The reason we don't want to create multiple Fair Value Formulas for different values per year using FV Effective dating is that if an amount is updated/decided, instead of someone creating FV Formula with new values each year, if system can automatically fetch the value through a…

Thanks! Got it. Hope NS implement this system enhancement soon!

Thanks! We found the issue! As suspected, due to different Timezone and the time when external system stamps the Exchange Rates, even if the TX Date on SO and INV were same, it was on different time which made the system take two different Exchange rates. Again, thanks for all your help in this. I think we can now close…

Thanks @Patrick Fresnosa-Oracle The type in System notes on the Invoice is "Set" for Total I couldn't find it in Sales order System Notes I will have to check if this is a recurring or one off issues When you say it might be updated through a Workflow/Script, can you please provide details on that?

Thanks for your response! Few comments and questions: We use Xignite to fetch Currency Exchange Rates When the Sakes Order gets created (through Integration and not manually), it takes the exchange rate from NS ERP (Xignite in our case). Is that correct? If yes, why is the FX Rate 0.80 on the SO in your example. Did you…

Hi All, Thanks so much for your responses! We were able to resolve it by following the steps in my original post (mentioned below) 1) Issue a Credit memo to the original invoice for the full amount. 2) Edit the Sales Order to add duplicate lines same as existing ones (The TCV will be doubled for the SO). Also Close the…

Thanks @Patrick Fresnosa-Oracle :)

Thanks! Just to clarify, the rev rec start dt is coming from Integration. Also, we plan to resolve it a step before Rev Rec JEs are booked and yes we include Prior Periods while running the same.

Hi @Patrick Fresnosa-Oracle We are not using Contracts for Renewals. Please consider Renewals as a separate Sales order here. Our Rev Rec Start Date and Rev Rec End Date are the custom ones that we are using which we are determing in our integration before it reaches NS. However, we found a way around for this by running…

Hi @Micah Timbol-Oracle Thanks for your response! I have confirmed that the "Default Revenue Recognition Journal Date to" field is set to Last day of period and was not updated while booking the Rev Rec JE to 8/29/2021 and was system generated as "8/31/2021" Would it be advisable to run Update RA program for criteria…

Thanks so much @Patrick Fresnosa-Oracle and @Micah Timbol-Oracle for your suggestions! We were able to create the report using the customizations suggested.

Hi @Patrick Fresnosa-Oracle Sorry for the delay in responding to this! The response to this query/issue I received from NS was that it happened due to an error that was occurred while running Revenue Reclassification JE in NS during Month End Close. There was also a reported NS Bug on the system errors while running…

Thanks! I have created a NS Support ticket for this and provided all examples. I will update on this thread once I get any concrete response from NS Support!!

Hi @Patrick Fresnosa-Oracle Thanks! I checked and the Preference for "Exclude Contract Assets from FX Reclassification" is set to True for our organization in NS Prod environment which explains that NetSuite does not include foreign currency revaluation for the contract asset account in the reclassification process. But we…

Thanks @Patrick Fresnosa-Oracle once again for your response! All the possibilities mentioned by you for not reversing the 10,000 Unbilled Receivable adjustment in April in NS but reversed in May instead can not occur in our scenario. Its been only 2 Revenue Month End closes that we have performed in NS and we follow a…

Thanks @Patrick Fresnosa-Oracle ! This is helpful. We have observed that in NS, an FX gain/loss on unbilled AR eventually hit Defer Revenue/Revenue, but no impact on Contract Assets (unbilled AR) GL. Can you please help understand/defend the GAAP logic behind such a design?

Thanks @Patrick Fresnosa-Oracle This is really helpful! One quick follow up question from your example: Why the 1.50 FX gain/loss for Contract Assets was booked into Defer Revenue GL? Thanks!

Hi @Micah Timbol-Oracle Thanks a lot for your response! We have setup a Workflow for approval of JEs (system created and Manual) and also setup the reviewers for the employers who would be creating/generating these JEs. Thanks again!

Thanks @Shamaine Chan-Oracle and @Micah Timbol-Oracle ! We don't have approval WF setup currently but I will try the Saved Search method and let you know if I face any issue! Thanks!

Thanks Shamaine! Let me explore this option and I will revert back with more questions :) Thanks! Sarika

Thanks again! Two observations here: 1) The existing Sales order Lines that were billed were updated with a system warning message saying the line is already invoiced. But the system let the user update the invoiced lines and updated the lines in Invoice itself! 2) Even if the Invoice got disassociated from Sales order and…