Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Complex vendor payment...
Small and medium business | Business Central, N...
Suggested answer

Complex vendor payment terms

(1) ShareShare
ReportReport
Posted on by Teresa Babel 24

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!

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
Dynamics 365 Business Central
  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 13,042 Moderator on at
    Complex vendor payment terms
    I don't believe you can do this without customisation. You can only pick one payment term per vendor master.
    Either you change the payment term manually based on the invoice date, or you customise it to update the payment term based on the invocie date.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,981 Super User 2025 Season 1 on at
    Complex vendor payment terms
    Valentin is right, the price master data in BC is also not associated with payment terms. I don’t think it can be perfect without customization, unless you add discount manually.
     
    Hope this helps as well.
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,349 Super User 2025 Season 1 on at
    Complex vendor payment terms
    I don't believe its possible to combine both date criteria into one payment term.
     
    The only way I can see this working out of the box is by having two payment terms (one for invoices dated between 1-10, and one for invoices dated between the 11-EOM). It would then be up to users to manually select the correct payment term when the invoice is posted based on the posting date. 
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans