SOP Integration - Trade Discount Percent

(0) Share

Report

Posted on by DebN

3,954

I'm importing SOP transactions. I have two source files - a header and an item detail file. My header file contains a trade discount. (I can't put this discount in the customer master table because these percents only pertain to these documents.)

How do I calculate the trade discount amount when I don't have a Document Total in my files?

*This post is locked for comments

All responses (2)

Answers (0)

DebN 3,954 on at

Like (0)

Report

RE: SOP Integration - Trade Discount Percent

Hi Harry,

I got the discount amount calculated in another file and added that as another source. Thanks for the response!
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: SOP Integration - Trade Discount Percent

You'll either need to run a before script or a SSIS against your current source file to sum your document lines and multiply them by your trade discount to get this figure. It should look something like [sum(docamt)*tradediscount]. You might be able to squeeze this script into the tradediscount field, but I am not sure from the details of your post.