Query to calculate Invoice discount based on the Payment Terms?
Our Invoices are calculating the Discounts Incorrectly. It is including the Freight amount too. All the setup was verified and everything looks good.
I need to be able to write a query to determine the correct discount amount that should have been taken based on the Terms. Can you please help.