JP2021152753A - Accounting data generation device, accounting data generation method, and accounting data generation program - Google Patents

Abstract

To provide an accounting data generation device, an accounting data generation method, and an accounting data generation program that can reduce the time and effort of obtaining accurate accounting data regarding goods scheduled to be stored into a storage location and retrieve from the storage location.SOLUTION: In an accounting data generation system 1000, an accounting data generation device 100 that generates accounting data regarding goods scheduled to be stored into a storage location and retrieved from the storage location includes a control unit. The control unit includes a storage/retrieval cost data generation unit that generates storage/retrieval cost data including storage/retrieval cost information regarding storage/retrieval cost incurred in connection with the storage/retrieval of the goods as one of the accounting data. The storage/retrieval cost is calculated based on storage/retrieval cost unit price information regarding storage/retrieval cost unit price which is a unit price for the storage/retrieval cost and for which either a fixed multiplication rate unit price or a fixed amount unit price that can be set for each storage and for each retrieval of the goods is set and storage/retrieval record data including storage/retrieval quantity information.SELECTED DRAWING: Figure 1

Description

The present invention relates to an accounting data generation device, an accounting data generation method, and an accounting data generation program.

Patent Document 1 describes that every time a product is moved, such as warehousing or shipping, a storage fee and a moving fee are entered in the books (right column on page 1). Further, Patent Document 1 discloses that the storage fee is calculated by "(remaining amount in the previous period + number of warehousing items in the current period) x unit price of storage fee" (page 2, upper right column, last paragraph to lower left column, first paragraph). ..

Japanese Unexamined Patent Publication No. 52-0171919

However, it is a laborious task to calculate the transfer fee that accompanies the receipt and delivery of goods such as goods. In recent years, there are many businesses that provide storage locations (consignment warehouses) for goods, which are also called third-party logistics (3PL), and the set unit price of the transfer fee differs depending on each business. To give a specific example, the set unit price includes a fixed amount unit price and a fixed multiplication rate unit price, and further, the set unit price may differ between warehousing and warehousing. The fixed amount unit price is a unit price that determines a fee according to the quantity of goods received and shipped. The fixed rate unit price is a unit price that determines a fee according to the total amount of goods to be loaded and unloaded. For this reason, especially for users who use multiple third-party logistics, it becomes necessary to confirm the set unit price each time in order to calculate the transfer fee, and as a result, accurate accounting processing can be performed. There are situations where it is not possible or it takes a lot of time for accounting.

Therefore, it is required to be able to reduce the time and effort required to obtain accurate accounting data for goods scheduled to be stored in the storage location and to be delivered from the storage location.

The present invention has been made in view of the above-mentioned problems (requirements), and reduces the time and effort required to obtain accurate accounting data regarding goods to be stored in the storage location and to be delivered from the storage location. It is an object of the present invention to provide an accounting data generation device, an accounting data generation method, and an accounting data generation program which can be used.

In order to solve the above-mentioned problems and achieve the object, the accounting data generation device according to the present invention is for generating accounting data for goods scheduled to be received in and out of the storage location. An accounting data generation device including a control unit, wherein the control unit generates warehousing / delivery cost data including warehousing / delivery cost information regarding warehousing / delivery costs incurred in connection with warehousing and warehousing of one or more articles in the storage location. The warehousing / delivery cost data generation means including the warehousing / delivery cost data generation means generated as one of the accounting data is a unit price for the warehousing / delivery cost set for the goods to be warehousing or warehousing at the storage location. There is warehousing / delivery cost unit price information related to the warehousing / delivery cost unit price for which either the fixed amount unit price or the fixed multiplication rate unit price that can be set for each warehousing and each warehousing of the goods is set, and one or more goods in the storage location. It is characterized in that the warehousing / delivery cost is calculated based on the warehousing / delivery record data including the warehousing / delivery quantity information regarding the warehousing / delivery quantity of the warehousing and the warehousing / delivery.

Further, the accounting data generation device according to the present invention is characterized in that the warehousing / delivery cost data is various warehousing data including the warehousing / delivery cost information as various warehousing information.

Further, in the accounting data generation device according to the present invention, the various charges indicated by the various charges information are the sum of the warehousing cost incurred due to the warehousing of the goods and the warehousing cost incurred in connection with the warehousing of the goods. It is a feature.

Further, in the accounting data generation device according to the present invention, the control unit further includes an evaluation unit price calculation means for calculating an evaluation unit price on a predetermined date of the article based on the warehousing / delivery cost information, and the evaluation unit price calculation means. Calculates the incurred cost inclusion quantity of the goods up to the predetermined date, calculates the incurred cost inclusion amount of the goods up to the predetermined date and includes the warehousing / delivery cost, and calculates the incurred cost inclusion amount. It is characterized in that the valuation unit price is calculated based on the inventory quantity and the inventory amount of the goods on the previous due date of the predetermined date, the incurred cost included quantity, and the incurred cost included amount.

Further, in the accounting data generation device according to the present invention, the control unit further includes an inventory quantity updating means for updating the inventory quantity of the article on the predetermined date, and the inventory quantity updating means is the inventory on the previous date. By calculating the inventory quantity on the predetermined date based on the quantity and the warehousing / delivery quantity up to the predetermined date, the inventory quantity on the previous date is updated with the inventory quantity on the predetermined date. ..

In addition, the accounting data generation method according to the present invention is for generating accounting data related to goods scheduled to be received in and out of a storage location, which is executed in an information processing apparatus provided with a control unit. The accounting data generation method, which is executed in the control unit, accounts for the warehousing / delivery cost data including the warehousing / delivery cost information regarding the warehousing / delivery cost incurred in connection with the warehousing / delivery of one or more articles in the storage location. Including the warehousing / delivery cost data generation step generated as one of the data, in the warehousing / delivery cost data generation step, it is a unit price for the warehousing / delivery cost set for the goods to be warehousing or warehousing at the storage location. The warehousing / delivery cost unit price information related to the warehousing / delivery cost unit price in which either the fixed amount unit price or the fixed multiplication rate unit price that can be set for each warehousing and each warehousing of the goods is set, and the warehousing / delivery of one or more goods at the storage location and It is characterized in that the warehousing / delivery cost is calculated based on the warehousing / delivery record data including the warehousing / delivery quantity information regarding the warehousing / delivery quantity of the warehousing / delivery.

In addition, the accounting data generation program according to the present invention is for generating accounting data regarding goods scheduled to be received in and out of a storage location, which is executed in an information processing apparatus provided with a control unit. The accounting data generation program, which is to be executed by the control unit, obtains warehousing / delivery cost data including warehousing / delivery cost information regarding warehousing / delivery costs incurred in connection with warehousing and warehousing of one or more articles in the storage location. Including the warehousing / delivery cost data generation step generated as one of the accounting data, in the warehousing / delivery cost data generation step, it is the unit price for the warehousing / delivery cost set for the goods subject to warehousing or warehousing at the storage location. The warehousing / delivery cost unit price information related to the warehousing / delivery cost unit price for which either the fixed amount unit price or the fixed multiplication rate unit price that can be set for each warehousing and each warehousing of the goods is set, and the warehousing of one or more goods at the storage location. It is characterized in that the warehousing / delivery cost is calculated based on the warehousing / delivery record data including the warehousing / delivery quantity information regarding the warehousing / delivery quantity of the warehousing / delivery.

According to the present invention, it is possible to reduce the time and effort required to obtain accurate accounting data for goods scheduled to be stored in the storage location and to be delivered from the storage location.

FIG. 1 is a block diagram showing an example of a configuration of an accounting data generation system including an accounting data generation device according to an embodiment of the present invention. FIG. 2 is a flowchart showing a processing procedure of an accounting data generation method executed by the accounting data generation device 100 in the accounting data generation system 1000 of FIG. FIG. 3 is a diagram schematically showing an example of the configuration of the warehousing / delivery cost unit price master registered in step S201 of FIG. FIG. 4 is a diagram schematically showing an example of the configuration of the article master registered in step S201 of FIG. FIG. 5 is a diagram schematically showing a configuration example of warehousing data received in step S202 of FIG. FIG. 6 is a diagram schematically showing a configuration example of the issue data received in step S203 of FIG. FIG. 7 is a diagram schematically showing a configuration example of the warehousing / delivery record data acquired in step S206 of FIG. 2, FIG. 7 (a) shows a part of the warehousing / delivery record data, and FIG. 7 (b). ) Is a diagram showing a portion following FIG. 7 (a). FIG. 8 is a diagram schematically showing a configuration example of various data generated in step S208 of FIG. FIG. 9 is a diagram schematically showing a configuration example of inventory quantity data generated as a result of calculation of the evaluation unit price in step S209 of FIG. 2, and FIG. 9 (a) shows a part of the warehousing / delivery record data. , FIG. 9B is a diagram showing a portion following FIG. 9A.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. composition]
An example of the configuration of the accounting data generation system including the accounting data generation device according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of a configuration of an accounting data generation system including an accounting data generation device according to an embodiment of the present invention.

The accounting data generation system 1000 shown in FIG. 1 includes an accounting data generation device 100 as an information processing device, a server 200, and a network 300 for communicably connecting the accounting data generation device 100 and the server 200.

The accounting data generation device 100 is an information processing device for generating accounting data related to goods scheduled to be received in and out of the storage location, and is composed of, for example, a commercially available desktop personal computer. One accounting data generation device 100 is installed in, for example, a department (for example, an accounting department or a general affairs department) that manages accounting associated with contract work. The accounting data generation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like on the market. It may be a type information processing device. Further, a plurality of accounting data generation devices 100 may be installed in the accounting data generation system 1000, and by synchronizing among the plurality of accounting data generation devices 100, one accounting data generation device 100 can be used. It may work.

The accounting data generation device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the accounting data generation device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the accounting data generation device 100 to the network 300 so as to be communicable 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. Here, the network 300 has a function of connecting the accounting data generation device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. Therefore, the communication interface unit 104 is configured to be able to receive information or the like from another information processing device (for example, an information processing device of a business partner) via the network 300 or via the network 300 and the server 200. At the same time, it is configured to be able to output predetermined information to a predetermined information processing device (for example, an information processing device of a business partner).

Various databases, tables, files, and the like are stored in the storage unit 106. A computer program (including the program of the present invention) for giving a command to a CPU (Central Processing Unit) to perform various processes in cooperation with an OS (Operating System) is recorded in the storage unit 106. As the storage unit 106, 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, or the like can be used. In addition, various data used for executing the program of the present invention are stored in the storage unit 106 so that they can be written / read.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used.

The control unit 102 is a CPU or the like that collectively controls the accounting data generation device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

Further, the configuration of the storage unit 106 and the control unit 102 will be described in detail with reference to FIG.

As shown in FIG. 1, the storage unit 106 includes a warehousing / delivery cost unit price master 106a, an article master 106b, a warehousing / delivery record data storage area 106c, a warehousing / delivery cost data storage area 106d, and an inventory quantity data storage area 106e. And the valuation cost data storage area 106f. Further, the storage unit 106 may include other masters and data storage areas.

It is a master that registers information on the unit price of the warehousing / delivery cost 106a and the unit price of the warehousing / delivery cost, which will be described later. A configuration example of the warehousing / delivery cost unit price master 106a will be described later with reference to FIG. The article master 106b is a master that registers information about the article, and in the present embodiment, the information about the article is registered including the information about the product unit price of the article. A configuration example of the article master 106b will be described later with reference to FIG.

The warehousing / delivery cost data storage area 106d, the inventory quantity data storage area 106e, and the valuation cost data storage area 106f are areas for storing the warehousing / delivery cost data, the stock quantity data, and the valuation cost data, which will be described later, respectively, and are necessary. Each data is kept outputable accordingly. All of these data function as accounting data for the user.

The control unit 102 includes a plurality of modules as shown in FIG. In the example shown in FIG. 1, the control unit 102 includes a warehousing / delivery cost data generation unit 102a, an evaluation unit price calculation unit 102b, and an inventory quantity update unit 102c.

The warehousing / delivery cost data generation unit 102a generates warehousing / delivery cost data including warehousing / delivery cost information regarding the warehousing / delivery cost incurred in connection with the warehousing / delivery of one or more goods at the storage location as one of the accounting data. It is a module that functions as a means of generating cost data. The evaluation unit price calculation unit 102b is a module that functions as an evaluation unit price calculation means for calculating the evaluation unit price of an article on a predetermined date based on the warehousing / delivery cost information. The inventory quantity update unit 102c is a module that functions as an inventory quantity update means for updating the inventory quantity of goods on a predetermined date. The functions of each part include a function for realizing the processing contents described later.

[2. process]
Next, the accounting data generation method executed in the accounting data generation system 1000 shown in FIG. 1 will be described exemplarily.

FIG. 2 is a flowchart showing a processing procedure of an accounting data generation method executed by the accounting data generation device 100 in the accounting data generation system 1000 of FIG. The process shown in FIG. 2 is generally associated with the receipt and delivery of one or more articles in the storage location when managing the goods scheduled to be received in and out of the storage location. The warehousing / delivery cost data including the warehousing / delivery cost information related to the warehousing / delivery cost to be generated is automatically generated as one of the accounting data, and most of this processing is executed by the control unit 102 of the accounting data generation device 100. Will be done. In the following, we will give an example of generating warehousing / delivery cost data in units of accounting months when warehousing / delivery of multiple products as our own goods at a storage location owned by a third party logistics (3PL). explain.

In FIG. 2, first, in step S201, registration of a necessary master is accepted. If the master has already been constructed, editing (maintenance) of such a master may be accepted. Examples of the master include a warehousing / delivery cost unit price master, which will be described later with reference to FIG. 3, and an article master, which will be described later with reference to FIG. Further, if necessary, another master (for example, a master in which a business partner such as a third party logistics (hereinafter, also referred to as “3PL”) is registered) may be prepared. The name of the master is for convenience, and any name can be adopted. Further, the configuration example of the master is not limited to the one described later, and for example, the property master and the contract management master may be integrated. If an existing master exists, access (reference) to the existing master may be enabled in step S201.

FIG. 3 is a diagram schematically showing an example of the configuration of the warehousing / delivery cost unit price master registered in step S201 of FIG.

The warehousing / delivery cost unit price master illustrated in FIG. 3 is a master that registers the unit price related to the warehousing / delivery cost of goods. The unit price related to the warehousing / delivery cost of goods (hereinafter, also referred to as “the warehousing / shipping cost unit price”) is usually the contract for warehousing, storage, and warehousing from the storage place owned by 3PL for the company's goods. It is determined when concluding with 3PL. The warehousing / delivery cost is a term that includes the fee required for warehousing and the fee required for warehousing, and is a debt to the business partner for the company and a claim to the company for the business partner. The warehousing / delivery cost unit price is the unit price for the warehousing / delivery cost set for the goods to be warehousing or warehousing at the storage location. The unit price for warehousing / delivery costs may be the same as or different from the unit price at the time of warehousing, and is set based on the contract. In addition, the unit price of warehousing / delivery costs may differ between the product (other than the material) and the material (for example, gift box, ribbon) depending on the type of goods (hereinafter, also referred to as “variety”), and is based on the contract. It is set for each product type. Furthermore, as mentioned above, the unit price of warehousing and delivery costs includes a fixed amount unit price (hereinafter, also referred to as "fixed unit price") and a fixed multiplication rate unit price (hereinafter, also referred to as "commodity unit price"). The unit price adopted based on the above (hereinafter, also referred to as "adopted unit price") is applied.

The warehousing / delivery cost unit price master shown in FIG. 3 includes storage location identification information (for example, warehouse code) for identifying the storage location, transaction type information (receipt / delivery), and product type information (goods / materials). , Information on the hiring unit price (commodity unit price / fixed unit price), information on the fixed amount unit price (currency unit), and information on the fixed multiplication rate unit price (multiplication rate or its percentage). The storage location identification information registered in the warehousing / delivery cost unit price master is when the business partner such as 3PL has only one storage location or when the unit price is the same even if multiple storage locations are owned. , Information that can identify the business partner (eg, business partner code) may be used. The transaction type registered in the warehousing / delivery cost unit price master may include information indicating transfer processing, etc. in addition to the information indicating warehousing and the information indicating warehousing. Can be managed without omission in the warehousing / delivery cost unit price master.

Here, in the warehousing / delivery cost unit price master, when the registered hiring unit price is a fixed multiplication rate unit price, Null (or zero) is automatically set as information on the fixed amount unit price, while the hiring unit price is the fixed amount unit price. In the case of, it is preferable that the multiplication rate "1" or the percentage 100% representing the multiplication rate is automatically set as the information regarding the fixed multiplication rate unit price, thereby preventing the registration error by the user. Can be prevented. In addition, if the hiring unit price other than the fixed amount unit price and the fixed rate unit price is generated by the contract, it is possible to additionally register it in the warehousing / delivery cost unit price master. According to the warehousing / delivery cost unit price master shown in FIG. 3, it is possible to manage a plurality of records in which a fixed amount unit price or a fixed multiplication rate unit price according to the hiring unit price is registered for each storage location unit, transaction type unit, and product type unit. can. A warehousing / delivery cost unit price master may be prepared for each storage location. In this case, the warehousing / delivery cost unit price master does not have to include the storage location identification information. Similarly, if the varieties handled by the company are only products or only materials, the warehousing / delivery cost unit price master does not have to include information on the varieties.

FIG. 4 is a diagram schematically showing an example of the configuration of the article master registered in step S201 of FIG.

The article master illustrated in FIG. 4 is a master that registers information about the article. In the present embodiment, the article master includes at least the article identification information (for example, the product code and the product name) for identifying the article and the information regarding the unit price (commodity unit price) of the article. The article master may include information about the product type, and for example, a part of the product code (for example, the upper one digit number) may be information about the product type. The article master shown in FIG. 4 and the warehousing / delivery cost unit price master shown in FIG. 3 may be integrated with each other. In this case, the hiring unit price is registered for each product.

Returning to FIG. 2, subsequently, in steps S202 and S203, the warehousing data and the warehousing data are accepted. It is preferable that the warehousing data and the warehousing data are generated by registering the warehousing data and the warehousing data based on the slip at the time of warehousing and the warehousing, respectively. Acceptance may be completed by making slip data such as slips, delivery slips, invoices, and invoices accessible.

FIG. 5 is a diagram schematically showing a configuration example of warehousing data received in step S202 of FIG. The warehousing data shown in FIG. 5 includes information on work days related to warehousing, storage location identification information (example: warehouse code), product identification information (example: product code and product name), information on warehousing quantity, and goods. Includes at least product price information regarding the product price of. The product price of the product can be calculated as the product of the product unit price registered in the product master and the warehousing quantity. In addition, the warehousing data usually includes information indicating warehousing as information regarding the transaction type. Further, the warehousing data preferably includes information for identifying the slip related to warehousing (eg, slip number). In the example of the warehousing data shown in FIG. 5, it is composed of two records based on the warehousing of two goods.

FIG. 6 is a diagram schematically showing a configuration example of the issue data received in step S203 of FIG. The shipping data shown in FIG. 6 includes information on the work day related to shipping, storage location identification information (example: warehouse code), product identification information (example: product code and product name), information on the quantity of goods shipped, and goods. Includes at least product price information regarding the product price of. The product price of the product can be calculated as the product of the product unit price registered in the product master and the warehousing quantity. In addition, the issue data usually includes information indicating the issue as information regarding the transaction type. Further, the issue data preferably includes information for identifying the slip related to the issue (eg, slip number). In the example of the issue data shown in FIG. 6, it is composed of two records based on the issue of two articles.

The processes of steps S201 to S203 described above (editing of the master, acceptance of warehousing data, and acceptance of warehousing data) are continuously performed until a predetermined date is reached. The predetermined date may be a date determined for executing the series of processes of steps S205 to S211 described later and may include information on the time, and the predetermined date may be, for example, the accounting date of the current accounting month. It is set to a date earlier than (5 days before). It should be noted that an arbitrary date may be used instead of the predetermined date, and the arbitrary date in this case is executed by the user when he / she wants to acquire the data obtained by the series of processes of steps S205 to S211 as management accounting data. Corresponds to the day when the instruction was given.

Then, when a predetermined date arrives (Yes in step S204), a series of processes of steps S205 to S211 are automatically executed. In addition, the user may input an instruction to execute the series of processes of steps S205 to S211 on a predetermined date. On the other hand, if the predetermined date has not arrived (No in step S204), the process returns to step S201 and the processes of S201 to S203 are executed.

First, in step S205, the storage location is specified. Specifically, the storage location identification information regarding the storage locations in an arbitrary or user-specified order is specified from the plurality of referenceable storage location identification information. Preferably, it is preferable to preferentially identify the storage location identification information that is frequently included in the warehousing data and the warehousing data. The user may specify in advance the range of a plurality of storage location identification information that can be referred to.

Subsequently, in step S206, the warehousing data and the warehousing data including the storage location identification information specified in step S205 are acquired as the warehousing / delivery record data. Specifically, among the warehousing data and the warehousing data received in steps S202 and S203, the storage specified in step S205 from the data whose work date is after the previous predetermined date and up to the current predetermined date. It is generated as warehousing / delivery record data by extracting warehousing data and warehousing data including location identification information and integrating the main part of the evacuated data of the extracted warehousing data and the main part of the evacuated data of the warehousing data.

FIG. 7 is a diagram schematically showing a configuration example of the warehousing / delivery record data acquired in step S206 of FIG. 2, FIG. 7 (a) shows a part of the warehousing / delivery record data, and FIG. 7 (b). ) Is a diagram showing a portion following FIG. 7 (a).

The warehousing / delivery record data shown in FIG. 7 includes the main part of the warehousing data (the warehousing data shown in FIG. 5) and the warehousing data (the warehousing data shown in FIG. 6) for the current month whose work day belongs to April. Is integrated, and the receipt quantity and the issue quantity are integrated and represented by the receipt / issue quantity information regarding the receipt / issue quantity. Further, the warehousing / delivery record data shown in FIG. 7 includes warehousing / delivery cost information regarding the warehousing / delivery cost (for example, the warehousing / delivery fee). This warehousing / delivery cost is set to Null or zero until it is calculated in step S207.

Further, the warehousing / delivery record data shown in FIG. 7 includes information on the product unit price registered in the goods master, information on the varieties registered in the warehousing / delivery cost unit price master, information on the fixed unit price, and information on the multiplication rate. It is preferable to include it. Information on the product unit price is acquired by referring to the product master in the product identification information included in the warehousing / delivery record data. Information on the variety can be obtained, for example, by referring to the information included in the product code. Information on the fixed unit price and information on the multiplication rate are acquired by referring to the warehousing / delivery cost unit price master with information on the acquired product type, storage location identification information included in the warehousing / delivery record data, and information on the transaction type. Since this information is used to calculate the warehousing / delivery cost, the warehousing / delivery record data does not necessarily include this information.

Further, in step S207, the warehousing / delivery cost is calculated. Specifically, the warehousing / delivery cost is calculated based on the warehousing / delivery quantity information, the product unit price information, the fixed unit price information, and the multiplication rate information included in the warehousing / delivery record data shown in FIG. For example, when the product type is a product, the warehousing / delivery cost is calculated as the product of the warehousing / delivery quantity, the product unit price, and the multiplication rate of 1 (100% as a percentage). When the product type is a material, the warehousing / delivery cost is calculated as the product of the warehousing / delivery quantity and the multiplication rate. Then, the warehousing / delivery cost information of the warehousing / delivery record data is updated with the calculated warehousing / delivery cost. As a result, the warehousing / delivery record data functions as one of the accounting data including the warehousing / delivery costs.

Subsequently, in step S208, various data is generated. Specifically, various charges data are generated based on the warehousing / delivery record data including the warehousing / delivery cost information regarding the warehousing / delivery cost calculated in step S207. The monetary data is data including miscellaneous information related to the monetary amount on the monetary amount accounting date. Since it is not necessary to clarify the transaction type in the various charges indicated by the various charges, in the present embodiment, such various charges are associated with the warehousing cost incurred by the warehousing of the goods and the warehousing of the goods. It is expressed as the sum of the shipping costs incurred. From this point of view, the various charges data is the various charges related to the various charges, which is the sum of the warehousing costs and the warehousing costs for the same goods among the warehousing and shipping cost information included in the warehousing / delivery record data. Include as.

FIG. 8 is a diagram schematically showing a configuration example of various data generated in step S208 of FIG. As shown in FIG. 8, the various charges data includes information on the various charges accounting date, goods identification information (product code and product name), and various charges amount information. For example, the last day of the accounting is set as the accrual date. In the example of the various data shown in FIG. 8, the warehousing cost (120,000) and the warehousing cost (72,000) included in the warehousing / delivery record data are added for the goods with the product code “102”, and the like. Similarly, it can be considered that the warehousing cost (zero) or the warehousing cost (zero) is added to the goods of. It is preferable that the various data includes information on the slip number, and more preferably, the slip number includes a part or all of the slip number included in the receipt / delivery record data. As a result, it is possible to easily match the invoice with the invoice from the business partner by using the various data.

Next, in step S209, the inventory valuation unit price is calculated. The inventory valuation unit price refers to the valuation unit price of an article on a predetermined date, which is used to calculate the valuation amount of inventory in the period from the previous predetermined date to the current predetermined date (for example, the current month). When a cost (various costs) is required for warehousing or shipping of goods as in the present embodiment, it is necessary to reflect the costs in the inventory valuation unit price. Specifically, the inventory valuation unit price for the current month is calculated as follows for each item.

First, the incurred cost included quantity of goods up to the specified date (current incurred cost included quantity) and the incurred cost included amount of goods up to the specified date including the warehousing / delivery cost (current month incurred cost included) Amount) and. The quantity included in the cost incurred in the current month is the quantity received indicated by the receipt quantity information included in the receipt data for the current month. As the warehousing data for the current month, the warehousing data extracted when acquiring the warehousing / delivery record data in step S206 can be used. In the present embodiment, the amount included in the cost price incurred in the current month is represented by the sum of the product amount of the goods received in the current month and the amount of various charges. Here, the product price of the goods received in the current month is the product price indicated by the product price included in the storage data for the current month. The stake amount is the stake amount indicated by the stake amount information included in the stake data generated in step S208. Instead of this, the total amount of the warehousing / delivery costs calculated in step S207 may be used as the various charges.

Subsequently, the inventory quantity (inventory quantity at the end of the previous month) and the inventory value (inventory amount at the end of the previous month) of the goods on the previous due date of the predetermined date are acquired. Normally, the information regarding the inventory quantity at the end of the previous month is held as inventory quantity data in the storage unit 106. It is preferable to use the information stored in the storage unit 106 for the inventory amount at the end of the previous month, but instead, the inventory quantity at the end of the previous month indicated by the information about the inventory quantity at the end of the previous month included in the inventory quantity data and the goods master It is also possible to calculate by the product with the registered product unit price.

Then, when the inventory quantity at the end of the previous month, the inventory amount at the end of the previous month, the quantity included in the cost incurred in the current month, and the amount included in the cost incurred in the current month are N0, V0, N1, and V1, respectively, the predetermined dates of the goods acquired as described above. The valuation unit price (inventory valuation unit price at the end of the current month) is calculated by (V0 + V1) / (N0 + N1). Each information used for calculating the valuation unit price in step S209 and the calculated valuation cost information are generated as inventory quantity data for the current month and stored readable. In addition, instead of the inventory quantity data of the current month or together with the inventory quantity data of the current month, the valuation cost data including the valuation cost information regarding the valuation cost calculated as a result of the processing of step S209 is generated and read as the valuation cost data for the current month. You may save it if possible.

FIG. 9 is a diagram schematically showing a configuration example of inventory quantity data generated as a result of calculation of the evaluation unit price in step S209 of FIG. 2, and FIG. 9 (a) shows a part of the warehousing / delivery record data. , FIG. 9B is a diagram showing a portion following FIG. 9A. The inventory quantity data shown in FIG. 9 includes information on the valuation unit price calculated in step S209. Therefore, the user can calculate the valuation amount of the inventory using the valuation unit price and obtain information comparable to the product unit price. Further, since the valuation unit price calculated in step S209 reflects various charges, not only the warehousing cost but also the warehousing cost can be accurately reflected, and as a result of manual processing, the warehousing cost is the valuation unit price. It is possible to prevent human error such as not being reflected in.

Further, in step S210, a process of updating the inventory quantity of the article on a predetermined date (for example, the inventory quantity at the end of the current month) is executed. This process is performed for each article. Specifically, first, the inventory quantity at the previous date (inventory quantity at the end of the previous month) and the warehousing / delivery quantity up to the predetermined date (current warehousing / delivery quantity) are acquired. The inventory quantity at the end of the previous month is the same as the inventory quantity at the end of the previous month used when calculating the evaluation unit price in step S209. The current month's warehousing / delivery quantity is the sum of the warehousing quantity indicated by the warehousing quantity information included in the warehousing data extracted when acquiring the warehousing / delivery record data in step S206, and the sum of the warehousing quantity indicated by the warehousing quantity information included in the warehousing data. Is calculated by subtracting. The current month's warehousing / delivery quantity takes a positive value when the total warehousing quantity is larger than the total warehousing quantity, and takes a negative value when the total warehousing quantity is less than the total warehousing quantity. Next, the sum of the inventory quantity at the end of the previous month and the warehousing / delivery quantity for the current month is calculated. The sum calculated in this way is the inventory quantity at the end of the month. Then, the inventory quantity at the end of the previous month is updated with the calculated inventory quantity at the end of the current month. Specifically, inventory quantity data including information on the inventory quantity at the end of the current month is newly generated, and is stored readable as inventory quantity data at the end of the previous due date on the next due date.

To give a specific example, as shown in the inventory quantity data shown in FIG. 9, the inventory quantity at the end of the previous month is 2000 for the product code "101", 12000 for the product code "102", and 8000 for the product code "401". In this case, the inventory quantity at the end of the month is 3200 per product code "101" (quantity of goods received and shipped this month + 1200), 10000 per product code "102" (quantity of goods received and shipped this month-2000), and 1200 per product code "401" (stocked in this month). It is calculated as the delivery quantity-6800).

Then, in step S211 it is determined whether or not the processing of steps S205 to S210 is also performed for the other storage location identification information. If there is other storage location identification information (Yes in step S211), the process returns to step S205, identifies the other storage location identification information, and executes the processes of steps S206 to S210. On the other hand, if there is no other storage location identification information (No in step S211), this process ends. The process shown in FIG. 2 is similarly executed in the period up to the next predetermined date (next accounting month).

As described in detail above, according to the processing procedure of the accounting data generation method shown in FIG. 2, when managing the goods scheduled to be received in the storage location and to be delivered from the storage location, the storage location is used. The warehousing / delivery cost data including the warehousing / delivery cost information regarding the warehousing / delivery cost incurred in connection with the warehousing / delivery of one or a plurality of goods is generated as one of the accounting data (step S207) (the warehousing / delivery cost data generation means). Here, either the fixed amount unit price or the fixed multiplication rate unit price, which is the unit price for the warehousing / delivery cost set for the goods subject to warehousing or warehousing at the storage location and can be set for each warehousing and each warehousing of the goods. The warehousing / delivery cost unit price information regarding the warehousing / delivery cost unit price set in (step S201), and the warehousing / delivery record data including the warehousing / delivery quantity information regarding the warehousing / delivery quantity of one or more goods at the storage location (step S201). The warehousing / delivery cost is calculated based on step S206). As a result, it is possible to reduce the time and effort of the user for obtaining accurate accounting data regarding the goods scheduled to be received in the storage location and to be delivered from the storage location. In addition, since the warehousing / delivery cost can be calculated in-house, it is possible to grasp various charges without waiting for the invoice from the business partner (3PL), and when the invoice from the business partner arrives. Has an advantage in that the invoice can be easily performed. Prior to the match, it is preferable to share information on the product unit price registered in the goods master between the company and the business partner, thereby reducing the possibility of a discrepancy between the two. Can be done.

Further, according to the process of FIG. 2, the warehousing / delivery cost data is the warehousing data including the warehousing / delivery cost information as the warehousing information related to the warehousing (step S208). As a result, accurate accounting data necessary for financial accounting can be obtained. Further, according to the process of FIG. 2, the various charges indicated by the various charges information are the sum of the warehousing cost incurred in connection with the warehousing of the goods and the warehousing costs incurred in connection with the warehousing of the goods. As a result, both the warehousing cost and the warehousing cost can be automatically recorded as various charges, so that it is possible to prevent mistakes such as human error in recording.

Further, according to the process of FIG. 2, the evaluation unit price of the article on a predetermined date is calculated based on the warehousing / delivery cost information (step S209) (evaluation unit price calculation means). Here, the valuation unit price is the incurred cost inclusion amount of the goods up to the predetermined date and the incurred cost inclusion amount including the warehousing / delivery cost by calculating the incurred cost inclusion quantity of the goods up to the predetermined date. Is calculated, and is calculated by using the inventory quantity and the inventory amount of the goods on the previous due date of the predetermined date, the incurred cost included quantity, and the incurred cost included amount (step S209). This allows the user to obtain the information needed to determine the valuation of the inventory. In addition, since the calculated evaluation unit price reflects both the warehousing cost and the warehousing cost, it is possible to prevent mistakes such as human error in accounting.

Further, according to the process of FIG. 2, the inventory quantity of the article on the predetermined date is updated (step S210) (inventory quantity updating means). Here, the inventory quantity is calculated based on the inventory quantity on the previous date and the warehousing / delivery quantity up to the predetermined date. Then, the inventory quantity on the previous date is updated with the inventory quantity on the predetermined date. As a result, the user can save the trouble of calculating the inventory quantity.

Further, in the above explanation, the debt incurred by the company based on the contract concluded between the company and 3PL (business partner) has been described as an example, but the claims incurred by the business partner are also described in FIG. Processing can be applied.

Further, in the above-described embodiment, the case where a single warehousing / delivery cost unit price is set for each transaction type of warehousing or warehousing has been described as an example for a single article, but a single article has been warehousing. Alternatively, a plurality of warehousing / delivery cost unit prices may be set for each transaction type of warehousing. For example, for a single item, a fixed unit price may be adopted for the delivery of up to 1000 pieces, and a fixed multiplication rate unit price may be adopted for the delivery of more than 1000 pieces. In such a case, for example, a single article may be registered in the warehousing / delivery cost unit price master as two types of articles of different varieties (that is, an article as a commodity and an article as a material).

[3. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical ideas described in the claims.

For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part thereof can be automatically performed by a known method.

In addition, the processing procedure, control procedure, specific name, information including parameters such as registration data and search conditions of each processing, screen examples, and database configuration shown in the present specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the accounting data generation device 100 and the accounting data generation system 1000, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the accounting data generation device 100, particularly each processing function performed by the control unit, all or any part thereof is realized by the CPU and a program that is interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on 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 accounting data is generated as necessary. It is read mechanically by the device 100. 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 an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with a CPU to form a control unit.

Further, this computer program may be stored in an application program server connected to the accounting data generator 100 via an arbitrary network (for example, network 300), and all or a part thereof may be stored as needed. You can also download it.

Further, the program for executing the process 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" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disk), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium". Therefore, a recording medium containing a program for executing the processing described in the present specification also constitutes the present invention.

The "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as a plurality of modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. A well-known configuration or procedure can be used for 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.

Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the accounting data generation 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 an arbitrary peripheral device is connected. Further, the accounting data generation device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present specification on the device.

Further, the specific form of distribution / integration of the device is not limited to the one shown in the drawing, and all or a part thereof may be functionally or physically in an arbitrary unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is useful in managing one or more articles scheduled to be received in and out of a storage location.

100 Accounting data generator 102 Control unit 102a I / O cost data generation unit 102b Evaluation unit price calculation unit 102c Stock quantity update unit 104 Communication interface unit 106 Storage unit 106a I / O cost unit price master 106b Goods master 106c I / O record data storage area 106d Goods issue cost data storage area 106e Stock quantity data storage area 106f Valuation cost data storage area 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network 1000 Accounting data generation system

Claims (7)

An accounting data generator equipped with a control unit for generating accounting data for goods scheduled to be received in and out of a storage location.
The control unit
Includes a warehousing / delivery cost data generation means that generates warehousing / delivery cost data including warehousing / delivery cost information regarding warehousing / delivery costs incurred in connection with the warehousing and delivery of one or more goods in the storage location as one of the accounting data.
The warehousing / delivery cost data generation means is
It is a unit price for the warehousing / delivery cost set for the goods to be warehousing or warehousing at the storage location, and either the fixed amount unit price or the fixed multiplication rate unit price that can be set for each warehousing or warehousing of the goods is set. The warehousing / delivery cost is based on the warehousing / delivery cost unit price information regarding the warehousing / delivery cost unit price and the warehousing / delivery record data including the warehousing / delivery quantity information regarding the warehousing / delivery quantity of one or more goods at the storage location. An accounting data generator characterized by calculating. The accounting data generation device according to claim 1, wherein the warehousing / delivery cost data is various warehousing data including the warehousing / delivery cost information as various warehousing information. The accounting data generation according to claim 2, wherein the various charges indicated by the various charges information are the sum of the warehousing costs incurred due to the warehousing of the goods and the warehousing costs incurred in connection with the warehousing of the goods. Device. The control unit
Further including an evaluation unit price calculation means for calculating an evaluation unit price on a predetermined date of the goods based on the warehousing / delivery cost information.
The evaluation unit price calculation means is
Calculate the incurred cost included quantity of the goods up to the predetermined date,
Calculate the incurred cost included amount including the warehousing / delivery cost, which is the incurred cost included amount of the goods up to the predetermined date.
Claims 1 to 3 characterized in that the valuation unit price is calculated based on the inventory quantity and the inventory amount of the goods on the previous due date of the predetermined date, the incurred cost included quantity, and the incurred cost included amount. The accounting data generator according to any one of the above items. The control unit
Further including an inventory quantity updating means for updating the inventory quantity of the goods on the predetermined date,
The inventory quantity update means
By calculating the inventory quantity on the predetermined date based on the inventory quantity on the previous date and the warehousing / delivery quantity up to the predetermined date, the inventory quantity on the previous date is updated with the inventory quantity on the predetermined date. The accounting data generation device according to claim 4. It is an accounting data generation method for generating accounting data regarding goods scheduled to be received in and out of a storage location, which is executed in an information processing device equipped with a control unit.
Executed in the control unit,
Including a warehousing / delivery cost data generation step that generates warehousing / delivery cost data including warehousing / delivery cost information regarding warehousing / delivery costs incurred in connection with the warehousing and delivery of one or more goods in the storage location as one of the accounting data.
In the entry / exit cost data generation step,
It is a unit price for the warehousing / delivery cost set for the goods to be warehousing or warehousing at the storage location, and either the fixed amount unit price or the fixed multiplication rate unit price that can be set for each warehousing or warehousing of the goods is set. The warehousing / delivery cost is based on the warehousing / delivery cost unit price information regarding the warehousing / delivery cost unit price and the warehousing / delivery record data including the warehousing / delivery quantity information regarding the warehousing / delivery quantity of one or more goods at the storage location. An accounting data generation method characterized by calculating. An accounting data generation program that is executed in an information processing device equipped with a control unit to generate accounting data for goods scheduled to be received in and out of a storage location.
To be executed in the control unit
Including a warehousing / delivery cost data generation step that generates warehousing / delivery cost data including warehousing / delivery cost information regarding warehousing / delivery costs incurred in connection with the warehousing and delivery of one or more goods in the storage location as one of the accounting data.
In the entry / exit cost data generation step,
It is a unit price for the warehousing / delivery cost set for the goods to be warehousing or warehousing at the storage location, and either the fixed amount unit price or the fixed multiplication rate unit price that can be set for each warehousing or warehousing of the goods is set. The warehousing / delivery cost is based on the warehousing / delivery cost unit price information regarding the warehousing / delivery cost unit price and the warehousing / delivery record data including the warehousing / delivery quantity information regarding the warehousing / delivery quantity of one or more goods at the storage location. An accounting data generation program characterized by calculating.

Images