SAP Knowledge Base Article - Public

3598744 - Differences in values between Supplier Account Balance and the total Open Items of the Supplier

Symptom

The difference in values observed between the supplier account balance and the open amount in transaction currency under the same supplier.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the payables work center.
  2. Go to the Supplier accounts sub view.
  3. Search for the relevant Supplier ID.
  4. Observe that the account balance of this supplier is -1000 EUR.
  5. Navigate to the trade payables and check the open item: -1200 EUR.
  6. The open item value and the overall account balance is not equal; there is a difference of -200 EUR, which is causing discrepancy.

Note: The amounts and the currency mentioned in the above steps are for example references.

Cause

The difference is caused by Journal Entry Voucher with Journal entry type as 00084 - Manual Entry for Accounts Payable cleared under the relevant supplier account monitor.
Basically, the Journal entry vouchers with the type of Manual Entry for Accounts Payable cannot be approached for clearing against any Supplier invoices/Payments under Supplier account monitor.
The concept of Journal entry vouchers is to do the manual adjustment merely affecting the General Ledger.  

Resolution

To correct the difference amount, which was added in the Supplier account balance, follow the below steps.

  1. Go to Payables work center.
  2. Go to the Supplier account sub view.
  3. Search for the relevant Supplier ID.
  4. Navigate to the Trade Receivables tab--> All items
  5. Select the relevant Journal entry voucher which is causing difference of -200 EUR.
  6. Reverse the respective Journal entry voucher transaction by giving edit option.
  7. After the reversal got posted, the supplier account balance will be equal to the total open item value.

Note: If either Supplier invoice/payments cleared against this Journal entry voucher, then after the cancellation of the Journal entry voucher it will be now available under open items, select that Invoice/Payments under supplier account monitor. Highlight it and give New Charge/Credit and apply the corresponding debit/credit entries against the payable item. In this way the affected Invoice/Payment can be cleared.

See Also

KBA - " 1937047 - Journal Entry Voucher of type Manual Entry for Accounts Receivable does not Clear Invoice "

KBA - " 1780988 - No Application of Manual Journal Entry Vouchers of Type Payables/Receivables for Open Documents   "

Keywords

Supplier account balance, open items, transaction currency, discrepancy, Journal Entry Vouchers, Manual Entry for Accounts Payable. , KBA , AP-ACC , Business ByDesign: Financial Accounting , Problem

Product

SAP Business ByDesign all versions