SAP Knowledge Base Article - Public

1760524 - Cannot Upload Journal Entry Voucher from Microsoft Excel

Symptom

You try to upload journal entry voucher from Microsoft Excel, when you click Save Data to in the excel template, the system gives error messages:

'For gen. ledger purposes, at least one debit and credit line required;'

'Line items do not balance; correct the difference amount;'

'Action Post not possible; action is disabled.'

But you are sure the line items are balanced.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to General Ledger work center.
  2. Go to Journal Entries view.
  3. Go to Journal Entry Vouchers subview.
  4. Create new voucher from excel as New -> Journal Entry Voucher from Microsoft Excel.
  5. Select the Save data button in the Excel add-in.

You get the error messages mentioned above.

Cause

The issue is with the format in the excel template, when you enter the line items, you do not follow the right way, so the data format cannot be recognized by the system.

Resolution

In order to successfully upload the journal entry voucher into the system, follow the steps below:

  1. After you download the excel template, open it up, and you can see that, by default, there are two line items.
  2. There is an arrow at the end of the last column, and that arrow needs to be pulled down to add more line item with the same format.

In this way, you should be able to add line items properly to the excel.

Keywords

 jev; excel; journal entry voucher , KBA , upload journal entry voucher , action post not possible; , ne items do not balance , correct difference , upload excel , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions