Skip to Content

Date Error while importing Journal entries Lines with DTW

Jun 05, 2017 at 07:53 PM


avatar image
Former Member

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

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.

10 |10000 characters needed characters left characters exceeded