Did a bit of research but couldn't find an answer. I need a report that consists of all the line discounts we have given out to our customers.
This is to figure out how much free freight we subsidize for our customers. Just wondering if there is a quicker way of doing so rather than going through each posted sales invoice to see how much the freight cost was that we discounted 100% for.
Create a flowfield in the customer table looking into Sales invoice line with No.(in customer table) into Sell-to customer no.(Sales invoice line) table and add the Line amount field, also add Date filter(Customer table) into Posting date(Sales invoice line) table. You can then create a simple report off the Customer table.
You always enter your freight in the Line Discount field & you (will) never put anything in the Line Discount field except freight. is it true ?
Kindly confirm before modifying anything into the base objects