Skip to Content
0
Former Member
Jul 02, 2011 at 07:25 PM

Price is not being updated when creating a sales order using DTW oOrders

253 Views

Hello experts,

When I create a sales Order using DTW (oOrders), the information in the input files document.csv and document_lines.csv is updated with no problem, except the price. The price is being ignored from the input files.

Is there something that I must considered when trying to update the price of a sales order using the DTW?

The field "price" was mapped in the source and target fields in DTW.

Here is the document_lines.csv

RecordKey,LineNum,AccountCode,Address,ItemCode,LineTotal,Price,Quantity,ShipDate,WarehouseCode,TaxCode

RecordKey,LineNum,AccountCode,Address,ItemCode,LineTotal,Price,Quantity,ShipDate,WarehouseCode,TaxCode

1,1,_SYS00000000059, ,30PA08-0360-25,1,11.2,3,20110702,V08,A5

1,2,_SYS00000000059, ,30PA08-0707-25,1,15.2,3,20110702,V08,A5

1,3,_SYS00000000059, ,30PA08-0707-22,1,18.3,3,20110702,V08,A5

And the document.csv:

RecordKey,DocEntry,CardCode,DocDate,DocDueDate,DocTotal

RecordKey,DocEntry,CardCode,DocDate,DocDueDate,DocTotal

1, ,c-6167,20110702,20110702,2

Thank you for your help

Jorge Manzo