JP6508917B2 - INFORMATION PROCESSING APPARATUS, PROGRAM, AND INFORMATION PROCESSING METHOD - Google Patents

Description

  The present invention relates to an information processing apparatus, a program, and an information processing method.

  Journal entry and payment processing are usually performed separately. Also, for example, Patent Document 1 describes a technique that seems to be related to the present invention. Patent Document 1 discloses a method of creating and using payment information-added firm banking data (FB data) in a distributed accounting system.

JP 2002-352078 A

  However, since the journal entry and payment processing are performed separately, there is a problem that there is room for improvement in terms of work efficiency.

  The present invention has been made in view of the above problems, and it is possible to create FB data and output a form for confirming the payment amount only by performing journal entry, and to improve work efficiency. It is an object of the present invention to provide an information processing apparatus, program, and information processing method that can

  In order to solve the problems described above and to achieve the object, an information processing apparatus according to the present invention is an information processing apparatus including a control unit, and the control unit is a debit item name and amount, and a credit item. It is obtained by adding the amount of credit related to the combination of payee and payment date, using source journal data in which a plurality of data on name and amount, payee, and payment date are stored. Means for creating firm banking data corresponding to the combination using the specified amount, payment source, date of payment, payee, designated data regarding date of occurrence of journal entry, and source journal data And the bank and account corresponding to the payer, the payee, the accounted amount, and the bank and the account corresponding to the payee, with reference to predetermined bank data on the bank and the account used by the payer and payee. The first form creation means for creating the first form data storing the related data, the payment source, the date of payment, and the designated data on the bank corresponding to the payment source, and the above-mentioned journal data And second form creation means for creating second form data in which data relating to a payee, payment amount, transfer amount, and bank and account corresponding to the payee are stored with reference to the bank data. It is characterized by

Further, in the information processing apparatus according to the present invention, in the information processing apparatus, the control unit executes the following information processing (A) to (C) in any order to make a debit item, an amount, and a credit item. And a payment journaling means for generating payment journal data corresponding to the combination in which data relating to an amount and a date of occurrence is stored.
(A) As data relating to the item and amount of the debit of the payment journal data, data relating to the item of the credit stored in the original journal data and the amount of money obtained by the addition is set.
(B) As data relating to credit items and amounts of the payment journal data, data relating to the account type stored in the bank data and the amount based on the amount obtained by the addition is set.
(C) As data relating to the date of occurrence of the payment journal data, data relating to the date of payment stored in the source journal data is set.

  Further, in the information processing apparatus according to the present invention, in the information processing apparatus, the control unit further includes a source journal entry means for inputting the source journal data, and the source journal entry means includes an occurrence date and a payment If the destination is specified, the payment date is used as the starting date, referring to the payment conditions for specifying the date of payment and the predetermined payee data regarding the payee. It is characterized by calculating.

  Further, a program according to the present invention uses a computer as a payee, using original journal data in which a plurality of data relating to a debit item name and amount, a credit item name and amount, a payee, and a payment date are stored. The amount of credit related to the combination of payment and payment date is added, and using the amount obtained by the addition, the FB creation unit that creates the firm banking data corresponding to the combination, payment source, payment date , Payee, and specified data on the date of occurrence of the journal entry and the above-mentioned journal entry data, referring to the predetermined bank data on the payer and the bank and account used by the payee, First form creation means for creating first form data storing data on corresponding bank and account, payee, recorded amount, and bank and account corresponding to payee, payment source Payment date, payment address, payment amount, payment amount, and payment recipient by referring to the bank data using designated data on the payment date and the bank corresponding to the payment source and the journal data. It is intended to function as a second form creation means for creating second form data in which data relating to a bank and an account is stored.

  Further, an information processing method according to the present invention is an information processing method executed by an information processing apparatus including a control unit, wherein the control unit includes a payment source, a payment date, a payee, and a journal entry. Using the specified data on the date, the item name and amount of the debit, the item name and amount of the credit, the payee, and the original journal data storing multiple data on the date of payment, the payment source and First, the bank and account corresponding to the payment source, the payee, the accounted amount, and the bank and account data corresponding to the payee are stored with reference to predetermined bank data regarding the bank and account used by the payee. Using the first form creation step of creating form data of the form, the payment source, the date of payment, the designated data regarding the bank corresponding to the payment source, and the original journal data, and referring to the bank data ,payment Second payment form creation step for creating second form data storing the payment amount, the transfer amount, and the bank and account data corresponding to the payee in any order, and the original journal data Using the amount of credit added to the combination of payee and payment date, and using the amount obtained by the addition to execute the FB creation step to create the firm banking data corresponding to the combination To be characterized.

  According to the present invention, it is possible to create FB data and output a form for confirming a payment amount only by performing journal entry, so that working efficiency can be improved.

FIG. 1 is a block diagram showing an example of the configuration of the PC 100. As shown in FIG. FIG. 2 is a block diagram showing an example of the journal entry screen. FIG. 3 is a block diagram showing an example of a vendor master maintenance screen. FIG. 4 is a block diagram showing an example of a vendor master maintenance screen. FIG. 5 is a block diagram showing an example of the bank fee master maintenance screen. FIG. 6 is a block diagram showing an example of a transfer request data creation screen. FIG. 7 is a view showing an example of a transfer request data creation screen. FIG. 8 is a diagram showing an example of the message screen. FIG. 9 is a diagram showing an example of the FB data creation screen. FIG. 10 is a diagram showing an example of a schedule table output screen. FIG. 11 is a diagram showing an example of a list output screen. FIG. 12 is a diagram showing an example of a flowchart regarding processing according to the present embodiment. FIG. 13 is a diagram showing an example of a due date list by transfer source. FIG. 14 is a view showing an example of a transfer list (by bank). FIG. 15 is a conceptual diagram showing addition of data to the transfer request 1 work table. FIG. 16 is a conceptual diagram showing the setting of the amount of money to the transfer request creation work table. FIG. 17 is a conceptual diagram showing an example of UPDATE of the transfer request 1 work table. FIG. 18 is a conceptual diagram showing an example of an error check of the transfer request creation work table. FIG. 19 is a conceptual diagram showing an example of updating of the transfer request creation work table. FIG. 20 is a conceptual diagram showing an example of updating the transfer request creation work table. FIG. 21 is a conceptual diagram showing an example of updating of the journal specification data table. FIG. 22 is a conceptual diagram showing an example of debt and cash data creation. FIG. 23 is a conceptual diagram showing an example of debt and fee data creation.

  Embodiments of the present invention will be described in detail based on the drawings. The present invention is not limited by this embodiment.

[1. Constitution]
Here, an example of the configuration of the PC (personal computer) 100 according to the present embodiment will be described with reference to FIG.

  The PC 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108, and a server 200 storing various masters (for example, a master described later) and a network 300 (for example, the Internet, an intranet, etc.). It is communicably connected via The units included in the PC 100 are communicably connected via an arbitrary communication path. The PC 100 may be, for example, a stationary type such as a desktop type personal computer, or a portable type such as a notebook type personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet type personal computer, etc. It may be

  The communication interface unit 104 communicably connects the PC 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 another device via a communication line.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving instructions to a central processing unit (CPU) in cooperation with an operating system (OS) to perform various processes. As the storage unit 106, for example, a memory device such as a random access memory (RAM) or a read only memory (ROM), a fixed disk device such as a hard disk, a flexible disk, an optical disk or the like can be used.

  The storage unit 106 includes a source journal data storage unit 106 a, a payment data storage unit 106 b, an FB data storage unit 106 c, a payment journal data storage unit 106 d, and a form data storage unit 106 e.

  The source journal data storage unit 106 a is for storing source journal data. Specifically, the source journal data is for storing data related to each item provided on a journal entry screen (see FIG. 2) described later.

  The transfer data storage unit 106b is for storing transfer data. Transfer data, specifically, mainly, company CD, transfer system NO1, transfer system NO2, transfer source bank CD, destination bank CD, destination branch CD, bank other bank division, tax amount, fee burden division, first party tax included It is intended to store data on items such as commissions, in-house tax fees, and total transfer amount. Transfer data is created based on original journal data and the like.

  The FB data storage unit 106 c is for storing FB data (text format data in a format defined by the National Bankers Association). In the present embodiment, the FB data is created based on the transfer data and the like.

  The payment journal data storage unit 106 d is for storing payment journal data. The payment journal data is specifically for storing data on payment journals in which accounts payable or payables are aggregated for each business partner and for each scheduled payment date based on original journal data and the like.

  The form data storage unit 106e is data on data (corresponding to the first form data of the present invention) related to the schedule details table by transfer source (see FIG. 13) described later, data on transfer list (by bank) (see FIG. 14), etc. This is for storing (corresponding to second form data of the present invention). In the present embodiment, the data on the transfer source-based due date schedule and the data on the transfer list (by bank) are created based on the transfer data and the like.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. For the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. The input device 112 can be a keyboard, a mouse, a microphone, and a monitor that implements a pointing device function in cooperation with the mouse. Hereinafter, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The control unit 102 is a CPU or the like that controls the PC 100 in an integrated manner. The control unit 102 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, required data, etc., and performs various information processing based on the stored programs. Run.

  The control unit 102 functionally and conceptually includes a journal management unit 102a, a transfer data creation unit 102b, an FB data creation unit 102c, a payment journal creation unit 102d, and a form creation unit 102e.

  The journal management unit 102a is an information processing unit that includes the original journal entry means of the present invention, and manages (for example, new registration or correction) the original journal data. When a journal entry screen (see FIG. 2), which will be described later, is displayed on the monitor 114, the journal management unit 102a executes various information processing in accordance with the operation by the operator.

  In particular, the operator sets the item code of accounts payable or unpaid in the "area for entering and displaying information of the credit" provided in the journal entry screen, sets the supplier code, and the supplier. When the cursor is removed from the code column, the journal management unit 102a acquires information on the closing date payment date 1 with reference to a vendor master (see FIG. 3) described later based on the set supplier code. Based on the acquired information on closing date, payment date 1 and information on the date of occurrence in the journal entry screen, calculate the expected payment date with the date of occurrence as the start date (no bank holidays may be taken into account) The calculated estimated due date is displayed as an initial value in the field corresponding to "analysis 1" in the "area for inputting / displaying information on credit" provided on the journal entry screen. The scheduled payment date after the initial display can be corrected. In addition, when the supplier code is changed, the estimated payment date is calculated and displayed again. When the supplier code is blank, the field corresponding to “analysis 1” is also blank. In the case of accounts payable and unpaid, a specification may be made such that there is no blank check in the column corresponding to “analysis 1” (but with master check). The target of payment may be only payables and payables in which the date (scheduled payment date) is included in the column corresponding to “analysis 1”.

  The transfer data creation unit 102b functions as a part of the FB creation means, a part of the first form creation means, and a part of the second form creation means of the present invention. Is an information processing means for creating and outputting transfer data with reference to FIG. When a transfer request data creation screen (see FIG. 6) to be described later (see FIG. 6) is displayed on the monitor 114, when a predetermined operation is performed by the operator, the transfer data creation unit 102b creates and outputs transfer data.

  The FB data creation unit 102c corresponds to the FB creation unit of the present invention, and is an information processing unit that creates and outputs the FB data with reference to various masters using transfer data and the like. When a predetermined operation is performed by the operator when an FB data creation screen (see FIG. 9) described later is displayed on the monitor 114, the FB data creation unit 102c creates and outputs FB data.

  The payment journal creation unit 102d corresponds to the payment journal creation unit of the present invention, and is an information processing unit that creates and outputs the payment journal data by referring to various masters using original journal data, transfer data, and the like. is there. When an FB data creation screen (refer to FIG. 9) to be described later (see FIG. 9) is displayed on the monitor 114, a predetermined operation is performed by the operator in a state where the check box of "payment journal creation classification" in the screen is selected. In addition to the creation and output of FB data, the creation and output of payment journal data are performed.

  The form creation unit 102e includes the first form creation means and the second form creation means of the present invention, and using the transfer data and the like, referring to various masters, the data of the due date schedule by transfer source and the transfer list It is an information processing means that creates and outputs data of a table (by bank). When a schedule output screen (see FIG. 10) to be described later (see FIG. 10) is displayed on the monitor 114 and the operator performs a predetermined operation, the form creation unit 102e creates data of a due date list by transfer source and transfers The original due date schedule is displayed on the monitor 114 or printed via a printer. When a list output screen (see FIG. 11) to be described later (see FIG. 11) is displayed on the monitor 114 and the operator performs a predetermined operation, the form creation unit 102e creates data of a transfer list (by bank), The transfer list (by bank) is displayed on the monitor 114 or printed via a printer.

[2. screen structure]
Here, an example of the screen configuration in the present embodiment will be described with reference to FIGS. 2 to 11.

[2-1. Journal Entry Screen]
FIG. 2 is a diagram showing an example of a journal entry screen for journal entry. The journal entry screen, for example, includes the following items. In the present embodiment, a field (a field corresponding to "analysis 1") for entering / displaying a scheduled payment date is provided in the following "area for entering / displaying information on credit". Is one of the features.
・ Edit box for entering / displaying establishment CD ・ Button for referring to establishment CD ・ Area for displaying establishment name (for example, “Tokyo head office” etc.) ・ Input / display classification reference CD Edit box for entering, button for referencing reference category CD, area for displaying reference category name (eg "Common" etc.), edit box for entering / displaying date of occurrence, entry of slip category CD An edit box for displaying, a button for referring to a slip classification CD, an area for displaying a slip classification name (for example, "normal journal etc."), an edit box for inputting / displaying matters concerning slip abstract Refer to the button for referring to the matters concerning the abstract, the edit box for entering and displaying the prompt issue CD, and refer to the prompt issue CD -Display button for immediate transmission name ("Yes" or "No")-Edit box for displaying the document number-Edit box for displaying the previous document number-Enter the calling document number · An edit box for displaying · A button for instructing display · An area for inputting and displaying debit information · An area for inputting and displaying credit information · An area for inputting and displaying summary information・ Area for displaying the total amount of debit ・ Area for displaying the total amount of credit

  When the journal entry screen is displayed on the monitor 114, in particular, the function key F10 of the keyboard 112 functions as a button for instructing registration of a journal set on the journal entry screen.

[2-2. Vendor master maintenance screen]
FIG. 3 is a view showing an example of a vendor master maintenance screen for managing information on vendors included in the vendor master. The vendor master maintenance screen shown in FIG. 3 includes, for example, the following items. In addition, in this embodiment, it is one of the characteristics to reference the information of the following closing date payment date 1 in the case of calculation of a scheduled payment date.
・ Edit box for entering / displaying reference date ・ Edit box for entering / displaying vendor CD ・ Button for referring to vendor CD ・ Edit box for entering / displaying payee CD -A button for referring to the payee CD-An edit box for entering the debt management establishment CD-A button for referring to the debt management establishment CD-A check box for selecting each closing-Closing date Payment date 1Edit box for entering / displaying CD 1 button for referring to 1CD for closing date payment date 1 area for displaying 1 person on closing date payment date Edit box for entering / displaying 1CD for payment An area for displaying a button for referencing the condition 1CD and one person for the settlement condition

FIG. 4 is a diagram showing an example of a vendor master maintenance screen for managing information on a payee included in the vendor master. The vendor master maintenance screen shown in FIG. 4 includes, for example, the following items. In the present embodiment, when calculating the transfer fee, information on the fee burden classification within the “area for inputting and displaying information on the transferee” (a fee burden classification CD, a fee burden classification name (“ "Payment" or "Payment by customer") is referred to.
・ Edit box for entering / displaying reference date ・ Edit box for entering / displaying vendor CD ・ Button for referring to vendor CD ・ Edit box for entering / displaying payee CD -A button for referring to the payee CD-An area for entering and displaying information of the mailing address-An area for entering and displaying information of the cash on hand and due cash-For entering and displaying information of the settlement account Area · Area for entering / displaying information of transfer destination

[2-3. Bank fee master maintenance screen]
FIG. 5 is a diagram showing an example of the bank fee master maintenance screen for managing the bank fee master. The bank fee master maintenance screen includes, for example, the following items. In the present embodiment, when calculating the transfer fee, the information on the following condition amount and the tax-included transfer fee is referred to.
· An edit box for entering and displaying a bank CD · A button for referring to a bank CD · An area for displaying a bank name (eg "○○ bank" etc.) · For entering and displaying a transfer method CD Edit box ・ button for referring to the transfer method CD ・ area for displaying the transfer method name (for example, “FB” etc.) ・ type of the transfer destination type CD Refer to the edit box for entering and displaying the CD ・ transfer destination type CD Area to display the name of the transferee type (for example, "Affiliated other branch" etc.) Area to display the transfer classification CD Edit box to enter / display the CD · button to refer to the transfer classification CD · transfer classification Area for displaying names (eg "Telephone treatment" etc.), edit box for entering / displaying application start date, button for referring to application start date And conditions amount edit box for entering and displaying the edit box-tax transfer fee for entering and displaying the

[2-4. Transfer request data creation screen]
FIG. 6 is a diagram showing an example of a transfer request data creation screen in a state where a radio button for selecting creation of transfer data is selected. FIG. 7 is a view showing an example of a transfer request data creation screen in a state where a radio button for selecting creation of FB data is selected. The transfer request data creation screen includes, for example, the following items.
-An edit box for entering and displaying the payment establishment CD-A button for referring to the payment establishment CD-An area for displaying the payment establishment name-An edit box for entering and displaying the designated transfer date- Edit box for entering / displaying payment settlement account number, button for referencing payment settlement account number, edit box for entering / displaying actual transfer date, radio button for selecting creation of transfer data Radio button for selecting the creation of transfer request error list, radio button for selecting the creation of bank transfer list, radio button for selecting the creation of transfer request form, and for selecting creation of FB data Select radio button · radio button to select creation of due date list by transfer source · Create transfer list (by bank) Radio button eyes

  When the transfer request data creation screen is displayed on the monitor 114, in particular, the function key F10 of the keyboard 112 functions as a button for instructing execution of processing associated with the radio button in the selected state.

[2-5. Message screen]
FIG. 8 is a diagram showing an example of the message screen. The message screen is displayed when the function key F10 is pressed in a state where the "radio button for selecting the creation of transfer data" in the transfer request data creation screen is selected. The message screen has, for example, an edit box for inputting / displaying a transfer designated date to be changed (modified date), a button for instructing to change the designated transfer date to a modified date, and change of the designated transfer date. Including a button for instructing not to

[2-6. FB data creation screen]
FIG. 9 is a diagram showing an example of the FB data creation screen. The FB data creation screen is displayed when the function key F10 is pressed in a state where the "radio button for selecting creation of FB data" in the transfer request data creation screen is selected. The FB data creation screen includes, for example, the following items.
-An edit box for displaying the payment establishment CD-A button for referring to the payment establishment CD-An area for displaying the payment establishment name-An edit box for displaying the designated transfer date-Payment settlement account number Select edit box for entering / displaying, button for referring payment settlement account number, edit box for displaying payment method CD, edit box for displaying payment method name, creation of payment journal Check box for editing · Edit box for displaying the path of the folder for storing FB data · Button for referencing the folder for storing FB data · File name for inputting / displaying FB data Check to select to put a line feed code at the end of edit box record Check box to choose to give the end-of-file code (EOF) at the end of the box-file

  When the FB data creation screen is displayed on the monitor 114, in particular, the function key F10 of the keyboard 112 is a button for instructing to execute the output of the FB data under the conditions set in the FB data creation screen. Function.

[2-7. Schedule output screen]
FIG. 10 is a diagram showing an example of a schedule table output screen for outputting a due date list by transfer source (for example, one having a format shown in FIG. 13). The schedule table output screen is displayed when the function key F10 is pressed in a state in which the “radio button for selecting the creation of the due date list by transfer source” in the transfer request data creation screen is selected. is there. The schedule table output screen includes, for example, the following items.
-An edit box for displaying a payment establishment CD-A button for referring to a payment establishment CD-An area for displaying a payment establishment name-An edit box for displaying a transfer designated date-A payee CD Two edit boxes for entering / displaying the range (FROM, TO) Two buttons for referring to the payee CD Edit box for entering / displaying the date range of occurrence (FROM, TO) Two radio buttons for selecting whether the order of the original due date schedule is in payee kana order or payee code order

  In particular, when the schedule output screen is displayed on the monitor 114, the function key F10 of the keyboard 112 executes the output (printing) of the transfer source due date schedule under the conditions set in the schedule output screen. Act as a button for instructing.

[2-8. List output screen]
FIG. 11 is a diagram showing an example of a list output screen for outputting a transfer list (by bank) (for example, in the format shown in FIG. 14). The list output screen is displayed when the function key F10 is pressed in a state where the "radio button for selecting the creation of the transfer list (by bank)" in the transfer request data creation screen is selected. It is. The list output screen includes, for example, the following items.
・ Edit box for entering / displaying payment office CD ・ Button for referring to payment office CD ・ Edit box for entering / displaying payment date ・ Range of transfer source bank CD (FROM, TO) Two edit boxes for entering and displaying · Two buttons for referring to the source bank CD · Sorting order on the list of transfers (by bank) by payee kana order or payee code order Two radio buttons for selecting

  Particularly, when the list output screen is displayed on the monitor 114, the function key F10 of the keyboard 112 executes the output (printing) of the transfer list (by bank) under the conditions set in the list output screen. Act as a button to indicate that.

[3. processing]
Here, an example of the process according to the present embodiment will be described in detail with reference to FIG. 12 and the like.

[Step S1: Journal Entry (New Registration)]
When the operator sets necessary information (in particular, data of the due date of payment etc.) on the journal entry screen displayed on the monitor 114 and depresses the function key F10, the journal management unit 102a sets the set data. The stored original journal data is generated and stored in the original journal data storage unit 106a.

  In particular, the operator sets the item code of accounts payable, the supplier code, and the supplier code in the "area for entering and displaying credit information" provided on the journal entry screen. When the cursor is removed from the field, the journal management unit 102a refers to the vendor master and acquires information on the closing date payment date 1 based on the set supplier code, and acquires the closing date payment date 1 Based on the information and the information on the date of occurrence in the journal entry screen, calculate the scheduled due date starting from the date of occurrence (does not take bank holidays into account) and provide the calculated scheduled due date on the journal entry screen It is displayed in the field corresponding to "analysis 1" in the "area for inputting and displaying information of credit". For example, if the information of closing date payment date 1 is “payment on the end of the next day of the 15th, and the date of occurrence in the journal entry screen is“ 2014/8/20 ”,“ 2014/9/30 ”is Calculated as scheduled payment date.

  In addition, even if the same supplier has a transfer to a different account on one scheduled payment date, the supplier code is divided and the original journal entry is registered.

[Step S2: Transfer Data Creation]
When the operator sets necessary information on the transfer request data creation screen displayed on the monitor 114, selects the "Transfer data creation" radio button (see FIG. 6), and presses the function key F10, the transfer is performed. The data creation unit 102b displays a message screen (see FIG. 8).

  If the operator wants to change the designated transfer date, the desired date is set, and if the “Yes” button is pressed, the transfer data creation unit 102b sets the set date as the designated transfer date. If the change date is blank when the “Yes” button is pressed, the transfer data creation unit 102 b treats it as an error. When the “No” button is pressed, the transfer data creation unit 102b proceeds with the transfer data creation process without changing the designated transfer date.

  The transfer data creation unit 102b checks whether there is any transfer data created in the past, and deletes the transfer data if it exists, and the original journal data (but only the approved data is transfer data) Create transfer data anew with reference to the various masters, etc.). Specifically, the transfer data creation unit 102b consolidates the amount for each scheduled payment date stored in the “analysis 1” item of the original journal data, for each payee (also applies to the ¥ 0 specification), and the transfer fee Create transfer data by taking into consideration whether the former burden or the company's burden (calculate the transfer fee with reference to the bank fee master in the case of the former burden, and set the transfer fee to "0 yen" for the company's burden) .

  In addition, if transfer data are created, it becomes possible to create and output data of a due date list by transfer source and data of a transfer list.

[Step S3: FB data creation (including creation of payment journal data)]
When the operator selects the "FB data creation" radio button in the transfer request data creation screen displayed on the monitor 114 (see FIG. 7) and presses the function key F10, the control unit 102 creates the transfer request data. The screen is transitioned to the FB data creation screen (with the check box of “payment journal creation classification” checked) (see FIG. 9).

  When the operator sets necessary information on the FB data creation screen displayed on the monitor 114 and depresses the function key F10, the control unit 102 operates the FB data creation unit 102c and the payment journal creation unit 102d. .

  The FB data creation unit 102c creates FB data by acquiring necessary data according to the format of the FB data from the transfer data created in step S2, and storing the acquired data in the FB data.

  The payment journal creation unit 102d creates payment journal data using the original journal data registered in step S1 and the transfer data generated in step S2. Specifically, the payment journalizing unit 102d aggregates data in which accounts payable in the main journal are generated for each business partner and each scheduled payment date, and creates a journal of payment.

For example, if the following source journal exists, the following payment journal is created: In addition, since “revenue burden” or “recipient payer” is set in the vendor master for each client for the transfer fee, the bank fee master when “transferee pay” is set for the transfer fee The following payment journal is created, taking into account the transfer fee amount set in.
<An example of the original journal>
100 purchases / 100 payables Customers: 金属 metal; due date: 20XX / 9/30
Purchases 200 / Accounts payable 200 Customers: ○ ○ metal; Payment date: 20XX / 9/30
100 purchases / 100 payables Customers: ○ ○ metal; due date: 20XX / 10/31
<Example of payment journal>
Accounts payable 300 / savings account 300 Date of occurrence: 20XX / 9/30
<Example of payment journal entry when the transfer fee is "paying from the customer">
Accounts payable 300 / savings account 295 Date of occurrence: 20XX / 9/30
Transfer fee 5

[4. Specific example of processing]
A specific example of processing in the case of being realized by SQL (Structured Query Language) will be described in detail with reference to FIGS.

  First, when the operator selects the "Transfer data creation" radio button on the transfer request data creation screen (see FIG. 6) and depresses the function key F10, each processing unit (transfer data creation unit included in the control unit 102) The 102b and the payment journalizing unit 102d execute the following processes (1) to (6) relating to the preparation of the transfer data and the process (7) relating to the preparation of the payment journal data.

(1) Initialize each work table (specifically, the work table shown below) used in this processing.

(2) From the journal specification data table (corresponding to the original journal data), update target data is acquired according to the following extraction conditions, and the acquired update target data is added to the transfer request 1 work table (see FIG. 15).
<Extraction conditions>
Journal item data table. Analysis CD1 = Transfer request data creation screen. Transfer specified date Journal item data table. Office CD = Transfer request data creation screen. Office CD
Business partner master table. Settlement account CD = Transfer request data creation screen. Settlement account CD
Journal item data table. Balance indicator = 1
Journal item data table. Customer indicator = 1
Subject master table. Analysis check indicator = 1
Journal item data table. Analysis CD1 IS NOT NULL
Journal item data table. Analysis customization CD2 IS NULL
Journal item data table. Customer CD <>'*'

(3) Transfer request 1 The amount of transfer destination unit calculated based on the work table is set in the transfer request creation work table (the source of transfer data). Specifically, the following processes (3-1) and (3-2) are performed.

(3-1) Transfer Request 1 Based on the work table, the amounts are totaled in units of transfer destination according to the following aggregation conditions, and set in the transfer request creation work table (see FIG. 16).
<Total condition>
Payment office CD> Settlement account CD> Payment method CD
> Payment bank CD> Payment branch CD> Payment deposit type> Payment account number> Fee charge classification

(3-2) DtGroupKey (serial number) is set to the transfer request 1 work table and the transfer request creation work table. Specifically, DtGroupKey is updated to the transfer request creation work table according to the following numbering conditions, and DtGroupKey of the transfer request creation work table is updated to the transfer request 1 work table according to the following combination conditions (FIG. 17) reference).
<Numbering conditions>
Payment office CD> Settlement account CD> Payment method CD
> Payment bank CD> Payment branch CD> Payment deposit type> Payment account number> Fees burden classification ※ System NO identification = 50 is newly added <Combination condition>
Payment office CD> Settlement account CD> Payment method CD
> Payment bank CD> Payment branch CD> Payment deposit type> Payment account number> Fee charge classification

(4) Perform error check of the transfer destination etc. on the transfer request creation work table (see FIG. 18). Note that the error occurrence statement is deleted.

(5) UPDATE the fee in the transfer request creation work table. Specifically, the following processes (5-1) and (5-2) are performed.

(5-1) Update the transferee type in the transfer request creation work table according to the following conditions and contents (see FIG. 19).
<Joining condition>
Transfer request creation worktable. Destination bank CD = bank group master table. Main Bank CD
<Extraction conditions>
Transfer request creation worktable. Company CD = Login. Company CD
<Content of update>
(A) "Transfer request creation work table. Destination bank CD = Transfer request creation work table. Transfer destination bank CD" (A-1) "Transfer request creation work table. Destination branch CD = Transfer request creation work table. Transfer transfer In the case of destination branch CD "
Transfer request creation worktable. Bank Other Bank Division = 1 'Bank Transfer Bank (A-2)' Transfer request creation work table. Destination branch CD Transfer request creation work table. Transfer destination branch CD '
Transfer request creation worktable. Bank Other Bank Division = 2 'Bank Other Bank (B)' Transfer Request Creation Worktable. Destination Bank CD ≠ Transfer Request Creation Worktable. Transfer Destination Bank CD '(B-1) “Bank Group Master. Destination Bank CD In the case of <> NULL
Transfer request creation worktable. Bank Other Bank Classification = 3 'Same Bank Group (B-2)' Bank Group Master. Destination Bank CD IS NULL '
Transfer request creation worktable. Bank Other Line Division = 4 'Other Line

(5-2) The fee amount in the transfer request preparation work table is updated according to the following conditions and contents (see FIG. 20).
<Joining condition>
Transfer request creation worktable. Company CD = Fee Master Table. Company CD
AND transfer request creation work table. Transfer source bank CD = fee master table. Bank CD
AND transfer request creation work table. Bank other line classification = fee master table. Bank other group classification AND fee master table. Telegraph division = 0

str amount lower limit = ′ ′ amount lower limit _i ′ ′
str amount limit = “amount limit _i”
str fee = ′ ′ fee _i ′ ′
(※ i is the number of fee masters)

<Content of update>
(A) "str amount lower limit <= transfer request creation work table. Tax included amount AND transfer request created work table. Tax included amount> = str amount upper limit AND transfer request created work table. Fee burden division = 0"
Transfer request creation worktable. Forward tax fee = str fee
Transfer request creation worktable. Transfer amount total = Transfer request creation work table. Transfer amount total-str fee (B) "str amount lower limit <= transfer request making work table. Tax amount AND transfer request making work table. Tax amount amount> = str amount upper limit AND transfer request making work table. Fee burden division = 1" in the case of
Transfer request creation worktable. Own company tax fee = str fee

(6) In the journal item data table, update payment data preparation completion. Specifically, using the transfer request 1 work table, the transfer specification data table is updated in the journal item data table according to the following conditions and contents (see FIG. 21).
<Joining condition>
Journal item data table. Slip number = transfer request 1 work table. Document number Journal item data table. Line NO = Transfer request 1 work table. Row NO
<Content of update>
Journal item data table. Analysis customization CD1 = 1 (created)
Journal item data table. Analysis customization CD3 = Transfer request 1 work table. Transfer system NO1
Journal item data table. Analysis customization CD4 = Transfer request 1 work table. Transfer system NO2

(7) The following processes (7-1) to (7-6) are executed to create a journal entry work table (a source of payment journal data).

(7-1) Clear the journal entry work table.

(7-2) Data on the amount of debt and cash according to the following conditions using the journal entry specification data table after processing (6) and the transfer request creation data table after processing (5), etc. (See FIG. 22).
<Joining condition>
Journal item data table. Analysis customization CD3 = Transfer request creation work table. Transfer system NO1
Journal item data table. Analysis customization CD4 = Transfer request creation work table. Transfer system NO2
<Total condition>
Transfer System No. 1> Transfer System No. 2> Office CD> Division CD> Account CD> Breakdown CD> Customer CD> Tax Classification> Tax Classification> Tax Classification> Analysis CD1> Analysis CD2> Analysis CD3> Analysis CD4> Analysis CD5> New CD> Project CD
<Creating example>
Debt 1,000 / Cash 1,000

(7-3) Using the transfer request creation data table after the process (5), etc., create data on the amount of debt and fee according to the following conditions (see FIG. 23).
<Extraction conditions>
Transfer request creation worktable. Destination tax fee <> 0
(※ Consider consumption tax on fee)
<Creating example>
Debt 50 / Fee 50

(7-4) The fee portion created in the process (7-3) is subtracted from the debt and cash created in the process (7-2).
<Example before subtraction>
Debt 1,000 / Cash 1,000 (created by processing ※ (7-2))
Debt 50 / Fee 50 (※ Created by processing (7-3))
<Example after subtraction>
Debt 950 / Cash 950
Debt 50 / Fee 50

(7-5) The row numbers in the journal entry work table are updated under the following conditions.
<Condition>
System Number> Business Partner> Row Number ROW_NUMBER

(7-6) INSERT the data in the journal entry specification work table into the actual data table (corresponding to payment journal data).

Then, when the operator selects the radio button of "FB data creation" on the transfer request data creation screen (see FIG. 7) and presses the function key F10, the control unit 102 displays an FB data creation screen (payment journal creation In the check box of the classification, the check is set on the monitor 114 as an initial state (see FIG. 9).
Then, the operator (here, it is assumed that this operator wants to create a payment journal together with the FB data), on the FB data creation screen, the settlement account CD, the storage destination folder path, and the file name Set (check the check box for specifying "add line feed code to record break" if necessary, or specify "end of file code (EOF) at end of file") When the function key F10 is pressed, the FB data creation unit 102b of the control unit 102 sets the file name set based on the transfer data created in the above processing. Create FB data (text format), create FB data, and pay end created in the above process The data, and outputs the data to the set folder.

[5. Summary of Embodiments and Other Embodiments]
As described above, according to the present embodiment, using the original journal data, the amount of credit related to the combination of the payee and the date of payment is added, and the amount obtained by the addition is used to cope with the combination. On the basis of the created transfer data, etc., data on FB data, data on the due date schedule by transfer source, and data on the transfer list (by bank) are created under the instruction of the operator. The creation of FB data is performed using transfer data and the like originating from the original journal data. The preparation of data concerning the due date schedule by transfer source uses various data (banks and accounts used by payment source and payee using payment data originating from the original journal data and data set on the schedule output screen). This is done with reference to the master that has stored the data. The data on the transfer list (by bank) is created using various types of masters (banks and accounts used by payment source and payee using transfer data originating from the original journal data and data set on the list output screen. Is performed with reference to the master etc. which stored the data regarding. In this way, it is only necessary to perform journal entry and create FB data as linkage data to an external system (for example, FB system etc.) and check forms for payment amount (due schedule by transfer source and transfer list (bank Can be output, and work efficiency can be improved.

Further, according to the present embodiment, the information processing (A) to (C) below is executed in an arbitrary order to create payment journal data. This makes it possible to create payment journal data as linkage data to an external system (for example, a financial accounting system).
(A) As data relating to the debit items and amount of payment journal data, data relating to the item of credit stored in the source data and the amount obtained by addition is set.
(B) As data relating to credit items and amount of payment journal data, data relating to the amount of money based on the account type stored in the master and the amount obtained by addition is set.
(C) As data relating to the date of occurrence of the payment journal data, data relating to the date of payment stored in the source journal data is set.

  Further, according to the present embodiment, when the original journal data is input, if the date of occurrence and the payee are set on the journal entry screen, the payment condition for specifying the date of payment and the payee are specified. With reference to the payment conditions of the master in which the data is stored, the payment date is calculated with the date of occurrence as the start date. Thereby, the trouble of the input of the payment date by an operator can be saved.

  Furthermore, although the embodiments of the present invention have been described above, the present invention can be practiced in various different embodiments within the scope of the technical idea described in the claims besides the above-described embodiments. It is good.

  For example, among the processes described in the above-described embodiment, all or part of the process described as being automatically performed may be manually performed, or the process described as being manually performed. All or part of can be performed automatically by known methods.

  In addition, information including the processing procedures, control procedures, specific names, registered data of each processing, parameters such as search conditions shown in the above documents and drawings, screen examples, and database configurations are not described otherwise. Can be changed arbitrarily.

  Further, with regard to the PC 100, each component shown in the drawings is functionally conceptual, and does not necessarily have to be physically configured as shown.

  For example, all or any part of the processing functions of the devices constituting the PC 100, in particular the processing functions performed by the control unit, are realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is stored in a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment, and the program may be stored in each apparatus as necessary. It is read mechanically. 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). The computer program is executed by being loaded into the RAM, and cooperates with the CPU to configure the control unit.

  Also, this computer program may be stored in an application program server connected to the PC 100 via an arbitrary network, and it is also possible to download all or part of it as needed.

  Further, the program for executing the processing described in the present embodiment may be stored in a non-temporary computer readable recording medium, or may be configured as a program product. Here, the "recording medium" means 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), and an EEPROM (registration). Trademarks (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Blu-ray (registered trademark) Disc etc. Any "portable physical media It is intended to include.

  The “program” is a data processing method described in any language or description method, and may be in any format such as source code or binary code. Note that the “program” is not necessarily limited to one that is configured in a single way, and achieves its function in cooperation with a separate program represented by a plurality of modules or libraries or a separate program represented by the OS. Including things. In addition, as a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like, a known configuration and procedure can be used.

  The various databases stored in the storage unit are storage devices such as RAM, memory devices such as ROM, fixed disk devices such as hard disks, flexible disks, optical disks, etc. Stores programs, tables, databases, files for web pages, etc.

  Further, the PC 100 may be configured as an information processing apparatus such as a known personal computer or a work station, or may be configured as the information processing apparatus to which any peripheral device is connected. Also, the PC 100 may be realized by mounting software (including a program or data) that causes the PC 100 to realize the processing described in the present embodiment.

  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 may be functionally or physically in any unit in accordance with various additions or according to functional load. It can be distributed and integrated. That is, the embodiments described above may be implemented in any combination, and the embodiments may be implemented selectively.

  The invention is particularly useful in the field of accounting.

100 pcs
102 control unit 102a journal management unit 102b transfer data creation unit 102c FB data creation unit 102d payment journal creation unit 102e form creation unit 104 communication interface unit 106 storage unit 106a original journal data storage unit 106b transfer data storage unit 106c FB data storage unit 106d Payment journal data storage unit 106e Form data storage unit 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (4)

An information processing apparatus including a control unit,
The control unit
When the date of occurrence and the payee are designated, the designated date of occurrence is taken as the start date with reference to payment conditions for specifying the date of payment and predetermined payee data regarding the payee. Calculating means for calculating the payment date
An original journal in which a plurality of data relating to the account corresponding to the payee, the item name and amount of the debit, the item name and amount of the credit, the payee, and the date of payment calculated by the calculating means are stored. data using, by adding the amount of credit related to the combination of the payee and payment date, using the amount obtained in the adding, a firm banking data corresponding to the combination, the specified An FB creating means for creating an account corresponding to the payee and data on the date of payment in the original journal data ;
Using the specified data on the payment source, the payment date, the payee, and the occurrence date of the journal entry and the above-mentioned journal entry data, the predetermined bank data on the bank and account used by the payment source and the payee Referring to correspond to a payment source bank and account, payee, the first form to amounts recorded, data relating to the payment date of the bank and account and said in the original journal data corresponding to the supporting払先is stored First form creation means for creating data;
The payment source, payment date, and using and the original journal data with the specified data on the bank corresponding to the payment source, referring to the bank data, payee, amount paid, the transfer amount, supported払先A second form creation means for creating second form data in which data relating to the date of payment in the bank and account corresponding to and the original journal data is stored;
Having
An information processing apparatus characterized by The control unit
The payment journal entry corresponding to the combination, in which data on debit items and amounts, credit items and amounts, and date of occurrence are stored by executing the following information processes (A) to (C) in an arbitrary order: Further comprising payment journalizing means for generating data;
(A) As data relating to the item and amount of the debit of the payment journal data, data relating to the item of the credit stored in the original journal data and the amount of money obtained by the addition is set:
(B) As data relating to a credit item and amount of the payment journal data, data relating to an account type stored in the bank data and an amount based on the amount obtained by the addition is set:
(C) As data relating to the date of occurrence of the payment journal data, data relating to the date of payment stored in the source journal data is set:
The information processing apparatus according to claim 1, characterized in that Computer,
When the date of occurrence and the payee are designated, the designated date of occurrence is taken as the start date with reference to payment conditions for specifying the date of payment and predetermined payee data regarding the payee. Calculation means for calculating the payment date
An original journal in which a plurality of data relating to the account corresponding to the payee, the item name and amount of the debit, the item name and amount of the credit, the payee, and the date of payment calculated by the calculating means are stored. data using, by adding the amount of credit related to the combination of the payee and payment date, using the amount obtained in the adding, a firm banking data corresponding to the combination, the specified FB creating means for creating an account corresponding to the payee and data on the date of payment in the original journal data ,
Using the specified data on the payment source, the payment date, the payee, and the occurrence date of the journal entry and the above-mentioned journal entry data, the predetermined bank data on the bank and account used by the payment source and the payee Referring to correspond to a payment source bank and account, payee, the first form to amounts recorded, data relating to the payment date of the bank and account and said in the original journal data corresponding to the supporting払先is stored First form creation means to create data,
The payment source, payment date, and using and the original journal data with the specified data on the bank corresponding to the payment source, referring to the bank data, payee, amount paid, the transfer amount, supported払先A second form creation means for creating second form data in which data relating to the date of payment in the bank and account corresponding to the above and the original journal data is stored;
Program to function as. An information processing method executed by an information processing apparatus including a control unit, the information processing method comprising:
The control unit
When the date of occurrence and the payee are designated, the designated date of occurrence is taken as the start date with reference to payment conditions for specifying the date of payment and predetermined payee data regarding the payee. A calculation step of calculating the payment date
Specified data on payment source, payment date, payee, and occurrence date of journal entry, debit item name and amount, credit item name and amount, payee, and payment calculated in the above calculation step Bank and account corresponding to the payment source by referring to predetermined bank data on the bank and account used by the payment source and the payee using the original journal data in which the data on the date and time are stored in plurals, amounts recorded, a first form creation step of creating a first form data data is stored relating to the payment date of the bank and account and said in the original journal data corresponding to the supporting払先,
The payment source, payment date, and using and the original journal data with the specified data on the bank corresponding to the payment source, referring to the bank data, payee, amount paid, the transfer amount, supported払先And a second form creation step of creating a second form data storing data relating to the date of payment in the bank and account corresponding to and the original journal data, and in any order;
Using the data specified for the account corresponding to the payee and the original journal data, the credit amount related to the combination of the payee and the payment date is added, and using the amount obtained by the addition And executing the FB creating step of creating firm banking data corresponding to the combination, the account corresponding to the designated payee and the data on the payment date in the original journal data stored therein. To do,
An information processing method characterized by

Images