Issue Regarding Querying the Actual Payment Amount for Purchase Orders

[Lan_Hui]

查询采购订单实际付款金额的问题 Issue Regarding Querying the Actual Payment Amount for Purchase Orders （System: ERP6.0, ECC EHP8）实际业务中用户有查询采购订单实际付款金额的需求。已开发报表通过取已清表bsak中采购订单字段的数据来取已付金额，即发票校验环节应付行项目采购订单字段。但是该字段数据存在问题，导致已付金额取值不准，该字段的详细问题过程如下： In actual business operations, users have a requirement to query the actual payment amount for purchase orders. A custom report was developed to retrieve the paid amount by extracting data from the purchase order field in the cleared items table BSAK, which corresponds to the purchase order field in the payable line items during the invoice verification process. However, there are issues with the data in this field, leading to inaccurate retrieval of the paid amount. The detailed issues with this field are outlined below: 1、系统刚上线时。发票校验环节，生成的会计凭证中应付行项目的采购订单字段为空。 1. During the initial system go-live phase, in the invoice verification process, the purchase order field in the payable line items of the generated accounting documents was empty. 2、2021年6月，关于发票校验环节采购订单字段的多个功能增强传输到生产系统，此处涉及以下两个功能增强点： 2. In June 2021, multiple functional enhancements related to the purchase order fields in the invoice verification process were transported to the production system. This involved the following two enhancement points: （1）功能增强点一：为发票校验会计凭证的应付行项目的采购订单字段赋值 (1) Enhancement Point 1: Populating the purchase order field in the payable line items of accounting documents generated during invoice verification. ①部分程序增强内容如下： ①Enhancements to some programs include the following: ②该程序增强的业务逻辑是应付行项目的采购订单字段取采购凭证中的其他行的采购订单字段，如下图： ②The enhanced business logic of this program is that the purchase order field in the accounts payable line item retrieves the purchase order fields from other lines within the purchase document, as shown in the figure below: ③该方式存在的问题是：若一张发票校验凭证涉及多笔采购订单，生成的会计凭证的供应商挂账会将多笔采购订单进行合并。导致应付行项目的金额是多笔订单的合计应付金额，而应付行项目的采购订单字段是发票校验涉及的其中一个采购订单号。如下图所示： ③The issue with this method is: If an invoice verification document involves multiple purchase orders, the generated accounting document will consolidate the vendor liabilities across those purchase orders. This results in the accounts payable line item amount reflecting the total payable sum of multiple orders, while the purchase order field in the payable line item only displays one of the involved purchase order numbers. As shown in the example below: （2）功能增强点二：在金额分摊页签新增了采购订单字段 (2) Functional Enhancement 2: Added the Purchase Order field in the Amount Distribution tab ①部分程序增强内容如下： ①Partial program enhancements are as follows: ②该程序增强的业务逻辑是通过金额分摊页签录入不同的采购订单的金额 ②The enhanced business logic of the program allows entering amounts for different purchase orders through the Amount Allocation tab. ③存在的问题是：回车后采购订单字段被强制清空，生成的会计凭证的应付行项目的采购订单字段仍为空。 ③The existing issues are: after pressing Enter, the purchase order field is forcibly cleared, and the purchase order field in the accounts payable (AP) line item of the generated accounting document remains empty. ④总结：这个采购订单会被清空的问题，通过修改增强程序能够解决，当时的业务顾问想验证一下后续的付款操作是否会出现问题。尝试在系统里直接写入EBELN数据进行测试，发现即使这一步操作后，BSEG里的EBELN有值，但是付款时仍然会被合并。所以该功能增强未进一步推进。 ④Summary: The issue where the purchase order (PO) field is cleared can be resolved by modifying the enhanced program. However, the business consultant at the time wanted to verify whether subsequent payment operations would encounter problems. Testing was conducted by directly writing EBELN (PO number) data into the system. It was discovered that even after this step, although the EBELN field in BSEG (accounting document line items) contained a value, payments were still consolidated during processing. As a result, further development of this enhancement was halted. 基于以上原因，已开发报表中的采购订单实际付款金额并不准确。希望SAP团队提供技术支持解决该问题，或其他方式取到采购订单的实际已付金额。 Based on the above reason/description, the actual payment amounts for purchase orders in the developed report are currently inaccurate. We request technical support from the SAP team to resolve this issue or provide alternative methods to accurately retrieve the actual paid amounts for purchase orders.