Cross-account library age management method, apparatus, device, and medium

Abstract

The application relates to the technical field of warehouse age management, and discloses a cross-account set warehouse age management method, device, equipment and medium. The method comprises the following steps: in response to a received warehouse age analysis request, displaying a warehouse age analysis interface; in response to an account set selection operation on the warehouse age analysis interface, displaying materials to be analyzed contained in a target account set in the warehouse age analysis interface; based on the type of the target account set, performing adaptive warehouse age analysis on the materials to be analyzed to obtain target warehouse age information; and saving the target warehouse age information to the target account set. The embodiment of the application can perform combined analysis on multiple account sets, thereby improving the inventory management efficiency.

Description

Technical Field

[0001] This application relates to the field of inventory aging management technology, and in particular to a method, apparatus, equipment and medium for cross-account inventory aging management. Background Technology

[0002] In the modern business environment, inventory management is a crucial link in supply chain optimization. Effective inventory management not only ensures an adequate supply of goods to meet market demand but also reduces holding costs, minimizes capital tied up, and improves operational efficiency. In inventory management, warehouse managers, operations personnel, and finance staff typically need to regularly review the age of the company's existing inventory and assess its overall health to make decisions regarding warehousing planning, operational planning, and cost planning.

[0003] However, traditional inventory aging management methods primarily rely on manual records and basic spreadsheets to track inventory dates and arrival times. These methods have significant drawbacks in practice, including severe data update delays, frequent human errors, and difficulty in handling large-scale data processing demands. While some inventory aging management systems have achieved real-time inventory level monitoring with the evolution of information technology, these systems generally cannot integrate data from multiple independent accounting sets for unified analysis. For example, when enterprises involve different management dimensions such as company accounts, warehouse accounts, or regional accounts, existing technology lacks the ability to merge the inventory aging of materials across different accounting sets. This results in the planning, product, and warehouse management departments being unable to fully grasp the distribution of material aging across different accounting sets, thus affecting the scientific and timely nature of inventory decisions. This technological limitation makes it difficult for enterprises to effectively optimize their inventory structure, increasing inventory backlog and cash flow risks. Summary of the Invention

[0004] The purpose of this application is to provide a method, apparatus, equipment, and medium for cross-account set inventory aging management, which can perform combined analysis on multiple accounts, thereby improving inventory management efficiency.

[0005] This application provides a method for cross-account aging management, including: In response to a received inventory aging analysis request, the inventory aging analysis interface is displayed; In response to the account set selection operation for the inventory aging analysis interface, the inventory aging analysis interface displays the materials to be analyzed contained in the target account set; Based on the type of the target account set, adaptive inventory aging analysis is performed on the materials to be analyzed to obtain target inventory aging information; the type of the target account set includes company account set, warehouse account set, and regional account set. Save the target inventory age information to the target account set.

[0006] In some embodiments, the step of displaying the materials to be analyzed in the target account set included in the inventory aging analysis interface in response to an account set selection operation on the inventory aging analysis interface includes: The inventory aging analysis interface displays the account set selection operation area; In response to a trigger operation received in the account set selection operation area, the materials to be analyzed contained in the target account set are displayed.

[0007] In some embodiments, when the target accounting set is a company accounting set, the adaptive inventory aging analysis of the materials to be analyzed based on the type of the target accounting set includes: Based on the material code and company code of the material to be analyzed, retrieve the first inventory entry ledger; Based on the first inventory entry ledger, determine the first valid inventory entry date and the valid inventory quantity corresponding to the first valid inventory entry date of the material to be analyzed; Based on the first valid entry date and the current analysis date, the effective inventory days of the material to be analyzed are determined, and based on the effective inventory quantity and the effective inventory days, the monthly inventory quantity of the material to be analyzed is determined, thus obtaining the target inventory age information.

[0008] In some embodiments, when the target account set is a warehouse account set, the adaptive inventory aging analysis of the materials to be analyzed based on the type of the target account set includes: Based on the material code and warehouse code of the material to be analyzed, retrieve the second inbound ledger; Based on the second inventory entry ledger, determine the second valid inventory entry date and the valid inventory quantity corresponding to the second valid inventory entry date for the material to be analyzed. Based on the second valid entry date and the current analysis date, the effective inventory days of the material to be analyzed are determined, and based on the effective inventory quantity and the effective inventory days, the monthly inventory quantity of the material to be analyzed is determined, thus obtaining the target inventory age information.

[0009] In some embodiments, determining the monthly inventory level of the material to be analyzed based on the effective inventory level and the effective inventory days includes: Based on the effective inventory days, determine the monthly inventory range in which the effective inventory level falls; The effective inventory levels within the monthly inventory range are summed to determine the monthly inventory level of the material to be analyzed, thus obtaining the target inventory age information.

[0010] In some embodiments, when the target account set is a regional account set, the adaptive inventory aging analysis of the materials to be analyzed based on the type of the target account set includes: Based on the material code and region code of the material to be analyzed, retrieve the third inventory entry ledger; Based on the third inbound inventory record, determine the third valid inbound date of the material to be analyzed and the valid inventory quantity corresponding to the third valid inbound date; Based on the third valid entry date and the current analysis date, the effective inventory days of the material to be analyzed are determined, and based on the effective inventory quantity and the effective inventory days, the daily inventory quantity of the material to be analyzed is determined, thus obtaining the target inventory age information.

[0011] In some embodiments, determining the daily inventory level of the material to be analyzed based on the effective inventory level and the effective inventory days includes: Based on the effective inventory days, determine the daily inventory range in which the effective inventory level falls; The effective inventory levels within the daily inventory range are summed to determine the daily inventory level of the material to be analyzed, thus obtaining the target inventory age information.

[0012] This application embodiment also provides a cross-account set inventory aging management device, including: The first module is used to respond to the received inventory age analysis request and display the inventory age analysis interface; The second module is used to respond to the account set selection operation for the inventory aging analysis interface and display the materials to be analyzed contained in the target account set in the inventory aging analysis interface. The third module is used to perform adaptive inventory aging analysis on the materials to be analyzed based on the type of the target account set, and obtain target inventory aging information; the type of the target account set includes company account set, warehouse account set and regional account set; The fourth module is used to save the target inventory age information to the target account set.

[0013] This application also provides an electronic device, which includes a memory and a processor. The memory stores a computer program, and the processor executes the computer program to implement the above-described cross-account aging management method.

[0014] This application also provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the above-described cross-account aging management method.

[0015] The beneficial effects of this application are as follows: When cross-account set inventory aging management is required, by responding to user-initiated inventory aging analysis requests and providing an inventory aging analysis interface, users can select accounts for centralized analysis. Based on the type of the selected target account set, adaptive inventory aging analysis is performed on the materials to be analyzed within that target account set, and the obtained target inventory aging information is saved to the target account set. This achieves adaptive inventory aging management across accounts, effectively solving the technical problems of low data processing efficiency, poor accuracy, and the inability to perform cross-account set merged analysis in existing technologies, thereby improving inventory management efficiency. Attached Figure Description

[0016] Figure 1 This is a flowchart of the cross-account aging management method provided in the embodiments of this application.

[0017] Figure 2 This is a flowchart of a method for adaptive storage age analysis of the material to be analyzed, provided in the first embodiment of this application.

[0018] Figure 3 This is a flowchart of a method for adaptive storage age analysis of the material to be analyzed, provided in the second embodiment of this application.

[0019] Figure 4 This is a flowchart of a method for adaptive storage age analysis of the material to be analyzed, provided in the third embodiment of this application.

[0020] Figure 5 This is a schematic diagram of the cross-account aging management device provided in the embodiments of this application.

[0021] Figure 6 This is a schematic diagram of the hardware structure of the electronic device provided in the embodiments of this application. Detailed Implementation

[0022] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this application.

[0023] It should be noted that although functional modules are divided in the device schematic diagram and a logical order is shown in the flowchart, in some cases, the steps shown may be performed in a different order than the module division in the device or the order in the flowchart. The terms "first," "second," etc., in the specification, claims, and drawings are used to distinguish similar objects and are not used to describe a specific order or sequence.

[0024] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs. The terminology used herein is for the purpose of describing embodiments of this application only and is not intended to limit this application. Furthermore, the information, data, and signals involved in the embodiments of this application are all authorized by relevant parties or have been fully authorized by all parties, and the collection, use, and processing of related data comply with the relevant laws, regulations, and standards of the relevant countries and regions.

[0025] In traditional inventory management, the inventory aging analysis process is limited by the data processing architecture of a single account set. This prevents the automatic integration and unified view generation of inventory data from multiple account sets, making it difficult for planning, product, and warehouse departments to obtain complete material inventory aging distribution information, thus affecting the timeliness and accuracy of inventory decisions. Furthermore, existing technologies lack mechanisms for linking cross-account data, resulting in fragmented and inconsistent storage of inventory aging information, which cannot support multi-dimensional inventory health assessments. For example, in the supply chain operations of a manufacturing company, the company account set stores inbound records for global material codes and company codes, the warehouse account set stores real-time inventory data for material codes and warehouse codes, and the regional account set stores distribution information for material codes and regional codes. When finance personnel need to assess the overall inventory aging of a certain electronic component, the existing system requires accessing each account set interface separately, manually extracting inbound date and inventory quantity data, and then performing cumulative calculations using external tools. This process suffers from incorrect matching of valid inbound dates due to fragmented data sources and the inability to dynamically link the current analysis date with inventory quantity changes, resulting in distorted inventory aging interval divisions.

[0026] If the above problems are not resolved, inventory management will face the technical consequences of increasingly outdated inventory aging information and a continuous decline in inventory turnover efficiency. This includes a significant increase in the risk of material expiration, difficulty in optimizing capital tied up in inventory, and potential delays in supply chain response. Furthermore, the fragmentation of decision-making criteria will lead to wider deviations in warehouse planning, ineffective operational adjustment measures, and ultimately constrain the overall reliability of the inventory management system.

[0027] Based on this, embodiments of this application provide a method, apparatus, device, and medium for cross-account set inventory aging management. By providing users with an inventory aging analysis interface, users can flexibly select one or more accounts for centralized analysis, thereby achieving unified inventory aging management across accounts and improving inventory management efficiency.

[0028] See Figure 1 In one embodiment, a cross-account set inventory aging management method is provided. The execution subject of the method can be a terminal device, including but not limited to steps S101 to S104.

[0029] Step S101: In response to the received inventory age analysis request, display the inventory age analysis interface.

[0030] An inventory aging analysis request is a user-initiated instruction or event that starts the inventory aging analysis process. This request is the starting point for triggering subsequent inventory aging analysis procedures.

[0031] The inventory aging analysis interface is a graphical user interface presented to the user by the executing entity after receiving an inventory aging analysis request. This interface displays the materials to be analyzed, the inventory aging analysis results, and provides an interactive area for the user to select and operate on account sets.

[0032] When a user needs to perform inventory aging analysis, they can send a request to the execution entity in several ways. For example, a user can select the "Inventory Aging Analysis" option from a menu in a general management system. Upon receiving this selection instruction, the execution entity will then display an initial inventory aging analysis interface on the display device. Alternatively, the execution entity can be configured to automatically generate an inventory aging analysis task at a preset time (e.g., the beginning of each month) and push a notification to a designated user. The user can then access the inventory aging analysis interface by clicking the notification.

[0033] Step S102: In response to the account set selection operation for the inventory aging analysis interface, the materials to be analyzed contained in the target account set are displayed in the inventory aging analysis interface.

[0034] The account set selection operation refers to the operation performed by the user on the inventory aging analysis interface to specify one or more accounting account sets as the target for this inventory aging analysis. Through this operation, the executing entity can clarify the scope of data extraction and analysis.

[0035] The target accounting set refers to the specific accounting set that the executing entity has determined as the object of this inventory aging analysis after the accounting set selection operation. A target accounting set can be a company accounting set, a warehouse accounting set, or a regional accounting set, which contains the material data that needs to be analyzed for inventory aging.

[0036] Materials to be analyzed refer to inventory items or raw materials identified in the target accounting system that require aging analysis. The data for these materials will serve as input for the aging analysis.

[0037] After the inventory aging analysis interface is displayed, the user needs to specify which account sets to analyze. For example, the user can manually enter the unique identifiers of one or more account sets through text input boxes on the interface. After receiving these identifiers, the executing entity will retrieve and display all current inventory material information in these account sets from the corresponding database. As an alternative implementation, the executing entity can preset a default list of account sets from which the user can select one or more account sets. Based on the user's selection, the executing entity will load all material data in these account sets and present it on the interface.

[0038] Step S103: Based on the type of the target account set, perform adaptive inventory aging analysis on the materials to be analyzed to obtain target inventory aging information.

[0039] The target accounting sets include company accounting sets, warehouse accounting sets, and regional accounting sets.

[0040] Adaptive inventory aging analysis refers to the process of adaptively adjusting the analysis logic based on the type of the target accounting system and information such as the material's receipt date, current date, and inventory level to calculate the length of time the material has been stored in inventory. This process aims to assess material turnover efficiency and potential unsold inventory risks.

[0041] Target inventory age information refers to the inventory age data of the materials being analyzed, obtained after inventory age analysis. This information typically includes the effective inventory days, monthly inventory level, or daily inventory level of the materials, and is used to support inventory management decisions.

[0042] After the target account type and the materials to be analyzed are determined and displayed, the executing entity will perform adaptive inventory aging calculations for these materials. For example, the executing entity can determine the corresponding inventory aging analysis logic based on the target account type, then assign a uniform inbound date to each material based on the determined inventory aging analysis logic, and calculate the inventory days of the material based on the uniform inbound date and the current date. These days are then simply categorized into several preset age ranges (e.g., 0-90 days, 91-180 days, and over 180 days), and the total quantity of materials in each age range is calculated to obtain preliminary inventory aging information. As another implementation method, the executing entity can determine an inbound date for each batch based on the batch information of the materials, and calculate the inventory days and corresponding inventory quantity for each batch based on these batch inbound dates and the current date. This information is then summarized as the target inventory aging information.

[0043] Step S104: Save the target inventory age information to the target account set.

[0044] After the inventory aging analysis is completed, the target inventory aging information needs to be properly stored. For example, the executing entity can store the target inventory aging information as a separate report file in the local file system for users to review later. Alternatively, the executing entity can export the target inventory aging information as tabular data to an external database for other terminal devices to access the data.

[0045] The following example will provide a more detailed explanation of the above technical solution: Suppose a company has multiple subsidiaries and warehouses, each belonging to a different region (e.g., a province or country). Each subsidiary, warehouse, and region maintains its own independent accounting system, and each system contains a large amount of inventory. The company's inventory management department needs to periodically perform inventory aging analysis on all subsidiaries' materials to identify potential slow-moving risks and optimize the inventory structure.

[0046] First, User A, acting as an inventory manager, initiates an inventory aging analysis request through the company's internal inventory management system. Upon receiving the request, the executing entity immediately displays an inventory aging analysis interface on User A's display device. This interface may initially display some basic information and await further user interaction.

[0047] Next, User A performs an account set selection operation on the inventory aging analysis interface. For example, User A sees a list of account sets on the interface, which lists "Company Account Set," "Warehouse Account Set," and "Regional Account Set." User A selects "Company Account Set" and "Warehouse Account Set" by clicking the selection box. The executing entity responds to User A's account set selection operation and then displays a list of all materials to be analyzed contained in the "Company Account Set" and "Warehouse Account Set" on the inventory aging analysis interface, such as material code, material name, and current inventory quantity.

[0048] Subsequently, the executing entity performs an inventory aging analysis on these materials to be analyzed. Specifically, the executing entity iterates through all selected materials in the "Company Accounts" and "Warehouse Accounts." For each material, the executing entity queries its historical receipt records to obtain the receipt date and corresponding receipt quantity. Then, the executing entity calculates the inventory days for each batch of materials based on the difference between the receipt date and the current analysis date. Based on these inventory days and corresponding inventory quantities, the executing entity statistically summarizes and aggregates the material inventory according to different inventory aging intervals (e.g., 0-30 days, 31-60 days, 61-90 days, etc.) to obtain detailed target inventory aging information. For example, material X has 100 units in the "Company Accounts," of which 50 units have an inventory aging of 0-30 days, 30 units have an inventory aging of 31-60 days, and 20 units have an inventory aging of 61-90 days.

[0049] Finally, the executing entity saves the generated target inventory aging information to the corresponding target accounting set. For example, for the inventory aging information of the "company accounting set," the executing entity saves it to a designated data table within the "company accounting set"; for the inventory aging information of the "warehouse accounting set," the executing entity saves it to a designated data table within the "warehouse accounting set." Thus, these inventory aging analysis results are closely linked to the original accounting set data, facilitating subsequent queries, audits, and further analysis. Through the above process, this method achieves unified inventory aging management for materials across accounting sets, providing enterprises with a comprehensive view of inventory health.

[0050] Therefore, the cross-account aging management method provided in this embodiment demonstrates a significant technical contribution.

[0051] In existing technologies, inventory aging management typically relies on manual recording or simple spreadsheets, which leads to untimely data updates, susceptibility to errors, and difficulty in effectively handling large volumes of data. For example, in the above example, if user A needs to manually summarize material information from multiple sets of accounts and calculate inventory aging, this would be a time-consuming and error-prone process. In contrast, this embodiment automates the initiation and visualization of the inventory aging analysis process by responding to inventory aging analysis requests and displaying the inventory aging analysis interface, greatly improving operational efficiency and data accuracy.

[0052] Furthermore, some existing inventory aging management systems fail to meet the need for consolidated analysis of multiple accounting sets. In the example above, if user A can only analyze the "company accounting set" and the "warehouse accounting set" separately, and cannot select and view them under a unified interface, then a holistic inventory view across accounting sets cannot be obtained. This embodiment provides an accounting set selection operation and displays the materials to be analyzed contained in the target accounting set in response to this operation, allowing users to flexibly select one or more accounting sets for centralized analysis. Thus, this method overcomes the limitations of traditional systems when processing data from multiple accounting sets, achieves unified inventory aging management across accounting sets, and provides enterprises with a more comprehensive and macro-level inventory health assessment capability.

[0053] Furthermore, this embodiment performs inventory aging analysis on the selected materials to be analyzed and obtains target inventory aging information, which is then saved to the target accounting system. This integrated processing method ensures a close correlation between the inventory aging analysis results and the original accounting system data, facilitating subsequent data traceability and management. Unlike existing technologies that may store analysis results in independent, unrelated reports or files, the saving mechanism in this embodiment guarantees data integrity and consistency, thereby improving the usability and value of inventory aging information.

[0054] In summary, the cross-account inventory aging management method of this embodiment effectively solves the technical problems of low data processing efficiency, poor accuracy, and inability to perform cross-account consolidation analysis in the prior art through an automated and integrated process, providing enterprises with an efficient, accurate, and comprehensive inventory management tool.

[0055] In some embodiments, in response to a set of accounts selection operation on the inventory aging analysis interface, displaying the materials to be analyzed contained in the target set of accounts in the inventory aging analysis interface includes: displaying a set of accounts selection operation area on the inventory aging analysis interface; and displaying the materials to be analyzed contained in the target set of accounts in response to a trigger operation received by the set of accounts selection operation area.

[0056] The account set selection area is an interactive component within the inventory aging analysis interface specifically designed for users to select account sets. Its main function is to provide users with a clear and intuitive entry point, allowing them to easily specify the particular account sets for which inventory aging analysis is required. This area can be implemented in various forms. For example, it could be a drop-down list pre-populated with all available account set names or identifiers, allowing users to select an account set by clicking and choosing one from the list; alternatively, it could be a set of radio buttons or checkboxes, each corresponding to an account set, allowing users to select one or more account sets by clicking the corresponding controls; furthermore, it could be an input box with a search function, where users enter account set keywords, and the system dynamically displays matching results for further selection.

[0057] A trigger operation is a specific instruction issued by the user to the executing entity after completing the account set selection in the account set selection area. This instruction confirms the user's selection intent and initiates the subsequent data processing flow. Its purpose is to ensure that the executing entity only loads and displays materials after explicit user instruction, thereby avoiding invalid data loading due to user errors or incomplete selections, and improving the responsiveness of the executing entity and the accuracy of user operations. Trigger operations can be implemented in ways including, but not limited to: the user clicking a clear "Confirm" or "Query" button; the executing entity automatically detecting changes in the selected item and immediately triggering subsequent operations after the user completes the selection; or the user pressing a specific key on the keyboard (e.g., the "Enter" key) after completing the selection to issue the trigger instruction.

[0058] This application's solution optimizes the interaction logic between account set selection and material display by explicitly displaying the account set selection operation area in the inventory aging analysis interface and requiring that the materials to be analyzed in the target account set are only displayed in response to a trigger operation received in this area. Specifically, when a user enters the inventory aging analysis interface, the executing entity first presents a dedicated account set selection operation area, providing the user with a structured selection entry point. The user selects an account set in this area, such as selecting an account set from a drop-down list or checking a checkbox. After the user completes the selection, the executing entity does not immediately display the materials but waits for the user to perform an explicit trigger operation, such as clicking the "OK" button. Once the executing entity receives this trigger operation, it accurately retrieves and loads the corresponding materials to be analyzed from the background database based on the target account set selected by the user and displays them in the inventory aging analysis interface. This mechanism ensures that the display of materials is based on the user's explicit intent and confirmation, avoiding unnecessary or incorrect material loading, making the entire inventory aging analysis process more controllable and efficient.

[0059] The following is a concrete example. Suppose a user needs to perform an inventory aging analysis on materials in a specific company's accounting set. When the user accesses the inventory aging analysis function through the system menu, the executing entity first loads the inventory aging analysis interface in the browser. At the top of this interface, the executing entity displays a drop-down list box named "Select Account Set," which is the account set selection area. This drop-down list box is pre-filled with the names of all company account sets, warehouse account sets, and regional account sets that the user has permission to access. The user clicks this drop-down list box and selects "Company Account Set A" from the pop-up options. At this time, "Company Account Set A" is displayed in the drop-down list box. On the right side of the drop-down list box, the executing entity provides a "Query" button. When the user clicks this "Query" button, the executing entity receives this trigger operation. Subsequently, based on the user's selection of "Company Account Set A," the executing entity sends a request to the backend service to retrieve all material data in "Company Account Set A" that requires inventory aging analysis, and presents these materials in tabular form in the main display area of ​​the inventory aging analysis interface.

[0060] The above technical solution explicitly defines the account set selection area in the inventory aging analysis interface and requires that the materials to be analyzed are only displayed after a trigger operation is received. This effectively solves the ambiguity and operational efficiency problems that may exist in the account set selection operation in the basic solution. This design allows users to select account sets in a clearer and more controlled manner, avoiding premature or incorrect data loading by the system due to ambiguous operations. Therefore, this solution improves the accuracy and convenience of user operations, optimizes the use of system resources, and significantly enhances the overall user experience and operational efficiency of the cross-account set inventory aging management method.

[0061] See Figure 2 In one embodiment, when the target account set is the company account set, the method for adaptive inventory aging analysis of the materials to be analyzed includes, but is not limited to, steps S201 to S203.

[0062] Step S201: Based on the material code and company code of the material to be analyzed, retrieve the first inventory entry ledger.

[0063] Step S202: Based on the first inventory entry ledger, determine the first valid inventory entry date and the corresponding valid inventory quantity of the material to be analyzed.

[0064] Step S203: Based on the first valid entry date and the current analysis date, determine the effective inventory days of the material to be analyzed, and based on the effective inventory quantity and the effective inventory days, determine the monthly inventory quantity of the material to be analyzed, and obtain the target inventory age information.

[0065] When the target ledger is designated as the company ledger, it means that the inventory aging analysis will be performed on the material inventory of the entire company. The company ledger typically refers to the general ledger or financial ledger at the enterprise level, which records the financial and operational data such as the receipt, issuance, and inventory of all materials of the company, and is usually based on the company as the accounting entity.

[0066] The material code uniquely identifies a material, while the company code uniquely identifies a company. Using these two codes, all inbound records related to a specific material and company can be precisely retrieved from the company's database or information system. These records collectively constitute the first inbound ledger. This retrieval process can use a database query language combined with the material code and company code as query conditions to obtain data from the inbound details table of the material management system; or it can retrieve the corresponding inbound data by calling the enterprise's internal data interface and passing in the material code and company code parameters.

[0067] The first valid receipt date refers to the earliest date of a still existing receipt batch in the current inventory, after considering factors such as outbound shipments and inventory counts. The effective inventory quantity refers to the quantity of inventory corresponding to this earliest receipt date that has not yet been shipped. This can be determined by sorting the receipt records in the first receipt ledger according to the first-in, first-out (FIFO) principle and combining them with the current inventory quantity; alternatively, the receipt dates and quantities of each batch in the current inventory can be directly queried using the batch management information recorded by the system.

[0068] The current analysis date serves as the baseline date for inventory aging analysis. By calculating the number of days between the first valid entry date and the current analysis date, the actual number of days the material to be analyzed has been stored, i.e., the effective inventory days, can be obtained. This can be achieved by directly calculating the difference in days between two dates using date functions, or by querying a preset calendar table.

[0069] Monthly inventory refers to categorizing effective inventory into different monthly intervals based on their effective inventory days, thereby calculating the inventory quantity for each monthly interval. This helps to understand the age distribution of materials from a monthly perspective.

[0070] The target inventory age information is the final analysis result, which includes the inventory age distribution of materials. It can be mapped to the corresponding monthly interval based on the effective inventory days (for example, 0-30 days is the first month, 31-60 days is the second month), and then the effective inventory quantity is accumulated into the corresponding monthly interval; or the effective inventory quantity can be allocated to different inventory age segments through predefined inventory age interval rules.

[0071] The proposed solution, through the aforementioned steps, when the target accounting set is a company accounting set, firstly utilizes a combination of material codes and company codes to accurately filter all inbound records of the materials to be analyzed from the company-level inbound ledger, ensuring the comprehensiveness and accuracy of the data source. Next, by processing these inbound records, the earliest inbound batch and its corresponding quantity in the current inventory are identified, providing a reliable starting point for subsequent inventory aging calculations. Subsequently, the earliest inbound date is compared with the current analysis date to calculate the actual number of days the material is in stock, thereby quantifying the material's "age." Finally, based on the effective inventory quantity and effective inventory days, the inventory quantity is categorized and statistically analyzed monthly, forming clear monthly inventory aging distribution information. This allows inventory aging analysis for a company accounting set to delve from the macro-level of the company down to specific material batches, providing refined, multi-dimensional inventory aging data, effectively solving the problem of difficulty in accurately analyzing the characteristics of a company accounting set under general inventory aging analysis methods.

[0072] The following is a concrete example to illustrate this. Suppose a company needs to perform an inventory aging analysis on "Product A" in its company's accounting system. First, the user selects "Company Accounting System" as the target accounting system in the inventory aging analysis interface. After receiving this operation, the executing entity will prompt the user to enter the material to be analyzed, such as the material code of "Product A" (e.g., MAT001). Based on the material code MAT001 and the company's own company code (e.g., COMP001), the executing entity will retrieve all the inbound records under COMP001 corresponding to MAT001 from the company's ERP system, forming the first inbound ledger. Suppose that by analyzing this ledger, the executing entity determines that the earliest batch of "Product A" in the current inventory was received on January 15, 2023, with a quantity of 100 units. At this time, the first valid inbound date is January 15, 2023, and the valid inventory quantity is 100 units. If the current analysis date is March 15, 2024, the executing entity will calculate the valid inventory days as 425 days. According to the preset inventory age range rules, 425 days may correspond to the inventory age range of the 15th month (e.g., 421-450 days). The executing entity will add these 100 effective inventory units to the monthly inventory of the 15th month to obtain the target inventory age information of "Product A" under the company's accounting system, such as "Inventory quantity in the 15th month: 100 units".

[0073] Through the above technical solution, this application provides a more accurate and detailed inventory aging analysis method tailored to the characteristics of a company's accounting system. By retrieving data based on material and company codes, it can accurately locate material receipt records at the company level, avoiding data confusion or omissions across accounting systems. The mechanism for determining the first valid receipt date and valid inventory quantity allows inventory aging analysis to accurately trace back to the oldest inventory batch, thus providing a reliable starting point for inventory aging. Finally, by calculating the number of valid inventory days and determining the monthly inventory quantity, this solution provides the company's accounting system with refined, monthly-level inventory aging distribution information, greatly improving the accuracy and practicality of inventory aging analysis and providing a solid data foundation for enterprise inventory management decisions.

[0074] See Figure 3 In one embodiment, when the target account set is a warehouse account set, the method for adaptive inventory aging analysis of the materials to be analyzed includes, but is not limited to, steps S301 to S303.

[0075] Step S301: Based on the material code and warehouse code of the material to be analyzed, retrieve the second inbound ledger.

[0076] Step S302: Based on the second inventory entry ledger, determine the second valid inventory entry date and the corresponding valid inventory quantity of the material to be analyzed.

[0077] Step S303: Based on the second valid entry date and the current analysis date, determine the effective inventory days of the material to be analyzed, and based on the effective inventory quantity and the effective inventory days, determine the monthly inventory quantity of the material to be analyzed, and obtain the target inventory age information.

[0078] When the target account set is specified as a warehouse account set, it means that the inventory aging analysis will be performed on the material inventory of a specific warehouse. A warehouse account set typically refers to the general ledger or financial account set at the warehouse level. It records the financial and operational data such as the receipt, issuance, and inventory of all materials in a warehouse, and usually takes the warehouse as the accounting entity.

[0079] A warehouse code is an identifier used to uniquely identify a specific warehouse, such as a warehouse ID or storage location code.

[0080] The second inbound inventory record is a database table or data set that records detailed information about materials entering a specific warehouse. It may include fields such as material code, warehouse code, inbound date, and inbound quantity. This record can be data from the inventory module of an enterprise resource planning system, or it can be inbound records from a standalone warehouse management system.

[0081] The second valid entry date refers to the date on which materials actually enter the warehouse and form valid inventory. It can be the date on the entry document or the arrival date recorded by the system.

[0082] This application's solution achieves refined analysis for specific management levels by tightly integrating the inventory aging analysis process with the target account set type (here, a warehouse account set). When the executing entity identifies the user-selected account set as a warehouse account set, it no longer uses general data query logic. Instead, it precisely utilizes the material code and warehouse code of the material to be analyzed as dual indexes to retrieve data from a second inbound ledger that specifically records material flow at the warehouse level. This data source selection mechanism based on a specific account set type ensures that the acquired inbound data is a true and valid record for that warehouse. Subsequently, the executing entity identifies the second valid inbound date and its corresponding valid inventory quantity for each batch of materials from these inbound records, which is the basis for inventory aging calculation. By comparing these second valid inbound dates with the current analysis date, the effective inventory days for each batch of materials can be accurately calculated. Finally, these effective inventory quantities with specific days are further aggregated, and according to preset monthly interval rules, the monthly inventory quantity of the material to be analyzed in each monthly interval is calculated, forming comprehensive and accurate target inventory aging information. This operational logic ensures that warehouse aging analysis can fully reflect the actual inventory status, avoiding analytical biases caused by mismatched data sources, thus providing reliable data support for warehouse management.

[0083] The following is a concrete example to illustrate this. Suppose a user selects a warehouse account set named "Warehouse No. 1 in a Certain Region" for inventory aging analysis and specifies "Product A" as the material to be analyzed. The executing entity will first obtain the material code of "Product A" (e.g., "PA001") and the warehouse code of "Warehouse No. 1 in a Certain Region" (e.g., "WH001"). Subsequently, based on these two codes, the executing entity will retrieve all inbound records of "Product A" in "Warehouse No. 1 in a Certain Region" from a database table named `warehouse_inbound_records`. For example, this table might show that 100 units of "Product A" were received on January 10, 2023, and 50 units were received on March 15, 2023. Assuming the current analysis date is March 20, 2024, the executing entity will calculate: for the 100 units received on January 10, 2023, their effective inventory days are (March 20, 2024 - January 10, 2023) = 435 days; for the 50 units received on March 15, 2023, their effective inventory days are (March 20, 2024 - March 15, 2023) = 371 days. Next, the executing entity will categorize these effective inventory quantities according to preset monthly range rules (e.g., 0-30 days is 1 month, 31-60 days is 2 months, and so on). For example, 435 days might fall into the "14-15 months" range, and 371 days might fall into the "12-13 months" range. Ultimately, the executing entity will accumulate the effective inventory quantity within each monthly interval to obtain the monthly inventory quantity of "Product A" in "Warehouse No. 1 in a certain region". For example, there are 50 units in the "12-13 months" interval and 100 units in the "14-15 months" interval, thus forming complete target inventory age information.

[0084] Through the aforementioned technical solution, this application can provide highly customized and accurate inventory aging analysis for specific scenarios where the target account set is a warehouse account set. By utilizing material codes and warehouse codes as dual location criteria, data is retrieved from a dedicated second inbound ledger, ensuring a high degree of consistency between the data source for inventory aging analysis and the actual inventory status of the warehouse, avoiding data mismatches and analysis errors that may arise from general analysis methods. This refined data retrieval and calculation method enables the implementing entity to accurately track the second valid inbound date and valid inventory quantity for each batch of materials, and calculate the precise number of valid inventory days accordingly, thereby generating monthly inventory quantities that reflect the true age distribution of inventory. This not only significantly improves the accuracy and reliability of inventory aging analysis results, but also provides warehouse managers with more operational inventory aging information, helping to promptly identify and handle stagnant inventory, optimize inventory structure, reduce inventory holding costs, and thus improve overall inventory management efficiency.

[0085] In some embodiments, determining the monthly inventory of the material to be analyzed based on the effective inventory quantity and the effective inventory days includes: determining the monthly inventory range in which the effective inventory quantity falls based on the effective inventory days; accumulating the effective inventory quantities in the monthly inventory range to determine the monthly inventory of the material to be analyzed, thereby obtaining target inventory age information.

[0086] The proposed solution operates through the following mechanism: When performing inventory aging analysis on the materials to be analyzed in the target accounting set, the corresponding inbound ledger is first retrieved based on the material code, company code, or warehouse code. The valid inbound date and corresponding valid inventory quantity of the materials to be analyzed are then determined, and the valid inventory days are calculated. Based on this, to transform this fine-grained inventory data into more macroscopic monthly inventory aging information, for each determined valid inventory quantity and its corresponding valid inventory days, the executing entity maps the valid inventory days to a specific monthly inventory range according to preset rules. For example, if the valid inventory days are 45 days, it may be classified into the "31-60 days" monthly inventory range. Subsequently, all valid inventory quantities falling within the same monthly inventory range are accumulated. In this way, the originally scattered, daily-based inventory aging data is effectively aggregated into monthly inventory quantities, thus clearly showing the distribution of the materials to be analyzed at different monthly inventory aging stages. This approach makes inventory aging analysis results more comprehensive and readable, enabling managers to assess inventory structure from a monthly perspective and make more effective inventory management and decisions based on this.

[0087] As a specific implementation method, assume that when performing inventory aging analysis on a certain material to be analyzed, multiple valid inventory quantities and their corresponding valid inventory days have been obtained. For example, there are three valid inventory records: the first valid inventory quantity is 100 units, with a valid inventory day of 20 days; the second valid inventory quantity is 50 units, with a valid inventory day of 40 days; and the third valid inventory quantity is 200 units, with a valid inventory day of 25 days. To determine the monthly inventory quantity of the material to be analyzed, the executing entity will first define a monthly inventory range, such as "0-30 days", "31-60 days", "61-90 days", etc. Next, the executing entity determines the monthly inventory range for each valid inventory entry based on its effective inventory days: the first valid inventory entry of 100 units (20 days) falls into the "0-30 days" range; the second valid inventory entry of 50 units (40 days) falls into the "31-60 days" range; and the third valid inventory entry of 200 units (25 days) also falls into the "0-30 days" range. Finally, the executing entity sums up the effective inventory amounts within each monthly inventory range: for the "0-30 days" range, 100 units and 200 units are added, resulting in a total of 300 units; for the "31-60 days" range, 50 units are added, resulting in a total of 50 units. In this way, the monthly inventory amount of the material to be analyzed is obtained, that is, the inventory amount for the "0-30 days" inventory age is 300 units, and the inventory amount for the "31-60 days" inventory age is 50 units, thus forming the target inventory age information.

[0088] The above technical solution effectively aggregates discrete effective inventory levels and effective inventory days into monthly inventory levels, solving the problem that relying solely on daily inventory days makes macro-level inventory aging analysis difficult. This makes inventory aging analysis results more structured and readable, allowing managers to intuitively understand the distribution of materials across different monthly inventory aging stages, more accurately assess inventory aging risks, formulate targeted inventory turnover strategies, effectively reduce inventory backlog and losses, and improve the precision and efficiency of inventory management.

[0089] See Figure 4 In one embodiment, when the target account set is a regional account set, the method for adaptive inventory aging analysis of the materials to be analyzed includes, but is not limited to, steps S401 to S403.

[0090] Step S401: Based on the material code and area code of the material to be analyzed, retrieve the third inventory entry ledger.

[0091] Step S402: Based on the third inbound ledger, determine the third valid inbound date and the corresponding valid inventory quantity of the material to be analyzed.

[0092] Step S403: Based on the third valid entry date and the current analysis date, determine the effective inventory days of the material to be analyzed, and based on the effective inventory quantity and the effective inventory days, determine the daily inventory quantity of the material to be analyzed, and obtain the target inventory age information.

[0093] A regional accounting system refers to an accounting system established in enterprise management to independently account for and manage inventory, sales, and procurement within a specific geographical or business area (e.g., Indonesia). This type of accounting system is typically used for refined management of warehouses, stores, or branches within a region, facilitating inventory turnover, risk control, and performance evaluation for regional managers. It can be implemented by configuring a separate accounting module in an Enterprise Resource Planning (ERP) system or by setting up independent logical partitions for data from different regions in a database.

[0094] The third-level inventory entry ledger is a database table or data set that records detailed information about materials entering a specific area. It may include fields such as material code, area code, entry date, and entry quantity. This ledger can be data from the inventory module of an enterprise resource planning system, or it can be inventory entry records from an independent regional warehouse management system.

[0095] The third valid receipt date refers to the date on which materials are actually received and form valid inventory. It excludes date changes caused by non-actual receipt operations such as transfers and inventory counts. Valid inventory quantity refers to the actual quantity of materials in stock that can be used for sale or production on the third valid receipt date. It excludes damaged, reserved, or already issued portions. Determination can be achieved by iterating through each receipt record in the third receipt ledger, selecting the latest receipt date as the third valid receipt date, and accumulating the receipt quantity corresponding to that date as the valid inventory quantity. Alternatively, the executing entity can pre-configure business rules, for example, considering records with receipt types of "purchase receipt" or "production receipt" as valid receipts, and determining the valid batch and quantity according to the First-In-First-Out (FIFO) principle.

[0096] Building upon the aforementioned methods, when the target account set is designated as a regional account set, this application's solution introduces a more refined inventory aging analysis logic to adapt to the specific needs of regional inventory management. Specifically, the executing entity first retrieves all inventory entry records for the material within a specific region from the third inventory entry record of the storage region's inventory entry history, based on the material code and its regional code. This process ensures the regionality and accuracy of the analyzed data. Subsequently, based on these inventory entry records, the executing entity identifies the third valid inventory entry date and its corresponding valid inventory quantity for each batch of materials. This eliminates interference from non-actual inventory entry operations on inventory aging calculations, ensuring data authenticity. Next, the executing entity compares the third valid inventory entry date of each batch of materials with the current analysis date to accurately calculate the effective inventory days for that batch of materials. Finally, this solution correlates the effective inventory quantity of each batch with its corresponding effective inventory days to determine the daily inventory quantity of the material under analysis within different daily inventory intervals. In this way, the solution provides regional accounting systems with more granular and timely inventory aging information, enabling regional managers to have a clearer understanding of the daily aging of inventory, thereby supporting more accurate inventory turnover decisions and risk control. This customized analysis for regional accounting systems allows inventory aging management to go beyond monthly or quarterly reports, delving into daily inventory dynamics and greatly improving the precision of regional inventory management.

[0097] As a specific implementation method, suppose a company has a regional accounting system in Indonesia, which includes multiple warehouses. When a user selects this Indonesian accounting system and requests an aging analysis for material A, the executing entity first obtains the material code and the Indonesian regional code for material A. Subsequently, based on these codes, the executing entity queries the third-party inbound ledger in the database for all inbound records of material A in each warehouse in Indonesia. For example, the executing entity might find that 100 units of material A were received in warehouse 001 in a certain region on January 1, 2023, and 50 units were received on February 15, 2023; and 80 units were received in warehouse 002 in a certain region on January 10, 2023. The executing entity identifies these inbound dates as third-party valid inbound dates and records the corresponding valid inventory quantities. Assuming the current analysis date is March 1, 2023, the executing entity will calculate: 100 units of material received on January 1, 2023, have an effective inventory period of 60 days; 50 units of material received on February 15, 2023, have an effective inventory period of 14 days; and 80 units of material received on January 10, 2023, have an effective inventory period of 50 days. Finally, the executing entity will correlate these effective inventory quantities with their corresponding effective inventory periods. For example, it will generate an inventory aging report showing that material A has 100 units in stock in Indonesia with an inventory age of 60 days, 50 units with an inventory age of 14 days, and 80 units with an inventory age of 50 days. This will provide the daily inventory distribution of material A in Indonesia, which will then be saved as target inventory aging information to the Indonesian accounting system.

[0098] Through the above technical solution, when the target account set is a regional account set, this application can provide more refined inventory aging analysis. By retrieving the third-party inbound ledger based on material code and regional code, and determining the third valid inbound date and corresponding valid inventory quantity, the accuracy and authenticity of regional inventory data are ensured. Furthermore, by calculating the valid inventory days and determining the daily inventory quantity, regional managers can monitor the daily distribution of materials in different inventory aging intervals in real time. This allows for more timely detection of obsolete inventory risks, optimization of inventory turnover efficiency within the region, and provides more accurate data support for regional procurement, sales, and allocation decisions, effectively improving the refinement and responsiveness of regional inventory management.

[0099] In some embodiments, determining the daily inventory level of the material to be analyzed based on the effective inventory level and the effective inventory days includes: determining the daily inventory range in which the effective inventory level falls based on the effective inventory days; accumulating the effective inventory levels in the daily inventory range to determine the daily inventory level of the material to be analyzed, thereby obtaining target inventory age information.

[0100] This application's solution first precisely categorizes the effective inventory of the material to be analyzed into preset daily inventory intervals based on its effective inventory days, thus achieving a refined division of inventory age. Subsequently, by summing up the effective inventory quantities of all categories within each daily inventory interval, the daily inventory quantity of the material to be analyzed can be accurately obtained within each interval. This approach overcomes the limitation of obtaining refined daily inventory data solely based on effective inventory quantity and effective inventory days when the target accounting system is a regional accounting system. Through this step-by-step refinement and aggregation method, this application can provide more detailed and accurate inventory age analysis data for regional accounting systems, thereby supporting more targeted inventory management and decision-making, especially in scenarios requiring daily monitoring of inventory turnover rate and slow-moving inventory risk, where its effectiveness is particularly significant.

[0101] As a specific implementation method, suppose a certain regional accounting system needs to perform an inventory aging analysis on material A. The executing entity first obtains all valid inventory records for material A. For example, the first batch of 100 units has an effective inventory period of 5 days; the second batch of 50 units has an effective inventory period of 6 days; and the third batch of 200 units has an effective inventory period of 12 days. When determining the daily inventory level, the executing entity can preset daily inventory ranges such as "0-7 days", "8-14 days", and "15-21 days". For the first and second batches, their effective inventory days (5 days and 6 days) both fall within the "0-7 days" range. Therefore, adding 100 units and 50 units together, the daily inventory level for the "0-7 days" range is 150 units. For the third batch, its effective inventory days (12 days) fall within the "8-14 days" range. Therefore, the daily inventory level for the "8-14 days" range is 200 units. In this way, the executing entity can clearly present the daily inventory distribution of material A in different inventory age ranges. For example, the inventory quantity for 0-7 days is 150 units, the inventory quantity for 8-14 days is 200 units, and so on, thereby obtaining detailed target inventory age information.

[0102] Through the above technical solution, this application provides a clear and systematic method for accurately determining the daily inventory level of materials to be analyzed when the target account set is a regional account set. This method overcomes the shortcomings of traditional methods in obtaining refined daily inventory age data by meticulously dividing the effective inventory level into specific daily inventory intervals and accumulating them. This enables regional managers to obtain highly granular inventory age distribution information, thereby enabling them to more timely and accurately identify inventory backlogs, slow-moving risks, or materials nearing their expiration date, and thus adopt more precise inventory allocation, promotion, or scrapping strategies. Compared to providing only monthly or coarser inventory age information, determining the daily inventory level greatly improves the refinement and responsiveness of regional inventory management, effectively reduces inventory costs and operational risks, and significantly enhances the efficiency and scientific basis of regional inventory management and decision-making.

[0103] See Figure 5 This application also provides a cross-account set inventory aging management device, which can implement the above-mentioned cross-account set inventory aging management method. The device includes: The first module 501 is used to respond to the received inventory age analysis request and display the inventory age analysis interface; The second module 502 is used to respond to the account set selection operation for the inventory aging analysis interface and display the materials to be analyzed contained in the target account set in the inventory aging analysis interface. The third module 503 is used to perform adaptive inventory aging analysis on the materials to be analyzed based on the type of the target account set, and obtain the target inventory aging information; the types of target account sets include company account sets, warehouse account sets, and regional account set information. Module 4, 504, is used to save the target inventory age information to the target account set.

[0104] The specific implementation method of the cross-account aging management device is basically the same as the specific implementation method of the cross-account aging management method described above, and will not be repeated here.

[0105] Figure 6 This is a schematic diagram of the hardware structure of the electronic device provided in the embodiments of this application.

[0106] The following reference Figure 6 To describe an electronic device 600 according to such an embodiment of the present disclosure. Figure 6 The electronic device 600 shown is merely an example and should not impose any limitation on the functionality and scope of use of the embodiments disclosed herein.

[0107] like Figure 6 As shown, the electronic device 600 is presented in the form of a general-purpose computing device. The components of the electronic device 600 may include, but are not limited to: at least one processing unit 610, at least one storage unit 620, a bus 630 connecting different system components (including storage unit 620 and processing unit 610), a display unit 640, etc.

[0108] The storage unit stores program code, which can be executed by the processing unit 610, causing the processing unit 610 to perform the steps described in the section on cross-account aging management method of this specification according to various exemplary embodiments of this disclosure.

[0109] Storage unit 620 may include a readable medium in the form of a volatile storage unit, such as random access memory (RAM) 6201 and / or cache memory 6202, and may further include a read-only memory (ROM) 6203.

[0110] Storage unit 620 may also include a program / utility 6204 having a set (at least one) program module 6205, such program module 6205 including but not limited to: operating system, one or more application programs, other program modules and program data, each or some combination of these examples may include an implementation of a network environment.

[0111] Bus 630 can represent one or more of several types of bus structures, including a memory cell bus or memory cell controller, a peripheral bus, a graphics acceleration port, a processing unit, or a local bus using any of the various bus structures.

[0112] Electronic device 600 can also communicate with one or more external devices 600' (e.g., keyboard, pointing device, Bluetooth device, etc.), and with one or more devices that enable a user to interact with electronic device 600, and / or with any device that enables electronic device 600 to communicate with one or more other computing devices (e.g., router, modem, etc.). This communication can be performed via input / output (I / O) interface 650. Furthermore, electronic device 600 can also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN), and / or public networks, such as the Internet) via network adapter 660. Network adapter 660 can communicate with other modules of electronic device 600 via bus 630. It should be understood that, although not shown in the figures, other hardware and / or software modules can be used in conjunction with electronic device 600, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0113] This application also provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the above-described method.

[0114] The cross-account set inventory aging management method, apparatus, equipment, and medium provided in this application, when cross-account set inventory aging management is required, respond to user-initiated inventory aging analysis requests and provide an inventory aging analysis interface. Users can select one or more accounts for centralized analysis through this interface. Based on the type of the selected target account set, adaptive inventory aging analysis is performed on the materials to be analyzed within that target account set. After obtaining the target inventory aging information, it is saved to the target account set. This achieves adaptive inventory aging management across accounts, effectively solving the technical problems of low data processing efficiency, poor accuracy, and inability to perform cross-account set merged analysis in existing technologies, thereby improving inventory management efficiency.

[0115] From the above description of the embodiments, those skilled in the art will readily understand that the exemplary embodiments described herein can be implemented by software or by combining software with necessary hardware. Therefore, the technical solutions according to the embodiments of this disclosure can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (such as a CD-ROM, USB flash drive, external hard drive, etc.) or on a network, including several instructions to cause a computing device (such as a personal computer, server, or network device, etc.) to execute the methods described above according to the embodiments of this disclosure.

[0116] The program product may employ any combination of one or more readable media. A readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples (a non-exhaustive list) of readable storage media include: electrical connections having one or more wires, portable disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof.

[0117] Computer-readable storage media may include data signals propagated in baseband or as part of a carrier wave, carrying readable program code. Such propagated data signals may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A readable storage medium may also be any readable medium other than a readable storage medium that can transmit, propagate, or transfer a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained on the readable storage medium may be transmitted using any suitable medium, including but not limited to wireless, wired, optical fiber, RF, etc., or any suitable combination thereof.

[0118] Those skilled in the art will understand that the above modules can be distributed in the device as described in the embodiments, or they can be modified accordingly and placed in one or more devices that are unique to this embodiment. The modules in the above embodiments can be combined into one module, or they can be further divided into multiple sub-modules.

[0119] Exemplary embodiments of this disclosure have been specifically shown and described above. It should be understood that this disclosure is not limited to the detailed structures, arrangements, or implementations described herein; rather, this disclosure is intended to cover various modifications and equivalent arrangements contained within the spirit and scope of the appended claims.

Claims

1. A method for cross-account set inventory aging management, characterized in that, include: In response to a received inventory aging analysis request, the inventory aging analysis interface is displayed; In response to the account set selection operation for the inventory aging analysis interface, the inventory aging analysis interface displays the materials to be analyzed contained in the target account set; Based on the type of the target account set, adaptive inventory aging analysis is performed on the materials to be analyzed to obtain target inventory aging information; the type of the target account set includes company account set, warehouse account set, and regional account set. Save the target inventory age information to the target account set; When the target accounting set is a company accounting set, the adaptive inventory aging analysis of the materials to be analyzed based on the type of the target accounting set includes: Based on the material code and company code of the material to be analyzed, retrieve the first inventory entry ledger; Based on the first inventory entry ledger, determine the first valid inventory entry date and the valid inventory quantity corresponding to the first valid inventory entry date of the material to be analyzed; Based on the first valid entry date and the current analysis date, the effective inventory days of the material to be analyzed are determined, and based on the effective inventory quantity and the effective inventory days, the monthly inventory quantity of the material to be analyzed is determined, thereby obtaining the target inventory age information; When the target account set is a warehouse account set, the adaptive inventory aging analysis of the materials to be analyzed based on the type of the target account set includes: Based on the material code and warehouse code of the material to be analyzed, retrieve the second inbound ledger; Based on the second inventory entry ledger, determine the second valid inventory entry date and the valid inventory quantity corresponding to the second valid inventory entry date for the material to be analyzed. Based on the second valid entry date and the current analysis date, the effective inventory days of the material to be analyzed are determined, and based on the effective inventory quantity and the effective inventory days, the monthly inventory quantity of the material to be analyzed is determined, thus obtaining the target inventory age information; When the target account set is a regional account set, the adaptive inventory aging analysis of the materials to be analyzed based on the type of the target account set includes: Based on the material code and region code of the material to be analyzed, retrieve the third inventory entry ledger; Based on the third inbound inventory record, determine the third valid inbound date of the material to be analyzed and the valid inventory quantity corresponding to the third valid inbound date; Based on the third valid entry date and the current analysis date, the effective inventory days of the material to be analyzed are determined, and based on the effective inventory quantity and the effective inventory days, the daily inventory quantity of the material to be analyzed is determined, thus obtaining the target inventory age information.

2. The cross-account set inventory aging management method according to claim 1, characterized in that, In response to a selection operation on the inventory aging analysis interface, the interface displays the materials to be analyzed contained in the target inventory set, including: The inventory aging analysis interface displays the account set selection operation area; In response to a trigger operation received in the account set selection operation area, the materials to be analyzed contained in the target account set are displayed.

3. The cross-account set inventory aging management method according to claim 1, characterized in that, Determining the monthly inventory of the material to be analyzed based on the effective inventory level and the effective inventory days includes: Based on the effective inventory days, determine the monthly inventory range in which the effective inventory level falls; The effective inventory levels within the monthly inventory range are summed to determine the monthly inventory level of the material to be analyzed, thus obtaining the target inventory age information.

4. The cross-account set inventory aging management method according to claim 1, characterized in that, Determining the daily inventory level of the material to be analyzed based on the effective inventory level and the effective inventory days includes: Based on the effective inventory days, determine the daily inventory range in which the effective inventory level falls; The effective inventory levels within the daily inventory range are summed to determine the daily inventory level of the material to be analyzed, thus obtaining the target inventory age information.

5. A cross-account set inventory aging management device, characterized in that, include: The first module is used to respond to the received inventory age analysis request and display the inventory age analysis interface; The second module is used to respond to the account set selection operation for the inventory aging analysis interface and display the materials to be analyzed contained in the target account set in the inventory aging analysis interface. The third module is used to perform adaptive inventory aging analysis on the materials to be analyzed based on the type of the target account set, and obtain the target inventory aging information; The target accounting sets include company accounting sets, warehouse accounting sets, and regional accounting sets; The fourth module is used to save the target inventory age information to the target account set; When the target accounting set is a company accounting set, the adaptive inventory aging analysis of the materials to be analyzed based on the type of the target accounting set includes: Based on the material code and company code of the material to be analyzed, retrieve the first inventory entry ledger; Based on the first inventory entry ledger, determine the first valid inventory entry date and the valid inventory quantity corresponding to the first valid inventory entry date of the material to be analyzed; Based on the first valid entry date and the current analysis date, the effective inventory days of the material to be analyzed are determined, and based on the effective inventory quantity and the effective inventory days, the monthly inventory quantity of the material to be analyzed is determined, thereby obtaining the target inventory age information; When the target account set is a warehouse account set, the adaptive inventory aging analysis of the materials to be analyzed based on the type of the target account set includes: Based on the material code and warehouse code of the material to be analyzed, retrieve the second inbound ledger; Based on the second inventory entry ledger, determine the second valid inventory entry date and the valid inventory quantity corresponding to the second valid inventory entry date for the material to be analyzed. Based on the second valid entry date and the current analysis date, the effective inventory days of the material to be analyzed are determined, and based on the effective inventory quantity and the effective inventory days, the monthly inventory quantity of the material to be analyzed is determined, thus obtaining the target inventory age information; When the target account set is a regional account set, the adaptive inventory aging analysis of the materials to be analyzed based on the type of the target account set includes: Based on the material code and region code of the material to be analyzed, retrieve the third inventory entry ledger; Based on the third inbound inventory record, determine the third valid inbound date of the material to be analyzed and the valid inventory quantity corresponding to the third valid inbound date; Based on the third valid entry date and the current analysis date, the effective inventory days of the material to be analyzed are determined, and based on the effective inventory quantity and the effective inventory days, the daily inventory quantity of the material to be analyzed is determined, thus obtaining the target inventory age information.

6. An electronic device, characterized in that, The electronic device includes a memory and a processor. The memory stores a computer program, and when the processor executes the computer program, it implements the cross-account aging management method according to any one of claims 1 to 4.

7. A computer-readable storage medium storing a computer program, characterized in that, When the computer program is executed by the processor, it implements the cross-account aging management method as described in any one of claims 1 to 4.

Images