Skip to Content
author's profile photo Former Member
Former Member

Date Error while importing Journal entries Lines with DTW

Hello everybody,

I'm getting the following error when trying to import journal entries lines with DTW for past periods:

"Date deviates from permissible range [JDT1.RefDate][line: 1]65171"

I have already unlocked the periods, checked the due dates, reference dates and tax dates and everything looks fine to me (within the period).

These are some example lines:

ParentKey,AccountCode,Debit,Credit,DueDate,ReferenceDate1,Reference1,TaxDate JdtNum,Account,Debit,Credit,DueDate,RefDate,Ref1,TaxDate

1,_SYS00000001808,,212.4,20170215,20170228,APagar,20170215 1,_SYS00000001808,,208.41,20170215,20170228,APagar,20170215 1,_SYS00000001808,,186.38,20170215,20170228,APagar,20170215

Any idea about what's wrong with my template's information?

Thanks in advance!

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2017 at 05:59 PM

    Found my problem, so I'm posting it for the reference:

    When I tried to do it from SAP, i got the same error, in order to fix it I had to modify the header so it can update all the lines... but my problem was that I wanted to do it with DTW... so I had to make 2 files and get them imported at the same time with DTW: One for the header and one for the lines. Hope it can help.

    Add comment
    10|10000 characters needed characters exceeded