Adding Discounts to Order Lines using DTW

[Former Member]

I am using SBO 2005 SP1 PL2 and have been able to use DTW to sucessfully import our master data as well as orders, deliveries, invoices, and payments from our legacy system.

I am having trouble figuring out what fields in DTW I need to populate to add discounts to order lines in SBO.

I want to be able to enter the following:

$100 unit price - 10% discount percent = $90 Price after Discount

Entering this by hand fills in these fields in the RDR1 table:

PriceBefDi = $100

DiscPrcnt = 10

Price = $90

Does anyone know what fields in the DTW DocumentLines template I would need to fill in to accomplish that?

Any help would be greatly appreciated.

[former_member221340]

It looks like a "UnitPrice" field has been added to the DocumentLine DTW Template.

Entering this information in DTW yields the desired results.

UnitPrice = 100

DiscountPercent = 10