Notes receivable summary sheet

Outputs a notes receivable summary sheet according to the items specified.
 →  To Operation Procedure

Screen Transition

[Notes Receivable Module]
  ↓
[Forms]
  ↓
[Notes receivable summary sheet]
  ↓
[Notes receivable summary sheet] screen
  "Start" button  →  [Output destination] screen

Output conditions specification

An item that can be entered on the [Notes receivable entry] screen can be specified as a searching condition.
This section only comments on items that specifically require comments, such as items not on the [Notes receivable entry] screen.

• Status
  Select the status of the notes receivable to search for.  Check the box for the status concerned out of "Holdings," "Collection," "Discount," "Endorsement," "Endorsed sale," "Buyout," "Settle," "Sale," "Dishonor," "Renewal" and "Not controlled."  More than one status can be selected.  An error message will be displayed if none of the check boxes are turned ON.
• Summary item 1, 2
  Set the key items for making a summary of the retrieved data.  Select from "  (blank)," "Department," "Correspondent," "Financial institution," "Credit bank account," "Receipt location" and "Flexible master 1-5."
  Specify the range of summary of the set items.  If "  (blank)" is selected, it is not set up as  searching or summary condition.
  The same condition cannot be set for "Summary item 1" and "Summary item 2."
• Summary Sort (sub total/group total/total)
  Specify the order for the list of retrieved notes to be output.  Options include: "Status/Item 1/Item 2," "Item 1/Status/Item 2" and "Item 1/Item 2/Status."
• Macro file, macro

[Buttons]

• Refer
  Clicking this button when specifying a macro file name shows files in a tree structure.
• Start
  Clicking this button opens the [Output destination] screen.  Click the "Excel output" or "Create CSV" button on the [Output destination] as required to output a list that meets the output condition.
• Clear
• Exit