Adding Discounts to Order Lines using DTW
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.