File registration support apparatus, file registration support method, and file registration support program
The file registration support device allows simultaneous registration of evidence and non-evidence files from a single screen, addressing user errors and workload issues while ensuring compliance with regulatory standards.
Patent Information
- Application Number
- JP2023086071
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-05-25
- Publication Date
- 2024-12-05
- Estimated Expiration
- 2043-05-25
AI Technical Summary
Existing systems require separate screens for registering evidence and non-evidence files, leading to user errors and increased workload due to the need to determine the correct screen for each file type, and do not allow simultaneous registration from a single interface.
A file registration support device and method that enables the registration of both evidence and non-evidence files from the same screen, utilizing a control unit to manage the process and display appropriate fields based on file type, with integrated storage and search functions to ensure compliance with institutional requirements.
Facilitates efficient and error-reduced file registration by allowing simultaneous handling of different file types, reducing user workload and improving compliance with regulatory standards.
Smart Images

Figure 2024168971000001_ABST
Abstract
Description
[Technical field]
[0001] The present invention relates to a file registration support device, a file registration support method, and a file registration support program. [Background technology]
[0002] Paragraph 0006 of Patent Document 1 states, "However, in order to digitize and store a large number of supporting documents using a scanner, and to make journal entries or prepare expense reimbursement application documents based on these supporting documents, the work of matching the journal entries or expense reimbursement application documents with the supporting documents is necessary, which is cumbersome." Paragraph 0007 of Patent Document 1 also states, "Therefore, the present invention aims to provide a supporting document processing system and a supporting document processing method that enable the efficiency of accounting processing based on supporting documents." [Prior art documents] [Patent documents]
[0003] [Patent Document 1] JP 2018-116602 A Summary of the Invention [Problem to be solved by the invention]
[0004] When creating a voucher, not only supporting documents such as receipts but also non-supporting documents such as approval documents may be attached to the voucher. This is because, for example, when approving a voucher, there is a desire to check not only the receipt corresponding to the voucher but also the approval document corresponding to the voucher.
[0005] However, in the past, supporting evidence files and non-supporting evidence files were registered from different screens, so the user had to decide which screen to launch depending on the type of file they wanted to register, and there was a risk that the user would launch the wrong screen and register the file in the wrong registration destination (for example, registering a supporting evidence file in the registration destination for a non-supporting evidence file).
[0006] In addition, if a user wanted to register both evidential and non-evidence files, they had to register them from separate screens, which imposed a large workload on the user.
[0007] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a file registration support device, a file registration support method, and a file registration support program that can support the registration of evidence files and non-evidence files from the same screen. [Means for solving the problem]
[0008] In order to solve the above-mentioned problems and achieve the object, the file registration support device of the present invention is a file registration support device having a control unit capable of supporting the registration of evidential files and non-evidence files from a single screen, the control unit comprising: an attachment list screen display means for displaying an attachment list screen, which is a screen for attaching a file, when a button for attaching a file is selected on a voucher input screen, which is a screen for inputting the contents of a voucher; and an attachment detail screen display means for displaying an attachment detail screen, which is a screen for inputting detailed information about a file to be attached to a voucher, including an area for inputting an image of the attached file and detailed information about the attached file, when a file is attached on the attachment list screen, the attachment detail screen display means displays on the attachment details screen a list of items corresponding to the type of attached file selected on the attachment detail screen, and for some of the displayed items, if the contents of the voucher were input on the voucher input screen before the attachment list screen is displayed, the contents of the voucher input on the voucher input screen are displayed with the item values set to the contents of the voucher entered on the voucher input screen.
[0009] In addition, the file registration support device of the present invention is characterized in that the attachment details screen display means obtains a list of items corresponding to the type of attached file selected on the attachment details screen from a display item setting table which contains a list of items to be displayed on the attachment details screen for each file type.
[0010] In addition, the file registration support device of the present invention further includes a memory unit, in which a screen control table including system identification data for identifying the system to which the voucher input screen belongs and document type identification data for identifying the type of document, and a supporting document type table including the document type identification data, the document name, and an item name related to the date are stored, and the attachment details screen display means obtains from the screen control table the document type identification data linked to the system identification data for the system to which the voucher input screen to which the contents of the voucher are input belongs, then obtains from the supporting document type table the document name and item name related to the date linked to the obtained document type identification data, and finally displays the obtained document name and item name related to the date.
[0011] The file registration support device of the present invention is further characterized in that, when information is input on the attachment details screen and a button for registering an attached file is selected on the attachment details screen, the attachment list screen display means re-displays the attachment list screen including a list of attached files and the corresponding file types, and when a button for registering an attached file is selected on the attachment details screen, the control unit further comprises a work table generation means for generating a work table including file identification data for the attached file, a file type identification category for the type of the attached file, detailed information about the attached file input on the attachment details screen, and binary information about the attached file, when the button for registering an attached file is selected on the attachment list screen that is re-displayed.
[0012] Furthermore, in the file registration support device according to the present invention, when a button for registering an attached file is selected on the re-displayed attachment file list screen, the control unit re-displays the voucher input screen, and when a button for registering a voucher is selected on the re-displayed voucher input screen, the control unit displays (i) a linking table including a voucher number for identifying the registered voucher and the file identification data in the work table, in association with each other; and (ii) when the file type identification category in the work table is a category indicating the evidence file, a voucher information table including the file identification data, the file type identification category, and detailed information about the attached file in the work table, and a linking table including the file identification data, the file type identification category, and detailed information about the attached file in the work table, in association with each other. the system further comprises a linking table etc. generating means for generating (iii) a voucher image table including the voucher number and case identification data for identifying each case in the workflow when the file type identification category in the work table is a category indicating the non-voucher file, a file information table including the case identification data and detailed information about the attached file in the work table, a file image table including the case identification data and binary information about the attached file in the work table, and (iv) a voucher detail table including the voucher number and the contents of the voucher entered on the voucher input screen.
[0013] In addition, in the file registration support device according to the present invention, when a voucher approval screen is launched, which is a screen for a person in charge to approve the voucher, the control unit obtains from the voucher detail table the contents of the voucher linked to the voucher number in the workflow case table, and if a voucher linked to the case is registered in the linking table, obtains from the linking table the file identification data linked to the voucher number in the workflow case table, and further obtains detailed information and binary information linked to the obtained file identification data from the evidence information table and the evidence image table, respectively, and registers other files linked to the case in the file information table. is registered, binary information linked to the case identification data in the workflow case table is obtained from the file image table, and if the file selected on the voucher approval screen is the evidence file, the contents of the obtained voucher, detailed information obtained from the evidence information table, and binary information obtained from the evidence image table are displayed on the voucher approval screen, and if the file selected on the voucher approval screen is the non-evidence file, the contents of the obtained voucher and the binary information obtained from the file image table are displayed on the voucher approval screen.
[0014] In addition, the file registration support device of the present invention is characterized in that it further comprises a evidence search result display means for, when search conditions are input on a evidence search screen, which is a screen for searching for the evidence files, searching the evidence information table for information about the evidence files that match the input search conditions and displaying the search results on the evidence search screen.
[0015] Furthermore, the file registration support device according to the present invention is characterized in that the voucher is a delivery note, receipt, invoice or estimate, and the non-voucher is a request for approval.
[0016] Furthermore, the file registration support method of the present invention is a file registration support method executed by an information processing device equipped with a control unit, which can support the registration of evidential files and non-evidence files from the same screen, and includes an attachment list screen display step executed by the control unit, which displays an attachment list screen, which is a screen for attaching a file, when a button for attaching a file is selected on a voucher input screen, which is a screen for inputting the contents of a voucher, and an attachment detail screen display step, which displays an attachment detail screen, which is a screen for inputting detailed information about a file to be attached to a voucher, including an image of the attached file and an area for inputting detailed information about the attached file, when a file is attached on the attachment list screen, and in the attachment detail screen display step, a list of items corresponding to the type of attached file selected on the attachment detail screen is displayed on the attachment detail screen, and for some of the displayed items, if the contents of the voucher were entered on the voucher input screen before the attachment list screen is displayed, the contents of the voucher entered on the voucher input screen are displayed as item values.
[0017] In addition, the file registration assistance program of the present invention is a file registration assistance program to be executed by an information processing device having a control unit, which is capable of assisting in the registration of evidential files and non-evidence files from the same screen, and includes an attachment list screen display step for causing the control unit to execute the program, which displays an attachment list screen, which is a screen for attaching a file, when a button for attaching a file is selected on a voucher input screen, which is a screen for inputting the contents of a voucher, and an attachment detail screen display step for displaying, when a file is attached on the attachment list screen, an attachment detail screen, which is a screen for inputting detailed information about the file to be attached to the voucher, including an area for inputting an image of the attached file and detailed information about the attached file, wherein in the attachment detail screen display step, a list of items corresponding to the type of attached file selected on the attachment detail screen is displayed on the attachment details screen, and for some of the displayed items, if the contents of the voucher were entered on the voucher input screen before the attachment list screen was displayed, the contents of the voucher entered on the voucher input screen are displayed with the item values set. Effect of the Invention
[0018] According to the present invention, it is possible to provide an advantage that it is possible to support the registration of evidence files and non-evidence files from the same screen. [Brief description of the drawings]
[0019] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a file registration support device. [Diagram 2] FIG. 2 is a diagram showing an example of an outline of a processing flow according to the present embodiment. [Diagram 3] FIG. 3 is a diagram showing an example of an outline of the process flow when the system classification is "electronic transaction" or "scanner storage." [Figure 4]FIG. 4 is a diagram showing an example of an outline of a process flow when the system classification is "other attachments" and a workflow is used. [Diagram 5] FIG. 5 is a diagram showing an example of the screen control table and the voucher type table. [Figure 6] FIG. 6 is a diagram showing an example of the voucher work. [Figure 7] FIG. 7 is a diagram showing an example of the evidence information table and the evidence image table. [Figure 8] FIG. 8 is a diagram showing an example of a table in which an explanation of each item included in the evidence information table is given. [Figure 9] FIG. 9 is a diagram illustrating an example of the journal entry details table and the voucher linking table. [Figure 10] FIG. 10 is a diagram showing an example of a workflow case table, a file information table, and a file image table. [Figure 11] FIG. 11 is a diagram showing an example of the invoice input screen at the stage when the contents of the invoice have been entered. [Figure 12] FIG. 12 is a diagram showing an example of arguments for a dialog call. [Figure 13] FIG. 13 is a diagram showing an example of the attachment file list screen. [Figure 14] FIG. 14 is a diagram showing an example of an attachment file details screen for inputting detailed information about an invoice file (electronic transaction file). [Figure 15] FIG. 15 is a diagram showing an example of an attachment file details screen for inputting detailed information about a receipt file (scanner-saved file). [Figure 16] FIG. 16 is a diagram showing an example of an attachment file details screen for inputting detailed information about the approval request file (other attachment file). [Figure 17] FIG. 17 is a diagram illustrating an example of a display item setting table. [Figure 18] FIG. 18 is a diagram showing an example of the attached file list screen that is displayed again. [Figure 19] FIG. 19 is a diagram showing an example of the generated voucher work. [Figure 20] FIG. 20 is a diagram showing an example of the slip input screen that is displayed again. [Figure 21] FIG. 21 is a flow chart showing an example of the processing executed within the business system after the "Register" button on the redisplayed slip entry screen is pressed. [Figure 22] FIG. 22 is a diagram showing an example of obtaining a list of generated voucher voucher works and voucher vouchers. [Diagram 23] FIG. 23 is a diagram showing an example of the generated evidence linking table. [Figure 24] FIG. 24 is a diagram showing an example of a voucher information table and a voucher image table that are generated when the system classification is "electronic transaction or scanner storage." [Diagram 25] FIG. 25 is a diagram showing an example of the generated voucher work. [Figure 26] FIG. 26 is a diagram showing an example of a workflow case table, a file information table, and a file image table that are generated when the system classification is "other attachments" and a workflow system is used. [Figure 27] FIG. 27 is a diagram showing an example of a file information table and a file image table that are generated when the system classification is "other attachments" and the workflow system is not used. [Figure 28] FIG. 28 is a diagram illustrating an example of the generated journal entry detail table. [Figure 29] FIG. 29 shows an example of advance acquisition of information necessary for displaying the slip approval screen. [Diagram 30] FIG. 30 shows an example of the slip approval screen when file A, which is a system requirements file, is selected. [Diagram 31] FIG. 31 shows an example of the slip approval screen when file C, which is an additional attached file, is selected. [Diagram 32]FIG. 32 is a diagram showing an example of items that can be displayed as detailed information of a voucher on the slip approval screen. [Diagram 33] FIG. 33 is a diagram showing an example of the evidence information table to be searched. [Diagram 34] FIG. 34 is a diagram showing an example of items that can be used as search conditions. [Diagram 35] FIG. 35 is a diagram showing an example of items displayed as search results. [Diagram 36] FIG. 36 is a diagram showing an example of the evidence search screen. [Figure 37] FIG. 37 is a diagram showing buttons and the like arranged in the footer section of the evidence search screen. [Figure 38] FIG. 38 is a diagram showing an example of the evidence information table in which the TS presence / absence and the TS attachment date / time have been updated. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0020] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, preferred embodiments of a file registration support device, a file registration support method, and a file registration support program according to the present invention will be described in detail with reference to the accompanying drawings. Note that the present invention is not limited to the preferred embodiments.
[0021] [1. Overview] When creating a voucher, it is possible to attach supporting documents such as receipts or files for internal management such as approval documents to the voucher. In this case, supporting documents must be stored in accordance with the requirements of the Electronic Bookkeeping Act.
[0022] Here, a voucher file is document data that certifies the contents of a transaction. Examples of vouchers include delivery notes, receipts, invoices, and estimates. Voucher files generated by electronic transactions (electronic transaction files) and voucher files generated by scanner storage (scanner-saved files) must meet the system requirements of the Electronic Bookkeeping Act, and therefore belong to the category of "system requirement files."
[0023] In contrast, a non-voucher file is data of a document for internal management. For example, a non-voucher may be a request for approval. A non-voucher file does not need to meet the requirements of the Electronic Bookkeeping Act and is classified as "other attached files."
[0024] Since there are rules for storing system requirement files, they must be stored in a different way from the way other attachments are stored. Conventionally, in order to meet these rules, ports were created for uploading system requirement files and other attachments to different storage locations from different screens.
[0025] However, when registering files from different screens, the following issues (1) and (2) occurred. (1) Users need to determine which entry to attach depending on the type of file they are uploading, which may lead to errors. (2) The amount of work increases when uploading both the system requirements file and other attachments.
[0026] In addition, there was a request to be able to approve invoices by checking the file of the approval document that is the basis for the invoice, and in the case of business trip settlements, by checking the file of the travel expense schedule. There was also a request to store a set of related documents linked to the accounting entry.
[0027] Therefore, in this embodiment, for example, the following (1) to (4) are made possible. (1) It is now possible to register system requirement files (evidence files) that need to be kept in accordance with system requirements and other attachment files (non-evidence files) that do not need to be kept in accordance with system requirements from the same screen. This reduces the amount of work required by the user. (2) The system can now automatically determine the items that need to be entered for each system requirement depending on the type of file uploaded, and display them on the screen, reducing errors made by applicants. (3) It is now possible to search electronic transaction files and scanned files, which will reduce the costs of responding to tax investigations, etc. (4) When approving a document, all supporting documents and other attachments linked to the document can be viewed from the same screen. This reduces the amount of work required by users and also reduces the risk of misjudgment.
[0028] For details on how to view and delete uploaded files, please see below.
[0029] This section explains how to view uploaded files. Uploaded files, including electronic transaction files, scanner saved files, and other attached files, can be searched and viewed on the electronic evidence list, the slip screen for each business, and the workflow inquiry / approval screen. Note that other attached files differ depending on the calling method for each business, and can also be controlled by each business.
[0030] This section describes how to delete files. Physical deletion of electronic transaction files and scanner-stored files is not permitted by law, and therefore cannot be performed. Other attached files can be physically deleted, and the database can also be initialized. Deletion of other attached files can also be controlled by the respective business systems.
[0031] The specific configuration and operation will be described below.
[0032] [2. Configuration] An example of the configuration of a file registration support device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the file registration support device 100.
[0033] The file registration support device 100 is a commercially available desktop personal computer. The file registration support device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0034] File registration support device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in file registration support device 100 is connected to each other so as to be able to communicate with each other via an arbitrary communication path.
[0035] The communication interface unit 104 communicatively connects the file registration support device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the file registration support device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data such as various masters described later may be stored in the server 200, for example.
[0036] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.
[0037] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106.
[0038] The memory unit 106 includes, for example, a screen control table 106a, a voucher type table 106b, a voucher voucher work 106c as a work table, a voucher information table 106d, a voucher image table 106e, a voucher linking table 106f as a linking table, a workflow case table 106g, a file information table 106h, a file image table 106i, a journal entry details table 106j as a voucher details table, and a display item setting table 106k.
[0039] The screen control table 106a, the evidence type table 106b, the evidence slip work 106c, the evidence information table 106d, and the evidence image table 106e are tables stored in the electronic bookkeeping system. On the other hand, the evidence linking table 106f, the workflow case table 106g, the file information table 106h, the file image table 106i, and the journalization details table 106j are tables stored in each business system.
[0040] 5, screen control table 106a includes, for example, system identification data (system name) for identifying a system to which a slip input screen, which will be described later, belongs, document type identification data (initial display document code) for identifying the type of document, etc. In other words, screen control table 106a includes the name of the screen from which the attachment dialog box is called, the document code that is initially set when the attachment dialog box is called from that screen, etc.
[0041] As shown in FIG. 5, the evidence type table 106b includes, for example, the document type identification data (document code), document name, and item name related to date (transaction date label name), etc.
[0042] The evidence slip work 106c is a work table for temporarily storing information about files. As shown in Fig. 6, the evidence slip work 106c includes, for example, a WK key (work key) for uniquely identifying a record in the evidence slip work 106c, file identification data (evidence Guid) about the attached file, a file type identification category (regulation category) about the type of the attached file, detailed information about the attached file (file name, extension, document code, receipt date, transaction date, amount, business partner name, product name, resolution, gradation, TS presence / absence, TS attachment date and time, and origin system), and binary information (file image) about the attached file, etc. In reality, only a code is stored in the document code column. TS is an abbreviation for "time stamp".
[0043] The file type identification category (regulation category) is broadly divided into a category indicating the evidence file (regulation category of "electronic transaction" or "scanner storage") and a category indicating the non-evidence file (regulation category of "other attachment"). The category indicating the evidence file is further divided into a category indicating the electronic transaction file (regulation category of "electronic transaction") and a category indicating the scanner storage file (regulation category of "scanner storage").
[0044] The binary information is information that represents the attached file itself, and may be image information or information other than images. Examples of the binary information include a PDF file with an embedded image, e-mail data, Excel format data, and Word format data.
[0045] The evidence information table 106d is a table for managing detailed information about the evidence file, and is generated from the evidence slip work 106c. As shown in Fig. 7, the evidence information table 106d includes, for example, the file identification data (evidence Guid), the file type identification classification (regulation classification), and detailed information about the attached file (file name, extension, document code, receipt date, transaction date, amount, customer name, product name, resolution, gradation, TS presence / absence, TS attachment date / time, originating system, and deleted flag). Fig. 8 shows a table with an explanation of each item included in the evidence information table 106d.
[0046] The evidence image table 106e is a table for managing binary information about the evidence file, and is generated from the evidence slip work 106c. As shown in FIG. 7, the evidence image table 106e includes, for example, the file identification data (evidence Guid) and binary information (file image) about the attached file.
[0047] The evidence linking table 106f is a table for linking a voucher with an attached file. In the case of an accounting system, the "attached file" includes both the system requirement file and the other attached file. As shown in FIG. 9, the evidence linking table 106f includes, for example, a voucher number for identifying a registered voucher, the file identification data (electronic evidence Guid) in the evidence voucher work 106c, the file type identification category (system category) in the evidence voucher work 106c, and the like, which are linked together.
[0048] As shown in FIG. 10, the workflow case table 106g includes, for example, case identification data (case Guid) for identifying each case on the workflow, the approval status, the applying employee name, the voucher number (business voucher number), and the like.
[0049] The file information table 106h is a table for managing detailed information about the non-voucher file, and is generated from the voucher slip work 106c. As shown in FIG. 10, the file information table 106h includes, for example, the case identification data (case Guid) and detailed information about the attached file (attached file name and memo).
[0050] The file image table 106i is a table for managing binary information about the non-voucher file, and is generated from the voucher slip work 106c. As shown in FIG. 10, the file image table 106i includes, for example, the case identification data (case Guid) and binary information (file image) about the attached file.
[0051] As shown in Figure 9, the journal entry details table 106j includes, for example, the voucher number, the case identification data (case Guid), and the contents of the voucher (debit account item and debit amount) entered on the voucher input screen described below.
[0052] The display item setting table 106k includes a list of items to be displayed on the attachment details screen (described later) for each file type, as shown in Fig. 17. In the example of Fig. 17, items marked with "◯" are items to be displayed on the attachment details screen, and items marked with "X" are items not to be displayed on the attachment details screen.
[0053] The control unit 102 is a CPU or the like that performs overall control of the file registration support device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.
[0054] The control unit 102 has, in terms of functional concept, for example: (1) an attachment file list screen display unit 102a as attachment file list screen display means which displays an attachment file list screen, which is a screen for attaching a file, when a button for attaching a file is selected on a slip input screen, which is a screen for inputting the contents of a slip; (2) an attachment file detail screen display unit 102b as attachment file detail screen display means which displays an attachment file detail screen, which is a screen for inputting detailed information about a file to be attached to a slip, including an image of the attached file and an area for inputting detailed information about the attached file, when a file is attached on the attachment file list screen; and (3) a work table is generated that includes, when a button for registering an attached file is selected on the attachment file list screen that is displayed again, file identification data for the attached file, a file type identification category for the type of the attached file, detailed information about the attached file input on the attachment file detail screen, and binary information about the attached file. (4) when a button for registering an attached file is selected on the attached file list screen that is displayed again, the slip input screen is displayed again, and when a button for registering a slip is selected on the re-displayed slip input screen, (i) a linking table including a slip number for identifying the registered slip and the file identification data in the work table in a linked manner, (ii) when the file type identification category in the work table is a category indicating the evidence file, a evidence information table including the file identification data in the work table, the file type identification category, and detailed information about the attached file, and an evidence image table including the file identification data in the work table and binary information about the attached file, and (iii) when the file type identification category in the work table is a category indicating the non-evidence file, a workflow case table including the slip number and case identification data for identifying each case on the workflow.a linking table etc. generating unit 102d as linking table etc. generating means for generating a file information table including the case identification data and detailed information about the attached file in the work table, a file image table including the case identification data and binary information about the attached file in the work table, and (iV) a voucher detail table including the voucher number and the content of the voucher input on the voucher input screen; and (5) when a voucher approval screen which is a screen for a person in charge to approve the voucher is activated, the voucher content linked to the voucher number in the workflow case table is obtained from the voucher detail table, and if a voucher linked to a case is registered in the linking table, the file identification data linked to the voucher number in the workflow case table is obtained from the linking table, and further detailed information and binary information linked to the obtained file identification data are obtained from the evidence information table and the evidence image table, respectively, and the file information table is entered. (6) an approval information display unit 102e as an approval information display means for displaying the acquired voucher content, detailed information acquired from the evidence information table, and binary information acquired from the evidence image table on the voucher approval screen when other files associated with the document are registered; and (7) an evidence search result display unit 102f as evidence search result display means for searching the evidence information table for information on the evidence file matching the input search conditions from the evidence information table when search conditions are input on the evidence search screen, which is a screen for searching the evidence file, and displaying the search results on the evidence search screen. The contents of the processing executed by each unit will be described in detail in [4. Specific Processing Examples] below.
[0055] [3. Processing Overview] In this section, an overview of the processing according to this embodiment will be described.
[0056] [3-1.Overview] An overview of the process flow according to this embodiment is shown in Fig. 2. In this embodiment, as shown in Fig. 2, even if the file types are different, the point is that files can be registered from a common upload screen (attachment list screen and attachment details screen).
[0057] [3-2. Overview of each system category] An overview of the process flow when the system classification is "electronic transaction" or "scanner storage" is shown in Fig. 3. When the system classification is "electronic transaction" or "scanner storage", as shown in Fig. 3, a voucher information table 106d and a voucher image table 106e are generated as tables for storing information on the voucher file.
[0058] An overview of the process flow when the system classification is "other attachments" and a workflow is used is shown in Fig. 4. When the system classification is "other attachments" and a workflow is used, a file information table 106h and a file image table 106i are generated as tables for storing information on non-voucher files.
[0059] Here, in this embodiment, as shown in Figures 3 and 4, the key point is that even if the file's system classification is different, the file can be registered in the same flow, namely, journal entry input screen → attachment list screen and attachment details screen → journal entry input screen.
[0060] In Figures 3 and 4, the characters marked with * indicate the corresponding relationship with the following [4-1. Operational image]. For example, a specific example of the process at the point marked with "* Operational image (3)-D" in Figure 3 is described in (3)-D of [4-1. Operational image].
[0061] [3-3. Electronic bookkeeping systems and business systems] In this embodiment, the evidence files can be stored in an electronic bookkeeping system, which is a dedicated DB separate from the normal business DB, to meet the requirements of the Electronic Bookkeeping Act. This allows complete separation of processing between the electronic bookkeeping system that stores evidence files and the normal business system that stores non-evidence files. The features are that they can be collectively processed in the same DB, and that they are made into one DB to unify the handling of logical deletion within the same DB. The features of the processing or management performed in each system are shown below.
[0062] (Electronic bookkeeping system) - It is possible to add a time stamp, which prevents unauthorized persons from falsifying the evidence data and also makes it possible to detect whether or not the data has been falsified. · Physical deletion of evidence is not possible. Also, timestamp attachments can be consolidated into one DB (not distributed across business DBs). Since it is a separate DB, it is possible to encrypt it in the DB settings. Also, the DB can be backed up separately (this is not a requirement that includes securing the DB access rights). As explained in [4-3] below, it is possible to search for supporting evidence that satisfies the search requirements of the Electronic Bookkeeping Act.
[0063] (Normal business system) No time stamp is provided. - Attachments can be physically deleted. Also, the database can be initialized. The search method differs depending on the business system. There are also business systems that do not allow file search. In the case of a workflow system, you can refer to files from "File attachment specification. Inquiry", but you cannot search for individual files.
[0064] [4. Specific examples of processing] In this section, a specific example of the processing according to this embodiment will be described.
[0065] [4-1. Operation image] This section explains how to start the screen. Note that this section explains how to register a file using the accounting system's "journal entry input" as an example, but it is possible to register files in a similar way in other business systems.
[0066] (1) Calling the attachment dialog box from the business system First, when the button for attaching a file (the "Attach" button) is selected on the slip input screen (see FIG. 11) for inputting the contents of the slip, the attachment list screen display unit 102a displays the attachment list screen (see FIG. 13) for attaching a file. The display of the attachment list screen is, in other words, the start of the attachment dialog.
[0067] Here, the attachment file list screen display unit 102a displays the attachment file list screen in accordance with arguments of the dialogue call shown in Fig. 12. Note the following points regarding the arguments of the dialogue call. When you call a dialog at the source of the transition, you can pass the items you want to initially set to the dialog as arguments. You can also make those items read-only. The read-only flag is used to prevent the amount, etc. from being changed after final approval or when viewing in reference mode from a job. The originating system is used to set the upper limit of files that can be uploaded and to uniquely identify the evidence in [4-3]. The originating system is preset as an argument when the dialog is called.
[0068] (2) Launching and registering the attachment dialog (2-1) Step 1: Select the file you want to attach on the attachment list screen Next, the file to be attached is selected from the attachment list screen (see FIG. 13). There are four methods for attaching a file:
[0069] The first method is to select the file you want to attach by pressing the "Select from Explorer" button in Figure 13. The second method is to drag and drop the file you want to attach to the "You can drag and drop files here" area in Figure 13.
[0070] The third method is to upload a file taken with a mobile phone by pressing the "Select from the file taken with a document" button in Figure 13. With this method, it is possible not only to apply directly from the mobile phone using an image taken with a mobile phone, but also to import the image from an in-house PC.
[0071] The fourth method is to press the "Select from previously uploaded files" button in Fig. 13 and reattach the file that was deleted after being registered in the electronic bookkeeping system. With this method, it is possible to relink the evidence that has been logically deleted in the evidence information table 106d to the slip and upload it.
[0072] Once the file attachment is complete, you will be redirected to the attachment details screen.
[0073] (2-2) Step 2: Enter detailed information about the attachment on the attachment details screen When a file is attached on the attachment list screen (see Figure 13), the attachment details screen display unit 102b displays the attachment details screen (see Figures 14 to 16), which is a screen for entering detailed information about the file to be attached to the slip, including an image of the attached file and an area for entering detailed information about the attached file.
[0074] Fig. 14 shows the attachment details screen for inputting detailed information about an invoice file (electronic transaction file). Fig. 15 shows the attachment details screen for inputting detailed information about a receipt file (scanner saved file). Fig. 16 shows the attachment details screen for inputting detailed information about a request for approval file (other attachment file).
[0075] Here, the attachment details screen display unit 102b displays a list of items corresponding to the type of attached file selected on the attachment details screen (see Figures 14 to 16) on the attachment details screen (see Figures 14 to 16), and for some of the displayed items, if the contents of the voucher were entered on the voucher input screen before the attachment list screen was displayed, the contents of the voucher entered on the voucher input screen (see Figure 11) are displayed as the item value.
[0076] As described in the previous paragraph, the attachment details screen display unit 102b may obtain a list of items according to the type of the attached file selected on the attachment details screen (see Figs. 14 to 16) according to a fixed rule, but may obtain the list by referring to the display item setting table 106k (see Fig. 17) as described below. That is, the attachment details screen display unit 102b may obtain a list of items according to the type of the attached file selected on the attachment details screen from the display item setting table 106k (see Fig. 17) which includes a list of items to be displayed on the attachment details screen for each file type.
[0077] Specifically, when a file type (=regulation classification) is selected from the "Please select file type" section in the upper right corner of the attachment details screen (see Figs. 14 to 16), the attachment details screen display unit 102b acquires items corresponding to the selected regulation classification from the display item setting table 106k (see Fig. 17) to switch between displaying and hiding input items. If a value is set in the "dialog call argument" described in (1) in the business system, the attachment details screen display unit 102b launches the attachment details screen (see Figs. 14 to 16) with the items set.
[0078] Note that the following points should be noted regarding the display of the attachment details screen performed by the attachment details screen display unit 102b. The attachment details screen (see Fig. 14 to Fig. 16) is launched with the items passed from the slip input screen (see Fig. 11) initially set. What is set can be set by the business system. For example, in the case of a travel expense settlement application in a travel expense system, if there is a requirement to attach a voucher for each item, parameters can be set for each item. -On the same screen, you can select whether to upload a system requirements file or other attachments and upload the file. The input items will automatically change depending on the selected system category. In other words, the system will guide you so that you can enter items that meet the system requirements. For information on displaying or hiding items according to each system category, please refer to the display item setting table 106k (see Figure 17).
[0079] Here, the attachment details screen display unit 102b obtains, from the screen control table 106a (see FIG. 14), document type identification data (initial display document code) linked to system identification data (system name) for the system to which the slip input screen (see FIG. 11) on which the slip contents have been entered belongs. Next, the attachment details screen display unit 102b obtains, from the evidence type table 106b (see FIG. 14), the document name and date-related item name (transaction date label name) linked to the obtained document type identification data (document code). Finally, the attachment details screen display unit 102b displays the obtained document name and date-related item name (transaction date label name).
[0080] The display of the document name and the item name related to the date (transaction date label name) by the attachment details screen display unit 102b is specifically as follows. Document names are managed by the screen control table 106a (see FIG. 14). The document name that is initially displayed can be set for each screen that is called up. For example, as shown in the screen control table 106a (see FIG. 14), when the application is started from journal entry input, the document code of the delivery note is obtained, whereas when the application is started from travel expense settlement, the document code of the receipt is obtained. The "Date" label name can be set for each initially displayed document code in the evidence type table 106b (see FIG. 14). This function is provided because the concept of "transaction date" differs for each document. For example, as shown in the evidence type table 106b (see FIG. 14), if the document is a "delivery note", the transaction date label name will be "Date", and if the document is a "receipt", the transaction date label name will be "Receipt Date". When a specific document code is selected by the user on the attachment details screen, the selected document code is searched for in the evidence type table 106b (see FIG. 14), and the document name corresponding to the document code found in the search can be displayed on the attachment details screen.
[0081] Once you have completed entering the information, click the "Register" button. If multiple files are selected, the screen will switch to the input screen for the next file.
[0082] As described above in (2-1) and (2-2), the file registration support device 100 according to this embodiment can support the registration of evidence files and non-evidence files from the same screen. In this example, the evidence files are delivery note files (electronic transaction files) and receipt files (scanner-saved files). In this example, the non-evidence files are approval request form files (other attachment files). In this example, the same screen is the attachment file list screen (see FIG. 13) and the attachment file details screen (see FIG. 14 to FIG. 16).
[0083] (2-3) Step 3: Return to the attachment list screen and check that the attached file and its system classification are correct. When information is entered on the attachment details screen (see Figures 14 to 16) and a button for registering the attached file (the "Register" button) is selected on the attachment details screen (see Figures 14 to 16), the attachment list screen display unit 102a re-displays the attachment list screen (see Figure 18) including a list of the attached files and their corresponding file types.
[0084] Specifically, when the registration of all selected attachments is completed on the attachment details screen (see Figs. 14 to 16), the screen returns to the attachment list screen. On the returned attachment list screen, the attached files and their corresponding file types (=regulation classification) can be confirmed. When the attachment list screen is closed, the screen returns to the screen of the business system from which the transition originated.
[0085] In this specification, the term "display again" can be broadly understood and includes any of the following cases. When you move to the next screen, the original screen is temporarily hidden, and then when you return to the original screen from the next screen, the original screen is displayed again. When the next screen is displayed as a pop-up on top of the original screen, and the original screen becomes active when the next screen is closed. In this case, the information added to the next screen may be displayed on the original screen, or the original screen may simply be made active without displaying the information added to the next screen on the original screen.
[0086] When a button for registering an attached file ("Register" button) is selected on the redisplayed attachment file list screen (see FIG. 18), the work table generating unit 102c generates a voucher voucher work 106c (see FIG. 19) including file identification data (evidence Guid) for the attached file, file type identification classification (regulation classification) for the attached file, detailed information (file name, extension, document code, receipt date, transaction date, business partner name, amount, product name, resolution, gradation, TS presence / absence, TS attachment date and time, and origin system) for the attached file entered on the attachment file details screen (see FIG. 14 to FIG. 16), and binary information (file image) for the attached file. The work table generating unit 102c also stores the same WK key (work key) in the voucher voucher work 106c.
[0087] Specifically, when registration is made in the attachment dialog, detailed information and a file image of the attached evidence are stored in the evidence voucher work 106c. When storage is complete, the screen returns to the business system from which the transition originated. The items stored differ depending on the radio button selected on the attachment details screen (see Figs. 14 to 16). In other words, the columns in the evidence voucher work 106c that are updated differ depending on the system classification selected on the attachment details screen (see Figs. 14 to 16); for example, when a scanner-saved file is selected, information is stored in the columns for resolution and gradation.
[0088] (3) Registering a document in the calling system (business system) When the button for registering the attached file (the "Register" button) is selected on the redisplayed attachment file list screen (see FIG. 18), the linking table etc. generating unit 102d redisplays the slip input screen (see FIG. 20). Then, when the button for registering the slip (the "Register" button) is selected on the redisplayed slip input screen (see FIG. 20), the linking table etc. generating unit 102d starts generating each data (corresponding to "Start" in the flowchart in FIG. 21).
[0089] The type of data generated differs depending on the system classification selected on the attachment details screen (see Figs. 14 to 16) (=the storage location of information in the supporting document voucher work 106c differs). Each piece of data generated by the linking table etc. generating unit 102d will be explained below with reference to the flowchart in Fig. 21. Fig. 21 is a flowchart showing the processing executed within the business system after the "Register" button is pressed on the redisplayed document input screen (see Fig. 20).
[0090] (3)-A. Getting a list of supporting documents registered in the attachment dialog First, as shown in FIG. 22, the linking table etc. generation unit 102d uses common processing of the electronic bookkeeping system to obtain the file identification data (evidence Guid) and the file type identification classification (regulation classification) as information necessary for generating the evidence linking table 106f from the evidence voucher work 106c, which is a temporary table registered in the attachment dialog (corresponding to the processing of "A" in the flowchart in FIG. 21).
[0091] (3)-B. Creation of evidence linking table 106f Next, the linking table etc. generating unit 102d generates a voucher linking table 106f (see FIG. 23) including a voucher number for identifying the registered voucher and the file identification data (voucher Guid) in the voucher voucher work 106c in a linked manner (corresponding to the process of "B" in the flowchart in FIG. 21). The linking table etc. generating unit 102d may further include the file type identification category (regulation category) in the voucher voucher work 106c in the voucher linking table 106f (see FIG. 23).
[0092] In the evidence linking table 106f shown in Figure 23, three files are linked to one invoice identified by the invoice number "Zaimu100": a delivery note file (Evidence Guid: Guid_Evi01), a receipt file (Evidence Guid: Guid_Evi02), and a request form file (Evidence Guid: Guid_Evi03).
[0093] Note that the following points should be noted regarding the generation of the voucher linking table 106f performed by the linking table etc. generating unit 102d. On the business system side, the linking information is updated in the evidence linking table 106f of the business system DB (this update is delegated to the business side). Here, the slip in the business system and the electronic evidence are linked. Using the electronic evidence Guid as a key, link the document number in the business system with the electronic evidence registered in the attachment dialog. · Updating the supporting evidence linking table 106f is delegated to each business system. Therefore, the information held in the supporting evidence linking table 106f may differ depending on each business system. For example, the accounting system also updates "other attachments", while the travel expense system does not update "other attachments". This is to allow for flexibility, since each business system differs in where and how it stores "other attachments" in the DB.
[0094] (3)-C. Check the system classification Next, the linking table etc. generating unit 102d checks the type of the file type identification division (regulation division) in the evidence slip work 106c (corresponding to the process of "C" in the flowchart of FIG. 21).
[0095] 19, the record in the first line (regulation category: electronic transaction) and the record in the second line (regulation category: scanner storage) correspond to the records in the regulation requirement file. In this case, the linking table etc. generating unit 102d generates the voucher information table 106d and the voucher image table 106e based on the records in the first and second lines in the voucher voucher work 106c, as described in (3)-D below.
[0096] 19, the record in the third line (regulation classification: other attachments) corresponds to the record of the other attachments. In this case, the linking table etc. generating unit 102d generates the workflow case table 106g, the file information table 106h, and the file image table 106i based on the record in the third line in the voucher voucher work 106c, as described in (3)-F below, or generates the file information table 106h and the file image table 106i, as described in (3)-G below.
[0097] (3)-D. Institutional classification = Electronic transaction or scanner storage When the file type identification category (regulation category) in the evidence slip work 106c (see FIG. 19) is a category (electronic transaction or scanner storage) indicating the evidence file (when proceeding to the regulation requirement file (electronic transaction or scanner storage) in C in the flowchart of FIG. 21), a voucher information table 106d (see FIG. 24) including the file identification data (voucher Guid) in the voucher voucher work 106c (see FIG. 19), the file type identification category (regulation category) in the voucher voucher work 106c (see FIG. 19), and detailed information about the attached file in the voucher voucher work 106c (see FIG. 19) (file name, extension, document code, receipt date, transaction date, amount, product name, customer name, resolution, gradation, TS presence / absence, TS attachment date / time, originating system, and deleted flag); A voucher image table 106e (see FIG. 24) including the file identification data (voucher Guid) in the voucher voucher work 106c (see FIG. 19) and binary information (file image) about the attached file in the voucher voucher work 106c (see FIG. 19); (corresponding to the process of "D" in the flowchart of FIG. 21).
[0098] Note that the following points should be noted regarding the generation of the evidence information table 106d and the evidence image table 106e by the linking table etc. generating unit 102d. · Execute common processing for the electronic bookkeeping system (electronic document confirmation processing). The evidence information table 106d and the evidence image table 106e are updated. In addition, the data in the evidence slip work 106c is deleted. The relevant data is obtained using the "WK key" registered in the temporary table, voucher slip work 106c, as a key, and the information is updated in each table (voucher information table 106d and voucher image table 106e). The columns in the evidence information table 106d to be updated vary depending on the system classification. For example, when a scanner-stored file is selected, information is stored in the columns of resolution and gradation.
[0099] (3)-E. Check whether to use a workflow system If the file type identification category (regulation category) in the supporting document voucher work 106c (see FIG. 19) is a category indicating the non-supporting file (other attachments), the linking table etc. generation unit 102d further checks whether or not to use a workflow system (corresponding to the process of "E" in the flowchart in FIG. 21). This is because the storage location and storage method of other files differ depending on whether each business system uses a workflow system or not. All updates of other files are delegated to the business system. Each business system saves file images etc. obtained by common processing of the electronic bookkeeping system. FIG. 25 shows the supporting document voucher work 106c, which is the source table for updating.
[0100] (3)-F. System classification = Other attachments and using a workflow system The linking table etc. generating unit 102d determines whether the file type identification category (regulation category) in the supporting document slip work 106c (see FIG. 19) is a category (other attachments) indicating the non-supporting file (when proceeding to "other attachments" in C in the flowchart of FIG. 21), and when using a workflow system (when proceeding to "Use" in E in the flowchart of FIG. 21), ● A workflow case table 106g (see FIG. 26) including the slip number (business slip number), the case identification data (case Guid), etc.; ● A file information table 106h (see FIG. 26) including the case identification data (case Guid) and detailed information (attached file name and memo) about the attached file in the supporting document work 106c (see FIG. 19); A file image table 106i (see FIG. 26) including the case identification data (case Guid) and binary information (file image) about the attached file in the supporting document work 106c (see FIG. 19); (corresponding to the process "F" in the flowchart of FIG. 21).
[0101] Note that the following points should be noted regarding the generation of the workflow case table 106g, the file information table 106h, and the file image table 106i by the association table etc. generating unit 102d. · By executing common processing of the workflow system, information linking other attachments and documents is saved. -By using the workflow system, it is possible to simultaneously view documents and other attachments during approval.
[0102] (3)-G. System category = Other attachments and no workflow system is used (when saving attachments by business processes) The linking table etc. generating unit 102d determines that the file type identification category (regulation category) in the supporting document slip work 106c (see FIG. 19) is a category (other attachments) indicating the non-supporting file (when proceeding to "other attachments" in C in the flowchart of FIG. 21), and the workflow system is not used (when proceeding to "not used" in E in the flowchart of FIG. 21), ● A file information table 106h (see FIG. 27) containing the voucher number and detailed information (attached file name and memo) about the attached file in the supporting voucher work 106c (see FIG. 19); A file image table 106i (see FIG. 27) containing the voucher number and binary information (file image) about the attached file in the supporting voucher work 106c (see FIG. 19); (corresponding to the process of "G" in the flowchart of FIG. 21).
[0103] Note that the following points should be noted regarding the generation of the file information table 106h and the file image table 106i performed by the association table etc. generating unit 102d. Each business system stores file images, etc. obtained through common processing in the electronic bookkeeping system. In this example, the values for the accounting system used in the explanation so far are listed.
[0104] (3)-H. Generation of journal entry details table Finally, the linking table etc. generating unit 102d generates a journal entry detail table 106j (see FIG. 28) including the voucher number and the voucher content entered on the voucher input screen (see FIG. 20) (corresponding to the process of "H" in the flowchart of FIG. 21). In other words, the voucher is finalized by the voucher registration process of each business system.
[0105] By carrying out the processes described in this section (3) above, the linking table etc. generating unit 102d completes the generation of each data (corresponding to "end" in the flowchart of FIG. 21).
[0106] As explained in the section (3), the file registration support device 100 according to the present embodiment can store the evidence file and the non-evidence file in different locations. That is, the information of the evidence file can be stored in the evidence information table 106d and the evidence image table 106e, while the information of the non-evidence file can be stored in the workflow case table 106g, the file information table 106h, and the file image table 106i. In this way, by storing the evidence file and the non-evidence file separately in different locations, it is possible to easily approve the slip as described in [4-2] below and search for the evidence as described in [4-3] below.
[0107] [4-2. Approval of invoice] This section explains how to approve a document. When using workflow, all supporting documents and other files linked to the document can be viewed from the same screen when approving the document. The information that can be viewed is as follows: -Ticket contents File image of the supporting document linked to the document Detailed information related to the evidence (the information entered on the attachment details screen when uploading the evidence) File images of other attachments linked to the document
[0108] Here, in order to display information when approving a voucher, the information to be displayed must be acquired in advance, so we will first explain how to acquire the information to be displayed. When the voucher approval screen, which is the screen for the person in charge to approve the voucher, is launched, the approval information display unit 102e acquires information in advance as follows.
[0109] As shown in FIG. 29, the approval information display unit 102e acquires the contents of the voucher (debit account title, debit amount, etc.) linked to the voucher number in the workflow case table 106g from the journalization details table 106j.
[0110] In addition, when a voucher linked to a case is registered in the voucher linking table 106f, the approval information display unit 102e obtains the file identification data (voucher Guid) linked to the slip number in the workflow case table 106g from the voucher linking table 106f, as shown in FIG. 29, and further obtains detailed information (file name, extension, document code, receipt date, etc.) and binary information (file image) linked to the obtained file identification data (voucher Guid) from the voucher information table 106d and the voucher image table 106e, respectively.
[0111] Then, when other files linked to the case are registered in the file information table 106h, the approval information display unit 102e obtains binary information (file image) linked to the case identification data (voucher Guid) in the workflow case table 106g from the file image table 106i, as shown in FIG. 29.
[0112] Note that the following points should be noted regarding the advance acquisition of information performed by the approval information display unit 102e. The journal entry details table 106j and the supporting evidence linking table 106f are referenced from the workflow case table 106g. The information on the evidence is obtained from the evidence linking table 106f by the evidence acquisition process of the electronic bookkeeping system, which is referenced in the common process of the workflow. Other attachment information is obtained based on the Workflow CaseGuid.
[0113] The approval information display unit 102e then displays the acquired information on the slip approval screen in the following manner.
[0114] If the file selected on the voucher approval screen is the evidence file (regulatory requirements file), the approval information display unit 102e displays the contents of the acquired voucher, detailed information acquired from the evidence information table 106d, and binary information acquired from the evidence image table 106e on the voucher approval screen.
[0115] The display will be specifically described with reference to Fig. 30. Fig. 30 is a diagram showing the slip approval screen when the cursor is placed on the "File A.pdf" button. When File A, which is a system requirement file, is selected at the top of the screen as shown in Fig. 30, the approval information display unit 102e displays an area "Journal entry slip confirmation" on the left side of the screen as the contents of the slip, displays an area including the document name, etc. on the right side of the screen as the detailed information, and displays an image of the delivery note in the center of the screen as the binary information, as shown in Fig. 30. Note that items that can be displayed as the detailed information are summarized in Fig. 32.
[0116] In contrast, if the file selected on the invoice approval screen is the non-voucher file (other attachment file), the approval information display unit 102e displays the contents of the acquired invoice and the binary information acquired from the file image table 106i on the invoice approval screen.
[0117] This display will be specifically described with reference to Fig. 31. Fig. 31 is a diagram showing the voucher approval screen when the cursor is placed on the "File C.pdf" button. As shown in Fig. 31, when File C, which is an additional attachment, is selected at the top of the screen, the approval information display unit 102e displays the "Journal entry voucher confirmation" area on the left side of the screen as the contents of the voucher, and displays an image of the approval document on the right side of the screen as the binary information, as shown in Fig. 31.
[0118] Note the following points regarding the display of the slip approval screen by the approval information display unit 102e. At the top of the document approval screen, all attached files (system requirements files and other attached files) linked to the document are displayed as file buttons in a list. By clicking the displayed file button, you can download the attached files. By placing the cursor on one of the file buttons displayed at the top of the document approval screen, the preview of the attached file can be automatically switched. If the cursor is placed on the file button for the system requirements file, the content of the detailed information will also switch.
[0119] As explained above in section [4-2], according to the file registration support device 100 of this embodiment, when approving a voucher, the contents of the voucher (in this example, the contents of "Journal entry voucher confirmation"), an image of the supporting document linked to the voucher (in this example, an image of the delivery note), detailed information of the supporting document linked to the voucher (in this example, detailed information of the delivery note), and an image of the non-supporting document linked to the voucher (in this example, an image of the request form) can be displayed on one screen (in this example, the voucher approval screen). This allows the approving staff to approve the voucher after accurately and instantly checking a series of information related to the voucher, which reduces the burden on the approving staff and also eliminates mistakes in the approval process.
[0120] [4-3. Search for evidence (display list of electronic evidence)] This section explains how to search for evidence (displaying the list of electronic evidence). By searching for evidence, you can view all evidence stored in the electronic bookkeeping system. The list of electronic evidence has two jobs: one for the person himself and one for the accounting staff.
[0121] In the personal section, users can search, view, and logically delete vouchers that they have uploaded. In addition, users can also register new electronic transaction files that are not linked to vouchers.
[0122] The accounting staff version is used for responding to tax investigations, regular inspections, and daily confirmations. In addition, the accounting staff version allows them to search, view, and logically delete vouchers uploaded by all users.
[0123] The evidence data obtained from the electronic evidence list is obtained from the electronic ledger storage DB. While the slip data is distributed across each business system, the evidence data is consolidated in the electronic ledger storage DB. Therefore, by searching for evidence (displaying the electronic evidence list), it is possible to search and view evidence uploaded from all business systems.
[0124] Here, the search requirements of the Electronic Bookkeeping Act include the following (1) to (3). (1) The ability to search by "transaction date (or other date)," "transaction amount," and "transaction partner." (2) The ability to search by specifying a date or amount range. (3) The ability to search by combining two or more items. However, if you comply with a request for download, conditions (2) and (3) are not required.
[0125] Below, a specific description will be given of the search for evidence from the evidence search screen (see FIG. 36), which is a screen for searching for the evidence file, assuming that the following conditions exist. It is assumed that the evidence information table 106d shown in Fig. 33 exists as a search target. The evidence information table 106d shown in Fig. 33 is a table to which files are uploaded not only from the core accounting system, but also from the travel expense system and the sales system. As shown in Fig. 33, a scanner-saved file is uploaded from the travel expense system (record of evidence Guid: Guid_Evi03), and an electronic transaction file is uploaded from the sales system (record of evidence Guid: Guid_Evi04). Items that can be used as search conditions are, for example, as shown in Fig. 34. Search conditions can be entered in the left-hand area on the document search screen (see Fig. 36). Items displayed as search results are, for example, as shown in Fig. 35. The search results are displayed in the right-hand area of the evidence search screen (see Fig. 36).
[0126] When search conditions are entered on the evidence search screen (see Figure 36), the evidence search result display unit 102f searches the evidence information table 106d for information about the evidence file that matches the entered search conditions, and displays the search results on the evidence search screen (see Figure 36).
[0127] Note that the following points should be noted regarding the search for evidence performed by the evidence search result display unit 102f. By entering search conditions in the area on the left side of the document search screen (see Figure 36), it is possible to search (extract) documents using the details registered at the time of application. By being able to search for documents in this way, the search requirements of the Electronic Bookkeeping Act can be met. In the right area of the document search screen (see FIG. 36), the item details displayed as search results are controlled according to the selected system category. For control of the displayed item details, see FIG. 35. In [4-1], we explained an example of registering supporting documents from the core accounting system. However, as explained in this section [4-3], if supporting documents are registered from other systems (in this example, the travel expense system and sales system), you can search and view the supporting documents registered from those other systems.
[0128] Here, the buttons arranged in the footer section (lower section) of the voucher search screen (see FIG. 36) will be described. FIG. 37 shows an enlarged view of the buttons arranged in the footer section (lower section).
[0129] The "Add Evidence" button is a button for directly uploading an electronic transaction file to the electronic bookkeeping system without linking it to a slip. When the "Add Evidence" button is pressed, the screen transitions to the attachment list screen and the attachment details screen.
[0130] The "Delete" button is used to logically delete the evidence. Logical deletion means treating the data as deleted rather than physically deleting it. When logical deletion is performed, the "Deleted Flag" in the evidence information table 106d is updated from "False" to "True," as shown in FIG. 37. A record whose "Deleted Flag" has been updated to "True" is treated as deleted, but the record itself does not disappear.
[0131] The "Details" button is a button for viewing detailed information of the selected evidence (the values entered on the attachment details screen). When the "Details" button is pressed, the attachment details screen is launched in read-only mode.
[0132] As explained in section [4-3] above, the file registration support device 100 according to this embodiment can search for evidence and display the search results. This allows the person who registered the evidence to efficiently refer to the evidence he or she registered. The administrator can efficiently perform regular inspections and daily checks, and can also quickly respond to tax investigations.
[0133] Furthermore, as explained in section [4-3], the file registration support device 100 of this embodiment makes it possible to search for the desired voucher from the voucher information table 106d, which consolidates vouchers registered from multiple systems (in this example, including not only the core accounting system but also the travel expense system and the sales system), thereby enabling a comprehensive and thorough search of all registered vouchers.
[0134] [4-4. Adding a time stamp] This section describes how to assign a time stamp. When a time stamp is assigned, the presence or absence of a time stamp (TS presence or absence) and the time stamp assignment date and time (TS assignment date and time) in the evidence information table 106d are updated as shown in Fig. 38. By collecting evidence in the electronic bookkeeping system, it is possible to use a predetermined authenticated time stamp service.
[0135] [5. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.
[0136] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.
[0137] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0138] 6. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0139] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.
[0140] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.
[0141] Moreover, with regard to file registration support device 100, the components shown in the figures are merely conceptual functional elements, and the device does not necessarily have to be physically configured as shown in the figures.
[0142] For example, the processing functions of the file registration support device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the file registration support device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.
[0143] In addition, this computer program may be stored in an application program server connected to file registration assistance device 100 via any network, and it is also possible to download all or part of it as necessary.
[0144] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.
[0145] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.
[0146] The various databases etc. stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.
[0147] The file registration support device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The file registration support device 100 may be realized by installing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.
[0148] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]
[0149] The present invention is useful, for example, in fields related to accounting and fields using auxiliary ledgers. [Explanation of symbols]
[0150] 100 File registration support device 102 Control section 102a Attachment list screen display section 102b Attachment details screen display section 102c Worktable generation unit 102d Linking table generation unit 102e Approval information display section 102f Evidence search results display section 104 Communication interface section 106 Storage section 106a Screen Control Table 106b Evidence type table 106c Voucher Work 106d Evidence information table 106e Evidence Image Table 106f Evidence linking table 106g Workflow Case Table 106h File Information Table 106i File Image Table 106j Journal entry details table 106k Display Item Setting Table 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network
Claims
1. A file registration support device having a control unit capable of supporting the registration of evidence files and non-evidence files from a single screen, The control unit is an attachment file list screen display means for displaying an attachment file list screen, which is a screen for attaching a file, when a button for attaching a file is selected on a slip input screen, which is a screen for inputting the contents of a slip; an attachment file details screen display means for displaying an attachment file details screen, which is a screen for inputting detailed information about a file to be attached to a slip, including an image of the attached file and an area for inputting detailed information about the attached file, when a file is attached on the attachment file list screen; Equipped with said attachment details screen display means displays on said attachment details screen a list of items corresponding to the type of the attached file selected on said attachment details screen, and for some of the displayed items, if the contents of a slip have been input on said slip input screen before said attachment list screen is displayed, the contents of the slip input on said slip input screen are displayed in a state where they are set as item values; A file registration support device comprising:
2. The attachment file detail screen display means obtaining a list of items corresponding to the type of the attached file selected on the attachment details screen from a display item setting table including a list of items to be displayed on the attachment details screen for each file type; 2. The file registration support device according to claim 1, wherein:
3. Further comprising a storage unit, The storage unit includes: a screen control table including system identification data for identifying a system to which the slip input screen belongs and document type identification data for identifying a document type; a document type table including the document type identification data, the document name, and the item name related to the date; is stored, The attachment file detail screen display means obtaining, from the screen control table, document type identification data linked to system identification data for the system to which the slip input screen in which the slip contents are input belongs, then obtaining, from the voucher type table, item names relating to the document name and date linked to the obtained document type identification data, and finally displaying the obtained item names relating to the document name and date; 2. The file registration support device according to claim 1, wherein:
4. the attachment file list screen display means, when information is input on the attachment file details screen and a button for registering an attached file is selected on the attachment file details screen, displays again the attachment file list screen including a list of the attached files and the corresponding file types; The control unit is a work table generating means for generating a work table including file identification data for the attached file, a file type identification category for the type of the attached file, detailed information about the attached file inputted on the attachment details screen, and binary information about the attached file, when a button for registering the attached file is selected on the attached file list screen that is displayed again; Further comprising:
2. The file registration support device according to claim 1, wherein:
5. The control unit is When a button for registering an attached file is selected on the redisplayed attachment file list screen, the slip input screen is displayed again, and when a button for registering a slip is selected on the redisplayed slip input screen, (i) a linking table including a slip number for identifying a registered slip and the file identification data in the work table in a linked manner; (ii) when the file type identification category in the work table is a category indicating the evidence file, a evidence information table including the file identification data in the work table, the file type identification category, and detailed information about the attached file, and a evidence image table including the file identification data in the work table and binary information about the attached file; (iii) when the file type identification category in the work table is a category indicating the non-voucher file, a workflow case table including the slip number and case identification data for identifying each case on the workflow, a file information table including the case identification data and detailed information about the attached file in the work table, and a file image table including the case identification data and binary information about the attached file in the work table; (iv) a voucher detail table including the voucher number and the contents of the voucher entered on the voucher input screen; A means for generating a linking table, etc. Further comprising:
5. The file registration support device according to claim 4,
6. The control unit is When the invoice approval screen, which is a screen for the person in charge to approve the invoice, is launched, Obtaining the contents of the voucher linked to the voucher number in the workflow case table from the voucher detail table; When a voucher linked to a case is registered in the linking table, the file identification data linked to the slip number in the workflow case table is obtained from the linking table, and further, detailed information and binary information linked to the obtained file identification data are obtained from the evidence information table and the evidence image table, respectively; When other files linked to the case are registered in the file information table, binary information linked to the case identification data in the workflow case table is obtained from the file image table; When the file selected on the voucher approval screen is the evidence file, the acquired contents of the voucher, the detailed information acquired from the evidence information table, and the binary information acquired from the evidence image table are displayed on the voucher approval screen; an approval information display means for displaying, on the voucher approval screen, the contents of the acquired voucher and the binary information acquired from the file image table, when the file selected on the voucher approval screen is the non-voucher file; Further comprising:
6. The file registration support device according to claim 5,
7. The control unit is When search conditions are input on a voucher search screen, which is a screen for searching for the voucher files, a voucher search result display means searches the voucher information table for information on the voucher files that match the input search conditions and displays the search results on the voucher search screen. Further comprising:
6. The file registration support device according to claim 5,
8. The document is a delivery note, receipt, invoice or quotation, The non-certificate is a request for approval, 8. A file registration support device according to claim 1, wherein:
9. A file registration support method executed by an information processing device having a control unit, which can support the registration of evidence files and non-evidence files from a single screen, comprising: Executed by the control unit, an attachment list screen display step of displaying an attachment list screen, which is a screen for attaching a file, when a button for attaching a file is selected on a slip input screen, which is a screen for inputting the contents of a slip; an attachment details screen display step of displaying an attachment details screen, which is a screen for inputting detailed information about the file to be attached to the slip, including an image of the attached file and an area for inputting detailed information about the attached file, when a file is attached on the attachment list screen; Including, In the attachment details screen display step, a list of items corresponding to the type of the attached file selected on the attachment details screen is displayed on the attachment details screen, and for some of the displayed items, if the contents of a slip have been input on the slip input screen before the attachment list screen is displayed, the contents of the slip input on the slip input screen are displayed in a state where they are set as item values. A file registration support method comprising the steps of:
10. A file registration support program for an information processing device having a control unit, capable of supporting the registration of evidence files and non-evidence files from a single screen, the program comprising: To cause the control unit to execute an attachment list screen display step of displaying an attachment list screen, which is a screen for attaching a file, when a button for attaching a file is selected on a slip input screen, which is a screen for inputting the contents of a slip; an attachment details screen display step of displaying an attachment details screen, which is a screen for inputting detailed information about the file to be attached to the slip, including an image of the attached file and an area for inputting detailed information about the attached file, when a file is attached on the attachment list screen; Including, In the attachment details screen display step, a list of items corresponding to the type of the attached file selected on the attachment details screen is displayed on the attachment details screen, and for some of the displayed items, if the contents of a slip have been input on the slip input screen before the attachment list screen is displayed, the contents of the slip input on the slip input screen are displayed in a state where they are set as item values. A file registration support program characterized by the above.
Citation Information
Patent Citations
Accounting input system, terminal equipment, server device, method, and program
JP2016194802A
Accounting journal issue system and accounting journal issue program
JP2019200692A
Information processing device and information processing method
JP2020017149A
Voucher processing system and voucher processing method
JP2018116602A
Cited By
Document management device, document management method, and document management program
JP2026115250A
Business support device, business support method, and business support program
JP2026115251A
Document management device, document management method, and document management program
JP7939993B2
