CN114612035A - Data processing method and device based on table and electronic equipment - Google Patents
Data processing method and device based on table and electronic equipment Download PDFInfo
- Publication number
- CN114612035A CN114612035A CN202210194023.5A CN202210194023A CN114612035A CN 114612035 A CN114612035 A CN 114612035A CN 202210194023 A CN202210194023 A CN 202210194023A CN 114612035 A CN114612035 A CN 114612035A
- Authority
- CN
- China
- Prior art keywords
- commodity
- data
- inventory
- purchase
- list
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Tourism & Hospitality (AREA)
- Finance (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- General Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Accounting & Taxation (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a data processing method, a data processing device and electronic equipment based on a form, wherein the method is applied to the electronic equipment and comprises the following steps: acquiring a commodity purchase list, a commodity sales list and a commodity inventory list; extracting first data in the commodity purchasing detail table, extracting second data in the commodity selling detail table and extracting third data in the commodity inventory detail table; obtaining fourth data according to the first data, the second data and the third data, and generating a commodity purchase, sale and deposit report according to the fourth data, wherein the fourth data comprises commodity balance quantity and corresponding amount; and establishing association between the commodity purchase, sale and inventory statement and the commodity purchase statement, the commodity sale statement and the commodity inventory statement. The commodity purchase detailed list, the commodity sales detailed list and the commodity inventory detailed list are used for automatically generating the commodity purchase, sales and inventory report, so that the automatic data extraction and calculation can be realized according to the existing table, the commodity purchase, sales and inventory report can be obtained, the counting time is shortened, and the counting efficiency is improved.
Description
Technical Field
The present invention relates to the field of data processing, and in particular, to a method and an apparatus for processing data based on a table, and an electronic device.
Background
Nowadays, the social time is more and more precious, and enterprises are more and more urgent to want to improve the working efficiency of employees. For example, in the aspect of commodity statistics, if an enterprise resource planning system used by an enterprise is too old, the conventional excel table is required to be used for performing item statistics, and summary calculation is performed after the item statistics is completed.
Therefore, the inventor finds that in the process of invention creation, a data processing method based on a table is needed to be provided for conveniently and efficiently processing commodity purchase, sale and stock data.
Disclosure of Invention
The application provides a data processing method and device based on a form and electronic equipment. The commodity purchase detailed list, the commodity sales detailed list and the commodity inventory detailed list are used for automatically generating the commodity purchase, sales and inventory report, so that the automatic data extraction and calculation can be realized according to the existing table, the commodity purchase, sales and inventory report can be obtained, the counting time is shortened, and the counting efficiency is improved.
The embodiment of the invention provides the following technical scheme:
in a first aspect, an embodiment of the present invention provides a table-based data processing method, which is applied to an electronic device, and the method includes:
acquiring a commodity purchase list, a commodity sales list and a commodity inventory list;
extracting first data in a commodity purchasing list, second data in a commodity selling list and third data in a commodity inventory list, wherein the first data comprise commodity purchasing quantity and corresponding amount, the second data comprise commodity selling quantity and corresponding amount, and the third data comprise commodity inventory quantity and corresponding amount;
obtaining fourth data according to the first data, the second data and the third data, and generating a commodity purchase, sale and deposit report according to the fourth data, wherein the fourth data comprises commodity balance quantity and corresponding amount;
and establishing association between the commodity purchase, sale and inventory report and the commodity purchase, sale and inventory lists.
In some embodiments, the method further comprises:
acquiring a coding rule and a commodity information basic parameter of a commodity code, and generating a commodity code corresponding to the commodity according to the coding rule and the commodity information basic parameter of the commodity code;
acquiring a coding rule of a client code and a client information basic parameter, and generating a client code corresponding to a client according to the coding rule of the client code and the client information basic parameter;
and acquiring the encoding rule and the basic supplier information parameter of the supplier code, and generating the supplier code corresponding to the supplier according to the encoding rule and the basic supplier information parameter of the supplier code.
In some embodiments of the present invention, the,
the coding rule of the commodity code comprises at least one of a commodity brand, a commodity large class name, a commodity small class name and a serial number;
the encoding rule of the customer code includes at least one of a customer name, a customer category code, and a serial number;
the encoding rule of the supplier code includes at least one of a supplier name, a supplier level code, and a serial number.
In some embodiments of the present invention, the,
the commodity code is uniquely corresponding to the commodity and commodity information basic parameters, the customer code is uniquely corresponding to the customer and customer information basic parameters, and the supplier code is uniquely corresponding to the supplier and supplier information basic parameters.
In some embodiments, the method further comprises:
obtaining a commodity purchase list, comprising:
acquiring the commodity purchase quantity and the corresponding amount, and establishing a commodity purchase list according to the commodity purchase quantity and the corresponding amount, and the commodity code, the supplier code, the commodity information basic parameter and the supplier information basic parameter;
obtaining a commodity sales schedule comprising:
acquiring the commodity sales quantity and the corresponding amount, and establishing a commodity sales list according to the commodity sales quantity and the corresponding amount, as well as the commodity code, the customer code, the commodity information basic parameter and the customer basic parameter;
obtaining a list of inventory items, comprising:
and acquiring the inventory quantity of the commodities and corresponding amount, and establishing a commodity inventory list according to the inventory quantity of the commodities, the corresponding amount, the commodity codes and the commodity information basic parameters.
In some embodiments, the inventory purchase-sales report includes a time control, the method further comprising:
receiving a first instruction, wherein the first instruction is generated by triggering of a time control;
and changing the corresponding time of the commodity purchase, sale and inventory report according to the first instruction.
In some embodiments, after associating the merchandise purchase inventory statement with the merchandise purchase inventory statement, the merchandise sales inventory statement, and the merchandise inventory statement, the method further comprises:
acquiring the change information of a commodity purchase list, a commodity sales list and a commodity inventory list;
recalculating the fourth data according to the change information;
and updating the commodity purchase, sale and inventory report according to the recalculated fourth data.
In a second aspect, an embodiment of the present invention provides a table-based data processing apparatus, applied to an electronic device, where the apparatus includes:
the acquisition module is used for acquiring a commodity purchase list, a commodity sales list and a commodity inventory list;
the extraction module is used for extracting first data in the commodity purchase detailed table, second data in the commodity sale detailed table and third data in the commodity inventory detailed table, wherein the first data comprise commodity purchase quantity and corresponding amount, the second data comprise commodity sale quantity and corresponding amount, and the third data comprise commodity inventory quantity and corresponding amount;
the generation module is used for obtaining fourth data according to the first data, the second data and the third data and generating a commodity purchase, sale and inventory report according to the fourth data, wherein the fourth data comprises commodity balance quantity and corresponding amount;
and the association module is used for establishing association between the commodity purchase, sale and inventory statement and the commodity purchase detail list, the commodity sale detail list and the commodity inventory detail list.
In a third aspect, an embodiment of the present invention provides an electronic device, including:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform a method as in the first aspect.
In a fourth aspect, embodiments of the present invention provide a non-transitory computer-readable storage medium storing computer-executable instructions for enabling an electronic device to perform the method according to the first aspect.
The embodiment of the invention has the beneficial effects that: in contrast to the prior art, an embodiment of the present invention provides a table-based data processing method applied to an electronic device, where the method includes: acquiring a commodity purchase list, a commodity sales list and a commodity inventory list; extracting first data in the commodity purchasing detail table, extracting second data in the commodity selling detail table and extracting third data in the commodity inventory detail table; obtaining fourth data according to the first data, the second data and the third data, and generating a commodity purchase, sale and inventory report according to the fourth data, wherein the fourth data comprises commodity balance amount and corresponding amount; and establishing association between the commodity purchase, sale and inventory statement and the commodity purchase statement, the commodity sale statement and the commodity inventory statement. The commodity purchase detailed list, the commodity sales detailed list and the commodity inventory detailed list are used for automatically generating the commodity purchase, sales and inventory report, so that the automatic data extraction and calculation can be realized according to the existing table, the commodity purchase, sales and inventory report can be obtained, the counting time is shortened, and the counting efficiency is improved.
Drawings
One or more embodiments are illustrated by way of example in the accompanying drawings, which correspond to the figures in which like reference numerals refer to similar elements and which are not to scale unless otherwise specified.
FIG. 1 is a flow chart of a table-based data processing method according to an embodiment of the present invention;
FIG. 2 is a detailed flowchart of step S101 in FIG. 1;
FIG. 3a is a schematic diagram of a first portion of a merchandise purchase list of a table-based data processing method according to an embodiment of the present invention;
FIG. 3b is a second partial schematic diagram of a merchandise purchase list of a table-based data processing method according to an embodiment of the present invention;
FIG. 4a is a diagram of a first portion of a merchandise sales listing for a table-based data processing method according to an embodiment of the present invention;
FIG. 4b is a second partial schematic diagram of a merchandise sales listing for a table-based data processing method according to an embodiment of the present invention;
FIG. 5a is a diagram of a first portion of a merchandise inventory detail table of a table-based data processing method according to an embodiment of the present invention;
FIG. 5b is a second partial schematic diagram of a merchandise inventory detail table of a table-based data processing method according to an embodiment of the present invention;
FIG. 6a is a diagram of a first part of a commodity purchase, sale, and inventory report according to a table-based data processing method provided in an embodiment of the present invention;
FIG. 6b is a second partial schematic diagram of a commodity purchase, sale, and inventory report form of the table-based data processing method according to the embodiment of the present invention;
FIG. 7 is a block diagram of a table-based data processing apparatus according to an embodiment of the present invention;
fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, fig. 1 is a schematic flow chart illustrating a table-based data processing method according to the present invention;
as shown in fig. 1, the method is applied to an electronic device, and the method includes:
step S101: acquiring a commodity purchase list, a commodity sales list and a commodity inventory list;
specifically, by establishing a commodity purchase list, a commodity sales list, and a commodity inventory list in advance, establishing a commodity purchase list includes:
the method comprises the following steps of creating a commodity purchasing detail interface and a plurality of function buttons in a first application program, wherein each function button corresponds to one parameter, such as: the commodity purchase quantity, the commodity purchase amount, the commodity code, the supplier code, the commodity information basic parameter, the supplier information basic parameter and the like are obtained through acquiring the specific contents of the parameters, such as: and specific numerical values or information to establish a commodity purchasing list, wherein the acquisition mode comprises user input or import from a certain database.
Further, each function button may be triggered to filter the viewed object according to a selection rule, clicking a function button may trigger displaying a dialog box, displaying all parameter values related to the parameter in the dialog box, for example, clicking a product code function button may trigger the dialog box, displaying all entered product codes in the dialog box, selecting one or more specific parameter values to view, the selection rule may include that a parameter value of the parameter is equal to a specific text or a specific value, a beginning or an end of a parameter value of the parameter is equal to a specific text or a specific value, for example, a parameter corresponding to a function button is a product code, selecting a product code with a beginning of 10 by selecting the rule, directly inputting the product code to directionally select the product code to view information corresponding to the product code, or selecting a product to be viewed in a dialog box containing all product codes displayed after clicking the product code function button Code to view the corresponding information.
The specific steps of establishing the commodity sales list and the commodity inventory list are the same as the step of establishing the commodity purchase list, and the commodity sales list and the commodity inventory list established in the same step also have a plurality of functional buttons which are the same as or similar to the commodity purchase list, so the specific steps of establishing the commodity sales list and the commodity inventory list are not repeated herein.
Referring to fig. 2 again, fig. 2 is a detailed flowchart of step S101 in fig. 1;
as shown in fig. 2, the refinement flow of step S101 includes:
step S1011: acquiring the commodity purchase quantity and the corresponding amount, and establishing a commodity purchase list according to the commodity purchase quantity and the corresponding amount, and the commodity code, the supplier code, the commodity information basic parameter and the supplier information basic parameter;
the commodity code coding rule comprises at least one of a brand, a major name, a middle name, a minor name, a subclass name and a serial number, the brand, the major name, the middle name, the minor name, the subclass name and the serial number are represented by numbers in the commodity code, and the number of the numbers corresponding to the brand, the major name, the middle name, the minor name, the subclass name and the serial number can be freely set according to needs.
For example, if the encoding rule of the commodity code includes a brand, a major name, a middle name, a minor name, and a serial number, and the brand of the commodity corresponds to the number 01, the major name corresponds to the number 02, the minor name corresponds to the number 23, the minor name corresponds to the number 31, and the serial number corresponds to the number 01, then if the commodity code created according to the encoding rule of the brand + major name + middle name + minor name + serial number is 0102233101, the order of the brand, major name, middle name, minor name, and serial number in the encoding rule may be set in advance as needed in the actual creation process, and the number corresponding to the brand, major name, middle name, minor name, and serial number may be set freely as needed.
The encoding rule of the supplier code includes at least one of a supplier name, a supplier level code and a serial number, the supplier name, the supplier level code and the serial number are all represented by numbers, and the corresponding numbers of the supplier name, the supplier level code and the serial number can be freely set according to needs.
Further, the commodity information basic parameters include: a brand name, a major name such as an air conditioner, a middle name such as a cleaner, a minor name such as a plug-in type, a product model, a unit price, and the like2The flow number is, for example, A256. The unit refers to a unit of measurement of the product, such as a table, a box, or the like. The vendor information base parameters include: vendor name, vendor level code, etc.
Step S1012: acquiring the commodity sales quantity and the corresponding amount, and establishing a commodity sales list according to the commodity sales quantity and the corresponding amount, as well as the commodity code, the customer code, the commodity information basic parameter and the customer basic parameter;
wherein the encoding rule of the client code includes at least one of a client name, a client category code, and a serial number; the customer name, the customer category code and the serial number are represented by numbers in the customer code, and the number of the corresponding number can be freely set according to needs.
Further, the customer information basic parameters include: a customer name, such as company a, and a customer category code, such as level B.
Step S1013: and acquiring the inventory quantity of the commodities and corresponding amount, and establishing a commodity inventory list according to the inventory quantity of the commodities, the corresponding amount, the commodity codes and the commodity information basic parameters.
In steps S1011 to S1013, the product code uniquely corresponds to both the product and the information basic parameter of the product, the customer code uniquely corresponds to both the customer and the information basic parameter of the customer, and the supplier code uniquely corresponds to both the supplier and the information basic parameter of the supplier. And the customer code, the commodity code and the supplier code are all different from each other, namely have uniqueness.
Referring also to figures 3 a-5 b,
FIG. 3a is a schematic diagram of a first portion of a merchandise purchase list of a table-based data processing method according to an embodiment of the present invention;
FIG. 3b is a second partial schematic diagram of a merchandise purchase list of a table-based data processing method according to an embodiment of the present invention;
as shown in fig. 3a to 3b, the goods procurement details table includes a date, a supplier information base parameter including a supplier name, a goods information base parameter including a brand name, a major name, a minor name, a product model number, a unit, and a unit price, a goods code, a goods information base parameter, a goods procurement amount, and a remark.
Further, the merchandise purchase schedule may also include a supplier code and a supplier level code, wherein the supplier level code indicates a supplier level, e.g., a supplier level code of A indicates a supplier level of 1.
The commodity purchasing list is automatically generated by reading the data, so that the user can quickly know the purchasing condition of the commodity.
FIG. 4a is a diagram of a first portion of a merchandise sales listing for a table-based data processing method according to an embodiment of the present invention;
FIG. 4b is a second partial schematic diagram of a merchandise sales listing of a table-based data processing method according to an embodiment of the present invention;
as shown in fig. 4a to 4b, the commodity sales list includes a date, a customer information basis parameter including a customer name, a commodity code, a commodity information basis parameter including a brand name, a major name, a middle name, a minor name, a product model number, a unit, and a unit price, a commodity sales amount, and a remark.
Further, the merchandise sales list may further include a customer code and a customer category code, wherein the customer category code indicates a customer category, for example, a customer category code of B indicates a customer category of B.
The commodity sales list is automatically generated by reading the data, and the user can quickly know the sales condition of the commodity.
FIG. 5a is a diagram of a first portion of a merchandise inventory detail table of a table-based data processing method according to an embodiment of the present invention;
FIG. 5b is a second partial schematic diagram of a merchandise inventory detail table of a table-based data processing method according to an embodiment of the present invention;
as shown in fig. 5a to 5b, the goods inventory details table includes a goods code, goods information basic parameters, a goods inventory quantity, a goods inventory amount, and remarks, and the goods information basic parameters in the table include a goods name, a brand, a major name, a middle name, a minor name, a subclass name, a product model, a unit, and a unit price.
The inventory list of the commodities is automatically generated by reading the data, so that a user can quickly know the inventory condition of the commodities.
Through automatic generation commodity purchase list, commodity sales list and commodity inventory list, on the one hand, this application is generating these three tables according to the code rule automatic generation commodity code, can improve commodity statistical efficiency, reduces statistical time, and on the other hand, this application automatic generation commodity purchase list, commodity sales list and commodity inventory list can make things convenient for statistics personnel to look over the relevant condition of commodity as required, and do not need the manual work to make a table, have improved statistical efficiency.
Step S102: the method comprises the steps of extracting first data in a commodity purchasing list, extracting second data in a commodity selling list and extracting third data in a commodity inventory list, wherein the first data comprise commodity purchasing quantity and corresponding amount, the second data comprise commodity selling quantity and corresponding amount, and the third data comprise commodity inventory quantity and corresponding amount.
The first data comprises commodity codes and commodity purchase quantity and commodity purchase amount of commodities corresponding to the commodity codes, the second data comprises the commodity codes and commodity sales quantity and commodity sales amount of commodities corresponding to the commodity codes, and the third data comprises the commodity codes and commodity inventory quantity and commodity inventory amount of commodities corresponding to the commodity codes.
Wherein the item code is used to uniquely identify the item and is not the same as the customer code and the supplier code.
Step S103: and obtaining fourth data according to the first data, the second data and the third data, and generating a commodity purchase, sale and inventory report according to the fourth data, wherein the fourth data comprises commodity balance quantity and corresponding amount.
The generated fourth data includes the commodity code, and the commodity balance number and the corresponding amount of money of the commodity corresponding to the commodity code. The balance amount of the commodities is the sum of the purchase amount of the commodities, the sales amount of the commodities and the inventory amount of the commodities, and the balance amount of the commodities is the sum of the purchase amount of the commodities, the sales amount of the commodities and the inventory amount of the commodities.
For example, if the first data is the product code x, the product purchase amount of the product corresponding to x is 5, the purchase amount is 50, the second data is the product code x, the product sales amount of the product corresponding to x is 3, the sales amount is 60, the third data is the product code x, the product inventory amount of the product corresponding to x is 3, and the inventory amount is 40, then the fourth data obtained from the first data, the second data, and the third data is: the balance amount of the commodity corresponding to the commodity code x, x is 3, and the balance amount is 30.
Referring again to figures 6 a-6 b,
FIG. 6a is a diagram of a first part of a commodity purchase, sale, and inventory report according to a table-based data processing method provided in an embodiment of the present invention;
FIG. 6b is a second partial schematic diagram of a commodity purchase, sale, and inventory report form of the table-based data processing method according to the embodiment of the present invention;
as shown in fig. 6a to 6b, the goods purchase-sale-inventory report includes goods codes, goods information basic parameters, goods inventory quantity, goods inventory amount, goods sale quantity, goods sale amount, goods purchase quantity, goods purchase amount, goods balance quantity and goods balance amount. The commodity information basic parameters in the table comprise commodity names, brands, major names, middle names, minor names, subclass names, product models and units.
Optionally, the purchase-sale-inventory report may further include a customer code, a customer information basic parameter, a supplier code, a supplier information basic parameter, and the like.
Specifically, a function button is created in a first application program, a dialog box interface appears after the function button is clicked, and the first application program comprises Excel, a Wps table and the like; the function buttons comprise commodity code buttons, the commodity code buttons are used for being triggered to display a commodity code corresponding to each stored commodity on a dialog box interface so as to present the commodity code to a user, the user can select a commodity code to be checked on the dialog box interface, and unselected commodity codes and information corresponding to the unselected commodity codes, such as commodity names and commodity information basic parameters corresponding to the commodity codes, can not be displayed in a commodity purchase-sale-inventory report any more, wherein the commodity codes are defined in a digital form, for example: the N commodities correspond to N commodity codes, each commodity uniquely corresponds to one commodity code, the length of each commodity code is [1, N ], N is a positive integer, the specific length is determined by a coding rule of the commodity code, and the more information contained in the coding rule of the commodity code, the longer the length of the commodity code is.
Further, the function buttons further include a commodity name button, a brand button, a category name button, a subclass name button, a product model button, and a unit button, and the functions of the function buttons are similar to those of the commodity code button and are respectively used for checking and screening the commodity name, the brand name, the category name, the subclass name, the product model, and the unit, and therefore, the description thereof is omitted here. It should be noted that the commodity purchase-sale-stock report may further include a plurality of buttons having the same function, and the buttons may be set by themselves as needed.
Further, the commodity purchase, sale and inventory report form comprises a time control, and the method further comprises the following steps:
receiving a first instruction, wherein the first instruction is triggered and generated by a time control;
and changing the corresponding time of the commodity purchase, sales and inventory report according to the first instruction.
The first instruction is generated by triggering the time control, for example, the first instruction is generated by triggering the time control by operating a mouse, the first instruction can change the corresponding time of the commodity purchase, sale and inventory report, the unit of the corresponding time can be year, month and day, and the unit can include time, minute and second when necessary, for example, after receiving the first instruction, the corresponding time of the commodity purchase, sale and inventory report is switched from 12/1/6/5/6/second in 2021 to 11/2/8/3/6/8 in 2022 according to the first instruction. It should be noted that, after the switching time, the data counted in the commodity purchase-sale-inventory report may also be changed correspondingly.
Step S104: establishing association between the commodity purchase, sale and inventory statement and the commodity purchase statement, the commodity sale statement and the commodity inventory statement;
specifically, the association of the commodity purchase-sale-inventory report with the commodity purchase inventory, the commodity sale inventory and the commodity inventory refers to the synchronization of the change information to the commodity purchase-sale-inventory report after the commodity purchase inventory, the commodity sale inventory and the commodity inventory are changed.
After the association between the commodity purchase-sale-inventory statement and the commodity purchase inventory statement, the commodity sale inventory statement and the commodity inventory statement is established, the method further comprises the following steps:
acquiring the change information of a commodity purchase list, a commodity sales list and a commodity inventory list;
recalculating the fourth data according to the change information;
and updating the commodity purchase, sale and inventory report according to the recalculated fourth data.
Specifically, when the commodity purchase list, the commodity sales list and the commodity inventory list are changed, the first data, the second data and the third data included in the commodity purchase list, the commodity sales list and the commodity inventory list are also changed, so that the fourth data is recalculated according to the changed first data, second data and third data to update the commodity purchase-sale-inventory list, for example, when the sales quantity and the sales amount of a certain commodity in the commodity sales list are changed, the balance quantity and the balance amount corresponding to the commodity in the updated commodity purchase-sale-inventory list are also changed, and the balance quantity and the balance amount corresponding to the commodity are updated in the commodity purchase-sale-inventory list by the method.
The commodity purchase detailed list, the commodity sales detailed list and the commodity inventory detailed list are used for automatically generating and updating the commodity purchase, sales and inventory detailed list, so that the automatic data extraction and calculation can be realized according to the existing list, the commodity purchase, sales and inventory report can be obtained, the counting time is shortened, and the counting efficiency is improved.
Referring to fig. 7, fig. 7 is a schematic structural diagram of a table-based data processing apparatus according to an embodiment of the present invention;
the table-based data processing apparatus 200 is applied to electronic devices, where the electronic devices include terminals and controllers, and the like, the terminals include mobile terminals and fixed terminals, the mobile terminals include mobile phones, tablet computers, notebooks, and the like, and the fixed terminals include servers, computers, and the like.
As shown in fig. 7, the table-based data processing apparatus 200 includes an acquisition module 210, an extraction module 220, a generation module 230, and an association module 240.
The obtaining module 210 is configured to obtain a commodity purchase list, a commodity sales list, and a commodity inventory list;
the extracting module 220 is configured to extract first data in the commodity purchase detail table, second data in the commodity sale detail table, and third data in the commodity inventory detail table, where the first data includes a commodity purchase quantity and a corresponding amount, the second data includes a commodity sale quantity and a corresponding amount, and the third data includes a commodity inventory quantity and a corresponding amount;
the generating module 230 is configured to obtain fourth data according to the first data, the second data and the third data, and generate a commodity purchase, sale and inventory report according to the fourth data, where the fourth data includes a commodity balance number and a corresponding amount;
and the association module 240 is used for establishing association between the commodity purchase, sale and inventory statement and the commodity purchase detail table, the commodity sale detail table and the commodity inventory detail table.
In this embodiment of the present invention, the obtaining module 210 is further configured to:
acquiring a coding rule and a commodity information basic parameter of a commodity code, and generating a commodity code corresponding to the commodity according to the coding rule and the commodity information basic parameter of the commodity code;
acquiring a coding rule of a client code and a client information basic parameter, and generating a client code corresponding to a client according to the coding rule of the client code and the client information basic parameter;
acquiring a coding rule and a supplier information basic parameter of a supplier code, and generating a supplier code corresponding to a supplier according to the coding rule and the supplier information basic parameter of the supplier code;
the coding rule of the commodity code comprises at least one of a commodity brand, a commodity large class name, a commodity small class name and a serial number;
the encoding rule of the customer code includes at least one of a customer name, a customer category code, and a serial number;
the encoding rule of the supplier code includes at least one of a supplier name, a supplier level code, and a serial number;
the commodity code is uniquely corresponding to the commodity and commodity information basic parameters, the customer code is uniquely corresponding to the customer and customer information basic parameters, and the supplier code is uniquely corresponding to the supplier and supplier information basic parameters.
In this embodiment of the present invention, the obtaining module 210 is specifically configured to:
acquiring the commodity purchase quantity and the corresponding amount, and establishing a commodity purchase list according to the commodity purchase quantity and the corresponding amount, and the commodity code, the supplier code, the commodity information basic parameter and the supplier information basic parameter;
acquiring the commodity sales quantity and the corresponding amount, and establishing a commodity sales list according to the commodity sales quantity and the corresponding amount, as well as the commodity code, the customer code, the commodity information basic parameter and the customer basic parameter;
and acquiring the inventory quantity of the commodities and corresponding amount, and establishing a commodity inventory list according to the inventory quantity of the commodities, the corresponding amount, the commodity codes and the commodity information basic parameters.
In the embodiment of the present invention, the table-based data processing apparatus 200 further includes a time module, configured to receive a first instruction, where the first instruction is generated by triggering of a time control;
and changing the corresponding time of the commodity purchase, sales and inventory report according to the first instruction.
In an embodiment of the present invention, the table-based data processing apparatus 200 further comprises an updating module for, after associating the merchandise purchase-sale-inventory report with the merchandise purchase list, the merchandise sales list and the merchandise inventory list,
acquiring the change information of a commodity purchase list, a commodity sales list and a commodity inventory list;
recalculating the fourth data according to the change information;
and updating the commodity purchase, sale and inventory report according to the recalculated fourth data.
Since the apparatus embodiment and the method embodiment are based on the same concept, the contents of the apparatus embodiment may refer to the method embodiment on the premise that the contents do not conflict with each other, and are not described herein again.
Referring to fig. 8 again, fig. 8 is a schematic structural diagram of a table-based data processing apparatus according to an embodiment of the present invention;
as shown in fig. 8, the electronic apparatus 10 includes: one or more processors 11 and a memory 12, with one processor 11 being an example in fig. 8.
The processor 11 and the memory 12 may be connected by a bus or other means, and fig. 8 illustrates the connection by a bus as an example.
A processor 11 that acquires a commodity purchase list, a commodity sales list, and a commodity inventory list; extracting first data in the commodity purchasing detail table, extracting second data in the commodity selling detail table and extracting third data in the commodity inventory detail table; obtaining fourth data according to the first data, the second data and the third data, and generating a commodity purchase, sale and deposit report according to the fourth data, wherein the fourth data comprises commodity balance quantity and corresponding amount; and establishing association between the commodity purchase, sale and inventory statement and the commodity purchase statement, the commodity sale statement and the commodity inventory statement. The commodity purchase detailed list, the commodity sales detailed list and the commodity inventory detailed list are used for automatically generating the commodity purchase, sales and inventory report, so that the automatic data extraction and calculation can be realized according to the existing table, the commodity purchase, sales and inventory report can be obtained, the counting time is shortened, and the counting efficiency is improved.
The memory 12, which is a non-volatile computer-readable storage medium, may be used to store non-volatile software programs, non-volatile computer-executable programs, and modules, such as program instructions/modules of the table-based data processing method in the embodiments of the present application. The processor 11 executes various functional applications and data processing of the electronic device, i.e., implements the table-based data processing method of the above-described method embodiment, by running the nonvolatile software program, instructions and modules stored in the memory 12.
The memory 12 may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to use of the electronic device, and the like. Further, the memory 12 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some embodiments, the memory 12 optionally includes memory located remotely from the processor 11, which may be connected to the controller via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
One or more modules are stored in the memory 12, which when executed by the one or more processors 11 perform the table-based data processing method in any of the method embodiments described above, e.g. performing the method steps S101 to S104 in fig. 1 described above.
It should be noted that the above products can execute the method provided by the embodiments of the present application, and have corresponding functional modules and beneficial effects for executing the method. For technical details that are not described in detail in this embodiment, reference may be made to the methods provided in the embodiments of the present application.
Embodiments of the present application provide a non-transitory computer-readable storage medium, which stores computer-executable instructions, which are executed by one or more processors, such as one processor 11 in fig. 8, to enable the one or more processors to perform the table-based data processing method in any of the method embodiments described above, and perform the method steps S101 to S104 in fig. 1 described above.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; within the idea of the invention, also technical features in the above embodiments or in different embodiments may be combined, steps may be implemented in any order, and there are many other variations of the different aspects of the invention as above, which are not provided in detail for the sake of brevity; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and these modifications or substitutions do not depart from the spirit of the corresponding technical solutions of the embodiments of the present invention. Through the above description of the embodiments, those skilled in the art will clearly understand that the embodiments may be implemented by software plus a general hardware platform, and may also be implemented by hardware. It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program that can be stored in a computer-readable storage medium and that when executed, can include processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like.
Claims (10)
1. A data processing method based on a form is applied to electronic equipment, and is characterized in that the method comprises the following steps:
acquiring a commodity purchase list, a commodity sales list and a commodity inventory list;
extracting first data in the commodity purchase detailed table, second data in the commodity sales detailed table and third data in the commodity inventory detailed table, wherein the first data comprise commodity purchase quantity and corresponding amount, the second data comprise commodity sales quantity and corresponding amount, and the third data comprise commodity inventory quantity and corresponding amount;
obtaining fourth data according to the first data, the second data and the third data, and generating a commodity purchase, sale and storage report according to the fourth data, wherein the fourth data comprises commodity balance quantity and corresponding amount;
and establishing association between the commodity purchase, sale and inventory statement and the commodity purchase detail statement, the commodity sale detail statement and the commodity inventory detail statement.
2. The method of claim 1, further comprising:
acquiring a coding rule of a commodity code and a commodity information basic parameter, and generating a commodity code corresponding to the commodity according to the coding rule of the commodity code and the commodity information basic parameter;
acquiring a coding rule of a client code and a client information basic parameter, and generating a client code corresponding to the client according to the coding rule of the client code and the client information basic parameter;
acquiring an encoding rule of a supplier code and a supplier information basic parameter, and generating a supplier code corresponding to the supplier according to the encoding rule of the supplier code and the supplier information basic parameter.
3. The method of claim 2,
the coding rule of the commodity code comprises at least one of a commodity brand, a commodity large class name, a commodity small class name and a serial number;
the encoding rule of the customer code comprises at least one of a customer name, a customer category code and a serial number;
the encoding rule of the supplier code includes at least one of a supplier name, a supplier level code, and a serial number.
4. The method of claim 2, wherein the item code uniquely corresponds to both the item and the item information basis parameter, the customer code uniquely corresponds to both the customer and the customer information basis parameter, and the supplier code uniquely corresponds to both the supplier and the supplier information basis parameter.
5. The method according to any one of claims 2 to 4,
the acquiring of the commodity purchase list comprises the following steps:
acquiring commodity purchase quantity and corresponding amount, and establishing a commodity purchase list according to the commodity purchase quantity and the corresponding amount, the commodity code, the supplier code, the commodity information basic parameter and the supplier information basic parameter;
the acquiring of the commodity sales schedule includes:
acquiring the commodity sales quantity and the corresponding amount, and establishing a commodity sales list according to the commodity sales quantity and the corresponding amount, the commodity code, the customer code, the commodity information basic parameter and the customer basic parameter;
the acquiring of the inventory list of the goods comprises the following steps:
and acquiring the inventory quantity of the commodities and corresponding amount, and establishing a commodity inventory detail list according to the inventory quantity of the commodities, the corresponding amount, the commodity codes and the commodity information basic parameters.
6. The method of claim 1, wherein the inventory purchase-sale-inventory report includes a time control, the method further comprising:
receiving a first instruction, wherein the first instruction is triggered and generated by the time control;
and changing the corresponding time of the commodity purchase, sale and inventory report according to the first instruction.
7. The method of claim 1, wherein after associating the merchandise purchase-sale inventory report with the merchandise purchase inventory, the merchandise sales inventory, and the merchandise inventory, the method further comprises:
acquiring the change information of the commodity purchase list, the commodity sale list and the commodity inventory list;
recalculating the fourth data according to the change information;
and updating the commodity purchase, sale and inventory report according to the recalculated fourth data.
8. A form-based data processing apparatus for use in an electronic device, the apparatus comprising:
the acquisition module is used for acquiring a commodity purchase list, a commodity sales list and a commodity inventory list;
the extraction module is used for extracting first data in the commodity purchase detailed table, second data in the commodity sales detailed table and third data in the commodity inventory detailed table, wherein the first data comprise commodity purchase quantity and corresponding amount, the second data comprise commodity sales quantity and corresponding amount, and the third data comprise commodity inventory quantity and corresponding amount;
the generation module is used for obtaining fourth data according to the first data, the second data and the third data and generating a commodity purchase, sale and inventory report according to the fourth data, wherein the fourth data comprises commodity balance quantity and corresponding amount;
and the association module is used for establishing association between the commodity purchase, sale and inventory report and the commodity purchase detailed list, the commodity sale detailed list and the commodity inventory detailed list.
9. An electronic device, comprising:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method of any one of claims 1-7.
10. A non-transitory computer-readable storage medium having stored thereon computer-executable instructions for enabling an electronic device to perform the method of any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210194023.5A CN114612035A (en) | 2022-03-01 | 2022-03-01 | Data processing method and device based on table and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210194023.5A CN114612035A (en) | 2022-03-01 | 2022-03-01 | Data processing method and device based on table and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114612035A true CN114612035A (en) | 2022-06-10 |
Family
ID=81860162
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210194023.5A Pending CN114612035A (en) | 2022-03-01 | 2022-03-01 | Data processing method and device based on table and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114612035A (en) |
-
2022
- 2022-03-01 CN CN202210194023.5A patent/CN114612035A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111080208B (en) | BOM (bill of material) matching device and method, electronic equipment and storage medium | |
| CN110796416B (en) | Industrial networking based order processing method and computer storage medium | |
| CN106251178A (en) | Data digging method and device | |
| CN110990126A (en) | Method and device for realizing shortcut front-end service page based on js | |
| US20110276359A1 (en) | Information processing apparatus, cost forecast calculation method, and cost forecast calculation program | |
| CN110781235A (en) | Big data based purchase data processing method and device, terminal and storage medium | |
| CN104933601B (en) | A kind of method and apparatus exporting merchandise news | |
| US10672053B1 (en) | Systems, manufactures, and methods for comparative bid analysis and purchase order preparation | |
| JP2018005471A (en) | Information processing apparatus, information processing method, information processing program, and information processing system | |
| CN107464152A (en) | Data processing method, client and service end | |
| CN113362085A (en) | Primary and secondary account management method and system | |
| CN111178977B (en) | Potential customer thread display method, device and computer readable storage medium | |
| CN108959229A (en) | Planning report generation method, terminal and storage medium based on customer information | |
| CN112085537A (en) | Method and system for analyzing commodities based on big data | |
| CN114612035A (en) | Data processing method and device based on table and electronic equipment | |
| CN111126923A (en) | Material stagnation statistical method and device, storage medium and terminal equipment | |
| CN108021624B (en) | Method and device for displaying timeliness dynamic map | |
| CN113139835A (en) | Data processing method, data processing device, nonvolatile storage medium and processor | |
| CN111915405A (en) | Order management method and system | |
| CN107169845B (en) | Merchant attribute query method and device and server | |
| JP7471602B2 (en) | Information processing device and information processing method | |
| CN111126722A (en) | WeChat small program based commodity checking method | |
| CN115456739B (en) | Data management method and related device | |
| JP6307280B2 (en) | How to check sales pricing information | |
| CN110689409A (en) | Method and system for updating state of first-aid-purchase activity |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |