SAP Knowledge Base Article - Public

3649400 - The Payment Proposal is not Including all on Account Payments when the Corresponding Invoices are due

Symptom

  • The Payment Proposal does not include all on Account Payments when the corresponding Supplier Invoices are due.
  • The Proposal suggests a Payment to the Supplier even though the Supplier Account Balance indicates no Payment is owed.
  • In the Payment Proposal ID XXX (where XXX is the Payment Proposal ID) only one of the two on Account Payments is included, resulting in an incorrect Payment Suggestion of YYY,YY LC (where YYY,YY is the Local Currency amount).
  • Both Invoices ABC and DEF and Payment GHI are correctly mentioned in the Payment Proposal, but Payment JKL is missing (where ABC is the first Supplier Invoice, DEF is the second Supplier Invoice, GHI is the first on Account Payment and JKL is the second on Account Payment). 

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Navigate to the Payables Work Center.
  2. Access the Supplier Account view.
  3. Search for the Supplier Account ID ZZZ (where ZZZ is the Supplier Account ID).
  4. Press View.
  5. Verify that there are two on Account Payments and two Supplier Invoices.
  6. Now execute a Payment Proposal in the Payables Work Center - Payment Runs view.

Observe that only one on Account Payment GHI is included in the Payment Proposal, while on Account Payment JKL is missing.

Cause

  • During the Payment Proposal creation, the system groups Open Items based on various criteria such as Business Partners, Company and Currency.
  • When the system considers the Payments group for the Proposal creation, it adds Payment GHI to the Proposal and updates the Balance.
  • The Balance becomes -YYY,YY LC, and when the system evaluates the Payment JKL, it determines that the Balances of the groups are the same.
  • As a result, the Payment JKL is not added to the Proposal, and when the system attempts to add it to a separate Proposal, it is discarded because it would result in an Incoming Payment.
  • This behavior is the standard system functionality.

Resolution

Perform the following steps to manually include the missed Payment in the Proposal:

  1. Navigate to the Payables Work Center.
  2. Access the relevant Payment Run in the Payment Runs sub-view under Periodic Tasks.
  3. Highlight the relevant record in the Execution Details and click "View Payment Proposals".
  4. Select the row containing the Payment in status "Postponed".
  5. Go to "Actions" and choose "Reset Postpone".
  6. Edit the Proposal to add the Payment manually and execute the Proposal and then schedule a Payment Run for the remaining Open Items.

See Also

Refer to: SAP Business ByDesign Help Documentation section: Create and Edit Payment Proposals for Payables

Keywords

payment proposal, on account payments, invoices due, payables, grouping logic, postponed payment, manual clearing, payment run, supplier account, incorrect payment suggestion , KBA , SRD-FIN-ACP , Payables , Problem

Product

SAP Business ByDesign all versions