Price Lists, Analysis Codes, and Discounts

[Bev McConnell]

Can anyone give me any insight as to where the discount % are found in relationship to pi_mstr, an_mstr, and ans_det?
I have searched and cannot find where the actual discount % is located.
I have a scenario where the customer is tied to a price list that points to an analysis code (type '6'), but cannot track down the discount.

 

[dangaet]

:awink:

Discount price lists are also stored in the pi_mstr, the details however are in the pid_det. If you'd want to have a look at what price lists are applied to a sales order you can have a look in the pih_hist.

Regards
Danny