JP7198706B2 - INVENTORY INQUIRY DEVICE, INVENTORY INQUIRY METHOD, AND INVENTORY INQUIRY PROGRAM - Google Patents

Description

The present invention relates to an inventory inquiry device, an inventory inquiry method, and an inventory inquiry program.

For example, there is Patent Document 1 as a system for inventory inquiry. The system of Patent Document 1 includes means for creating an inventory table, registering product orders from stores or wholesale customers as future inventory data in the inventory table, creating an order receiving table based on the future inventory data, Alternatively, a means for placing an order with a vendor, a means for creating a shipping instruction table based on the order, processing the future inventory data as actual inventory data after the goods are received at the warehouse, and shipping the goods based on the shipping instruction table, then sales and a means for creating a table and processing actual inventory data as past inventory data, and centrally manages a series of physical distribution data from product ordering to sales via the Internet as three types of inventory data.

JP-A-2004-51374

However, in Patent Document 1, regarding a manufactured product that has multiple component parts and multiple processes in supplying overseas and manufacturing in-house, each department reports the current cost and inventory, and at that time overseas There is no description of expanding and inquiring the payment unit price and conversion rate to the parts level.

The present invention has been made in view of the above. It is another object of the present invention to provide an inventory inquiry device, an inventory inquiry method, and an inventory inquiry program capable of expanding and inquiring the unit price and conversion rate for overseas supply at that time to the parts level.

In order to solve the above-mentioned problems and achieve the object, there is provided an inventory checking device comprising a storage unit and a control unit, wherein the storage unit stores a parent item that is a manufactured product or an intermediate part of a manufactured product. For each configuration level that indicates the level of the parent item, the first master that registers the child items that are the parts that make up the parent item, the second master that registers the fixed rate and actual rate of each currency, and the Cost data including standard unit price, actual unit price, material unit price, labor cost unit price, and subcontracted processing cost unit price;
and inventory data including the current inventory quantity in each warehouse for each item, and the control unit,
By querying the first master, the second master, the cost data, and the inventory data according to query conditions including parent item, configuration level, currency fixed rate or actual rate, and for each configuration level of the parent item (2) an inquiry processing means for outputting an inquiry result of an inventory status, a cost status, a currency/rate unit price status of the parent item and child items constituting the parent item;

Further, according to a preferred aspect of the present invention, the inventory checking device is connected via a network to terminal devices of the manufacturing control department, the accounting department, and/or the cost department, and the inquiry processing means Inquiries may be made in response to requests including inquiry conditions from the terminal devices of departments, accounting departments, and/or cost departments, and the inquiry results may be output.

Further, in order to solve the above-described problems and achieve the object, the present invention provides an inventory inquiry method to be executed by an information processing apparatus having a control unit and a storage unit, wherein the storage unit includes a manufacturing For each configuration level indicating the manufacturing level of the parent item, which is a product or an intermediate part of the manufactured product, the first master that registers the child items that are the parts that make up the parent item, the fixed rate of each currency, and the actual Second master registering rate, cost data including standard unit price, actual cost unit price, material unit price, labor cost unit price, and subcontracted processing cost unit price for each item, and current stock quantity in each warehouse for each item and inventory data including, and are stored in, the first master, the second master, the Inquiry that inquires the cost data and inventory data, and outputs the inquiry results of the inventory status, cost status, and currency/rate unit price status of the parent item and child items that make up the parent item for each configuration level of the parent item. It is characterized by including a processing step.

Further, in order to solve the above-described problems and achieve the object, the present invention provides an inventory inquiry program to be executed by an information processing apparatus having a control unit and a storage unit, wherein the storage unit includes:
For each configuration level indicating the manufacturing level of parent items that are manufactured products or intermediate parts of manufactured products, the first master that registers child items that are parts that make up the parent item, the fixed rate of each currency, and Second master registering actual rates, cost data including standard unit price, actual cost unit price, material unit price, labor cost unit price, and subcontracted processing cost unit price for each item, and the current inventory quantity in each warehouse for each item and inventory data including the first master, the second master, according to query conditions including parent item, configuration level, currency fixed rate or actual rate, which are executed by the control unit. Inquire the cost data and inventory data, and output the inquiry results of the inventory status, cost status, and currency/rate unit price status of the parent item and child items that make up the parent item for each configuration level of the parent item. An inventory inquiry program characterized by including an inquiry processing step.

According to the present invention, regarding a manufactured product that has a plurality of component parts and a plurality of processes in supply to overseas and manufacturing in the company, the current cost and inventory from each department, and at that time overseas There is an effect that it becomes possible to develop and inquire the unit payment and the conversion rate down to the parts level.

FIG. 1 is a block diagram showing an example of an inventory inquiry system according to this embodiment. FIG. 2 is a diagram showing an outline of a system configuration example of master and data. FIG. 3 is a diagram showing a configuration example of main parts of the master and data. FIG. 4 is a diagram showing a display example of a configuration expanded inventory inquiry screen. FIG. 5-A is a diagram showing an output example of the inquiry result of the configuration expanded inventory inquiry screen. FIG. 5-B is a diagram showing an output example of the inquiry result of the configuration expansion inventory inquiry screen. FIG. 5-C is a diagram showing an output example of the inquiry result of the configuration expanded inventory inquiry screen. FIG. 5-D is a diagram showing an output example of the inquiry result of the configuration expansion inventory inquiry screen.

An embodiment of the present invention will be described in detail based on the drawings. It should be noted that the present invention is not limited by this embodiment.

[1. overview]
For example, in the case of manufactured products that have multiple parts and multiple processes in supply overseas and in-house manufacturing, especially in the case of manufactured products that have a large number of one configuration or products that have a small number of configurations but the cost varies greatly. In order to confirm the current cost, inventory, unit price paid overseas, conversion rate, etc., it was necessary to inquire with the department in charge, which was inconvenient.

In this embodiment, for example, regarding a manufactured product that has multiple parts and multiple processes in supplying overseas and manufacturing in-house, each department (for example, manufacturing management department, accounting department, cost department, etc.) ), the current cost and inventory, as well as the unit price and conversion rate for overseas supply at that time, can be inquired for each configuration level down to the parts level.

According to this embodiment, (1) in the cost department (the department that manages the cost), it is possible to grasp the cost of a product type based on the cost of one product and one configuration and the method of summarizing them. (2) In the accounting department, for example, from the exchange rate of the bank registered around 12:00, it becomes possible to grasp the unit price of the corresponding product and the amount of subcontracting. (3) The manufacturing control department can grasp the current inventory, the current selling price and the actual cost. As a result, any department can check their daily work, and there is no need to check with other departments. .

[2. composition]
An example of the configuration of an inventory inquiry system according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of an inventory inquiry system 1 according to this embodiment.

The inventory inquiry system 1 is composed of, for example, a server-client system, in which an inventory inquiry device 100 functioning as a server and terminal devices 400 of the production control department, the accounting department, the cost department, etc. are connected to a network 300. It is configured to be able to communicate via

In response to a request from the terminal device 400, the inventory inquiry device 100 provides the terminal device 400 with various input screens (for example, configuration development inventory inquiry screen), and inputs information on the various input screens by the terminal device 400. Accept and perform various processing. For example, the inventory inquiry device 100 provides a configuration development inventory inquiry screen to the terminal device 400 in response to a request from the terminal device 400, and according to the inquiry conditions specified on the configuration development inventory inquiry screen of the terminal device 400, various The master or data is referred to, and the result of the inquiry is transmitted to the terminal device 400 and displayed on the component expanded inventory inquiry screen.

The inventory inquiry device 100 can be composed of, for example, a workstation or a personal computer. The terminal device 400 includes a monitor and a printer, and may be, for example, a commercially available desktop personal computer, and is not limited to a stationary information processing device such as a desktop personal computer, and is a commercially available notebook personal computer. , PDA (Personal Digital Assistants), smart phones, tablet personal computers, and other portable information processing devices.

The inventory inquiry device 100 includes a control section 102 , a communication interface section 104 , a storage section 106 and an input/output interface section 108 . Each part provided in the inventory inquiry device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the inventory inquiry 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 another device via a communication line. Here, the network 300 has a function of connecting the inventory inquiry device 100 and the terminal devices 400 of the production management department, the accounting department, the cost department, etc. so that they can communicate with each other. Local Area Network) and the like. Thus, the communication interface unit 104 is configured to be capable of data communication with the terminal devices 400 . . . via the network 300 .

An input device 112 and an output device 114 are connected to the input/output interface section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that cooperates with the mouse to provide a pointing device function. Note that, hereinafter, the output device 114 may be referred to as the monitor 114 and the input device 112 may be referred to as the keyboard 112 or the mouse 112 .

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

The storage unit 106 also includes a product number master 106a, a configuration master 106b (first master), an arrangement master 106c, a product type master 106d, a process order master 106e, a customer master 106f, and a currency master 106g ( second master), a unit price master 106h, and a data file 106i for storing inventory data, actual cost data, and the like. FIG. 2 is a diagram showing an outline of a system configuration example of master and data. FIG. 3 is a diagram showing a configuration example of main parts of the master and data.

As shown in FIG. 3, the product number master 106a can be composed of a table or the like in which items (parent items, child items) CDs, item names, product type CDs for classifying items by product type, etc. are associated and registered. .

The configuration master 106b is a master in which parts (child items) constituting a product (parent item) are associated with each configuration level. The configuration level refers to the manufacturing level of parts that make up a product. For example, when parts are manufactured from raw materials (original parts) and final products are manufactured from those parts, the final product is the top item and the raw material is the bottom item. The configuration level of the product is set to "0 (zero)" indicating the highest level, and the configuration level of "1" or lower is set according to the manufacturing level of the part. A product with a large number of parts has a large number of configuration levels.

As shown in FIG. 3, the configuration master 106b can be composed of a table or the like in which configuration levels, parent item CDs, child item CDs, manufacturing configuration flags, configuration numerators, configuration denominators, configuration numbers, etc. are associated and registered. . Note that the parent item CD is not limited to the manufactured product, and may be intermediate parts of the manufactured product, and the inventory may be developed from the intermediate parts on the configuration development inventory inquiry screen described later.

The arrangement master 106c, as shown in FIG. 3, associates item CD, process sequence, business partner (arrangement destination) CD, manufacturing lead time, maximum lot, minimum lot, incremental lot, supply classification, conversion item CD, etc. It can be composed of a registered table or the like.

As shown in FIG. 3, the product type master 106d can be composed of a table or the like in which the product type CD, product name, etc. are associated and registered.

As shown in FIG. 3, the process order master 106e can be composed of a table or the like in which item CDs, process orders, revision dates, and unit CDs are associated and registered.

The supplier master 106f, as shown in FIG. 3, consists of a table or the like in which supplier (arrangement destination) CD, supplier (arrangement destination) name, supplier classification, sales destination classification, and currency CD are associated and registered. can do.

The currency master 106g, as shown in FIG. 3, can be composed of a table or the like in which currency CDs, currency names, actual rates, revision dates, and fixed rates are associated and registered.

The data file 106i is a file for storing inventory data, actual cost data, standard cost data, manufacturing performance data, movement performance data, purchase data, sales data, and the like.

Inventory data may include data such as item CD, process sequence, warehouse CD, current inventory, and site CD, as shown in FIG.

As shown in FIG. 3, the actual cost data includes item CD, process sequence, fiscal year and month, actual cost unit price, material unit price, labor cost unit price, outsourced processing unit price, subordinate material unit price 1, subordinate labor cost unit price 1, and subordinate Data such as the outsourced processing unit price 1 may be included.

In the above configuration, the product number master 106a, configuration master 106b, arrangement master 106c, process sequence master 106e, unit price master 106h, inventory data, and actual cost data are linked with the item CD as a key. The product number master 106a and the product type master 106d are linked with the product type CD as a key. Further, the supplier master 106f, the arrangement master 106c, and the unit price master 106h are linked with the supplier CD as a key. Using the currency code as a key, the currency master 106g, customer master 106f, and unit price master 106h are linked. The process order master 106e, arrangement master 106c, unit price master 106h, inventory data, and actual cost data are linked with the process order as a key.

Returning to FIG. 1, the control unit 102 is a CPU or the like that controls the inventory inquiry device 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. Here, the control unit 102 functionally conceptually includes a data update unit 102a, an inventory data processing unit 102b, a cost data processing unit 102c, an inquiry processing unit 102d, a master maintenance unit 102e, and a screen display control unit 102f. and

The data update unit 102a creates and updates the production performance data, movement performance data, purchase data, sales data, etc. shown in FIG. and store it in the data file 106i.

As shown in FIG. 2, the inventory data processing unit 102b creates and updates inventory data based on production performance data, movement performance data, purchase data, sales data, etc., and stores the data in the data file 106i.

The cost data processing unit 102c creates/updates actual cost data based on the actual manufacturing data, the moving actual data, the purchase data, the sales data, and the inventory data, and stores it in the data file 106i. For comparison, the cost data processing unit 102c basically acquires and accumulates the master values, creates and updates standard cost data, and stores the data in the data file 106i.

The inquiry processing unit 102d, in accordance with the inquiry conditions specified on the configuration development inventory inquiry screen displayed on the screens of the monitor 114 and each terminal device 400, etc. By referring to the cost data, the inventory status, cost status, and currency rate status are extracted and calculated for each configuration level of the target item defined in the configuration master 106b, and the inquiry result is displayed as the inquiry result of the configuration expanded inventory inquiry screen. Output to area.

The master maintenance unit 102e generates a product number master 106a, a configuration master 106b, an arrangement master 106c, a product type master 106d, a process order master 106e, and a This is for editing the data of the customer master 106f, the currency master 106g, and the unit price master 106h, such as inputting, adding, updating, etc., to maintain the latest state.

The screen display control unit 102f controls the display of various screens such as input screens (for example, configuration expansion inventory inquiry screen) displayed on the screens of the monitor 114 and the terminal devices 400, and acceptance of input on the screens.

[3. Concrete example]
A specific example of processing of the inventory inquiry device 100 according to the present embodiment will be described with reference to FIGS. 1 to 5-D. FIG. 4 is a diagram showing a display example of a configuration expanded inventory inquiry screen. FIGS. 5-A to 5-D are diagrams showing output examples of inquiry results on the expanded configuration inventory inquiry screen.

4 has an inquiry condition input area 501 for specifying inquiry conditions, an inquiry result output area 502 for outputting inquiry results, and an execute button 503 for instructing execution of the inquiry. It has

When the execution button 503 is pressed, the inquiry processing unit 102d refers to each of the masters 106a to 106h, the inventory data, the actual cost data, and the standard cost data according to the inquiry conditions specified in the inquiry condition input area. The inventory status, cost status, and currency rate status are extracted and calculated for each configuration level of the target item defined by the master 106b, and the inquiry result is output to the inquiry result output area 502 of the configuration expanded inventory inquiry screen.

Inquiry condition input area 501 contains site CD, item CD to be inquired, quantity required, delivery date, and an expansion level for expanding the composition level of the object item (if an expansion level larger than the number of composition levels is specified, , if all configuration levels are expanded and fewer expansion levels than the number of configuration levels are specified, the number of expansion levels specified from the upper configuration level is expanded), fixed rate base date, unit, and inventory location It has columns for designating (inventory CD) and cost reference date.

The inquiry condition input area 501 includes a selection box 501a for selecting extraction of product type data, a production structure (that constitutes the product itself) or a cost structure (that constitutes the product itself, labels, and cardboard boxes for packaging). etc.) is provided for selecting a selection box 501b.

In the example of the configuration exploded inventory inquiry screen shown in FIG. 4, the site CD "1: whole", the item CD "A00000001", the required quantity "1", the delivery date "2018/08/31", the expansion level "10", the fixed rate Reference date "2018/08/31", unit "unit", inventory location "0001 manufacturing warehouse 1", cost reference date "2018/08/31", and "production configuration" are specified.

Using the item CD "A00000001" as a key, acquire the child item CD for the expansion level "10" from the configuration master 106b. Inventory data and cost data (actual cost data and standard cost data) are collated, and the inventory status, cost status, and currency/rate of item CD "A00000001" and child item CDs for each composition level of item CD "A00000001" Output the query result of the unit price situation.

5-A to 5-D are diagrams showing examples of query results output (displayed) in the query result output area 502. FIG. As a result of the inquiry, for each composition level of the designated item, the lower item, lower cost item name, product type, order of process, inventory status, cost status, inventory status, and currency rate status are output. In the example shown in the figure, for each configuration level (0 to 3) for the specified item CD "A00000001", the lower item, lower cost item name, product type, order of process, and inventory status (for example, current inventory quantity, inventory unit) name, other current inventory quantity, planned incoming quantity, planned outgoing quantity, required quantity, surplus quantity, configuration availability, manufacturing lead time, destination CD, destination name, minimum lot number), unit price currency, fixed rate, prevailing rate Currency/rate unit price situation to grasp (for example, unit price, currency CD, currency name, rate acquisition date (2018/8/31), rate, conversion unit price (rate), supply delivery category, payment delivery category name, payment unit price (current situation), required payment unit price (current situation), payment unit price, currency CD, currency name, rate acquisition date (cost reference date = 8/31/2018), variable rate, converted unit price, converted payment unit price (Japanese currency), required payment unit price), cost status (e.g., standard cost unit price, actual cost breakdown total, actual material unit price, actual labor cost unit price, actual subcontracting cost unit price, actual subordinate route material unit price, actual subordinate route labor cost unit price, actual subordinate route subcontracting cost unit price, actual lower item material unit price, actual lower item labor cost unit price, actual lower item subcontracting cost unit price, actual indirect cost unit price 1, actual lower order indirect cost unit price 1, actual lower cost item indirect cost unit price 1, etc.) output. The item CD "A00000001", which is the parent item, is at configuration level 0, which is the highest level. Although the expansion level "10" is specified, since the configuration level is "3", up to "3" is output.

It should be noted that the shipping data and the receiving data may be acquired from the cost reference date. If there is inventory outside the inventory location on the screen, it may be output as other current inventory. This makes it possible to grasp whether or not to bring from another place. Finally, the surplus numbers can be confirmed and future movements can be judged.

As for the currency/rate unit price situation, the fixed rate may be acquired by referring to the currency master 106g based on the "fixed rate reference date" specified on the configuration expansion inventory inquiry screen. The variable rate (actual rate) may be acquired from the currency master 106g based on the "cost base date" specified on the configuration expanded inventory inquiry screen. The converted unit price can be calculated by multiplying the unit price by the rate.

For example, assuming that the “fixed rate” is reviewed every year, the fixed rate conversion unit price is as follows.
2010/4/1 = 1 (USD) → 100 (JPY) @ 5 (USD) * 100 = @ 500 (JPY), 2011/4/1 = 1 (USD) → 110 (JPY) @ 5 (USD) * 110 = @ 550 (JPY), 2012/4/1 = 1 (USD) → 120 (JPY) @ 5 (USD) * 120 = @ 600 (JPY), 2013/4/1 = 1 (USD) → 130 (JPY) @ 5 (USD) * 130 = @ 650 (JPY)

It is possible to register the in-house rate and the actual fluctuating rate in the currency master 106g and check the data. Even when parts are actually exchanged at a fixed rate, it is possible to acquire provisional information by registering them in the currency master 106g.

As for the cost status, it is also possible to select intermediate parts without setting a product, expand the parts from there, and output an inquiry result.

As described above, according to the present embodiment, for each configuration level indicating the manufacturing level of a parent item that is a manufactured product or an intermediate part of a manufactured product, a child item that is a part that constitutes the parent item is selected. Registered composition master 106b (first master), currency master 106g (second master) in which fixed rates and actual rates of each currency are registered, standard unit price, actual cost unit price, material unit price, labor for each item Cost data (actual cost data, standard cost data) including cost unit price and outsourced processing cost unit price, inventory data including current inventory quantity in each warehouse for each item, parent item, composition level, currency fixed rate or The first master, the second master, the cost data, and the inventory data are inquired according to the inquiry conditions including the actual rate, and the parent item and the child items that constitute the parent item for each composition level of the parent item. Since it has an inquiry processing unit 102d that outputs the inquiry results of the inventory status, cost status, and currency/rate unit price status, there are multiple component parts, and there are multiple processes in overseas supply and in-house manufacturing. With regard to such manufactured products, it is possible to inquire from each department on the current cost and inventory, as well as the unit price and conversion rate for overseas supply at that time, expanded to the parts level.

[4. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all of the processes described as being manually performed Alternatively, some can be done automatically by known methods.

In addition, unless otherwise specified, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed arbitrarily.

Also, with respect to the inventory inquiry device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the inventory inquiry device 100, particularly the processing functions performed by the control unit 102, are realized in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in this embodiment, and the inventory inquiry device as necessary. 100 mechanically read. That is, the storage unit 106 such as ROM or HDD (Hard Disk Drive) stores computer programs for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM, and constitutes the control section 102 in cooperation with the CPU.

Also, this computer program may be stored in an application program server connected to the inventory inquiry device 100 via any network, and it is possible to download all or part of it as necessary. be.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered (trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (registered trademark) such as Blu- shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases and the like stored in the storage unit 106 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 are used for various processes and website provision. programs, tables, databases, and files for web pages.

Further, the inventory inquiry 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 arbitrary peripheral devices are connected. In addition, the inventory inquiry device 100 may be implemented by installing software (including programs, data, etc.) for implementing the processing described in the present embodiment in the information processing device.

Furthermore, the specific form of distribution and integration of the device is not limited to the one shown in the figure, and all or part of it can be functionally or physically arranged in arbitrary units according to various additions or functional additions. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be implemented selectively.

1 Inventory inquiry system 100 Inventory inquiry device 102 Control unit 102a Data update unit 102b Inventory data processing unit 102c Cost data processing unit 102d Inquiry processing unit 102e Master maintenance unit 102f Screen display control unit 104 Communication interface unit 106 Storage unit 106a Part number master 106b Configuration Master 106c Arrangement master 106d Product type master 106e Process order master 106f Customer master 106g Currency master 106h Unit price master 106i Data file 108 Input/output interface unit 112 Input device 114 Output device 300 Network 400 Terminal device

Claims (4)

An inventory checking device comprising a storage unit and a control unit,
The storage unit contains
a first master in which child items, which are parts that make up the parent item, are registered for each configuration level indicating the manufacturing level of the parent item, which is a manufactured item or an intermediate part of the manufactured item;
a second master registering fixed rates and actual rates for each currency;
Cost data including standard unit price, actual cost unit price, material unit price, labor cost unit price, and subcontracted processing cost unit price for each item;
Inventory data, including current inventory counts for each item in each warehouse;
is stored and
The control unit
Inquiring the first master, the second master, the cost data, and the inventory data according to query conditions including parent item, composition level, fixed rate or actual rate of currency, and composition level of the parent item 1. An inventory inquiry device, characterized by comprising inquiry processing means for outputting an inquiry result of an inventory status, a cost status, a currency/rate unit price status of a parent item and child items composing the parent item for each item. The inventory checking device is connected via a network to terminal devices of the manufacturing control department, the accounting department, and/or the cost department,
2. The inquiry processing means makes an inquiry in response to a request including inquiry conditions from a terminal device of a production control department, an accounting department, and/or a cost department, and outputs an inquiry result. Inventory inquiry device as described. An inventory inquiry method to be executed by an information processing device having a control unit and a storage unit,
The storage unit contains
a first master in which child items, which are parts that make up the parent item, are registered for each configuration level indicating the manufacturing level of the parent item, which is a manufactured item or an intermediate part of the manufactured item;
a second master registering fixed rates and actual rates for each currency;
Cost data including standard unit price, actual cost unit price, material unit price, labor cost unit price, and subcontracted processing cost unit price for each item;
Inventory data, including current inventory counts in each warehouse for each item;
is stored and
to be executed by the control unit;
By querying the first master, the second master, the cost data, and the inventory data according to query conditions including parent item, configuration level, currency fixed rate or actual rate, and for each configuration level of the parent item (2) an inventory inquiry process step of outputting an inquiry result of the inventory status, cost status, currency/rate unit price status of the parent item and child items composing the parent item. An inventory inquiry program to be executed by an information processing device having a control unit and a storage unit,
The storage unit contains
a first master in which child items, which are parts that make up the parent item, are registered for each configuration level indicating the manufacturing level of the parent item, which is a manufactured item or an intermediate part of the manufactured item;
a second master registering fixed rates and actual rates for each currency;
Cost data including standard unit price, actual cost unit price, material unit price, labor cost unit price, and subcontracted processing cost unit price for each item;
Inventory data, including current inventory counts in each warehouse for each item;
is stored and
to be executed by the control unit;
By querying the first master, the second master, the cost data, and the inventory data according to query conditions including parent item, configuration level, currency fixed rate or actual rate, and for each configuration level of the parent item 2. An inventory inquiry program characterized by comprising an inquiry processing step for outputting inquiry results of the inventory status, cost status, and currency/rate unit price status of the parent item and child items composing the parent item.

Images