JPS61224075A - Output control system for form column - Google Patents

Abstract

PURPOSE:To display an optimum numerical value information and to use efficiently a form space by providing a column common to cumulative values and averages on a form and displaying either the cumulative value or the average value in this column at every item. CONSTITUTION:When monthly total data at every department is outputted, monthly total data is read to calculate the cumulative value in a prescribed period. It is discriminated whether monthly total data is displayed as the cumulative value or the average value. This discrimination is preliminarily determined in accordance with the classification of the item and is indicated by a flag in a form control file 51. If the cumulative value is selected by the discrimination of cumulative/average value at every item, the calculated cumulative value in the prescribed period is displayed, but if the average value is selected similarly, the cumulative value is divided by the number of months to calculate the monthly average value and it is displayed.

Description

[Detailed Description of the Invention] [Summary] In an electronic computer system, 1. When outputting item data in a predetermined form format, such as a profit and loss statement, to a printer, etc., a common column for cumulative total/average is provided on the form. 1. For example, when displaying information on several months' worth of item data on a form, you can select either the cumulative value or the monthly average value for each item as necessary.
A form field output control method that enables efficient use of form space is disclosed.

[Industrial application field]

The present invention relates to a processing method for outputting forms in a business management system for medium-sized chain stores such as supermarkets, and particularly improves space efficiency in form design related to cumulative values and average values of numerical items. This relates to a form column output control method. .

[Conventional technology]

FIG. 6 shows an example of a conventional business management system, and FIG. 7 shows an example of a system to which the present invention is considered.

For example, as shown in Figure 6, conventional business management systems include a sales management system 1 that manages sales, etc., a personnel and salary system 2 that manages salaries of employees, inventory management, non-operating income and expenditure data, etc. System 3 to manage
and a financial accounting system 4 that performs accounting processing based on the output data of these systems, and the processing is performed by an electronic computer.

However, in general, such systems have multiple stores in multiple regions, such as chain stores,
In the case of an organization where each store handles multiple product groups such as food, clothing, miscellaneous goods, etc., it is possible to manage the profit and loss of the company total or store total, but each store or processing center (P/C) 1 Department management on the headquarters side, etc. was not possible, and effective management information could not be obtained.

Therefore, the present inventors have considered a system as shown in FIG. In Figure 7, pB, sales management system 11 personnel salary system 2. The other systems 3 and financial accounting system 4 may be considered to be similar to the existing system shown in FIG.

10 is a journal interface file in which journal voucher data automatically journalized by the sales management system 1 etc. is stored; 11 is an update of the allocation standard when the amount entered as a company total or store total is allocated to each store department. Allocation standard value mask update file in which information is set, 12
13 is a display terminal for inputting journal entry slip data without going through the journal interface file 10;

14 is various profit and loss statements, 15 is journal entry slip for storage.

16 represents a financial interface file for passing journal data to the financial accounting system 4.

In the case of this system, a user can freely define an allocation standard according to sales volume, sales floor area, 9 people, etc. via the allocation standard value mask update file 11. In a configuration in which the store/department profit and loss management system 12 and the sales management system 1 etc. are not linked, the profit and loss management system 12 for each store and department can perform profit and loss management for two stores and departments even by inputting only from the display terminal 13. It is generalized so that it can be used.

By the way, in a system like the one shown in Figure 7, when calculating profit and loss for each store or department and outputting the results as a form to a printer, etc., it is possible to display various information regarding many items on one page of the form. is desired.

[Problem that the invention seeks to solve]

FIG. 8 shows an example of an output form for explaining the problems of the conventional method.

For example, when displaying items related to one year's worth of data on a form, there are cases where you want to see the cumulative value of data for each month and cases where you want to see the average value for September. For example, in the case of sales by nine divisions, both the cumulative value for two years and the monthly average value are meaningful information, but in the case of gross profit margin expressed as a percentage, the cumulative total of all Values are meaningless.

According to the conventional form output method, when sufficient space cannot be secured on the form 1, for example, in Figure 8 (A) or (
B) As shown in the figure, only either the cumulative value or the average value could be displayed. For example, the number of digits output per line by a printer is 136 digits, and since the number of output digits is limited, 1 For example, as shown in FIG. 8(C),
When outputting the cumulative total value and the average value side by side, space may be wasted, and other more important item data may be compressed, making it impossible to output them.

[Means for solving problems]

The present invention aims to solve the above problems and determines whether to display the cumulative value or the average value based on one item, and displays either the cumulative value or the average value in the same column on the form. provide the means. Therefore, the form structure output control system of the present invention is configured as shown in FIG. 1, for example.

In FIG. 1, a form format data storage unit 20 is a storage device that stores format control information regarding a form that has a common cumulative total/average tank 21 in which at least a cumulative value field and an average value field are shared. be. The item data storage unit 22 is a storage device that stores item data to be output.

The cumulative total/average division section 23 determines whether to output the cumulative total value or the average value regarding the data read from the 9-item data storage section 22.

The cumulative total display section 24 executes a process of displaying the cumulative total value regarding nine item data in the cumulative total/average common tank 21 of the form. The average display section 25 displays the cumulative total/average of the forms in the common tank 2.
In step 1, a process is executed to display the average value calculated for three items of data. The item data output unit 26 is
The item data edited nine times based on the data in the form format data storage section 20 is output to the printer 27.

[Effect]

Particularly 2, for example, output forms in a profit and loss management system for each store and department, to which the present invention is being considered.

It is used as business management information, and it is necessary to display a large number of two different items. According to the present invention, either the cumulative total display section 24 or the average display section 25 is selected by the cumulative total/average division section 23, and the cumulative total value is displayed in the cumulative total/average common tank 21 provided in common on the form. Or one of the average values is displayed. Therefore, for every two items, either the cumulative value or the average value, whichever is required, can be displayed within the number of digits for one item, and the space on the form can be used effectively.

〔Example〕

FIG. 2 is a block diagram related to one embodiment of the present invention;
5 and 4 are examples of output forms related to the present invention.
The figure shows a processing explanatory diagram of an embodiment of the present invention.

FIG. 2 shows a detailed block diagram of the parts particularly related to the store/department profit and loss management system 12 shown in FIG. 7. In FIG. 2, numerals 10, 11, 13 to 16 correspond to those shown in FIG.

The journal data manual section 30 executes a process of inputting journal slip data from the display terminal 13.

The input journal voucher data is stored in a journal voucher input monitor file 32 and a journal voucher accumulation file 33. The file set up section 31 stores these files 3.
2.33 initial setup and reorganization.

The data stored in the journal entry slip input monitor file 32 is output as a journal entry slip input monitor list 35 by the monitor list issuing unit 34.

The journal acceptance list issuing unit 36 calculates the total debits and total credits for the journal data stored in the journal slip accumulation file 33, and outputs a journal acceptance list 37 that allows checking for input errors.

The journal data in the journal ink face file 10 and the journal slip accumulation file 33 created by the sales management system are edited every 9 days by the journal data daily editing processing unit 38, and the edited journal results are the 2-edited journal. The first file 40° is stored in the post-edit journal entry second file 42 and financial interface file 16. The financial interface file 16 is a file in which data passed to the financial accounting system 4 shown in FIG. 7 is stored, and the financial accounting system 4 uses this financial interface file 16 to create a company-wide trial balance.

Output balance sheets, income statements, etc.

The journal entry slip issuing unit 43 prints out the journal entry slip 15 to be saved as accounting evidence based on the data stored in the nine-edited journal entry second file 42.

The allocation standard value mask update file 11 can store data for updating the allocation standard value for allocating the amount input as a company total or a store total to nine stores and departments. That is, rule data for allocating amounts and information on allocation of expenses such as personnel expenses are stored. The allocation reference value update processing unit 39 executes a process of updating the allocation reference value master 41 based on the contents of the allocation reference value mask update file 11.

The store/department allocation processing unit 45 allocates income and expenses to each store and department based on the journal data in the second edited journal first file 40 and the allocation standard value in the allocation standard value master 41. Execute the processing to charge. This allocation amount data is provided for each date for 200 stores, and is managed in the smallest unit for each department. Therefore, necessary data such as monthly totals for each store and force meters for each department can be obtained from this data at any time. This data is stored in the departmental allocation file 47 for each store.

Further, the common personnel expense file 46 stores expense data of common personnel expenses for one head office employee and the like.

The store/department breakdown aggregation unit 48 stores the common personnel expenses file 4.
61 Store/department distribution file 47. Allocation standard value master 4
1 to 1 store, nine departments, and a breakdown. This total result is a total of 50 totals for each store, department, and breakdown.
is stored in The total mask set-up section 49 performs initial setup of the total master 50.

The form control file 51 contains two stores 9 for the subjects to be output on each form.
This is a file that stores data specifying the form format for departments and their arrangement, and the departmental breakdown budget master 52 for two stores is for nine stores.

This is a file that stores budget data within a predetermined period by department and breakdown. These files 51.
52 is preset-amplified by a user or the like.

The various profit and loss statement issuing units 53 have tabulation masks 50 for each store and each department. Allocation standard value master 41. Form control file 5
19 Various profit and loss statements 14 etc. are issued and output based on the data of the budget master 52 for each store and department. For example, this output report includes: ■ Profit and loss statement by store/department ■ Profit and loss statement by department and store ■ Profit and loss statement by store ■ Profit and loss statement by department ■ Profit and loss statement by P/C department ■ P/C profit and loss statement・ ■ Expense statement by head office department ■ Operating expense statement by store etc. Furthermore, these forms can be output in various forms as necessary, such as a cumulative total from the beginning of the February total, a quarterly cumulative total, and a time series of the cumulative total of six months.

Figure 3 shows an example of an output report regarding the monthly profit and loss statement for one store/department.For store A, data such as sales, gross profit, gross profit margin, and total expenses are displayed for two meats, fruits and vegetables. , Fisheries, etc. are output by sector. Although 9 illustrations are omitted from this form.

For example, break-even point information, profit information per person, profit information per unit area of sales floor, inventory-related information, etc. are also output.

This report provides information about which departments in store A have good profit margins and which departments have room for improvement.

Similarly, Figure 4 shows an example of the output report for the monthly income statement for each department and store, and data such as sales, gross profit, gross profit margin, total expenses, etc. for the delicatessen department are shown. A
Stores such as Store B, Store B, Store 0, etc. are output together with the total for all stores and the average for all stores. This form provides business management information regarding which branches should be handled.

The present invention mainly relates to the various profit and loss statement issuing units 53 in FIG. The item data storage unit 22 shown in FIG. 1 corresponds to the store-by-department tally master 50 shown in FIG. 2. Further, the form format data storage unit 20 is
It is provided in the form control file 51.

Regarding the processing of the following 9 parts related to the present invention.

This will be explained according to FIG.

For example, when outputting monthly aggregated data by department,
First, the monthly total data is read in the process P1 shown in FIG. 5, and the cumulative value within a predetermined period is calculated in the process P2. Next, in process P3, it is determined whether the September total data is to be displayed as a cumulative value or as an average value. This distinction is predetermined based on the types of nine items and is indicated by a flag, for example, in the form control file 51 shown in FIG. Alternatively, nine judgment information may be provided as the logic of a processing program corresponding to nine items.

If it is found that the cumulative total value has been selected by determining the cumulative total/average classification for each item, the cumulative total value calculated in process P2 is displayed for that item in process P4. Further, if it is found that the average value has been selected, in process P5, the monthly average value is calculated by dividing the cumulative value by the number of months. Then, in process P6, the calculated monthly average value is displayed.

In addition, in order to allow the person viewing the form to easily distinguish whether the output is a cumulative value or an average value,
An appropriate identification mark may be added and displayed.

For example, there are nine hardware configurations for realizing the present invention.

a central processing unit (CPU) that fetches and executes instructions;
The device configuration may be a general-purpose computer system equipped with a main storage device, various peripheral devices, and the like.

〔Effect of the invention〕

As explained above, according to the present invention, a common tank for cumulative totals and averages is provided on the form for each item.

Either the cumulative value or the average value is displayed.

Depending on the item, the most appropriate numerical information can be displayed, and the space on the form can be used efficiently.

[Brief explanation of drawings]

FIG. 1 is a basic configuration diagram of the present invention, FIG. 2 is a block diagram related to an embodiment of the present invention, FIGS. 3 and 4 are examples of output forms related to the present invention, and FIG. 5 is a diagram of the present invention. FIG. 6 shows an example of a conventional business management system, FIG. 7 shows an example of a system to which the present invention is considered, and FIG. 8 shows a diagram explaining problems of the conventional system. In the figure, 20 is a form format data storage unit. 21 is a cumulative total/average common tank, 22 is an item data storage unit, 2
3 is a cumulative total/average division section, 24 is a cumulative total display section, 25 is an average display section, and 26 is an item data output section. 27 represents a printer. Patent Applicant: Fujitsu Ltd. Representative Patent Attorney Hiroshi Mori 1) (1 other person) 5th Leap

Claims (1)

[Claims] In a form field output control method in a system for outputting numerical data to predetermined item fields on a form based on a predetermined form format using an electronic computer, at least a cumulative value field and an average value field are provided. A form format data storage unit (20) that stores format control information regarding a form that has a cumulative total/average common field (21) in which the value field is shared; and item data that stores item data to be output. Storage part (
22), a cumulative total/average separation unit (23) that determines whether to output a cumulative value or an average value with respect to the data read from the item data storage unit (22), and the cumulative total/average common field. (21), a cumulative total display section (24) that displays the cumulative total value regarding the item data, and an average display section (25) that displays the average value calculated regarding the item data in the cumulative total/average common column (21). and an item data output section (26) that outputs item data edited based on data in the form format data storage section (20) to a printer (27).