FYI - It is possible to update JE's created from Amortization Schedules, to set line level details like 'Department'... We ran into a situation where we needed to set Department on these JE's and the only approved way to do it is to re-open the period of the original bill.. which is a no-go.. and when you edit the JE in the UI, NetSuite has disaabled the fields.. I was able to create a Map/Reduce Script to edit and set the values on the lines, however. Let me know if anyone needs something like this and I can assist!

I’d love to hear more about this as I’ve run into this situation multiple times

meaning to say the M/R script can edit and set value on JE line item even though period is not open?

@DX No, the M/R script only operates on transactions in open periods. So when the original transaction which has a related schedule was created, the department wasn’t specified, and the new JE that is created from the Amortization Schedule is created, it also will not have a Department.. The M/R script finds those JE’s and sets the department value you want, either based on Vendor, or the Amortization Schedule on the line.

@suitedev what is the trigger of your M/R to update those JE's? Do you first create those JE created by amortization schedule and then re-update it again using M/R?

@jhayczee09 Yes, the MR is a search for JE’s created from an amortization schedule, within open periods, and in my case, those without Departments specified. The M/R runs once per day, but it could run as little as once, per week, or be part of your closing checklist.