price of item after discount

foxclub

Hello
Please I need to make a query to know the price of item after discount.
Which tables could I use?
I am using dynamics Nav 2018 v11

jordi79

You'd have to insert the item and validate in purchase line, sales line to trigger all the logics to calculate item price. You can attempt to do it as a temp records, but I remembered there were errors if I did this on temp records. You can insert actual records And delete it after.