Sales processing device, sales processing method, and sales processing program
The patent addresses the challenge of processing internal transactions by automating the sales and internal transactions, and the sales processing device and method simplify the process of internal transactions, reducing the workload on staff by automating the creation of sales and internal transaction data for factories, head offices, and branches.
Patent Information
- Application Number
- JP2023007627
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2023-01-20
- Publication Date
- 2025-12-09
- Estimated Expiration
- 2043-01-20
AI Technical Summary
Existing systems fail to efficiently process internal transactions when goods are shipped directly from a factory to a customer under head office/branch accounting, placing a heavy workload on staff.
A sales processing device and method that includes a control unit to access warehouse and head office/branch account masters, automatically generating sales and internal transaction data based on input operations, reducing the burden on staff by simplifying the recording process.
Enables easy processing of internal transactions without burdening the person in charge, by automating the creation of sales and internal transaction data for factories, head offices, and branches.
Smart Images

Figure 0007783206000001 
Figure 0007783206000002 
Figure 0007783206000003
Abstract
Description
[Technical Field]
[0001] The present invention relates to a sales processing device, a sales processing method, and a sales processing program. [Background technology]
[0002] For example, some companies adopt head office / branch accounting. When head office / branch accounting is adopted, the actual movement of goods differs from the financial occurrence, so when goods are shipped directly from a factory to a customer, in order to match the financial occurrence, it is necessary to carry out virtual movement processing from the factory to the branch office once and create internal trading data, which places a heavy workload on the person in charge. Conventionally, there is a system for creating internal trading data, for example, as disclosed in Patent Document 1. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Japanese Patent Publication No. 2020-160823 Summary of the Invention [Problem to be solved by the invention]
[0004] However, Patent Document 1 does not describe at all how to easily and without burdening the person in charge process sales for internal transactions when products are shipped directly from the factory to the customer when head office / branch accounting is adopted.
[0005] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a sales processing device, a sales processing method, and a sales processing program that can easily process sales of internal transactions when products are shipped directly from a factory to a customer without placing a burden on the person in charge when head office / branch accounting is adopted. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides a sales processing device that includes a control unit and processes sales for a company that adopts a head office / branch account system and a centralized accounting system, wherein the control unit is configured to be able to access a warehouse master that associates and registers warehouse identification information for identifying a warehouse with business establishment identification information for identifying the warehouse, and a head office / branch account master that associates and registers business establishment identification information with a head office / branch account classification indicating a head office, branch office, or factory, and is characterized in that the control unit is configured to access a sales processing device that acquires a head office / branch account classification from the head office / branch account master using the business establishment identification information of the business establishment that will record the sales, entered as a key, in response to input operations by an operator on a sales input screen, and acquires business establishment identification information from the warehouse master using the entered warehouse identification information of the warehouse that will ship to a customer as a key, and acquires a head office / branch account classification from the head office / branch account master using the acquired business establishment identification information as a key, and when the acquired head office / branch account classification is a "factory," automatically generates sales data for the branch office, as well as internal transaction data between the factory and the head office and between the head office and the branch office, based on the input contents of the sales input screen.
[0007] According to another aspect of the present invention, the sales processing means may create only sales data when the acquired head office / branch office classification is other than "branch office" and "factory."
[0008] According to one aspect of the present invention, the sales data may be composed of a sales header including a sales number, business establishment identification information, warehouse identification information, customer identification information, sales date, shipping date, and an accounting pattern classification indicating normal or internal sales, and sales details including a sales number, line number, product identification information, quantity, unit sales price, sales amount, unit cost price, and cost amount.
[0009] In addition, according to one aspect of the present invention, the internal trading data may be composed of an internal trading header including an internal trading number, source business establishment identification information, source warehouse identification information, destination business establishment identification information, destination warehouse identification information, and sales number, and internal trading details including the internal trading number, row number, product identification information, quantity, cost unit price, and cost amount.
[0010] In addition, according to one aspect of the present invention, the control unit is configured to be able to access a journal entry definition table that registers journal entry patterns including debit items, debit business locations, credit items, credit business locations, and amount types for each regular sales or internal transaction, and may be equipped with a journal entry processing means that references the journal entry definition table based on the sales data and internal transaction data to create journal entry data for factories, head offices, and branches.
[0011] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides a sales processing method executed by an information processing device having a control unit, wherein the control unit is configured to be able to access a warehouse master in which warehouse identification information for identifying a warehouse and business establishment identification information for identifying the business establishment at the warehouse are associated and registered, and a head office / branch office master in which the business establishment identification information is associated and registered with a head office / branch office classification indicating a head office, branch office, or factory, and the control unit executes a sales processing step of: acquiring a head office / branch office classification from the head office / branch office master using the business establishment identification information of the business establishment that will record the sales as a key, input in response to an operator's input operation on a sales input screen; if the acquired head office / branch office classification is "branch office" and the input warehouse identification information of the warehouse that will ship to the customer is used as a key, acquiring a head office / branch office classification from the head office / branch office master using the acquired business establishment identification information as a key; and if the acquired head office / branch office classification is "factory," automatically generating sales data for the branch office, as well as internal transaction data between the factory and the head office and between the head office and the branch office, based on the input contents on the sales input screen.
[0012] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides a sales processing program to be executed by an information processing device having a control unit, the control unit being configured to be able to access a warehouse master in which warehouse identification information for identifying a warehouse and business establishment identification information for identifying the business establishment at the warehouse are associated and registered, and a head office / branch office master in which the business establishment identification information is associated and registered with a head office / branch office classification indicating a head office, branch office, or factory, the control unit, in response to input operations by an operator on a sales input screen, obtains a head office / branch office classification from the head office / branch office master using the business establishment identification information of the business establishment that will record the sales as a key, and if the obtained head office / branch office classification is "branch office," obtains business establishment identification information from the warehouse master using the input warehouse identification information of the warehouse that will ship to the customer as a key, obtains a head office / branch office classification from the head office / branch office master using the obtained business establishment identification information as a key, and if the obtained head office / branch office classification is "factory," the sales processing program is characterized in that it executes a sales processing step of automatically generating sales data for the branch office, as well as internal sales data between the factory and the head office and between the head office and the branch office, based on the input contents of the sales input screen. [Effects of the Invention]
[0013] According to the present invention, when head office / branch accounting is adopted, it is possible to easily process sales for internal transactions when goods are shipped directly from a factory to a customer without placing a burden on the person in charge. [Brief explanation of the drawings]
[0014] [Figure 1] Figure 1 is a diagram for explaining conventional (normal) sales processing when head office / branch accounting is adopted. [Figure 2] FIG. 2 is a diagram for explaining the sales processing of the present invention when head office / branch office accounting is adopted. [Figure 3] FIG. 3 is a block diagram showing an example of the configuration of the sales processing device according to this embodiment. [Figure 4] FIG. 4 is a diagram illustrating an example of the configuration of the establishment master. [Figure 5]FIG. 5 is a diagram illustrating an example of the configuration of the warehouse master. [Figure 6] FIG. 6 is a diagram illustrating an example of the configuration of the head office / branch office master. [Figure 7] FIG. 7 is a diagram illustrating an example of the configuration of the unit price master. [Figure 8] FIG. 8 is a diagram illustrating an example of the configuration of the journal definition master. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the processing performed by the control unit of the sales processing device according to the present embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the processing performed by the control unit of the sales processing device according to the present embodiment. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the processing performed by the control unit of the sales processing device according to the present embodiment. [Figure 12] FIG. 12 is a diagram for explaining a specific example of the processing performed by the control unit of the sales processing device according to the present embodiment. [Figure 13] FIG. 13 is a diagram for explaining a specific example of the processing performed by the control unit of the sales processing device according to the present embodiment. [Figure 14] FIG. 14 is a diagram for explaining a specific example of the processing performed by the control unit of the sales processing device according to the present embodiment. [Figure 15] FIG. 15 is a diagram for explaining a specific example of the processing performed by the control unit of the sales processing device according to the present embodiment. [Figure 16] FIG. 16 is a diagram for explaining a specific example of the processing performed by the control unit of the sales processing device according to the present embodiment. [Figure 17] FIG. 17 is a diagram for explaining a specific example of the processing performed by the control unit of the sales processing device according to the present embodiment. DETAILED DESCRIPTION OF THE INVENTION
[0015] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this embodiment.
[0016] [1. Overview] For example, some companies adopt head office / branch accounting and headquarters centralization systems. "Head office / branch accounting" is an accounting system used when a company has branches in addition to its headquarters. In companies with multiple branches, transactions occur between the head office and branches, and this system is used to process these internal transactions. With head office / branch accounting, branches are made to operate on an independent accounting system, and the headquarters and branches are treated as separate companies. The headquarters uses branch accounts and the branches use head office accounts, and each calculates its own profit and loss, making it possible to clearly show the profit and loss of each branch. Head office / branch accounting is useful when branches handle everything from manufacturing to sales.
[0017] The "headquarters centralized accounting system" is a system in which the head office records all transactions between branches in its books, and its characteristic is that even transactions between branches that do not actually go through the head office are accounted for as if they went through the head office. The advantage is that all transactions between branches can be tracked, but it makes the head office's bookkeeping work cumbersome.
[0018] When branch and head office accounting is adopted, the actual movement of goods differs from the financial occurrence, so when goods are shipped directly from the factory to a customer, a virtual transfer process must be carried out from the factory to the branch office in order to match the financial occurrence, which places a heavy workload (input) on the staff.
[0019] Therefore, in this embodiment, when head office / branch accounting is adopted, a system is proposed that can easily process sales for internal transactions when goods are shipped directly from the factory to customers without placing a burden on the person in charge.
[0020] Figure 1 is a diagram for explaining conventional (normal) sales processing when head office / branch accounting is adopted. In the diagram, (A) is a diagram for explaining the flow of goods and sales, (B) is a diagram showing an example of accounting entries at the factory (internal sales), (C) is a diagram showing an example of accounting entries at the head office (internal sales), (D) is a diagram showing an example of accounting entries at the branch office (internal sales), and (E) is a diagram showing an example of accounting entries at the branch office (normal sales).
[0021] When inventory is transferred from the factory to the branch, sales between departments occur. In this case, when goods are directly sent from the factory to the customer, transfer processing, shipping processing, and sales processing are required for internal sales, and branch inventory is virtually created, and sales processing is required after the above transfer is carried out, which increases the input burden and effort for the staff.
[0022] Figure 2 is a diagram for explaining the sales processing of the present invention when head office / branch accounting is adopted. In the figure, (A) is a diagram for explaining the flow of goods and sales, (B) is a diagram showing an example of accounting entries at the factory (internal sales), (C) is a diagram showing an example of accounting entries at the head office (internal sales), and (D) is a diagram showing an example of accounting entries at the branch office (internal sales and regular sales).
[0023] In this invention, when goods are directly shipped from a factory to a customer, the internal transaction can be recorded by just processing the sales. In this case, the sales are processed from the branch to the customer, but the internal transaction between the factory and the branch can be recorded virtually. In addition, the person in charge of recording the sales can simply enter the sales according to the actual situation, without having to worry about the head office or branch office.
[0024] The present invention can be widely applied to, for example, manufacturers in general who have multiple factories and branches and who conduct head office and branch office accounting.
[0025] [2. Configuration] An example of the configuration of the sales processing device 100 according to this embodiment will be described with reference to Fig. 3. Fig. 3 is a block diagram showing an example of the configuration of the sales processing device 100.
[0026] The sales processing device 100 is a commercially available desktop personal computer. Note that the sales processing device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.
[0027] The sales processing device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. The units comprised in the sales processing device 100 are connected to each other so as to be able to communicate with each other via any communication path.
[0028] The communication interface unit 104 communicatively connects the sales processing 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 communicatively connecting the sales processing device 100 and the server 200, and is, for example, the Internet or a LAN (Local Area Network).
[0029] 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 touch panel), 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 achieve a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112. Furthermore, "output" refers to outputting by the output device 114, and includes, for example, display output to the monitor 114, print output by the printer 114, and sending data to the outside.
[0030] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.
[0031] The storage unit 106 stores an establishment master 106a, a warehouse master 106b, a head office / branch office master 106c, a unit price master 106d, a journal definition master 106e, sales data 106f, in-house trading data 106g, a journal table 106h, and the like.
[0032] Fig. 4 is a diagram showing an example of the configuration of the business establishment master 106a. Fig. 5 is a diagram showing an example of the configuration of the warehouse master 106b. Fig. 6 is a diagram showing an example of the configuration of the head office / branch office master 106c. Fig. 7 is a diagram showing an example of the configuration of the unit price master 106d. Fig. 8 is a diagram showing an example of the configuration of the journal entry definition master 106e.
[0033] As shown in Figure 4, the business establishment master 106a can be configured as a table in which business establishment codes and business establishment names are registered in association with each other. The control unit 102 references the business establishment master 106a when converting the business establishment code and business establishment name. The business establishment code and / or business establishment name are referred to as business establishment identification information for identifying the business establishment. In the example shown in the figure, the first line has the business establishment code "T001" and the business establishment name "Head Office."
[0034] The warehouse master 106b can be configured as a table or the like in which warehouse codes, warehouse names, and the business establishment codes of the business establishments to which the warehouses belong are registered in association with each other, as shown in Fig. 5. The warehouse master 106b is referenced by the control unit 102 when converting warehouse codes and warehouse names. The warehouse code and / or warehouse name are referred to as warehouse identification information for identifying the warehouse. In the example shown in the figure, the first line has the warehouse code "K0011", the warehouse name "Head Office Warehouse", and the business establishment code "T001".
[0035] The head office / branch office master 106c can be configured as a table in which business establishment codes and head office / branch office classifications are registered in association with each other, as shown in Fig. 6. The head office / branch office classifications are "0: Head Office," "1: Branch Office," and "2: Factory." In the example shown in the figure, the first line contains the business establishment code "T001" and the head office / branch office classification "0."
[0036] As shown in FIG. 7, the unit price master 106d can be configured as a table or the like in which product codes, standard unit costs that are the unit costs of the head office, factory unit costs that are the unit costs of the factory, and unit sales prices are associated and registered. The product code and / or product name are referred to as product identification information for identifying the product. In the example shown in the same figure, the first line contains the product code "S001," the standard unit cost "180," the factory unit cost "150," and the unit sales price "220." Note that the storage unit 106 stores a product master (not shown) in which product codes and product names are associated and registered, and this is referenced by the control unit 102 when converting product codes and product names.
[0037] The journal entry definition master 106e is a master that sets the journal entry pattern to be used for each sales data or internal transaction data, and can be composed of a table, etc., that associates and registers data type (sales data or internal transaction data), debit item, debit business establishment, credit item, credit business establishment, amount type, accounting date, and condition value, as shown in Figure 8.
[0038] In the example shown in the figure, the first line has the data type "Sales," the debit item "Accounts Receivable," the debit location "Location," the credit item "Sales," the credit location "Location," the amount "Sales Amount," the accounting date "Sales Date," and the condition value "All." The second line has the data type "Internal Sales," the debit item "Head Office / Branch," the debit location "Destination Location," the credit item "Internal Sales," the credit location "Source Location," the amount "Cost Amount," the accounting date "Transfer Date," and the condition value "Source Location = Head Office or Factory." The third line has the data type "Internal Sales," the debit item "Internal Purchases," the debit location "Destination Location," the credit account "Head Office / Branch," the credit location "Source Location," the amount "Cost Amount," the accounting date "Transfer Date," and the condition value "Source Location = Head Office or Branch."
[0039] Sales data 106f consists of a sales header and sales details. The sales header may include a sales number, business code, warehouse code, customer code, sales date, shipping date, and accounting pattern classification (0: normal, 1: internal sales). The sales details may include a sales number, line number, product code, quantity, sales price, sales amount, cost price, and cost amount.
[0040] The internal trading data 106g consists of an internal trading header and internal trading details. The internal trading header may include the internal trading number, source business code, source warehouse code, destination business code, destination warehouse code, and sales number (linked slip number). The internal trading details may include the internal trading number, line number, product code, quantity, cost unit price, and cost amount.
[0041] The journal table 106h stores journal data. The journal data may include a journal number, a posting date, an original document number (sales number or internal transaction number), an amount, a debit account, a debit business, a credit account, and a credit business.
[0042] Returning to Figure 3, the control unit 102 is a CPU or the like that performs overall control of the sales processing device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.
[0043] The control unit 102 is configured to be able to access the business establishment master 106a, warehouse master 106b, head office / branch office master 106c, unit price master 106d, journal entry definition master 106e, sales data 106f, internal trading data 106g, journal entry table 106h, etc., stored in the storage unit 106. Note that the business establishment master 106a, warehouse master 106b, head office / branch office master 106c, unit price master 106d, journal entry definition master 106e, sales data 106f, internal trading data 106g, journal entry table 106h, etc. may be provided in another location (for example, server 200) as long as the control unit 102 is able to access them.
[0044] The control unit 102 conceptually includes a sales processing unit 102a, an accounting processing unit 102b, a master maintenance unit 102c, and a screen display control unit 102d.
[0045] For example, in response to input operations by an operator on the sales input screen displayed on the monitor 114, the sales processing unit 102a acquires the head office / branch office classification from the head office / branch office master 106c using the business establishment identification information of the business establishment that will record the sales as a key, and if the acquired head office / branch office classification is "branch office" and the input warehouse identification information of the warehouse that will ship to the customer as a key, acquires the head office / branch office classification from the head office / branch office master 106c using the acquired business establishment identification information as a key, and if the acquired head office / branch office classification is "factory," generates sales data for the branch office as well as internal sales data between the factory and the head office and between the head office and the branch office in accordance with the input on the sales input screen, and stores the data in the memory unit 106.
[0046] The sales processing unit 102a may create only sales data if the acquired head office / branch office classification is neither "branch office" nor "factory."
[0047] In this case, the sales data may consist of a sales header including the sales number, business establishment identification information, warehouse identification information, customer identification information, sales date, shipping date, and accounting pattern classification indicating normal or internal sales, and sales details including the sales number, line number, product identification information, quantity, unit sales price, sales amount, unit cost price, and cost amount.
[0048] In addition, the internal trading data may be composed of an internal trading header including the internal trading number, the business establishment identification information of the source of the transfer, the warehouse identification information of the source of the transfer, the business establishment identification information of the destination of the transfer, the warehouse identification information of the destination of the transfer, and the sales number, and internal trading details including the internal trading number, row number, product identification information, quantity, cost price, and cost amount.
[0049] The journalizing processor 102b creates journalizing data for factories, head offices, and branches based on the sales data and intra-company transaction data, and registers the data in the journalizing table, with reference to the journalizing definition master 106e.
[0050] The master maintenance unit 102c performs editing such as inputting, adding, and changing data in the business establishment master 106a, warehouse master 106b, head office / branch office master 106c, unit price master 106d, and journal entry definition master 106e in response to operator operations on a master maintenance screen (not shown) displayed on the monitor 114.
[0051] The screen display control unit 102d controls the display of various screens (for example, a sales input screen, a master maintenance screen, etc.) displayed on the monitor 114 and the inputs thereto.
[0052] [3. Specific Examples] A specific example of the processing by the control unit 102 of the sales processing device 100 in this embodiment will be described with reference to Figures 3 to 17. Figures 8 to 17 are diagrams showing sample data for explaining a specific example of the processing by the control unit of the sales processing device 100 in this embodiment. The following explanation will be given using data examples of the business establishment master 106a, warehouse master 106b, head office / branch office master 106c, unit price master 106d, and journal entry definition master 106e in Figures 4 to 8.
[0053] Specific examples of the sales processing executed by the sales processing section 102a and the journal entry creation processing executed by the journal entry processing section 102b will be described with reference to FIGS.
[0054] The sales processing unit 102a executes sales processing, and, for example, in response to input operations by an operator on the sales input screen displayed on the monitor 114, acquires the head office / branch office classification from the head office / branch office master 106c using the business establishment identification information of the business establishment that will record the sales as a key, and if the acquired head office / branch office classification is "branch office" and the input warehouse identification information of the warehouse that will ship to the customer as a key, acquires the head office / branch office classification from the head office / branch office master 106c using the acquired business establishment identification information as a key, and if the acquired head office / branch office classification is "factory," generates sales data for the branch office as well as internal sales data between the factory and the head office and between the head office and the branch office according to the input on the sales input screen, and stores the data in the memory unit 106.
[0055] The journal entry processing unit 102b executes the journal entry creation process, and based on the sales data and the internal transaction data, creates journal entry data for the factory, head office, and branch offices by referring to the journal entry definition master 106e, and registers the data in the journal entry table. It also outputs the accrual journal entries for the factory, head office, and branch offices based on the created journal entry data.
[0056] (Internal trading decision flow) First, the flow of determining whether a transaction is an in-house transaction in the sales process will be described with reference to Fig. 9. Fig. 9 is a diagram showing a display example of a sales input screen 500.
[0057] As shown in FIG. 9, the sales input screen 500 includes a slip information input area 501 for inputting slip information, a detail information input area 502 for inputting detail information, and a registration button (not shown).
[0058] The detailed information input area 501 has fields for inputting the establishment code of the establishment where the sales are recorded, the warehouse code of the warehouse where the merchandise is shipped to the customer, the customer code, the sales date, and the shipping date.
[0059] The detailed information input area 502 has fields for inputting the product code, quantity, sales price, sales amount, standard cost unit price, and cost amount. The sales price and standard cost unit price are obtained from the unit price master 106d using the input product code as a key and are automatically displayed (input). The sales amount is automatically calculated by multiplying the sales price by the input quantity and is automatically displayed (input). The cost amount is automatically calculated by multiplying the standard cost unit price by the input quantity and is automatically displayed (input).
[0060] The operator enters the necessary data on the sales input screen and presses the registration button (not shown), which automatically creates sales data and internal sales data (if the following conditions are met) according to the input on the sales input screen. This allows the operator to simply enter sales without having to worry about the head office, reducing the burden on the operator.
[0061] (1) Using the business establishment code that records the sales in the slip information as a key, the head office / branch office classification is acquired from the head office / branch office master 106c. (2) Using the warehouse code from which the product is shipped on the slip information as a key, the establishment code is acquired from the warehouse master 106b, and using the acquired establishment code as a key, the head office / branch office classification is acquired from the head office / branch office master 106c. (3) Determine the combination of head office / branch office classifications obtained in (1) and (2) to determine whether or not internal trading data is to be created. If the head office / branch office classification of the sales office in (1) is "1: Branch" and the head office / branch office classification of the shipping warehouse in (2) is "2: Factory", internal trading data is created. In all other cases, internal trading data is not created. In other words, if the head office / branch office is to be created as a voucher, a voucher (internal trading data) is created to carry out an internal transaction from the factory to the head office, and then from the head office to the branch office when the voucher is registered.
[0062] (Factory direct sales: direct shipment from the factory warehouse to the customer) The case of direct factory sales will be described with reference to Figures 10 to 15. Figure 10 is a diagram showing a display example of a sales input screen 500. Figure 11 is a diagram showing an example of sales data and intra-company buying and selling data to be created.
[0063] In the example display of the sales input screen 500 shown in Figure 10, the business establishment code "T100: Tokyo Branch", warehouse code "K2011: Utsunomiya A Warehouse", sales date "2022 / 11 / 28", shipping date "2022 / 11 / 28", and customer code "4468: 4468 Mart" are entered in the slip information input area 501.
[0064] In addition, in the detail information input area 502, the product code "S001: Freshly baked croissant" and quantity "30" are entered, and the sales price "220", sales amount "6600", standard cost price "180", and cost amount "5400" are automatically displayed.
[0065] (1) Using the establishment code "T100" for which sales are to be recorded as a key, the head office / branch office classification "1: Branch office" is acquired from the head office / branch office master 106c. (2) Using the warehouse code "K2011" from which the goods are shipped as a key, the business establishment code "T201" is obtained from the warehouse master 106b, and using the obtained business establishment code "T201" as a key, the head office / branch office classification "2: Factory" is obtained from the head office / branch office master 106c. (3) Since the head office / branch division of the sales establishment in (1) is "1: Branch" and the head office / branch division of the shipping warehouse establishment in (2) is "2: Factory," this is treated as an internal transaction, and internal transaction data is created.
[0066] FIG. 11 shows an example of sales data and intra-company trading data created in the case of input contents on the sales input screen of FIG.
[0067] Figure 11 (A) shows an example of sales header data for sales data. The sales header has the following fields: sales number, business establishment code, warehouse code, customer code, sales date, shipping date, and accounting pattern classification (0: normal, 1: internal sales). The sales number is automatically assigned. The business establishment code is entered on the sales input screen. The warehouse code is entered on the sales input screen. The accounting pattern classification refers to the head office / branch office master 106c to obtain the head office / branch office classification for the business establishment / warehouse, and sets "1: internal sales" when the business establishment = "1: branch" and warehouse = "2: factory", and sets "0: normal" otherwise.
[0068] In the example shown in the figure, the sales number is "U000002", business code is "T100", warehouse code is "K2011", customer code is "4468", sales date is "2022 / 11 / 28", shipping date is "2022 / 11 / 28", and accounting pattern classification is "1: Internal sales".
[0069] Figure 11(B) shows an example of sales details data for sales data. The sales details include the following fields: sales number, row number, product code, quantity, unit sales price, sales amount, unit cost price, and cost amount. The unit cost price is set by obtaining the standard unit cost from the unit price master 106d using the product code as a key, and the cost amount is set by calculating cost amount = standard unit cost price x quantity. In the example shown in the figure, the first row contains sales number "U000002," row number "1," product code "S001," quantity "30," unit sales price "220," sales amount "6600," unit cost price "180," and cost amount "5400."
[0070] Figure 11 (C) shows an example of the data in the intra-company transaction header for intra-company transaction data. The intra-company transaction header has the following fields: intra-company transaction number, source business code, source warehouse code, destination business code, destination warehouse code, and sales number (linked slip number). The intra-company transaction number is automatically assigned. The linked slip number is the same as the sales number. For intra-company sales data, a first record for intra-company transactions with the source being the factory and the destination being the head office, and a second record for intra-company transactions with the source being the head office and the destination being the branch office are created.
[0071] In the example shown in the figure, the first line (first record) contains the internal transaction number "S00001," source business code "T201," source warehouse code "K2011," destination business code "T001," destination warehouse code "K0011," and sales number "U000002." The source business code in the first line is set by obtaining the business code from the warehouse master 106b using the source warehouse code as the key. The source warehouse code in the first line is set by the warehouse code on the sales input screen. The destination business code in the first line is set by the business code of the head office / branch office classification "0: Head Office" in the head office / branch office master 106c. The destination warehouse code in the first line is set by obtaining the warehouse code for the business office = head office from the warehouse master 106b.
[0072] The second line (second record) contains the internal transaction number "S00002", source business code "T001", source warehouse code "K0011", destination business code "T100", destination warehouse code "K1011", and sales number "U000002". The source business code on the second line is set to the destination business code on the first line. The source warehouse code on the second line is set to the destination warehouse code on the first line. The destination business code on the second line is set to the business code on the sales input screen. The destination warehouse code on the second line is set by retrieving the warehouse code from warehouse master 106b using the destination business code on the second line as the key.
[0073] Figure 11(D) is a diagram showing an example of data for an internal transaction statement. The internal transaction statement has fields for the internal transaction number, line number, product code, quantity, unit cost, and cost amount. The unit cost is set by obtaining the head office / branch office classification from the head office / branch office master data 106c using the source business establishment code in the internal transaction header as a key, and then obtaining and setting the factory unit cost or standard unit cost according to the obtained head office / branch office classification using the product code as a key. The cost amount is then calculated and set as follows: factory unit cost or standard unit cost x quantity. Specifically, if the source head office / branch office classification is "2: Factory," the factory unit cost is obtained from the unit price master data 106d, and cost amount = factory unit cost x quantity is calculated. If the source head office / branch office classification is "2: Head Office," the standard unit cost is obtained from the unit price master data 106d, and cost amount = standard unit cost x quantity is calculated.
[0074] In the example shown in the figure, the first line (first record) has the internal transaction number "S000001," line number "1," product code "S001," quantity "30," unit cost price "150," and cost amount "4500." Specifically, the system retrieves the head office / branch division "2: Factory" from the head office / branch master 106c using the source business office code "T201" in the internal transaction header as a key, retrieves the factory unit cost price "150" from the unit price master 106d using the product code "S001" as a key, sets this as the unit cost price, and then calculates and sets the cost amount = factory unit cost price "150" x quantity "30" = 4500.
[0075] The second line (second record) has the internal transaction number "S000002," line number "1," product code "S001," quantity "30," unit cost price "180," and cost amount "5400." Specifically, the system retrieves the head office / branch division "0: Head Office" from the head office / branch master 106c using the source office code "T001" in the internal transaction header as a key, retrieves the standard unit cost "180" from the unit price master 106d using the product code "S001" as a key, sets this as the unit cost price, and then calculates and sets the cost amount = standard unit cost price "180" x quantity "30" = 5400.
[0076] Figure 12 is a diagram for explaining the actual movement of goods and the financial movement of goods. In reality, goods are moved from the factory to the customer, but financially, in addition to sales data from the branch to the customer, internal sales data from the factory to the head office and from the head office to the branch is created.
[0077] The journalizing processing unit 102b creates journalizing data based on the sales data and the internal transaction data, referring to the journalizing patterns for sales data / internal transaction data in the journalizing definition master 106e, and registers the data in the journalizing table. Also, based on the journalizing data, it outputs the accrual journalization of the factories, headquarters, and branches.
[0078] FIG. 13 is a diagram for explaining the creation of journal data. In the figure, (A) shows an example of data for the sales header of the sales data, (B) shows an example of data for the sales details of the sales data, (C) shows an example of data for the internal trading header of the internal trading data, (D) shows an example of data for the internal trading details of the internal trading data, (E) shows an example of data from the journal definition master 106e, and (F) shows an example of data from the journal table. (A) to (D) are the same as in FIG. 11. (E) is the same as in FIG. 8. FIG. 14 is a diagram showing an example of accrual journal entries for factories, headquarters, and branches that are output based on the journal data in the journal table. Numbers are assigned between FIG. 13(F) and FIG. 14 to indicate the correspondence.
[0079] 13, as shown in (E), the journal entry definition master 106e has the following fields: data type (sales data or internal transaction data), debit account, debit establishment, credit account, credit establishment, amount, posting date, and condition value to be applied. The first line shows the journal entry pattern for sales data, and includes the data type "Sales," debit account "Accounts Receivable," debit establishment "Establishment," credit account "Sales," credit establishment "Establishment," amount "Sales Amount," posting date "Sales Date," and condition value "All."
[0080] The second line shows the accounting pattern when the source business location for internal sales data is the head office or a factory, with the data type "internal sales", debit account "head office / branch", debit business location "destination business location", credit account "internal sales", credit business location "source business location", amount "cost amount", accounting date "transfer date", and condition value "source business location = head office or factory".
[0081] The third line shows the accounting pattern when the source business location for internal transaction data is the head office or branch office, and includes the data type "Internal transaction", debit account "Internal purchases", debit business location "Destination business location", credit account "Head office / branch (head office or branch)", credit business location "Source business location", amount "Cost amount", accounting date "Transfer date", and condition value "Source business location = head office or branch office".
[0082] The journal data is created in the order of data types in the journal entry definition master 106e. As shown in (F), the journal data in the journal entry table has the following fields: journal entry number, posting date, original document number, amount, debit account, debit business, credit account, and credit business. The first row is created based on the sales data of (A) and (B) and by referencing the journal entry pattern of the first row of the journal entry definition master 106e of (E). The second row is created based on the internal trading data of the first row of (C) and (D) and by referencing the journal entry pattern of the second row of the journal entry definition master 106e of (E). The third row is created based on the internal trading data of the second row of (C) and (D) and by referencing the journal entry pattern of the second row of the journal entry definition master 106e of (E). The fourth row is created based on the internal trading data of the first row of (C) and (D) and by referencing the journal entry pattern of the third row of the journal entry definition master 106e of (E). The fifth line is created based on the internal trading data in the second line of (C) and (D) by referring to the journal entry pattern in the third line of the journal entry definition master 106e in (E).
[0083] Based on the journal entry data in the journal entry table (F), the journal entries for (A) the factory, (B) the head office, and (C) the branch office are output as shown in FIG.
[0084] (Normal sales: When processing sales from inventory in a branch warehouse) With reference to Figures 15 to 17, the case of processing inventory at a branch warehouse for sales will be described. Figure 15 is a diagram showing an example of the display of the sales input screen 500. Figure 16 is a diagram showing examples of sales data and journal data to be created. (A) shows example data of the sales header of the sales data, (B) shows example data of the sales details of the sales data, (E) shows example data of the journal entry definition master 106e, and (F) shows example data of the journal entry table. (F) is the same as Figure 8. Figure 17 is a diagram showing an example of branch accrual journal entry output based on the journal entry data in the journal entry table. Numbers are assigned between Figures 16(F) and 17 to indicate the correspondence.
[0085] In the example display of the sales input screen 500 shown in Figure 15, the business establishment code "T100: Tokyo Branch", warehouse code "K1011: Tokyo Branch Warehouse", sales date "2022 / 11 / 28", shipping date "2022 / 11 / 28", and customer code "4468: 4468 Mart" are entered in the slip information input area 501.
[0086] In addition, in the detail information input area 502, the product code "S001: Freshly baked croissant" and quantity "30" are entered, and the unit sales price "220", sales amount "6600", standard cost unit price "180", and cost amount "5400" are automatically displayed (entered).
[0087] (1) Using the establishment code "T100" for which sales are to be recorded as a key, the head office / branch office classification "1: Branch office" is acquired from the head office / branch office master 106c. (2) Using the warehouse code "K1011" from which the product is shipped as a key, the business establishment code "T100" is obtained from the warehouse master 106b, and using the obtained business establishment code "T100" as a key, the head office / branch office classification "1: Branch" is obtained from the head office / branch office master 106c. (3) (1) The head office / branch division of the sales office is "1: Branch" and the head office / branch division of the shipping warehouse office is "1: Branch", and the head office / branch division of the sales office is not "1: Branch" and the head office / branch division of the shipping warehouse office is not "2: Factory", so only sales data is created as normal sales and internal sales data is not created.
[0088] FIG. 16 shows an example of sales data and journal data created in the case of input contents on the sales input screen of FIG.
[0089] As shown in (A), the sales header of the sales data is sales number "U000001", business code "T100", warehouse code "K1011", customer code "4468", sales date "2022 / 11 / 28", shipping date "2022 / 11 / 28", and accounting pattern classification "0: Normal".
[0090] As shown in (B), the sales details of the sales data are sales number "U000001", row number "1", product code "S001", quantity "30", sales price "220", sales amount "6600", cost price "180", and cost amount "5400".
[0091] Since the accounting pattern classification is "0: Normal," no internal trading data is created, as shown in (C) and (D).
[0092] Based on the sales data (A) and (B), the journal entry pattern in the first row of the journal entry definition master 106e (E) is referenced, and the journal entry data shown in (F) is created and stored in the journal entry table. Based on the journal entry data in the journal entry table (F), the branch accrual journal entry shown in (C) of Figure 17 is output.
[0093] As described above, the system is provided with the warehouse master 106b in which warehouse identification information for identifying a warehouse and business establishment identification information for identifying the business establishment of the warehouse are registered in association with each other, the head office / branch office master 106c in which the business establishment identification information is registered in association with the head office / branch office classification indicating a head office, a branch office, or a factory, and the sales processing unit 102a which, in response to input operations by an operator on the sales input screen, acquires the head office / branch office classification from the head office / branch office master 106c using the business establishment identification information of the business establishment that will record the sales as a key, and when the acquired head office / branch office classification is "branch office" and the input warehouse identification information of the warehouse that will ship to the customer is used as a key, acquires the head office / branch office classification from the head office / branch office master 106c using the acquired business establishment identification information as a key, and when the acquired head office / branch office classification is "factory," automatically generates, based on the input contents of the sales input screen, sales data for the branch office as well as internal transaction data between the factory and the head office and between the head office and the branch office. Therefore, when head office / branch office accounting is adopted, it is possible to easily process sales for internal transactions when goods are shipped directly from the factory to the customer without placing a burden on the person in charge.
[0094] [4. 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 the achievement of SDGs Goals 8 and 9.
[0095] 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.
[0096] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.
[0097] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0098] 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.
[0099] Furthermore, 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 can be changed as desired unless otherwise specified.
[0100] Furthermore, with regard to the sales processing device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.
[0101] For example, all or any part of the processing functions of the sales processing device 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the sales processing device 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to issue instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM and cooperates with the CPU to form the control unit.
[0102] In addition, this computer program may be stored in an application program server connected to the sales processing device 100 via any network, and all or part of it may be downloaded as needed.
[0103] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "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.
[0104] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. 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, can use well-known configurations and procedures.
[0105] The various databases 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 used for various processes and providing websites.
[0106] Sales processing device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. Sales processing device 100 may also be realized by installing software (including programs or data) that causes the device to perform the processing described in this embodiment.
[0107] 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 configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]
[0108] 100 Sales Processing Device 102 Control section 102a Sales Processing Department 102b Journal entry processing section 102c Master Maintenance Department 102d Screen display control unit 104 Communication interface unit 106 Storage section 106a Business establishment master 106b Warehouse Master 106c Head Office / Branch Master 106d Unit Price Master 106e Journal entry definition master 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network
Claims
1. A sales processing device that includes a control unit and processes sales for a company that adopts head office / branch accounting, The control unit a warehouse master in which warehouse identification information for identifying a warehouse and business establishment identification information for identifying the business establishment of the warehouse are associated and registered; A head office / branch office master in which business establishment identification information and a head office / branch office classification indicating a head office, branch office, or factory are associated and registered; It is configured to be accessible to A sales processing device characterized by comprising a sales processing means for, in response to input operations by an operator on a sales input screen, acquiring a head office / branch office classification from the head office / branch office master using the business establishment identification information of the business establishment that will record the sales as a key, and if the acquired head office / branch office classification is "branch office", acquiring business establishment identification information from the warehouse master using the input warehouse identification information of the warehouse that will ship to the customer as a key, and acquiring a head office / branch office classification from the head office / branch office master using the acquired business establishment identification information as a key, and if the acquired head office / branch office classification is "factory", automatically generating sales data for the branch office as well as internal sales data between the factory and the head office and between the head office and the branch office based on the input contents on the sales input screen.
2. 2. The sales processing device according to claim 1, wherein said sales processing means creates only sales data when said acquired head office / branch office classification is other than "branch office" and "factory."
3. The sales processing device of claim 1, characterized in that the sales data consists of a sales header including a sales number, business establishment identification information, warehouse identification information, customer identification information, sales date, shipping date, and an accounting pattern classification indicating normal or internal sales, and sales details including a sales number, line number, product identification information, quantity, sales price, sales amount, cost price, and cost amount.
4. The sales processing device described in claim 1, characterized in that the internal sales data is composed of an internal sales header including an internal sales number, source business identification information, source warehouse identification information, destination business identification information, destination warehouse identification information, and sales number, and internal sales details including the internal sales number, row number, product identification information, quantity, cost unit price, and cost amount.
5. The control unit The system is configured to be able to access a journal entry definition table in which journal entry patterns including debit items, debit business locations, credit items, credit business locations, and amount types are registered for each normal sales or internal sales transaction, A sales processing device as described in any one of claims 1 to 4, characterized in that it is provided with a journal processing means that creates journal data for factories, head offices, and branches by referring to the journal definition table based on the sales data and internal trading data.
6. A sales processing method executed by an information processing device having a control unit, The control unit a warehouse master in which warehouse identification information for identifying a warehouse and business establishment identification information for identifying the business establishment of the warehouse are associated and registered; A head office / branch office master in which business establishment identification information and a head office / branch office classification indicating a head office, branch office, or factory are associated and registered; It is configured to be accessible to Executed in the control unit: A sales processing method characterized by including a sales processing step of: acquiring a head office / branch office classification from the head office / branch office master using the business establishment identification information of the business establishment that will record sales as a key, which is input in response to input operations by an operator on a sales input screen; if the acquired head office / branch office classification is "branch office," acquiring business establishment identification information from the warehouse master using the input warehouse identification information of the warehouse that will ship to the customer as a key; acquiring a head office / branch office classification from the head office / branch office master using the acquired business establishment identification information as a key; and if the acquired head office / branch office classification is "factory," automatically generating internal sales data between the factory and the head office and between the head office and the branch office, along with sales data for the branch office, based on the input contents on the sales input screen.
7. A sales processing program to be executed by an information processing device having a control unit, The control unit a warehouse master in which warehouse identification information for identifying a warehouse and business establishment identification information for identifying the business establishment of the warehouse are associated and registered; A head office / branch office master in which business establishment identification information and a head office / branch office classification indicating a head office, branch office, or factory are associated and registered; It is configured to be accessible to In the control unit, A sales processing program for executing a sales processing step in which, in response to input operations by an operator on a sales input screen, the head office / branch office classification is obtained from the head office / branch office master using the business establishment identification information of the business establishment that will record the sales as a key, and if the obtained head office / branch office classification is "branch," the business establishment identification information is obtained from the warehouse master using the input warehouse identification information of the warehouse that will ship to the customer as a key, and the head office / branch office classification is obtained from the head office / branch office master using the obtained business establishment identification information as a key, and if the obtained head office / branch office classification is "factory," then, based on the input contents on the sales input screen, the program automatically generates sales data for the branch office as well as internal sales data between the factory and head office and between the head office and the branch office.
Citation Information
Patent Citations
Inter-accounting-unit transfer classification division system, method, and program
JP2012123706A
Balance management device for each store, balance management method therefor, and balance management program therefor
JP2019175156A
Departmental profit / loss management apparatus, departmental profit / loss management method and departmental profit / loss management program
JP2020052693A
Journal creation device, journal creation program and journal creation method
JP2020160823A
Head / branch office journal input device, head / branch office journal input method, and head / branch office journal input program
JP2020194577A