JP2020004173A - Commodity unit price acquisition device, commodity unit price acquisition method and commodity unit price acquisition program - Google Patents

Abstract

To set a unit price of commodities to be sold at an individual negotiation meeting and an exhibition at a commodity unit price that is different from a general sale price.SOLUTION: A storage part 106 comprises: an event master 106a for defining categorization of an event; and an event/client commodity unit price master 106b for registering a commodity unit price by event and by client in association with an event code, a client code and a commodity code categorized by the event master 106a. A controller 102 comprises: a received order input part 102a for obtaining a commodity unit price from the event/client commodity unit price master 106b on the basis of the event code, the client code and the commodity code input at the time when a received order is input; a sales input part 102b for calculating sales by using a received order number and the event code input at the time when the order is input, and the obtained commodity unit price; and a journal entry collaboration part 102c for making entries in a journal to understand the profit and loss of each event in collaboration with the event code of the calculated sales information.SELECTED DRAWING: Figure 1

Description

  The present invention relates to a product price acquisition device, a product price acquisition method, and a product price acquisition program.

  According to Patent Literature 1, it is customary in commercial transactions to provide a product with a lower price to a customer with a higher transaction value than a customer with a lower transaction value. From the host computer, master data such as customer master, merchandise master, delivery price determination submaster (acquisition unit price master and discount master), classification name master, telephone directory master, etc., monthly schedule data (current month and next month), designated daily report, specialty Download information data such as sales analysis data for two years to PDA. Then, when "product information" is selected on the customer service menu screen (FIG. 6) of the PDA, selection items such as "distribution (classification and sales form of promotional products, store special sales, low-priced products, etc.)" are provided. The screen of the product information menu (FIG. 16) is displayed. A technique is disclosed in which the user refers to the master data (FIG. 3) of each product by any means of "distribution", "classification", "article name", "manufacturer", "JAN", and "unique code".

JP-A-2006-177777

  As described above, Patent Literature 1 uses a delivery price determination submaster (a settlement unit price master and a discount master) as a means for setting a product price according to a customer, and uses master data of each product according to a sales form. Is referred to. However, in Patent Literature 1, as in the apparel industry, sales are often performed separately from general sales at events such as individual business meetings and exhibitions, and unit prices are set not only by customers but also by factors of events. There was a problem that it could not be performed.

  The present invention has been made in view of the above, and it is possible to set a product unit price by setting a difference between a product price sold at an event such as an individual business meeting or an exhibition and a general selling price. It is an object of the present invention to provide an acquisition device, a product price acquisition method, and a product price acquisition program.

  In order to solve the above-described problems and achieve the object, a commodity unit price acquisition device according to the present invention includes a storage unit and a control unit, and is provided for each event such as an individual business meeting or an exhibition held for a specific customer. A unit price acquisition device for acquiring the unit price of the event, wherein the storage unit stores an event master that defines a classification of the event, an event code classified by the event master, a customer code, and a product code. An event-specific customer unit price master in which the linked event-specific customer unit price is registered is stored, and the control unit receives an order number at the time of order entry, and stores the event code and the event code. An order input means for acquiring a sales unit price from the customer-specific product unit price master based on the customer code and the product code, and the event code based on the order number input at the time of inputting the order; Sales input means for recording sales using the sales unit price, and journal linking means for performing journal entry for grasping profit and loss for each event in conjunction with the event code of sales information for which sales have been recorded. Features.

  In addition, the product unit price acquisition device according to the present invention, the control unit further includes an output unit that outputs a list of event-specific customer unit-values set in the event-specific customer-specific unit price master. Features.

  Further, the product unit price acquisition device according to the present invention is characterized in that the control unit further includes master maintenance means for registering data of the event master and the customer unit product price master by event.

  Further, the commodity unit price acquiring device according to the present invention is characterized in that the event master defines events by classifying them into a plurality of hierarchical structures, and the lowest class is an event code.

  In addition, the method of acquiring a product unit price according to the present invention is performed by a product unit acquisition device that includes a storage unit and a control unit and acquires a product unit price for each event such as an individual business meeting or an exhibition held for a specific customer. An event master which defines a class of the event, an event code classified by the event master, a customer code and a product code in the storage unit. An event-specific customer unit price master in which a different customer-specific product unit price is registered is stored, and an order number is input at the time of order entry executed by the control unit. An order input step of acquiring a sales unit price from the customer unit price master according to the event based on the preceding code and the product code, and the event code based on the order number input at the time of inputting the order, A sales entry step of accounting for sales using the obtained sales unit price, and a journal linking step of performing journal entry for grasping profit and loss for each event in conjunction with the event code of the sales information for which sales are included. Features.

  In addition, the product price acquisition program according to the present invention is executed by a product price acquisition device that includes a storage unit and a control unit, and that acquires a product price for each event such as an individual business meeting or an exhibition held for a specific customer. A product unit price acquisition program for causing the storage unit to link an event master defining the event classification, an event code classified by the event master, a customer code, and a product code. A customer unit price for each event, in which customer unit prices for each event are registered, is stored, and an order number is input at the time of order entry for execution by the control unit, and the event code, An order entry step of acquiring a sales unit price from the event-specific customer unit price master based on the customer code and the product code; and A sales inputting step of recording sales using the event code and the acquired unit price, and a journal linkage for performing journal entry for grasping profit and loss for each event in conjunction with the event code of sales information for which sales have been recorded. And step.

  ADVANTAGE OF THE INVENTION According to this invention, there exists an effect that the product price sold at an event, such as an individual business meeting or an exhibition, and a general selling price can be set and the product unit price can be set.

FIG. 1 is a block diagram illustrating an example of a configuration of a unit price acquisition device according to the present embodiment. FIG. 2 is a diagram illustrating an example of the event master. FIG. 3 is a diagram showing an example of a merchandise unit price master by event and by customer. FIG. 4 is a diagram illustrating an example of the relationship between the event master, the event-specific customer unit price master, and each input data. FIG. 5 is a diagram showing an example of a process for performing from order entry to journal entry cooperation using the event master and the event-specific customer unit price master. FIG. 6 is a diagram illustrating an example of a form of a merchandise unit price master list by event and by customer.

  An embodiment of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited by the present embodiment.

[1. Overview]
In the conventional sales management system, a function for acquiring a unit price for each supplier and each product and each period was implemented, but control could not be performed for each event type.

  Therefore, apparel trading companies have demanded that the prices of products to be opened at individual business meetings and exhibitions held for specific customers be different from prices sold at normal times. There are also channels such as wholesale, in-store, and EC (Electronic Commercial) sites in sales forms, and there has been a request to make a difference in product prices depending on the difference in these sales forms. For this reason, the commodity unit price acquisition apparatus according to the present embodiment increases the acquisition key of the unit price master by at least one, thereby increasing the commodity price in an event for a specific customer, or the automatic unit price for each channel due to a difference in sales form. This makes acquisition feasible.

[2. Constitution]
An example of the configuration of the unit price acquisition device according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram illustrating an example of a configuration of a unit price acquisition device according to the present embodiment.

  The product unit price acquisition device 100 is a commercially available desktop personal computer. In addition, the product price acquisition device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like. It may be a type information processing device.

  The product price acquisition device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the unit price acquisition device 100 is communicably connected via an arbitrary communication path.

  The communication interface unit 104 communicably connects the unit price acquisition 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 unit price acquisition device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

  The storage unit 106 stores various databases, tables, files, and the like. In the storage unit 106, a computer program for performing various processes by giving instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used. Here, the storage unit 106 includes an event master 106a, a customer unit price master 106b by event, and the like.

  The event master 106a is a master that defines the event classification. For example, as shown in FIG. 2, the event master 106a has three hierarchical structures such as "sales channel" as a large category, "event type" as a middle category, and "event code" as a small category. By specifying the "event code" of the lowest layer, what kind of event can be specified. Here, the number of hierarchical structures is three, but it is merely an example, and it may be defined by classifying into two or four or more hierarchical structures.

  The event-specific customer unit price master 106b is a master in which the event code classified by the event master, the customer code and the product code are linked, and the event-specific customer unit product price is registered. For example, as shown in FIG. 3, the event-specific customer unit price master 106b includes “event code”, “customer code”, “article code”, “application start date”, “application end date”, and “application end date”. Sales unit price ”is registered. Therefore, by specifying the "event code" defined in the event master 106a in addition to the "customer code" and the "product code", the "sales unit price" for each event can be obtained.

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

  The control unit 102 is a CPU or the like that controls the merchandise unit price acquisition device 100 as a whole. 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 types of information processing based on the stored programs. Execute. Here, the control unit 102 functionally conceptually includes an order input unit 102a as an order input unit, a sales input unit 102b as a sales input unit, a journal link unit 102c as a journal link unit, and an output unit 102d as an output unit. And a master maintenance unit 102e as master maintenance means.

  The order input unit 102a inputs an order number at the time of inputting an order and specifies an event code, a customer code, and a product code, and based on these, the customer by event registered in the product unit price master by event customer based on these. Get another product price automatically. For example, when the order input unit 102a specifies "event code" in the order header data when inputting an order, the event master 106a determines the "sales channel" and the "event type" associated with the "event code". Also, the order input unit 102a specifies the “customer code” in the order header data and the “product code” in the order detail data, and thereby stores the event registered in the event-specific customer unit price master 106b. Automatically acquire the "sales unit price" of products for different customers.

  The sales input unit 102b records sales using the event code and the sales unit price of the acquired product based on the order number input at the time of inputting the order. For example, the sales header data of the sales input unit 102b holds “order number” and “event code”, and the sales detail data holds “sales unit price” for which sales have been recorded. As described above, even when the sales are recorded, the “event code” inherited from the order information is held as the sales information.

  The journal coordinating unit 102c performs journal entry for grasping the profit and loss for each event in conjunction with the event code of the sales information in which the sales are recorded. For example, the journal linking unit 102c realizes the profit and loss of each event by linking the event code with the “event code” (or the “sales channel” or “event type” associated therewith) as the analysis code of the sales item. can do. In other words, the journal linking unit 102c creates “debit analysis code” and “credit analysis code” as “event code” in the journal detail data, and adds “event code” to the sales item that performs journalizing. Thus, it is possible to grasp the profit and loss for each event simply by looking at the journal.

  The output unit 102d outputs a list of event-specific customer unit-specific product prices set in the event-specific customer-specific unit price master 106b. For example, when the output unit 102d wants to check the event-specific customer unit price set in the event-specific customer unit price master 106b, the output unit 102d can display the list on the monitor 114 or output a form. . FIG. 6 is an output example of a product unit price master list by event and by customer.

  The master maintenance unit 102e registers data of the event master 106a and the customer unit price master 106b by event. For example, the master maintenance unit 102e changes the “event (sales channel, event type, event code)”, “customer code”, “product code”, “sales unit price” registered in the master, or newly changes the event. When data is added, the administrator can always maintain the latest data by performing master maintenance every time.

[3. Concrete example]
With respect to a specific example of the present embodiment, an example of processing of the product unit price acquisition device 100 according to the present embodiment will be specifically described with reference to FIGS. FIG. 2 is a diagram illustrating an example of the event master. FIG. 3 is a diagram showing an example of a merchandise unit price master by event and by customer. FIG. 4 is a diagram illustrating an example of the relationship between the event master, the event-specific customer unit price master, and each input data. FIG. 5 is a diagram showing an example of a process for performing from order entry to journal entry cooperation using the event master and the event-specific customer unit price master. FIG. 6 is a diagram illustrating an example of a form of a merchandise unit price master list by event and by customer.

  As shown in FIGS. 2 and 3, the administrator of the product unit price acquisition device 100 according to the present embodiment uses the master maintenance unit 102e in advance to store the data of the event master 106a and the event-specific customer unit price master 106b. register. As shown in FIG. 2, the event master 106a further includes a “sales channel” that roughly categorizes the event, a “event type” that is a detailed category of the event, and an event type that further defines the event. It has a three-stage hierarchical structure, such as the "event code" of the subdivided subdivision. As shown in FIG. 3, the event-specific customer unit price master 106b includes “event code” as a key, and includes “customer code”, “product code”, “application start date”, and “application end date”. "Sales unit price" is set in accordance with "".

  As shown in FIGS. 3 to 5, the product unit price acquisition device 100 according to the present embodiment specifies an “event code” and a “customer code” in order header data of an order input by an order input unit 102a, and By specifying "product code" in the data, the product unit price for each event type customer is automatically acquired from the event-specific customer unit price master 106b.

  For example, as shown in the event-specific customer unit price master 106b in FIG. 3, the “event code” is designated as “201802SS”, the “customer code” is designated as “T1001”, and the “product code” is designated as “S0001”. Then, “sales unit price” “1,500” is automatically acquired.

  Also, if the “event code” “201802SS” and the “product code” “S0001” in the event-specific customer-specific product unit price master 106b in FIG. 3 are left as they are and the “product code” is designated as “S0002”, the “sales unit price” "" 1,550 "is automatically acquired.

  Furthermore, if the “event code” “201802SS” and “product code” “S0001” in the event-specific customer-specific product unit price master 106b in FIG. 3 are left as they are and the “product code” is designated as “S0003”, the “sales unit price” "" 1,400 "is automatically acquired.

  Subsequently, as shown in FIG. 5, the sales input unit 102b of the product unit price acquisition device 100 according to the present embodiment, as shown in FIG. Sales are calculated using the “sales unit price”. At this time, as shown in FIG. 4, the sales header data of the sales input unit 102b holds the “event code” inherited from the order information, and the sales specification data includes the “sales unit price” recorded as the sales. Holding.

  Then, the journal linking unit 102c of the commodity unit price acquisition device 100 according to the present embodiment performs journal processing for grasping profit and loss for each event in conjunction with the “event code” of the sales information that has recorded sales. At this time, as shown in FIG. 4, the journal linking unit 102c links the “event code” (or “sales channel” and “event type”) as the analysis code of the sales item in conjunction with the journal. Accordingly, the journal linking unit 102c creates “debit analysis code” and “credit analysis code” as the “event code” in the journal detail data, and sets the sales item as in the journal example shown in FIG. Can be created with an event code added to the entry. As a result, the profit and loss for each event can be ascertained from the journal results.

  Further, as shown in FIG. 5, the output unit 102d of the product unit price acquisition device 100 according to the present embodiment, when the product unit price for each customer by event is registered in the product unit price master for customer by event 106b, If you want to check the registered contents, you can output a form. For example, FIG. 6 is an example in which a product unit price master list for each customer by event is output in a form, and “event code” “201802SS” is printed on the upper right of the product unit price master list for each customer by event. You can also check by looking at the list of unit prices opened at the store.

  As described above, according to the product price acquisition device 100 according to the present embodiment, when opening a store at an individual business meeting or exhibition in the apparel industry or the like and receiving an order from a buyer, the difference between the product price at the time of general sales and It is necessary to attach it, but by simply specifying the "event code" for the product unit price, the product unit price for each event can be automatically acquired.

  Further, according to the commodity unit price acquisition device 100 according to the present embodiment, the combination of the “event code” and the “customer code” is designated by using the event-specific customer unit price master 106b. Can also be automatically acquired.

  Furthermore, according to the product unit price acquisition device 100 according to the present embodiment, when it is desired to confirm the contents of the event-specific customer unit price registered in the event-specific customer unit price master 106b, the output unit 102d is used. It is possible to output a list of product unit prices for each event and for each customer.

  In the above embodiment, an example in which the unit price of each event in an individual business meeting or exhibition by an apparel trading company is automatically acquired has been described. However, the present invention is not necessarily limited to this. The present invention can be applied to any industry that requires a difference in service unit price.

[4. Other Embodiments]
The present invention may be embodied in various different embodiments within the scope of the technical idea described in the claims, in addition to the above-described embodiments.

  For example, of the processes described in the embodiment, all or some of the processes described as being performed automatically can be manually performed, or all of the processes described as being performed manually can be performed. Alternatively, it can be performed partly automatically by a known method.

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

  In the unit price acquisition device 100, the illustrated components are functionally conceptual, and need not necessarily be physically configured as illustrated.

  For example, all or any part of the processing functions provided in the product unit price acquisition device 100, particularly the processing functions performed by the control unit 102, are realized by the CPU and a program interpreted and executed by the CPU. And may be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium containing a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment. It is read mechanically by the device 100. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and configures the control unit 102 in cooperation with the CPU.

  Further, this computer program may be stored in an application program server connected to the product unit price acquisition device 100 via an arbitrary network, and all or part of the computer program may be downloaded as necessary. It is.

  Further, the program for executing the processing described in the present embodiment may be stored in a non-transitory 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 (registered). Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical Disc, Digital (Digital and Digital), DVD (Digital, Digital and Digital, etc.) Any "portable physical media It is intended to include.

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

  Various databases and the like stored in the storage unit 106 are storage devices such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Programs, tables, databases, web page files, and the like.

  The product unit price acquisition device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as an information processing device to which an arbitrary peripheral device is connected. Further, the product unit price acquisition device 100 may be realized by mounting software (including a program or data) for realizing the processing described in the present embodiment on the information processing device.

  Further, the specific form of the dispersion / integration of the apparatus is not limited to the illustrated one, and all or a part of the apparatus may be functionally or physically separated in arbitrary units according to various additions or the addition of functions. It can be configured to be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

  INDUSTRIAL APPLICABILITY The present invention is applicable to all types of industries and industries having a plurality of sales forms such as a wholesale trade and a trading company, and in particular, a sales management system for selling at individual business meetings and exhibitions such as the apparel industry. Useful for such things.

100 Commodity Unit Price Acquisition Device 102 Control Unit 102a Order Input Unit 102b Sales Input Unit 102c Journal Linkage Unit 102d Output Unit 102e Master Maintenance Unit 104 Communication Interface Unit 106 Storage Unit 106a Event Master 106b Product Unit Price Master by Event 108 Input / Output Interface Part 112 Input device (keyboard)
114 Output device (monitor)
200 server 300 network

Claims (6)

A product price acquisition device comprising a storage unit and a control unit, wherein the product price acquisition device acquires a product price for each event such as an individual business meeting or an exhibition held for a specific customer,
In the storage unit,
An event master defining the event classification;
An event code classified by the event master, an event customer-specific product unit price master in which an event-specific customer unit price in which a customer code and a product code are linked is registered,
Is stored,
The control unit includes:
An order number is inputted at the time of order entry, the event code, the customer code, and an order input means for acquiring a sales unit price from the product unit master by customer according to the event based on the product code,
Based on the order number input at the time of inputting the order, based on the event code, the sales input means for recording sales using the acquired sales unit price,
Journal linking means for journalizing the profit and loss for each event in conjunction with the event code of sales information that has recorded sales,
A unit price acquisition device characterized by comprising: The control unit includes:
The apparatus according to claim 1, further comprising an output unit configured to output a list of customer unit price for each event set in the customer unit price for each event. The control unit includes:
3. The apparatus according to claim 1, further comprising: a master maintenance unit configured to register data of the event master and the commodity price master by customer for each event. 4. The event master,
Events are defined by classifying them into a plurality of hierarchical structures, and the lowest class is used as event codes.
The unit price acquisition device according to any one of claims 1 to 3, wherein: A method for acquiring a product unit price, comprising a storage unit and a control unit, the method being performed by a product unit price acquisition device that acquires a unit price for each event such as an individual business meeting or an exhibition held for a specific customer,
In the storage unit,
An event master defining the event classification;
An event code classified by the event master, an event customer-specific product unit price master in which an event-specific customer unit price in which a customer code and a product code are linked is registered,
Is stored,
Executed by the control unit,
An order number is input at the time of inputting an order, and the event code, the customer code, and an order input step of acquiring a sales unit price from the customer unit price unit master according to the event based on the product code,
Based on the order number input at the time of inputting the order, based on the event code, the sales input step of accounting for sales using the obtained sales unit price,
A journal coordination step of performing a journal to grasp profit and loss for each event in conjunction with the event code of the sales information that has recorded sales,
A method for obtaining a unit price of a product, comprising: A product unit price acquisition program that includes a storage unit and a control unit, and is executed by a product unit price acquisition device that acquires a product unit price for each event such as an individual business meeting or an exhibition held for a specific customer,
In the storage unit,
An event master defining the event classification;
An event code classified by the event master, an event customer-specific product unit price master in which an event-specific customer unit price in which a customer code and a product code are linked is registered,
Is stored,
To be executed by the control unit,
An order number is input at the time of inputting an order, and the event code, the customer code, and an order input step of acquiring a sales unit price from the customer unit price unit master according to the event based on the product code,
Based on the order number input at the time of inputting the order, based on the event code, the sales input step of accounting for sales using the obtained sales unit price,
A journal coordination step of performing a journal to grasp profit and loss for each event in conjunction with the event code of the sales information that has recorded sales,
A product price acquisition program characterized by including:

Images