3286434 - Journal Entry Voucher Excel Upload Error: 'The Value '' of the Field 'Credit Amount *' is Invalid.' or 'The Value '' of the Field 'Debit Amount *' is Invalid.'

While uploading a Journal Entry Voucher from Microsoft Excel the following error messages occur:

'The value '' of the field 'Credit Amount *' is invalid.'

'The value '' of the field 'Debit Amount *' is invalid.'

SAP Business ByDesign

1. Go to the General Ledger work center.
2. Go to the Journal Entries - Journal Entry Vouchers view.
3. Press the New button and select the Journal Entry Voucher from Microsoft Excel option.
4. Download the file and enter the relevant data in the Excel file.
5. Press Save Data to, to proceed with the upload of the Journal Entry Voucher file to the Business ByDesign system.
6. Error occurs:

'The value '' of the field 'Credit Amount *' is invalid.'

'The value '' of the field 'Debit Amount *' is invalid.'

The issue is with the credit/debit amount format in the excel template. When enter the credit/debit amount in the file, the format is incorrect so the data cannot be recognized by the system.

Use the 'Text to Columns' button under the Data tab in the Excel file for Debit Amount and Credit Amount.

KBA 1736565 - Error Message "The Value " " of the Field 'Cost Object Type' is Invalid"

KBA 1760524 - Cannot Upload Journal Entry Voucher from Microsoft Excel