Procedure for Output repayment schedule list, borrowings balance
summary sheet
Outline
Almost the same output method applies for repayment schedule
lists and borrowings balance summary sheets. This section explains the output method with the example of repayment
schedule lists.
After entering the condition, you can output the repayment schedule list in
either an Excel or CSV format.
1.
Screen display method
- Select [Finance] → [Borrowings control] → [Forms].
- Select "Repayment Schedule List" from the menu.
→ [Repayment schedule list] will appear.
2.
Entering searching conditions
→ To Menu Reference
- Enter the condition of borrowings data to be output.
- Click the "Start (A)" button.
→ A dialog will appear to select the output.
3.
Specifying the output form
- If you want to
output the data in an Excel file (when the number of rows is 65,000 or fewer in
the form), click the "Excel Output (Y)" button.
→ The form image (Excel screen) will be displayed.
- If you want to
output the data in a CSV type (when the number of rows is over 65,000 in the
form), click the "Create CSV (F)" button.
→ The screen will be displayed allowing
you to specify the destination to save the data. If necessary, you can also change the file name and save the
data.
You can
also save the data in an Excel file under whatever filename you please.