Multiperiod Accounting invoices amortization details

need help in getting details of MPA invoices,

query to get details of MPA Invoices with1) Monthly amortization amount 2) Current Month amortization amount 2) Accumulated/YTD amortization amount (as of the report running date) 3) MPA NBV or Remaining Invoice Balance/Amount (as of the report running date) => (Beginning MPA invoice amount-Accumulated Amortization Amount)