DTW - sale order error

[former_member187989]

hi all,

While uploading sale order through DTW,error message appears as below

Invalid total (RDR1.RG23Part2][Line:65] 'INR' Application defined or object-defined

oOrders.

Thanks,

With reagards,

A.Jeyakanthan

Edited by: Darius Heydarian on Jan 15, 2008 12:21 PM

[former_member583013 · Accepted solution]

Jeyakanthan,

Please remember, when uploading Sales Orders through DTW, you need not specify the Line Total or Doc Total amounts.

SAP automatically calculates this.

You ONLY have to specify Quantity and Price.

Sometimes these may also cause the error to occur.

Regards

Suda

[former_member187989]

After upgrading to latest patch problem was solved.

Jeyakanthan

[former_member187989]

hi Tony.Chu ,

Still our client was facing same problem,what we posted as question.

Jeyakanthan

[former_member187989]

First I thank you all for replies,

But still we are facing same error message posted initially.

with regards,

Jeyakanthan

[Former Member]

DTW bring me same problem, how to you solved?

thanks!

Tony

[Former Member]

Hi Jeya,

Have you entered the value in 'Price' field as <b>INR ****</b>? If yes, remove 'INR' and simply enter the numeric value in this field - this should do the trick for you.

Regards,

Gyanesh

[former_member187989]

hi jimmy,

I attached templates,Pl check your mail.

Regards,

Jeyakanthan

[former_member186095]

Hi Jeya,

I have sent the template and let me know if the problem still persists.

Rgds,

[former_member187989]

hi Shwu Hua Gan ,

We have also set docduedate,default warehouse code,We uploaded

sale order in CSV format.

We will try it out in txt format.

With Regards,

A.Jeyakanthan

[former_member583013]

Jayakanthan,

One more thing I remembered. Try setting Discount % to 0

Suda

[Former Member]

Hi,

If you still encounter problem, open up the file in txt. You would find that sometime the header is actually corrupted with some funny character in front or spacing etc.

If that still does not resolve this issue, it will be time to report to SAP support. Before you know. there could simply be problem with the DTW version you currently used.

[former_member186095]

Hello Jaya,

Just send the template you use to me, it is really upset now, the e-mail is anthoni76@yahoo.com

Rgds,

[former_member187989]

hi all.

I checked with templates & removed line total,doc total from sale order line

template,but still same error message appears.

I have made entries in header fields like,record key,cardcode,docdate,NumAtcard,series

& row fields like record key,line number,item code,quanity,price,tax code.

Is there any thing mandtory to enter both in header & line templates ?

Is there any specific settings do with document settings in Admin module for

uploading sale order thru DTW ?

Thanks,

With regards,

A.Jeyakanthan

[Former Member]

Hi,

In the Header, I normally has DocDueDate as well.

For each items, do you have a default warehouse?

If not, I normally put in WarehouseCode as well.

Are you importing using CSV or Txt? Whenever I have problem using CSV, I normally use the Txt version.

Also, for the price and quantity, do not use $2.00 etc or 2,999.00(thousand seperator).

Use number format General and you should be fine.

[former_member186095]

Hello,

Check field relates to doctotal field in the sales order. I mean if the error message arise when upload file using dtw is application defined or object-defined... it means the value, characters, amount or etc written in the column of the template is not correct. So, the best method is to check one by one. The primary point to check here is doctotal. if the fields relates to doctotal is not correct, e.g. decimal places set in the adm module --> general settings --> tab displays is 2, meanwhile your specified the digit amount in the template is 4, so the error will be thrown away.

Rgds,