JPH09305349A - Data output method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a data output method which facilitates the operation of a color output defining function for item data as to an output defining function for item data of a document, etc., and facilitates the data output defining function. SOLUTION: A CPU(central processing unit) 2 reads an article master file out of an article master memory 4b in a RAM(random access memory) 4 in a document display process as an output process for document data stored in a document data memory in the RAM 4. Then ordering-point quantities by articles set in the article master file are compared with the quantities of inventories and respective articles are colored and displayed on the basis of the comparison results according to color information on corresponding reference values among reference values set in a color control file memory 4c in the RAM 4.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data output method, and more particularly, to an output method in which cell data is changed in output form based on definition data set for a table composed of a plurality of cells. Data output method.

[0002]

2. Description of the Related Art In recent years, for example, various application programs such as spreadsheets and databases have been used in office computers and general-purpose computers mainly for office work, and tabulated data is output in various forms. It has a form output function that enables it.

Further, in order to output a form, it is necessary to set definition contents such as its format and output form. For example, the form definition function incorporated in the application program is used. , Set the form format, set the items and item definition contents to be output in this form, and set the record file name (table file name) in which the data to be output to the setting items is expanded, and design the output form It is done by the procedure such as setting above.

With the form set in such a procedure displayed on the screen, the type of data output for each cell expanded in the form is calculated from characters, numerical values, and a plurality of items. There are calculation results etc. Furthermore, as a conventional form definition function, a function to define the output form of data output in cell units in cell units is also provided.
By using this definition function, for example, it is possible to specify the output color of data in cell units.

[0005]

However, the output form definition function of cell data, which is one of the form definition functions built into various application programs such as conventional spreadsheets and databases, is not required for each cell unit. When using the function of defining the output form of the data to be output in cell units, it was necessary to set the definition contents in cell units, so the effort to set the definition contents of the output form was complicated, There is a problem that it is difficult to effectively use the cell data output form definition function.

Further, when changing the output form of the desired cell expanded in the form displayed on the screen, similarly, the labor for setting the definition contents of the output form is complicated. , It is difficult to use the output form definition function of cell data.

Further, in addition to coloring the cell data in the form as the definition contents of the output form, marking display, alarm display, etc. are possible, but the display contents on the screen become complicated and the displayed contents are not displayed. There is a problem that it becomes difficult to read.

An object of the present invention is to provide a data output method which facilitates the operation of the color output definition function of item data in the output definition function of item data such as a form and facilitates the use of the data output definition function. Is.

[0009]

According to the first aspect of the present invention,
Numerical data corresponding to the item is compared with the reference value set for this item, and the background color or character color of the item when displaying the item is changed and output according to the comparison result. A data output method, which provides a comparison result obtained by comparing the numerical data corresponding to the item with the reference value and a color definition table defining color information according to the comparison result, and numerical data corresponding to the item is provided. And a reference value set corresponding to this item are compared, the comparison result defined in the color definition table corresponding to this comparison result is determined, and the color defined in accordance with the corresponding comparison result. It is characterized in that the background color or the character color of the item is changed and output according to the information.

According to the data output method of the invention described in claim 1, the numerical data corresponding to the item is compared with the reference value set corresponding to this item, and the item is determined according to the comparison result. Is a data output method for changing and outputting the background color or the character color of the item when displaying, and comparing the numerical data corresponding to the item with the reference value, and according to the comparison result. A color definition table defining color information is provided, and numerical data corresponding to the above items,
Compared with the reference value set corresponding to this item, the comparison result defined in the color definition table to which this comparison result corresponds is discriminated, and according to the color information defined according to the corresponding comparison result. The background color or text color of the item is changed and output.

Therefore, it is possible to easily display the status of each item in a color-coded manner, so that the user can be alerted. Further, the display contents are not complicated, and a display screen that is easy to see can be displayed, and the display contents can be easily grasped.

Since a color definition table is provided separately,
Since the labor of defining the reference value and the color information for each item can be omitted and the setting can be freely performed, the color display mode can be arbitrarily set.

In this case, as in the invention described in claim 2, in the data output method according to claim 1, the numerical data corresponding to the item is the stock quantity of the product, and the reference value is the ordering point of the product. The quantity is defined as the quantity, and the comparison result of comparing the stock quantity of each product with the order point quantity and the color information corresponding to this comparison result are defined in the color definition table, and the stock quantity of each product is compared with the order point quantity. Then, the comparison result defined in the corresponding color definition table to which this comparison result corresponds is determined, and the background color or the character color of the product name is changed and output based on the color information defined according to the corresponding comparison result. You may do it.

According to the data output method of the present invention, the numerical data corresponding to the item is the stock quantity of the product, the reference value is the order point quantity of the product, and the stock quantity of each product. And the ordering point quantity are compared, and color information corresponding to the comparison result is defined in the color definition table, and the stock quantity and the ordering point quantity for each product are compared, and the comparison result is applicable. The comparison result defined in the color definition table is determined, and the background color or character color of the product name is changed and output based on the color information defined according to the corresponding comparison result.

Therefore, the stock status of each product can be easily displayed in a color-coded manner, and the user can be alerted. In addition, the display content is not complicated, and an easy-to-see display screen can be displayed, and the stock status of each product can be easily grasped.

Further, as in the invention described in claim 3,
2. The data output method according to claim 1, wherein the numerical data corresponding to the item is the credit limit amount of the customer, the reference value is the receivable balance of the customer, and the receivable for the credit limit amount of each customer. The balance ratio and color information corresponding to this ratio are defined in the color definition table, and the credit limit amount for each customer and the receivable balance are compared to obtain the ratio of the receivable balance to the credit limit amount. The ratio defined in the corresponding color definition table may be determined, and the background color or character color of the customer name may be changed and output according to the color information defined according to the corresponding ratio. .

According to the data output method of the third aspect of the present invention, the numerical data corresponding to the item is set as the credit limit amount of the customer, and the reference value is set as the receivable balance of the customer. The ratio of the receivable balance to the credit limit amount for each and the color information according to this ratio are defined in the color definition table, and the credit limit amount and the receivable balance for each customer are compared to the credit limit amount. The ratio of the accounts receivable balance is obtained, the ratio defined in the relevant color definition table to which this ratio is applicable is determined, and the background color or character color of the customer name is determined by the color information defined according to the applicable ratio. It is changed and output.

Therefore, the ratio of the balance of accounts receivable to the credit limit amount can be grasped for each customer name, the situation of the customer can be checked in advance, and the work efficiency can be improved.

According to a fourth aspect of the present invention, there is provided a data output method for outputting a graphic display corresponding to the data in a color according to the quantity, the quantity of the data and the quantity. A color definition table that defines color information according to the above is provided, the quantity of the data defined in the color definition table corresponding to the quantity of the data is determined, and the color information defined according to the quantity of the corresponding data is used. The feature is that the graphic display corresponding to the data is output in a color according to the quantity.

According to the data output method of the present invention as defined in claim 4, there is provided a data output method for outputting a graphic display corresponding to the data in a color corresponding to the quantity according to the quantity of the data. A color definition table that defines the quantity of data and color information according to this quantity is provided. The quantity of data defined in the color definition table corresponding to the quantity of the data is determined, and the quantity of the corresponding data is determined. According to the color information defined accordingly, the graphic display corresponding to the data is output in the color according to the quantity.

Therefore, the status of the data quantity can be grasped by the graphic color. Further, since the color definition table is provided separately, it is possible to omit the trouble of defining the quantity and the color information for each data, and the setting can be freely performed, so that the color display mode can be arbitrarily set.

In this case, as in the invention described in claim 5, in the data output method according to claim 4, the quantity of the data is the stock quantity of the product, and the ratio of the stock quantity to the standard value and this ratio Define the corresponding color information in the color definition table, compare the inventory quantity and reference value for each product,
Obtain the ratio of the stock quantity to the standard value, determine the ratio defined in the relevant color definition table to which this ratio applies, and set the inventory quantity of the product to that ratio using the color information defined according to the applicable ratio. The length and color of the corresponding bar graph may be changed and output.

According to the data output method of the present invention as defined in claim 5, the quantity of the data is the stock quantity of the product, and the ratio of the stock quantity to the standard value and the color information corresponding to this ratio are the color definition table. The stock quantity is compared with the standard value for each product, the ratio of the stock quantity to the standard value is obtained, the ratio defined in the relevant color definition table is determined, and the ratio is determined. According to the color information defined accordingly, the stock quantity of the product is output with the length and color of the bar graph changed according to the ratio.

Therefore, it is possible to grasp the stock status for each product, facilitate the next processing such as stocking a product with a small number of stocks, and improve the work efficiency.

Further, as in the invention described in claim 6,
The data output method according to claim 5, wherein a range is set for the reference value, color information corresponding to the range of the reference value is defined in the color definition table, and the color quantity is in accordance with the ratio of the stock quantity to the reference value. The colors in the bar graph that are output may be color-coded and output according to the color information defined according to the range of the reference value.

According to the data output method of the present invention, the range is set to the reference value, and the color information corresponding to the range of the reference value is defined in the color definition table. In the bar graph output according to the ratio of the stock quantity to, the color is output according to the color information defined according to the range of the reference value.

Therefore, it is possible to grasp the status of the stock quantity of each product, for example, by the color of the standard range of the proper stock quantity, and it is possible to perform more detailed stock management.

[0028]

Embodiments of the present invention will be described below in detail with reference to the drawings.

(First Embodiment) FIGS. 1 to 6 are views showing a computer system of a first embodiment to which the data output method of the present invention is applied.

First, the configuration will be described.

FIG. 1 is a block diagram showing a main configuration of a computer system 1 according to the first embodiment.

In FIG. 1, a computer system 1
Is composed of a CPU 2, an input unit 3, a RAM 4, a storage medium control unit 5, a storage device 6, a color printing unit 7 and a color display unit 8, and each unit is connected by a bus 9.

CPU (Central Processing Unit) 2
A window system program as a GUI stored in the storage device 6, an application program specified from various application programs corresponding to the window system, and various instructions or data input from the input unit 3 in the RAM 4. Various processes are executed in accordance with the application program stored in the RAM 4 in accordance with the input instruction and the input data, and the processing results are stored in the work memory 4a in the RAM 4 and the color display unit 8 is stored.
To be displayed. Then, the processing result stored in the work memory 4a is stored in a storage destination in the storage device 6 which is instructed to be input from the input unit 3.

Further, the CPU 2 reads the product master file stored in the product master memory 4b in the RAM 4 in the form display process described later as an output process of the form data stored in the form data memory 4b in the RAM 4, and The order point quantity for each product set in the product master file and the stock quantity are compared, and based on the comparison result, the corresponding reference value among the reference values set in the color control file memory 4c in the RAM 4 is determined. Each product name is color-coded and displayed according to the color information.

The input unit 3 includes a keyboard having cursor keys, numeral input keys, various function keys, and the like, and a mouse as a pointing device. The input unit 3 outputs to the CPU 2 a pressing signal of a key pressed by the keyboard. , The operation signal by the mouse is output to the CPU 2.

The RAM (Random Access Memory) 4 is
Work memory 4a for storing designated application programs, input instructions, input data, processing results, etc.
And a product master memory 4b for storing a plurality of product master files, and a color control file memory 4c for storing a color control file in which color control information corresponding to each product master file is set.

The storage medium control unit 5 has a function as a storage medium drive device for driving and controlling the storage medium 10 (for example, a floppy disk) shown in the figure, and drives the storage medium 10 according to an instruction from the CPU 2. When a write instruction is input, the designated data is written to a designated storage area in the storage medium 10, and when a read instruction is input, the designated data is read from the storage medium 10,
Write to a designated storage area in the RAM 4 or the storage device 6.

The storage device 6 has a storage medium in which programs and data are stored in advance, and this storage medium is composed of a magnetic or optical recording medium or a semiconductor memory. The storage medium is fixedly provided in the storage device 6 or is detachably mounted. The storage medium includes a window system program as the GUI, various application programs corresponding to the window system, and printing processing. A program and data processed by each processing program are stored.

Further, the program, data, etc. stored in this storage medium may be configured to be received and stored from another device connected via a communication line or the like, and further connected via the communication line or the like. A storage device provided with the storage medium may be provided on the other device side, and the programs and data stored in the storage medium may be used via a communication line.

The color printing section 7 prints out print data (form data, etc.) input from the CPU 2 in a designated color.

The color display section 8 is a CRT (Cathode Ray).
Tube), a liquid crystal display device, and the like, and display data input from the CPU 2 in a designated color.

Next, the operation of this embodiment will be described.

The form display process executed by the CPU 2 will be described with reference to the flowchart shown in FIG.

First, when the form display process is instructed by the input from the input unit 3 and the product master file to be displayed is designated, the CPU 2 starts the form display process, and the RA
A specified product master file, for example, as shown in FIG. 3B is read from the product master memory 4b in the M4, and is loaded into the work memory 4a in the RAM 4 (step S1). Then, the order point quantity set for each product name in the developed product master file of FIG. 3B and the stock quantity are compared (step S2), and the result of the comparison is "order point quantity <stock quantity. It is determined whether or not it is "(step S3).

If the stock quantity "20" is larger than the order point quantity "10" as indicated by the product name "AAAAAA" in FIG. 3B, the color control file memory 4c in the RAM 4 stores, for example, With reference to the color control file as shown in FIG. 3A, the product name "" is indicated by "green" set in the color column corresponding to "the number of stocks larger than the order point quantity" of the reference value a. "AAAAA" is drawn in green (step S4), and the process returns to step S1.

When it is determined in step S3 that the stock quantity is less than or equal to the order point quantity, it is judged whether or not the stock quantity has a relationship of "order point quantity ≧ stock quantity>0" (step). S5). The product name "BBBB" in FIG.
As indicated by B, the stock quantity is "5" and the "order point quantity is 1".
If there is a relationship of 5 ”≧ stock quantity“ 5 ”> 0”, RA
Referring to the color control file shown in FIG. 3 (A) stored in the color control file memory 4c in the M4, the color corresponding to the reference value b "the number of stocks below the order point quantity and 0 or more" The product name “B
BBBB "is drawn in yellow (step S6), and the process returns to step S1.

If the stock quantity is not in the relationship of "order point quantity ≧ stock quantity>0", the product name "CC" in FIG.
When the stock quantity is “0” as indicated by “CCC”, refer to the color control file shown in FIG.
The product name "CCCCC" is drawn in red by "red" set in the color column corresponding to the reference value c "stock quantity is 0" (step S7), and the product master developed in step S1 It is confirmed whether or not all the product names have been read from the file (step S8). If all the product names have not been read, the process returns to step S1, the product master read process and the subsequent steps S3 to S8 are repeatedly executed, and all product names have been read. In this case, as shown in FIG. 3C, the steps S4, S6 and S7 are performed.
The "commodity candidate" window including the contents drawn in step 3 is displayed on the currently displayed slip (step S9), and this processing ends.

As described above, in the computer system 1 of the first embodiment, in the form display process, the order point quantity set in the designated product master file to be displayed and the stock quantity are compared. Depending on the result, the product name is displayed in color in the color control file according to the color information predefined in correspondence with the comparison result, so that it is easy to identify and display the stock status of each product, for example. The user can be alerted. Further, the display contents are not complicated, and a display screen that is easy to see can be displayed, and the display contents can be easily grasped.

Since the color control file is separately provided, the labor of defining the reference value and the color information for each product can be omitted, and the setting can be freely performed. Therefore, the color display mode can be arbitrarily set. You can

Further, in addition to the contents (reference values) defined in the color control file shown in FIG. 3A, for example, a color control file defining contents (reference values) as shown in FIG. Conceivable. In the color control file of FIG. 4, the comparison contents of “input value” and “stock quantity” are defined in the reference value column, and the color information corresponding to the comparison contents of the reference value column is defined in the color column. There is. An example of the slip data displayed by using this color control file is shown in FIG. In FIG. 5, the product name “AAAA” is displayed according to the color information defined in the color column of the color control file in accordance with the result of comparison between the numerical value input in the quantity column and the stock quantity (not shown).
It indicates that "A" is displayed in green.

Such form display processing will be described with reference to the flowchart shown in FIG.

First, when the form display process is instructed by the input from the input unit 3 and the form data to be displayed is designated, the CPU 2 starts the form display process and the storage device 6 is operated.
The form data instructed from is read out, developed in the work memory 4a in the RAM 4, and displayed on the color display unit 8 as shown in FIG. Then, when the quantity is keyed in the quantity column in the displayed form data (step S11), the product master file corresponding to this form data is read from the product master file memory 4b in the RAM 4 (step S12).

Then, the input quantity is compared with the stock quantity set in the product master file (step S1).
3) It is determined whether or not the comparison result has a relation of "input quantity <stock quantity" (step S14). If the comparison result is "input quantity <stock quantity", the color corresponding to the line defined as "input value <stock" in the reference value column is referred to by referring to the color control file shown in FIG. Color information of "green" is acquired from the column, and the product name "AAAAAA" shown in FIG. 5 is drawn in green by this "green" (step S15).

The comparison result is "input quantity <stock quantity".
If the comparison result is "input quantity = stock quantity", it is determined whether or not the comparison result is "input quantity = stock quantity" (step S1).
6). If the comparison result shows the relationship of "input quantity = stock quantity", refer to the color control file shown in FIG. 4, and color corresponding to the line defined as "input value = stock" in the reference value column. The color information of "yellow" is acquired from the column, and the product name "AAAAAA" shown in FIG. 5 is drawn in yellow by this "yellow" (step S17).

The comparison result is "input quantity = stock quantity".
If the reference value is "input value>inventory" in the color control file of FIG. 4,
"Red" of the color information defined in the color column is acquired, and the product name "AAAAAA" shown in FIG. 5 is drawn in red by this "red" (step S18). Then, step S
It is confirmed whether all the product names have been read from the product master file read in step 12 (step S).
19). If all the product names have not been read, the process returns to step S12, the product master read process and the subsequent steps S13 to S18 are repeatedly executed, and all product names have been read. In this case, the “commodity candidate” window including the contents drawn in steps S15, S17 and S18 is displayed on the slip being displayed (step S2).
0), this process ends.

As described above, by using the color control file of FIG. 4 different from the one shown in FIG. 3, the color control file based on the color information defined by the comparison result of the input quantity and the stock quantity is used. It is also possible to display the product name in color.

(Second Embodiment) In the first embodiment, the products in the product master file are based on the relationship between the order point quantity and the stock quantity or the input quantity and the stock quantity in the product master file. The case where the name is displayed in color as a book candidate has been described, but in the second embodiment,
A case will be described in which the inventory quantity is compared with the appropriate inventory quantity in the commodity candidate list, and the ratio is displayed in a bar graph in color.

Since the computer system of the second embodiment is the same as that shown in FIG. 1 of the first embodiment, its illustration and configuration description are omitted.

First, in a slip inputting operation in inventory management of products, a product candidate list for selecting products is displayed as shown in FIG. 7A, and as shown in FIG.
A bar graph showing the ratio of the inventory quantity for each product is displayed in color. And, in the product master file, as shown in FIG.
As shown in (A), the "appropriate inventory quantity", the "minimum inventory stock quantity", and the "current inventory quantity" are registered in advance for each product. The registered "appropriate inventory quantity" is to be displayed in color. In addition, separately from this, a reference value which is a reference when a bar graph showing the ratio of the “current stock number” to the “appropriate inventory number” is displayed in color and the color information corresponding to the reference value are shown in FIG. ), The color control file is stored in the color control file memory 4c in the RAM 4. The bar graph of "stock quantity" is displayed in color according to the contents defined in this color control file.

The inventory display processing executed by the CPU 2 for displaying the "stock quantity" bar graph in color will be described with reference to the flowchart shown in FIG.

First, when the inventory display processing is instructed by the input from the input unit 3 and the product master file to be displayed is designated, the CPU 2 starts the inventory display processing, and the RA
For example, the instructed product master file shown in FIG. 8A is read from the inquired product master memory 4b in the M4 and expanded in the work memory 4a in the RAM 4 (step S31). Then, the current number of stocks for each product set in the developed product master file is compared with the appropriate inventory number and the minimum inventory stock (step S32), and it is determined from the comparison result whether the current inventory number is an excess inventory. Is determined (step S33).

When it is determined that the current number of stocks is an excess stock, the color control file shown in FIG.
"Blue" set in the color column corresponding to the standard value "when there is excess inventory" is acquired, and the length corresponding to the ratio of the current stock to the appropriate stock is acquired by this acquired "blue". 7 is drawn in blue as shown in FIG. 7B (step S34), and the process returns to step S31.

That is, the product name "BB" shown in FIG.
The stock quantity "60" of "BBB" is an excess stock, and a bar graph having a length corresponding to the ratio of the stock quantity to the proper stock quantity is displayed in blue.

When it is determined that the current number of stocks is not the excess inventory, it is determined whether or not the current number of stocks is ½ or more of the appropriate number of stocks (step S35). If the number of stocks is more than 1/2 of the proper stock quantity, refer to the color control file in FIG. 8B and respond to the standard value "when there is more than half of the proper stock quantity". "Green" that is set in the color column is acquired, and a bar graph of the length corresponding to the ratio of the inventory quantity to the appropriate inventory quantity is acquired by this acquired "Green",
Drawing in green as shown in FIG. 7B (step S3
6) and returns to step S31.

That is, the product name "AA" shown in FIG.
The inventory quantity "80" of "AAA" is more than half of the appropriate inventory quantity, and a bar graph with a length corresponding to the ratio of the inventory quantity to the appropriate inventory quantity is displayed in green.

If the current stock quantity is not more than 1/2 of the proper stock quantity, it is judged whether or not the current stock quantity is at least the minimum holding stock quantity and less than 1/2 of the proper stock quantity (step S).
37). If the current inventory is equal to or greater than the minimum number of stocks held and less than 1/2 of the proper stock quantity, the color control file in FIG. "Yellow" set in the color column corresponding to "A certain time" is acquired, and a bar graph having a length corresponding to the ratio of the inventory quantity to the appropriate inventory quantity is acquired by the obtained "Yellow", as shown in FIG. Draw in yellow as shown in (Step S3
8) and returns to step S31.

That is, the product name "DD" shown in FIG.
The stock quantity "20" of "DDD" is more than the minimum owned stock quantity and less than half of the proper stock quantity, and a bar graph having a length corresponding to the ratio of the stock quantity to the proper stock quantity is displayed in yellow.

If the current number of stocks is equal to or greater than the minimum number of stocks held and is not less than 1/2 of the appropriate number of stocks, the reference value in the color control file of FIG. 7B is obtained, and a bar graph having a length corresponding to the ratio of the inventory quantity to the appropriate inventory quantity is acquired by acquiring “red” of the color information defined in the color column, and FIG. Draw in red as shown in (Step S3
9).

That is, the product name "CC" shown in FIG.
The stock quantity “10” of CCC is the stock that is less than the minimum stock quantity, and a bar graph with a length corresponding to the ratio of the stock quantity to the proper stock quantity is displayed in red.

Next, it is confirmed whether or not all the product names have been read from the product master file read in step S31 (step S40). If all the product names have not been read, the process returns to step S31, the product master read process and the subsequent steps S32 to S39 are repeatedly executed, and all product names have been read. If so, the above step S3
4, step S36, step S38 and step S3
The "commodity candidate" window including the contents drawn in 9 is displayed on the slip being displayed (step S41), and this processing is terminated.

As described above, in the computer system according to the second embodiment, the ratio of the current stock number to the proper stock number is defined in the color control file for each product in the product master file by the inventory display process. Color information is acquired and a bar graph with a length corresponding to the ratio of the current stock to the appropriate stock is displayed in color, so the user can grasp the stock status for each product and the stock is small. It is possible to improve the work efficiency by facilitating the next processing such as purchasing of products.

Since the color control file is separately provided, the labor of defining the reference value and the color information for each product can be omitted, and the setting can be freely performed. Therefore, the color display mode can be set arbitrarily. You can

In the second embodiment, an example in which only the ratio of the current stock number to the proper stock quantity is displayed in color on the bar graph is shown. However, the ratio of the current stock quantity to the proper stock quantity is color-controlled. The color may be changed and displayed for each range of the reference value defined in the file.

For example, in the color control file shown in FIG. 10A, "blue" in the case of "appropriate inventory quantity-excess inventory" in the standard value and color column, "100% -50% of proper inventory quantity"
In the case of "green", in the case of "49% to 0% of the appropriate stock quantity" it is "yellow", in the case of "the minimum stock quantity is below" and "red", the display example shown in the same figure (B) A bar graph of the stock quantity for each product is displayed as shown in. That is, FIG.
In the one bar graph shown in FIG. 5, the range of the stock quantity corresponding to the range defined by each reference value of the color control file of FIG.

Therefore, it is possible to grasp the status of the stock quantity of each product for each color of the standard range of the proper stock quantity, and it is possible to perform more detailed stock management.

(Third Embodiment) In the first embodiment, the products in the product master file are based on the relationship between the order point quantity and the stock quantity or the input quantity and the stock quantity in the product master file. The case where the name is displayed in color as a book candidate will be described. In the second embodiment, the inventory quantity is compared with the appropriate inventory quantity in the commodity candidate list,
The case where the ratio is displayed in color in a bar graph has been described. However, in the third embodiment, the credit limit status is displayed in color for each customer name on the screen for entering the sales slip and the order data in the order sales management. The case of displaying will be described.

Since the computer system of the third embodiment is the same as that shown in FIG. 1 of the first embodiment, its illustration and configuration description will be omitted.

First, FIG. 11 shows a specific example of displaying the credit limit status in color for each customer name. FIG. 11A shows a case where the customer name “ABC store” selected from the customer list is displayed in the sales slip input screen in the color “yellow” that is color-displayed in the customer list. ing.

FIG. 9B is a RAM used to display the credit limit status in color for each customer name.
7 shows an example of a color control file stored in the color control file memory 4c in the above. In this color control file, a range of credit limit is defined in the reference value columns indicated by a to d, and color information corresponding to the credit limit range is defined in the color column. In the figure, each column indicated by "a" is "green" when "50% or less of credit limit amount", and each column indicated by "b" is "yellow green" when "51-79% of credit limit amount", "c". In the columns indicated by, "yellow" in the case of "80-99% of the credit limit amount", and in the columns indicated by d, "100% of the credit limit amount"
Is defined as "red".

FIG. 10C shows color information based on the credit limit amount range defined in this color control file.
An example of the displayed customer list is shown. In the customer name “AAA store” displayed in the customer list, the credit receivable amount is “1 million” and the receivables balance is “50,000”. The color control file “a” in FIG. Since this is the case, the customer name “AAA store” is displayed in green. Similarly, in the customer list, the customer name “ABC store” has a credit receivable amount of “1 million” and an accounts receivable balance of “850,000”, which corresponds to “c” in the color control file of FIG. , The customer name "ABC store" is displayed in yellow, and the customer name "BBC store" has a credit receivable amount of "1 million" and a receivable balance of "1.1 million". Since it corresponds to d in the control file, the customer name “BBC store” is displayed in red.

However, it is assumed that this customer list file is stored as a customer master file in the product master memory 4b in the RAM 4 of FIG.

In this way, when the status of the credit limit amount is color-displayed for each customer name in the customer list, the CPU
The credit limit display processing executed by No. 2 will be described based on the flowchart of FIG.

First, when the credit limit display process is instructed by the input from the input unit 3 and the customer master file to be displayed is designated, the CPU 2 starts the credit limit display process, and the commodity master memory in the RAM 4 is started. 4b, for example, the customer master file shown in FIG. 11C is read out and expanded in the work memory 4a in the RAM 4 (step S51). Then, the receivable balance for each customer name set in the expanded customer master file is compared with the credit limit amount (step S52), and the receivable balance is 50% of the credit limit amount from the comparison result. It is determined whether or not the following (step S53).

When it is determined that the balance of accounts receivable is 50% or less of the credit limit amount, the color control file shown in FIG. 11B is referred to, and the reference value "50 of the credit limit amount" is set.
"Green" set in the color column corresponding to "% or less" is acquired, and the customer name "AAA store" shown in FIG. 11C is drawn in green by the acquired "green" (step S5
4) and returns to step S51.

If it is determined that the accounts receivable balance is not less than 50% of the credit limit amount, it is determined whether or not the accounts receivable balance is 51 to 79% of the credit limit amount (step S55). When it is determined that the accounts receivable balance is 51 to 79% of the credit limit amount, the color control file shown in FIG. 11 (B) is referred to, and the reference value "51 to 79% of the credit limit amount" is set. Correspondingly, "yellowish green" set in the color column is acquired, and the customer name "ABC store" shown in FIG. 11C is drawn in yellowish green with the acquired "yellowish green" (step S56). ),
It returns to step S51.

Further, the accounts receivable balance is the credit limit amount of 51 to 7
If it is determined that it is not 9%, it is determined whether or not the balance of accounts receivable is 80 to 99% of the credit limit amount (step S57).
When it is determined that the balance of accounts receivable is 90 to 99% of the credit limit amount, the color control file shown in FIG. 11B is referred to, and the reference value “80 to 99% of the credit limit amount” is set.
“Yellow” set in the color column corresponding to is acquired, and the acquired “Yellow” is used to draw the customer name (there is no corresponding customer name shown in FIG. 11C) in yellow. Then (step S58), the process returns to step S51.

Further, the balance of accounts receivable is 80 to 9 which is the credit limit amount.
If it is determined that it is not 9%, the reference value in the color control file of FIG.
% "And" red "of the color information defined in that color column
And the customer name “BBC store” shown in FIG. 11C is drawn in red by the acquired “red” (step S
59).

Next, it is confirmed whether or not the reading of all the customer names from the customer master file read in step S51 is completed (step S60). If all the customer names have not been read, step S
Returning to step 51, the customer master reading process and the subsequent steps S52 to S59 are repeatedly executed, and when all the customer names have been read, the above steps S54, S56, and S58 are performed. Then, the "customer name list" window containing the contents drawn in step S59 is displayed on the slip being displayed (step S61), and this processing ends.

As described above, in the computer system according to the third embodiment, the credit limit display processing is performed so that the color control file is calculated from the ratio of the receivable balance to the credit limit amount for each customer name in the customer master file. The color information defined in is acquired, and the customer name is displayed in color in a color according to the credit limit amount range of the receivable balance, so the user can check the credit limit of the receivable balance for each customer name. The ratio to the amount of money can be grasped, the situation of the customer can be checked in advance, and the work efficiency can be improved.

Further, since the color control file is separately provided, it is possible to omit the trouble of defining the reference value and the color information for each customer, and the setting can be freely performed, so that the color display mode is arbitrarily set. be able to.

In the third embodiment described above, the customer name is displayed in color according to only the ratio of the balance of accounts receivable to the credit limit amount. The customer name may be displayed in color according to the content of the relationship, and an alarm may be displayed when the customer displayed in red is selected depending on the credit limit amount.

In the first and third embodiments described above, the case where the product name and the customer name are changed and displayed in different colors has been described. However, the character data of the product name and the customer name are set. The background color of the cells to be displayed may be changed and displayed.

[0093]

According to the data output method of the first aspect of the present invention, it is possible to easily display the status of each item in a color-coded manner, so that the user can be alerted. Also,
The display contents are not complicated, a display screen that is easy to see can be displayed, and the display contents can be easily grasped.

Since a color definition table is provided separately,
Since the labor of defining the reference value and the color information for each item can be omitted and the setting can be freely performed, the color display mode can be arbitrarily set.

According to the data output method of the second aspect of the present invention, the stock status of each product can be easily displayed in a color-coded manner, and the user can be alerted. In addition, the display content is not complicated, and an easy-to-see display screen can be displayed, and the stock status of each product can be easily grasped.

According to the data output method of the invention described in claim 3, the ratio of the balance of accounts receivable to the credit limit amount can be grasped for each customer name, and the situation of the customer can be checked in advance. Work efficiency can be improved.

According to the data output method of the fourth aspect of the present invention, the status of the data quantity can be grasped by the graphic color. Further, since the color definition table is provided separately, it is possible to omit the trouble of defining the quantity and the color information for each data, and the setting can be freely performed, so that the color display mode can be arbitrarily set.

According to the data output method of the invention described in claim 5, the stock status can be grasped for each product, and the next processing can be easily performed, such as stocking a product having a small number of stocks, Work efficiency can be improved.

According to the data output method of the invention described in claim 6, it is possible to grasp the status of the stock quantity of each product, for example, by the color of the standard range of the appropriate stock quantity, and perform more detailed stock management. be able to.

[Brief description of drawings]

FIG. 1 is a block diagram showing a main configuration of a computer system according to a first embodiment to which a data output method of the present invention is applied.

2 is a flowchart of a form display process executed by the CPU of FIG.

FIG. 3 is a diagram showing an example of a color control file, a product master file, and a display screen processed in the form display process of FIG.

FIG. 4 is a diagram showing another color control file according to the first embodiment.

5 is a diagram showing an example of slip data displayed according to the color control file of FIG.

FIG. 6 is the CP of FIG. 1 according to the color control file of FIG.
The flowchart of the form display process performed by U.

FIG. 7 is a diagram showing an example of a list of product candidates to be processed in the second embodiment to which the data output method of the present invention is applied.

FIG. 8 is a diagram showing an example of a product master file and a color control file used in the second embodiment.

FIG. 9 is a flowchart of inventory display processing executed by a CPU according to the second embodiment.

FIG. 10 is a diagram showing another color control file and a list of product candidates according to the second embodiment.

FIG. 11 is a diagram showing an example of a list of product candidates to be processed in the third embodiment to which the data output method of the present invention is applied.

FIG. 12 is a flowchart of a credit limit display process executed by a CPU in the third embodiment.

[Explanation of symbols]

 1 Computer System 2 CPU 3 Input Unit 4 RAM 4a Work Memory 4b Product Master Memory 4c Color Control File Memory 5 Storage Medium Control Unit 6 Storage Device 7 Color Printing Unit 8 Color Display Unit 9 Bus 10 Storage Medium

 ─────────────────────────────────────────────────── ─── Continuation of front page (72) Masayo Nakamura 3-2-1 Sakaemachi, Hamura-shi, Tokyo Casio Computer Co., Ltd. Hamura Technical Center (72) Inventor Kazuyasu Haraguchi 3-2-1 Sakaemachi, Hamura-shi, Tokyo No. 1 Casio Computer Co., Ltd. in Hamura Technical Center

Claims (6)

[Claims] 1. Numerical data corresponding to an item is compared with a reference value set corresponding to this item, and the background color or character color of the item when displaying the item is determined according to the comparison result. A data output method of changing and outputting, wherein a comparison result obtained by comparing the numerical data corresponding to the item with the reference value, and a color definition table defining color information according to the comparison result are provided, Compare the numerical data corresponding to and the reference value set corresponding to this item,
This comparison result determines the comparison result defined in the corresponding color definition table, changes the background color or the character color of the item according to the color information defined according to the corresponding comparison result, and outputs. Characteristic data output method. 2. Numerical data corresponding to the item is the stock quantity of the product, and the reference value is the ordering point quantity of the product,
The comparison result obtained by comparing the stock quantity and the order point quantity for each product and the color information corresponding to the comparison result are defined in the color definition table, and the stock quantity for each product and the order point quantity are compared. It is possible to determine the comparison result defined in the corresponding color definition table corresponding to the comparison result, and change the background color or the character color of the product name according to the color information defined according to the corresponding comparison result, and output. The data output method according to claim 1, which is characterized in that. 3. Numerical data corresponding to the above items is a credit limit amount of a customer, the reference value is a receivable balance of the customer, and a ratio of the receivable balance to the credit limit amount of each customer, Color information corresponding to this ratio is defined in the color definition table, the credit limit amount for each customer is compared with the accounts receivable balance, and the ratio of the accounts receivable balance to the credit limit amount is calculated. 2. The ratio defined in the color definition table is discriminated, and the background color or the character color of the customer name is changed and output according to the color information defined according to the corresponding ratio. Data output method. 4. A data output method for outputting a graphic display corresponding to the data in a color corresponding to the quantity according to the quantity of the data, wherein the quantity of the data and color information according to the quantity are output. The defined color definition table is provided, the quantity of the data defined in the color definition table corresponding to the quantity of the data is determined, and the graphic corresponding to the data is defined by the color information defined according to the quantity of the corresponding data. A data output method characterized in that the display is output in a color according to the quantity. 5. The quantity of the data is the stock quantity of the product,
The ratio of the stock quantity to the standard value and the color information corresponding to this ratio are defined in the color definition table, the stock quantity and the standard value are compared for each product, and the ratio of the stock quantity to the standard value is calculated. Determines the ratio defined in the applicable color definition table, and outputs the stock quantity of the product according to the color information defined according to the applicable ratio by changing the length and color of the bar graph according to the ratio. The data output method according to claim 4, wherein 6. A bar graph that sets a range for the reference value, defines color information according to the range of the reference value in the color definition table, and is output according to the ratio of the stock quantity to the reference value. 6. The data output method according to claim 5, wherein the contents are color-coded according to the color information defined according to the range of the reference value and output.