Journal

The Journal outputs, by entered voucher data or auto-journalized voucher, the contents of journal based on the order of entry date, in the as-is journal image status. For multi-currency accounting, the Journal outputs the balances in both Amt (SC) and entry currency. After entering your preferences, click the "Start" button and a dialog box will appear for confirmation. Choose to output the data either an Excel file or as a CSV file.
→To Operation Procedure

Screen Transition

[General Accounting Module]
  ↓
[Forms]
  ↓
[Journal]
  ↓
[Journal] screen
    "Start" button → [Output destination] screen

Output Conditions Specification

[Header]

• Entry Date
• Voucher Type
  Choose one of the following as summary objects:
  "Receiving", "Payment", "T/F", or "Deferred Tax Accounting"
• Internal No.
• Voucher No.
• Source Entry Date, Source Internal No., Source Voucher No.
  On the screen of voucher entry, set the range of Source Entry Date, Source Internal No., or Source Voucher No., which are held when you click the "Copy Vchr (F)" button.
• Voucher Description
• Update Operator
• Approval Operator
• Approval Status
  Choose one of the following as summary objects:
  "Unapproved", "Approved", or "Denied"
• Evidence No.
• File name
• Approval Comment
• Post Pad
  Choose the color of post pads as summary objects. You can also search the texts entered in the post pads.
• Data Level
  Mark a check here in a data level as searching objects.

[Detail]

• A/C//Sub A/C
  Select A/C or Sub A/C as summary objects.
• A/C, Sub A/C
  Set the range of A/C and Sub A/C as objects. You can also enter account group.
• Taxable Type
  Set the range of taxable types as summary objects. You can make an entry only when you select A/C or Sub A/C that are set up as "VAT Items" in [Register A/C and Sub A/C].
• Department
  Set the range of a department as summary objects. You can all enter Department, Warehouse/Process, and Summary Department
• Correspondent
  Set the range of correspondent group as summary objects. You can also enter employees.
• Project Code1, Project Code 2; Detail Description, Accounting Analysis Code1, Accounting Analysis Code 2
• Currency (shown in Multi-Currency Accounting)
  Select Currency when you want to output journal data entered in the specified currency.
• Amount
• Macro File, Macro
  When outputting data, if you want to use macros of Microsoft Excel, you should specify the macro file and macro names.

[Buttons]

• Browse
  If you click this button when you are selecting the name of a macro file, the file names will appear in tree format.
• Start
  Click "Start" to open the [Output Destination] screen. Click either "Excel Export" or "Create CSV" button to select the format for exporting the data name.
• Clear
• Exit