Hi I was wondering does anyone use ARM at the arra...
# accounting
c
Hi I was wondering does anyone use ARM at the arrangement level? We have been using it at the Element level but it has made unbilled reclass a bit of a pain so we are taking a look at the arrangement level. So far it is looking good, but we found that we need to have a DEFAULT DEFERRED REVENUE RECLASSIFICATION ACCOUNT. We are a little confused on how this is used. It says it catches errors but we have a deferred account tied at the SKU level but this says if we want to override this it has to be at the customer level. We have currently tested the process in sandbox and so far nothing is posting to that account but we are trying to understand when it's actually used.
k
because it is at the arrangement level there isn’t an option to do it at the item (i.e. element) level (pretty clear). NS then uses one (default) def revenue account to reclass. There is a system generated account, use that one, that’s the account they have in mind when they talk about default def rev account
c
Well that's funny since what you say makes complete sense. We spoke it ACS ARM SME about this and they understood how we have our system and didn't really explain this when we walked him through examples. However I think we are a little confused since many of our arrangements have multiple deferred revenue buckets and merged arrangements but when we ran the reclass process in SB everything tied out perfectly to the manual netting adjustments we have done in the past. Nothing even posted to the default account we chose.
k
this is a definite change in the process for you. See if you can make sense out of total amount by still using items; if you have each item going to its own def revenue account it might actually work for you
c
All of the items do have a def rev account. So far the march 2024 close looks good but we haven't started adding items in April to test new items. I am just trying to figure out how to get something to hit that default account because so far I haven't been able to.
k
The only way that account is used is if it is assigned to items or set up as default def rev account in Accounting Settings (which you probably do not want at this moment). There is no system triggered transactions using this account other than any transactions involved with def ref (invoice, revenue journal, reclass journal)
c
It is setup in the accounting because it was required when we flipped the switch from Element to Arrangement. It said the only way to override the default is to do it at the customer level or sales order (however this sounded like it was tied to legacy ARM)
k
so you did flip already…. ah
c
yea we refreshed our SB before we clsoed March and then in SB we flipped the switch and ran the reclass
and nothing is hitting that account
and everything we did as a manual netting entry tied out perfectly
So it seems like everything is working great but I just feel like there is going to be some NS oddity I didn't account for. 😂
We have not started adding items in April (in SB) to see what happens after the close process is completed
k
oh, so no transactions going into that default account which you set in the Accounting Settings? what account is it using?
c
So I went back and compared all of our settings For the setting "Unbilled Contract Asset Account" we do have a default Unbilled Receivable type and this appears to be the account that the unbilled process hits. Currently for the setting DEFAULT DEFERRED REVENUE RECLASSIFICATION ACCOUNT we have nothing. In Sandbox in order to change the feature from element to arrangement we were required to add an account and we added a Deferred Revenue Type account (maybe this is the incorrect type - originally ACS had it). So far even after running the reclass for March 24 we see that nothing hits that account and everything appears to tie. So it's more just about understanding what the purpose of it. I don't want to run into a situation in 2 months where things start getting posted to it when it didn't happen during our initial testing. We are also reaching out to our ACS contacts about it.
k
“Currently for the setting DEFAULT DEFERRED REVENUE RECLASSIFICATION ACCOUNT we have nothing”
this is because you were using different accounts for items because of element/item level of reclass
c
ok so would we expect new orders and arrangement to start carrying on in the new way and the only reason these are working is because they are legacy?
k
I have to declare 🙂 - I never had to switch but I do understand why it may happen
c
haha even the ACS people said they have never had someone do this which didn't give us the most confidence
and once you change it you can't go back
k
usually customers do not switch n the middle of the revenue life per se because you cannot have a clear cutoff
what def rev account is on your items after you switched? I do not think if would change “systematically” to something particularly since you do not have a default account. So there is nada for you
So I suggest to a) populate default account b) create a manual SO and process it c) see what happens.
But logically all your rev plans and invoices are already set, so your def rev account needs to change in transactions that have been created already but you also booked your journals until certain point (say, March 2024).
and that’s why there is a reason you do not want to flip the switch
after you have your transactions going
c
Yea I am going to try to get a new item in our release preview to see what happens now with something brand new. I'm confused on what you mean that's why we don't want to flip the switch. Are you saying we shouldn't attempt to make this change now that we have a lot of legacy orders?
k
you have numerous rev plans going right now. If you switch you cannot switch over time, plan by plan, so some plans will stay what they were and some will have new def rev account. So you will need to update all your existing items with the default rev account somehow (script probably) right after you close the period and no transactions happened yet (so that this account would not be applicable backward, only forward). Reporting will be off.
c
ok this is what i was concerned about. We don't want them to change the account
that's why I was confused when I kept reading about this new default account
k
you won’t if you do it right after you close the period - but you have to do it for all existing items
c
yea and we have years of plans
k
but you cannot have your reclass at the arrangement level if you do not use ONE def rev account
so all your items will be using the same def rev account
c
I am going to create a new rev arrangement and try to see what happens when i recognize and have unbilled for a items with different rev accounts
I may need to wait for ACS to assist to understand. I created a new SO/Rev ARR but everything seems to be hitting the deferred revenue account at the item level and then the unbilled adjustments are hitting the account we expect.
thanks for your help
👍🏻 1