Error when importing through DTW for JE

[Former Member]

Hi All,

When i try import Je through DTW it gives me the error as "You are not allowed to edit posting date".

I am trying to import around 1000 transactions of which it gives me this error for one transaction, when i remove the transaction and try to import, it imports the balance records.

Please help me out to resolve this issue.

Regards

Shanker

[former_member187989]

hi sankar,

Administration --> System Initialization --> Document Settings -->

Per Document -- > Select Journal Entry --> Remove Tick mark - Block Posting Date Editing Per Row

Do the above administrative setting & then upload JE's thru DTW.

Problem will be solved.

Jeyakanthan

[Former Member]

Hi Jayakanthan,

Thanks for the reply.

we had done the same thing.

we had taken care all the validations, the date we had entered is by default 1-04-08 for all transactions.

Regards

Shanker

[former_member187989]

hi sankar,

First of all while uploading bulk of transactions thru DTW,Split 7000 records into 3 or more excels sheets

of 2500,2500,2000 etc,It will enable to trace out faulty records and faster processing of records

while uploading also ensure correctness of data in excel & check & correct data's are entered in correct format,and then perform test Run in DTW & then correct errors using error log,also check error log file

to trace out further errors.

Also ensure correct posting period is set as default before uploading JE's thru DTW.

Jeyakanthan

[Former Member]

Your solution is simple: try to enter this JE manually. Something may be wrong for the posting date.

Thanks,

Gordon

[Former Member]

Hi Gordon,

Sorry for delay in replying.

This solution we had already found, the actual reason is when we are uploading 7000 transactions, it gives the around 2000 and once we resolve or remove that transaction again at 4300 give the error.

The reason is first SAP reads all the transactions which is takes around 15 Min(since we have 1 GB RAM on Server) and throws error if any, and by that time we resolve all the transactions, take lot of time in uploading the data.

Once again sorry for the delay in replying.

Regards

Shanker