JPH01109472A - System for trace back-processing unit price in stock control system - Google Patents

Abstract

PURPOSE:To continuously execute a work for controlling commodity stock by setting a temporary unit price when the determining date of the unit price goes to be later than the updating date of a buying unit price, executing transaction and at a time point the unit price is determined, executing a data processing with tracing back to the updating date. CONSTITUTION:A storage means 1 with a commodity master file 11, which includes a contract unit price history part 11A, an order file 12 and an incoming and outgoing file 13 is provided. The temporary unit price is stored to the contract unit price history part 11A and used for the transaction up to the determining date of the new unit price. Then, the result of the transaction is stored by either method of attaching a notice to show the transaction of the temporary unit price or providing the storing area of the storage means for the transaction with the temporary unit price. When the unit price is determined, in concerning the transaction from the updating time of the unit price to the determining time of the unit price, the transaction is calculated as transacting contents by the new unit price with tracing back to the updating time. Then, the storing contents to be already stored are corrected. Thus, the leakage of account is prevented from being generated and reversely, a cost not to be counted is prevented from being counted.

Description

[Detailed Description of the Invention] [Industrial Application Field] The present invention relates to a unit price retrospective processing method, and in particular, when the determination date is later than the renewal date of the unit price of purchased goods, the determined unit price is corrected retroactively to the renewal date. This invention relates to a unit price retroactive processing method for an inventory management system.

[Conventional technology]

Traditionally, inventory management of goods, especially for consumables used in hospitals etc., has been subject to price fluctuations depending on market conditions, but instead of contracting and purchasing each time, it has been possible to manage supplies over a set period of time. , unit prices are determined in advance and purchased as needed.

This prevents on-hand inventory from taking up more than necessary,
Some products have expiration dates, and this is an effective method to avoid being affected by these expiration dates. Additionally, there are some products whose maximum and minimum prices are effectively regulated, and unit prices may be revised due to changes in these regulated amounts.

Therefore, we are forced to revise unit prices relatively frequently.
However, since unit price updates affect future prices, even if a unit price update is proposed, it cannot be decided immediately, and time is spent negotiating until the unit price is decided. takes a certain number of days.

For example, as shown in Figure 3, even if you decide to update the unit price on December 1st, the unit price will not be determined until March 15th of the following year. It is not realistic to suspend daily processing when the unit price has not been determined. Also, as shown in X-2 and X-3, the original practice is to manage inventory using the old unit price or provisional unit price, and then transfer the difference to cost price after the new unit price is determined, but in general, it is used as is in the books. It was being processed. Strictly speaking, therefore, problems may arise in recording costs.

[Problem that the invention attempts to solveThe problem that the invention attempts to solve is that, as mentioned above, when the unit price is undetermined, even if inventory is managed using the old unit price or provisional unit price, the cost price will not change after the new unit price is determined. Because the books were processed without transfer, there is a possibility that expenses that should have been recorded may not be recorded, or that expenses that should not have been recorded may be recorded.

SUMMARY OF THE INVENTION Accordingly, an object of the present invention is to provide a retroactive unit price processing method for a nighthawk management system that solves the above-mentioned drawbacks.

[Means for solving problems]

The unit price retroactive processing method of the inventory management system of the present invention uses an article master file that stores information necessary for ordering articles;
storage means including an ordering file for storing and managing the contents of orders for the goods, and a delivery/shipping file storing inventory information for the ordered goods; data for retroactively correcting the data stored in the storage means according to a predetermined program at the time of unit price determination when the unit price determination date is later than the unit price update date of the purchased item. The apparatus is configured to include a control means for issuing processing instructions and outputting the results, and a computer unit for executing corrections based on the specifications of the control means.

〔Example〕

Next, the present invention will be described with reference to drawings showing embodiments.

FIG. 1 is a block diagram showing the configuration of an embodiment of the present invention.

2 is a flow chart showing the operation of an embodiment of the present invention, and FIG. 3 is an explanatory diagram showing the background and results of the present invention.

First, an overview of the present invention will be explained.

Looking at Y-1 and Y-2 in Figure 3, if the unit price was changed on December 1st due to peripheral conditions, the unit price for transactions after December 1st will change from the old unit price before November 30th. Predict the amount that will be determined as the new unit price, and set an amount as close to this as possible as the tentative unit price for the transaction.

Next, this provisional unit price is stored in the contract unit price history section 11A in the article master file 11, and is used for transactions until the new unit price determination date. The result of this transaction is stored by either attaching an indicator that it is a transaction at a provisional unit price, or by providing a storage area of a storage means for transactions at a provisional unit price.

Once the unit price is determined (that is, the new unit price can be determined),
Transactions from the time of unit price update to the time of unit price determination are retroactively calculated as transaction details based on the new unit price, and the already stored memory contents are corrected (see FIG. 3 Y-1). In this way, daily processing is carried out using provisional unit prices, and when unit prices are determined, corrections are made once again to resolve problems in the bookkeeping.

Next, a configuration of an embodiment of the present invention will be described.

Referring to FIG. 1, in this embodiment, the contract unit price history section 11A
a storage means 1 comprising an article master file 11, an order file 12, and a delivery/issue file 13;
The control means 2 includes a T terminal 21 and a printer 22, and a computer unit 3, which are connected by a data bus 100.

These operations will be explained.

Usually, the article master file 11, the order file 12, and the delivery/output file 13 are stored on a magnetic tape, a magnetic disk, or an optical disk. In particular, the article master file 11 also includes a contract unit price history file IIA, which stores contract unit prices and provisional unit prices for each point in time. - Generally, article information including the contract unit price or provisional unit price is input from the CTR terminal 21 of the control means 2 and stored in the article master file 11. When ordering an article, the CTR terminal 21 stores the order details in the order file 12, and the printer 22 outputs an order slip. When the ordered goods are delivered, the results are recorded in the CR, and when the goods are shipped, the contents of the shipment are recorded in the CR.
It is stored in the delivery/issue file 13 from the T terminal 21. Even if you change the unit price here and temporarily set a provisional unit price, the storage location for the provisional unit price in the contract unit price history section 11A in the article master file ll must be specially separated from others. Items up to → are treated in the same way as staff aisle. When deciding on a new unit price, confirm the new unit price and decision date in the CR.
Input is made from the T terminal 21, retrospective processing of the ledger is performed according to a program prepared in advance, and the results are stored in respective corresponding files.

Next, the operation of one embodiment of the present invention will be explained in order with reference to flowcharts.

First, looking at FIG. 2, when the regulation conditions for the unit price of an article change (step 2), it is often necessary to update the unit price. If the unit price does not need to be updated, the conventional unit price is maintained, and if the unit price needs to be updated, the operation of step ■ continues (step ■).

If the new unit price has been determined on the contract renewal date (step ■)
, the new unit price is set and stored in the contract unit price history section 11A (step 2). If the new unit price has not been determined on the contract renewal date (step ■), first, if there is no transaction before the new unit price is determined, maintain the previous unit price, and even if there is a transaction (step ■), the old unit price will be maintained. Even when and the tentative unit price are the same,
The unit price is set as before, and only the fact that it is a provisional unit price is stored in the contract unit price history section IIA (step 2).

Next, if the old unit price and new unit price are not the same, a provisional unit price is set and stored in the contract unit price history section 11A (step ■).
. When the new unit price is determined (step 2), it is also stored in the contract unit price history section 11A (step 2). Here, the items stored in the storage means are retrospectively calculated for transactions from the decision to renew the contract to the determination of the new unit price (step 0), and unnecessary data stored in the storage means l is Remove (step ■).

Next, for transactions from the decision to renew the contract to the decision of the new unit price, we aggregate and correct the purchase amount based on the difference between the tentative unit price and the new unit price, and at the same time, compare the purchase amount between the old unit price and the new unit price. It is displayed on the CRT terminal 21 and outputted from the printer 22 in response to a request (step [phase]).

Note that the input of the CRT terminal 21 may be replaced with an OCR input or a bar code input, and the control means 2 has a data bus 1 for each of the management, ordering, and warehouse departments, for example.
It is also possible to perform inventory management by connecting the numbers with 00 and installing them.

〔Effect of the invention〕

As explained in detail above, the unit price retrospective processing method of the inventory management system of the present invention sets a provisional unit price when the unit price determination date is later than the purchase unit price update date when performing inventory management of goods. Since the transaction is carried out and the data processing is performed retroactively when the unit price is determined, it is possible to continue the goods inventory management work and also to be able to compare the purchase amount according to the old and new unit prices.

[Brief explanation of the drawing]

FIG. 1 is a block diagram showing the configuration of an embodiment of the present invention, FIG. 2 is a flowchart showing the operation of an embodiment of the present invention,
FIG. 3 is an explanatory diagram showing the background and results of the present invention. 1... Storage means, 2... Control means, 3
... Computer unit, 11 ... Goods master file, 11A ... Contract unit price history section, 2
1...CRT terminal, 22...Printer. Agent Patent attorney Susumu Uchihara: #Product master tough I2; Order thread 13: Delivery/output file too: De°-y Novus 11:
'E approx. may *Figure 1

Claims (1)

[Claims] An item master file that stores information necessary for ordering items, an ordering file that stores and manages the contents of orders for the items, and a delivery/delivery file that stores inventory information for the ordered items.
A storage means including a shipping file, and the inventory of goods is managed based on the data stored in the storage means, and when the unit price determination date is later than the update date of the unit price of the purchased goods, the unit price is determined in advance at the time of unit price determination. A control means for instructing data processing to retroactively correct data stored in the storage means according to a prescribed program and outputting the results; and a computer unit for executing corrections based on specifications of the control means. A unit price retroactive processing method for an inventory management system characterized by comprising: