The present application discloses a method, device, equipment and medium for generating an aging analysis report of
accounts payable and receivable, and the method comprises: obtaining an initial template of an aging analysis report of
accounts payable and receivable; determining the aging analysis requirement information of
accounts payable and receivable according to the aging interval field and the analysis dimension field in the initial template; establishing the association relationship between the accounts payable and receivable document information, the
voucher auxiliary information and the auxiliary balance information, and generating an aging
data source of accounts payable and receivable; establishing a data statistics view of the aging
data source of accounts payable and receivable according to the aging analysis requirement information of accounts payable and receivable; and determining the aging
data acquisition information of accounts payable and receivable according to the aging analysis requirement information of accounts payable and receivable; semantically encapsulating the aging
data acquisition information of accounts payable and receivable according to the data statistics view, and generating a semantic object of the aging
data acquisition information of accounts payable and receivable; determining the data acquisition formula corresponding to the aging data acquisition information of accounts payable and receivable;
parsing the data acquisition formula through the semantic object, and acquiring the aging data of accounts payable and receivable, so as to generate an aging analysis report of accounts payable and receivable. The efficiency of generating the aging analysis report of accounts payable and receivable can be improved.