Does anyone have a customization that allows for different terms for individual lines on a sales order? Based on product group in our case.
Terms are stored in OrderHed.TermsCode. Because of this, you can only set different terms per line, if you make a new order for each line. A brief search reveals no terms codes in the OrderDtl table. You might be able to add a custom field to record the terms at the line level, but I don’t think this will be possible and still have the terms actually work through other places in Epicor.
Sorry, and good luck!
Thank you for the reply Nate - that is my understanding too, I was just curious if anyone else had this need and what they may have done as a work around or customization.
The easiest way would be to create individual sales orders for each line. Once you create the first line for the order, go to Actions > Order > Copy Order. Then just update your new order line with the new terms.
Unfortunately that will not work for us. All customer PO lines need to be on the same sales order acknowledgement for a number of reason.
Ultimately, anything with different terms will need a separate invoice. Can you ship and invoice the lines separately (per terms)?
That is what happens with these types of orders, we have vendor direct shipments that have different terms from other items on the same order and they are invoiced separately by line.
You can create a custom sales order acknowledgement report style that combines multiple sales orders - build it with a filter to select the group of orders.
2 Likes
This is always an idea I have. Like instead of doing crazy things with the actual entry data, why not just make the report crazy instead 
2 Likes
100% - if its the way the data LOOKS that is the problem, reporting is always the answer. Don’t screw up the functionality over appearances.
1 Like
So - create a UD field on the SOAck that allows for a list of Terms to choose from, make that available on the report style so the customer see’s it? This was a thought I had.
The thing is valorie, if you want to use the built in payment discount functionality for your customer, you might want to break up the orders and group the lines on each order by terms type. That way when the AR does invoicing it can apply the appropriate discount.
@aosemwengie1 is saying you should create a different report that groups multiple sales orders together so it looks like you have one order, but it’s really three.
Just an idea though.