https://netsuiteprofessionals.com logo
Join Slack
Powered by
Anyone know why rev rec JEs are scheduled to go in...
# general
p
Anyone know why rev rec JEs are scheduled to go in the wrong period? Trying to book revenue in Dec22. Period is still open. Half the invoice booked correctly the other half is trying to go in January. I see no difference in the items or elements that would cause them to diverge.
k
journals or invoices???
p
I have an invoices with maybe 50 line items. All the same item. All with the same start and end dates, same rev rec rule. Everything the same (i think), apart from being on different lines. Some generate a rev rec plan in dec 2022, some in jan 2023.
I just deleted the journal and the arrangement and regenerated everything and same issue.
So I can't generate a rev rec journal for the full invoice in the correct period for some reason. They aren't inventory items. non-inventory. Straight line
k
what is Create Revenue On trigger? Same for all items?
p
same for all. Billing
k
is AR closed?
p
No
k
there is something else that makes those invoices different
i would look into any custom work on invoices
p
Thank you. NetSuite is calling it a defect in ARM that they cannot solve. It has to be something custom. I can't believe that ARM has a defect like this.
k
agree 😞 it just does not make sense since you checked all the boxes. so I would look into workflows and scripts on RAs.
On that note - when you look at rev element are the dates the same as on source transactions?
p
I found the issue. It was a custom script.
👏🏻 1
It was applying the rev rec dates from the element to the plan (and other things), but was hitting a usage exceeded error. So it would apply the right dates to part of the invoice, but when it failed the remainder of the plans created with January dates.
Thanks for pushing me to review my scripts again.
k
you are welcome! glad you resolved it, and once again, NS Support proves itself LOL
3 Views
Open in Slack
PreviousNext
Powered by