Notes payable summary sheet by term

The Summary list of Notes payable is output according to the items and the period specified.
 →  To Operation Procedure

Screen Transition

[Notes Payable Module]
  ↓
[Forms]
  ↓
[Notes payable summary sheet by term]
  ↓
[Notes payable summary sheet by term] screen
 "Start" button  →  [Output destination] screen

Output conditions specification

Items that can be entered on the [Notes payable entry] can be specified as searching conditions.
Only the items particularly needed for comments such as items that are not one the [Notes payable entry] screen are described below.

• Entry date
  Enter the start date of summary. Select a setup entry date from "Entry date", "Payment date", "Drawing date" and "Due Date" to specify the date.
• Month/Date
  Enter the unit of the Summary period. Select from "Month" and "Date".
• Monthly/Daily intervals
  Enter monthly/daily intervals for summary. Enter how many months/days to be summarized from the start date.
• Output month/day count
  Enter how many units to be summarized using a "Monthly/Daily interval" as 1 unit.
• Status
  Select a status of the Notes payable to be searched for. Check off the checkboxes with the summary status from "Drawing", "Settle", "Renewal" and "Not controlled". You can select more than one. If none of the checkboxes is ON, an error message is displayed.
• Summary item1, 2
  Set up the key item to summarize the data searched. Select "(Blank)", "Department", "Correspondent", "Payment location", "Debit account" or "Flexible master1-5".
  Enter the summary range of the item set up. If "(Blank") is selected, it is not set up as a searching/summary condition.
  You cannot set up the same item in "Summary item1" and "Summary item2".
• Summary Sort (sub total/group total/total)
  Enter a sort order to output a list of the Notes searched. Can be selected from "Status/ Summary Item1/Summary Item2", "Summary Item1/Status/Summary Item2" and "Summary Item1/Summary Item2/Status".
• Macro file, Macro

[Buttons]

• Browse
  If this button is clicked when a Macro file name is entered, you can browse the file in the tree format.
• Start
  If clicked, the [Output destination] screen is started. Click on the "Excel Output" or "Create CSV" of the [Output destination] screen to output the list that meets the output conditions if necessary.
• Clear
• Exit