We have a vendor with unique payment terms: 1% 10TH & 25TH NET 30. For invoices dated between 1-10 need to be paid by the 25th to take the 1% discount, and invoices dated between the 11-EOM need to be paid by the 10th to take the 1% discount. We are on version v23 of SaaS Business Central.
I’m trying to come up with a date formula that will work but have not had any luck. In my research I have seen responses to identical questions that have simply stated that it’s possible to do this in BC without custom code, but they don't provide insight on how to accomplish this. I know you can specify a day of the month an invoice would be due by using D10 or D25 (day 10 or day 25 of the month), but since you can only have 1 payment term on a vendor card, I’m not sure how to combine these to make one formula. Any thoughts/recommendations are greatly appreciated. Thank you!
