has anyone found a way to identify different syste...
# generals
SuiteReg
05/10/2023, 9:07 PMhas anyone found a way to identify different system calculated JEs? (amortization, rev rec, reclassification JEs, etc) i'm trying to update our existing approval workflow to auto-approve these types of entries but also populate memo field based on JE type and i haven't found any native fields that can help me differentiate between the JEs
SuiteReg
05/10/2023, 9:09 PMonly thing i've found so far are XML fields that may be helpful if we can leverage them (isfromamortization, isfromrevrec, isanyreclassje)
m
Marc
05/10/2023, 9:45 PMyou can use the memo lines which are different according to the types of JE
Marc
05/10/2023, 9:51 PMYou can set the memo with your WF ( if the memo line is rev rec source or rev rec destination , set field value on your memo )
s
SuiteReg
05/10/2023, 9:53 PMwould be an issue if anyone uses “rev rec source/destination” on memo line on a manual JE though (not saying anyone would…)
m
Marc
05/10/2023, 9:58 PMBut you can use a condition on your workflow with a saved search using this criteria : is Amortization/Revenue recognition
s
SuiteReg
05/10/2023, 10:30 PMhmm perhaps, but still doesnt solve for revenue reclassification entries
SuiteReg
05/10/2023, 10:33 PMi appreciate the suggestions @Marc! just wanted to post here to see if anyone else had an easier solution but we can certainly try to build some conditions into a SS. you would think NetSuite would've built in some type of native indicator since there are available XML fields to differentiate the JE types 🤷♀️
SuiteReg
05/10/2023, 11:26 PMalso "is amortization/revenue recognition" doesn't work when using ARM 🥲
r
RJMNS
05/10/2023, 11:47 PMIt's not visible (at least in the UI), but the Created From field is filled in on at least Amortization entries. And I thought ARM entries too, though I could be thinking of Legacy Rev Rec.
Not sure about Reclass. If that is filled in for all types, you could do it on originating type if it's consistent enough. I'm pretty sure it gets filled in with the originating doc (JE or Vendor Bill) for Amortization and I was thinking Arrangement for ARM.
RJMNS
05/10/2023, 11:51 PMThe "revenue recognition" part of the Is Amortization/rev Rec flag refers to legacy Rev Rec, so that's why it's not flagging ARM entries.
I was thinking there was some other flag specific to ARM though too. Always possible it's not intuitively named. Might be "Advanced Revenue" or "Is Advanced Revenue". Some of the new boolean flags like that, they're often not putting "is" in front of them in the saved search field list.
a
Alex K
05/11/2023, 3:26 AMWe always use a custom form that has a 'Rev Rec' field checked by default for rev rec/reclass journals. Doesn't solve your other scenarios, but common enough to want to filter to only JE's created from ARM and easy to setup
You can set the default form for Rev/Reclass JE's under accounting preferences
💡 1
m
Marc
05/11/2023, 6:48 AM« also "is amortization/revenue recognition" doesn't work when using ARM »
I use that with ARM why it’s not working for you ?
j
Jesper M
05/11/2023, 7:51 AMJust want to add another bad thing about using memos. If a user post a system transaction journal entry, e.g. vendor bill variance, with anotheer language, the memo will follow that persons language.
r
RJMNS
05/11/2023, 2:56 PMI use that with ARM why it’s not working for youOh interesting. I don't think that worked for ARM when Legacy Rev Rec was still more prevalent. I just assumed that still might be the case since it wasn't working for Reg. I should probably stop commenting on ARM. I haven't touched it in ~3 years.
s
SuiteReg
05/11/2023, 7:06 PMyeah, it doesn't work for us and there's a SuiteAnswer article about it as well 🤷♀️
20 Views