Skip to Content
avatar image
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

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    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