i would suggest to use either or and not mix them up - but it is just me…. Good luck! Oh, perfect!

Is it possible to automatically update the Revenue Account in revenue arrangements by changing the Income Account in the item records? We accidentally assigned a wrong Income Account to item records that are already associated with open sales orders or billed sales orders (with invoices). There are also Revenue Arrangements and Revenue Plans generated but no Revenue Recognition JEs yet. Here's what I did: 1. Delete the revenue plans. 2. Update the income account of item records (does not automatically update the revenue account in RAs). 3. Manually change the revenue account in RAs. 4. Update the Revenue Plans. 5. Generate the Rev Rec JEs which show the NEW revenue account. The problem with this is that there are about 4000 RA lines to update. It is not yet possible to update this through CSV or script (correct me if I am wrong). When I tried to delete the RAs, I had to retoggle the item in the SOs (not possible if there is an invoice already) to effect the NEW revenue account.

Customer has done a business reorg 1/1/21 with new Class structure for 2021 transactions. Now they realize that the 2020 rev plans will continue in this month end JE with their old Classes structure. Is there some kind of Revenue Plan update we/they/I can run that will update future JEs? Their order process is SO >> CS with plans commencing upon payment/CS.

@Netsuite Tragic - have you looked into SA 82056?

thanks @Karina. When I now read 82056 it discusses updating the Account. We just want to change the Class that is being posted on the transaction lines. I will test "Open *Revenue Arrangement*> Click View Plans > Edit Plan and Delete" and see if that will do it.

Hello ARM Experts. has anyone tried to do Revenue Reclassification on revenue arrangements that have been merged? the ask is on my deferred revenue waterfall, i am seeing negative amounts on the Unplanned deferred revs and we expect that this to be zeroed out when the carve in/carve out reclass JE is processed. However, it's not, and what looks like netsuite does is it will only reclass the unplanned deferred based on what has been billed. Anyone who has already encountered this scenario?

As I understand it anything in Unplanned column is what it is - unplanned, meaning there is no plan for these elements. Reclassification in this case only affects carve-in/carve out piece provided invoicing has been completed. But carve-in/carve-out does not affect unplanned amounts. I will see if I have a case like this..

Is it possible to stop revenue arrangements from being created for a subset of invoices?

Month end chaos has begun and we discovered our credit memos are posting in positive amounts rather than negative. We think this is due to introducing revenue events into the process. For every credit line, we create a revenue event, which then makes the revenue plan. But the plan is posting like it were an invoice, so the JE is crediting revenue and debiting deferred. Why is this happening??

Hello, does anyone here know if NetSuite has any plans to support long-term vs short-term unbilled receivable? if not how do you handle this situation

Hi, I'm struggling in creating a saved search that will show the invoice and the related revenue recognition JEs, if any. The source transaction is the SO but the invoice will bear the deferred revenue. Basically, we want to show the recognized and unrecognized revenues per invoice. Thank you!

@Luis - there is a Billing and Revenue summary report available, see if this is what you need

Hey folks, I am finding that system notes are not showing up for changes to item records on the revenue recognition tab. Specifically there have been changes to the item revenue category with no system notes to document who made the change. Anyone else seen this?

Hello, has anyone here created a search or analytics report that shows recognized revenue vs how much is remaining for a specific plan? We would like to see recognized and the remaining amount to be recognized on the same report

has anyone ever switched arm off on an account? What does the process involve?

Hey guys, when we reject an invoice, ARM still tries to recognize it. We do use advanced billing schedules. Anyone have any idea why ARM does this?

anyone work with fair value pricing?

Hello, I want to create a rev rec rule that recognizes 50% upfront, and the first period $ of the remaining 50% at the same time as the upfront fees. Any ideas how this can be accomplished? I've set up an initial amount of 50%, but not sure how to recognize the first period $ amount of the remaining 50%.

@Sue Bhuvan - can you elaborate on “the first period $ of the remaining 50% at the same time as the upfront fee”? Maybe with an example?

@Karina SO total is $36,000, 3 year-term. Rev rec start: 1/1/2021, end date is: 12/31/2023 1st year pricing for this SAAS license item is $6000, 2nd year pricing is $12000, and 3rd year pricing is $18000. In January, they must recognize $18,500, which is the 50% upfront + $500 from 1st period $ of the remaining 50%.

@Sue Bhuvan - can you possibly set up two lines for that? One will be recognized ratably and another - on a custom schedule? Have it set as a kit so that the customer would not see your details, just the kit line

Hello, I am wondering is anyone ran into the Revenue Arrangement allocation error after the recent NS upgrade. The error is as follows: An error occurred while trying to evaluate the price calculation formula. Check formula syntax. I appreciate any help or tips.

Hello, we have Suitebilling and obviously ARM, and I have the need to create a fair value formula that includes the subscription line discount. I created a new custom field that is displayed on the revenue arrangement, and I have completed the Revenue Field Mapping to map the subscription line discount to the new field. The Cust Col I created is available to choose in the fair value formula, but I cannot get the Subscription Line discount to populate on the arrangement. I can manually populate the value to use in my fair value formula but I need it to auto populate. Any ideas?

RE: No Start and/or End Date on Rev Arr: Has anyone ever had a situation where they have made a Credit Memo but the start and/or end date did not flow over to the Revenue Arrangement? As a result, no Revenue Plan is created and Revenue is not posted. What might cause this and what is the fix?

Is there a way to set the default revenue recognition account for an expense billed to a customer? Currently this is defaulting to deferred revenue, and requiring a manual edit of the arrangement to enter the correct Revenue account

@Alex K - if you want to put your billable expenses on rev arr, you must use def reve account. you can post revenue directly for this item as well, just check mark the box on item record (implications, if change happens on a fly), outcome is this item will not be part of revenue reporting NS provides nor can you put this item on the same bill with deferred revenue

hi all - we have the below request from one of our auditors. We are using ARM and follow a Sales Order -> Invoice methodology, but will also every once in a while issue a one-off invoice. What NetSuite report would you recommend using for this?

Obtain the reconciliation of the sales ledger to the general ledger for the twelve months ended December 31, 2018

@Joe Blanchett - have you looked into Billing and Revenue Summary?

Is there a way to specify custom transaction types that doesn't create revenue elements?

@Archie Kawmongkolsi what are you looking to do ? there is even a way you can stop standard transactions from creating revenue elements (CM’s etc)