How can I upload or post in NetSuite (NS) Lease module an amortization schedule with more than 120 payments for a mid-life lease without using a csv file to upload the payments?
Per the instruction provided in NetSuite Help which states that I had to create a new lease record, checking the mid-life box , entering the pertinent information (lease term ,rental frequency, linked transaction , prior interest periods recognized, etc) and then click Save. Once saved, a lease record number would be assigned to the new record. Next, I would upload the csv file that I created with the assigned lease record number, dates and corresponding payments.
Following the NS instructions, I created a new lease record by entering the pertinent information. However, when I clicked the “Save” button, an error box appeared with the following message : “You must enter payment periods for the mid-life lease in the Lease Amortization Schedule sublist”.