Thank you sjrcpa for the reply.
That did the trick. I was sure I read that for amortization you needed to select "Method 99" but you were right once I changed that to straight line it worked perfectly.
