Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Amortization Schedules
Does anyone know of a way to create a payment whose expense distribution follows an amortization schedule? For example, if I have a 60 month note payable, I'd like to create a memorized transaction that, when I enter it, expenses the proper amount to interest expense and the difference to principal on the note, based on an amortization schedule.
I have already created the memorized transaction for the monthly payment, but each month, I have to open my amortization schedule for the note (in a spreadsheet), look up the split between principal and interest, then modify the amounts in the memorized transaction.
0