SAP Knowledge Base Article - Preview

3757640 - Issues when importing excel file for journal entry

Symptom

Errors appear when importing journal entries via excel file:

  • Invalid value "Primär" in row 1, column 2, for field "Series[OJDT.Series]".
  • Invalid value "XXX-XX-XX" in row 1, column 3, for field "Posting Date[OJDT.RefDate]".

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 


Read more...

Environment

SAP Business One 

Product

SAP Business One all versions ; SAP Business One, version for SAP HANA all versions

Keywords

journal entry import, import from excel, series, posting date, OJDT.Series, OJDT.RefDate, invalid value, umlaut, Primär, Primär, encoding, ANSI, UTF-8, tab-delimited, German localization , KBA , SBO-ADM-IE-DI-EXC , Import from Excel , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.