Sage 100

Customer has a vendor with 1% 10th/25th Net 30 terms. If the invoice is dated on or before the 15th, they get 1% on the 25th of the current month. If it's dated after the 15th, they get 1% when they pay by the 10th of the following month. Anyone have a good way to set this up in Sage 100 4.50 Advanced?

DSD SO-1241 Invoices with multiple due dates.

It's for AP. Their vendor gives them 1% 10th/25th Net 30 terms.

I don't think you can set that up in Terms code maintenance, I tried and failed. I think I would set it up as 1% 10th Net 30 and add script to the invoice date field to set the discount date to the 25th. if it is dated prior to the 15th of the month. when I say ""add script"" it means I would ask my VB programmer to add it for me. Let me know if you need it I can ask him how busy he is and if he has time to look at it, but I think it would be pretty simple code.

This came up previously - similar conclusion that you probably need either two terms codes or scripting -- https://90minds-com.socialcast.com/messages/18262282

@DavidOverholt I was thinking the same thing. I think I would set it up to be 1% 25th Net 30 with a minimum days allowed of 10 on the discount date. Then I could use an if/then to change just the day since the date is a string. Otherwise, I'd be manipulating the entire date. I'm also thinking I'd hard code the terms code.

I ended up scripting it. Even with two terms codes, the AP clerk would have missed it regularly. Thanks for your input, everyone!