web
You’re offline. This is a read only version of the page.
close
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... / Customize Business Cen...
Small and medium business | Business Central, N...
Suggested Answer

Customize Business Central for Payment terms for installment payment.

(0) ShareShare
ReportReport
Posted on by LB_Pgh 265
We are trying to customize our Business Central to have installment payment for customers using payment terms like the payments can be done in 30days/60 days /90 days, split evenly with 33% of total payment. We tried modifying the single cust. ledger entry while a sales order is posted and adding new cust. ledger entries. But the Business Central system is giving these errors:
'The transaction cannot be completed because it will cause inconsistencies in the G/L entry table.'
'You do not have the following permissions on the TableData Cust. Ledger Entry:Insert'
and I'm trying with a system administrator account in Business Central.
I know the partial payment terms (installment payments) is a feature in the Italian version of Business Central and we want to achieve this in the US version.
Any ideas or suggestion on how to achieve this is appreciated.
Thanks.
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hello,

    In standard BC there is no payment terms that can accommodate this. You can use Service Billing to break this up. You can create multiple Sales Invoice with the Terms setup. I will tell you I also copied the Italy Localized version, for my US customer. This might be the easiest solution.

    Thanks,

    Steve

  • SrinathNS Profile Picture
    SrinathNS 10 on at

    Hi Steve,

    How were you able to copy the Italy localized version? and you are saying that was the easiest solution for this issue? Would you please be able to send in the solution for this issue? if not, please provide some pointers on what code unit's need to be changed.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hello,

    After I found out that the Italy Localized version offered the feature, as a Partner I requested the Italy version and had my developers examine the code and create a separate customization for the functionality. I wish this was available in NA version but it was not.

    Thanks,

    Steve

  • uzomac Profile Picture
    uzomac 10 on at

    Wish i could see a video of the process. The customisation done to manage installment payments, breaks inventory into fractions. This doesn't work well for us. 

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hello,

    Maybe this will help... The code to generate a payment terms installment should only effect the Account Receivable Account and the Amount being posted with the correct Due Date. For example, you have an Invoice for 100,000.00. Your terms are 33% NET 30, 33% NET 60, Remainder NET 90 or 34%, total 100%. Upon posting the Original Invoice, the Posted Document Number was split into 3 Documents with a -1, -2 on the 2nd and 3rd document. The first was Document No. 12345 for 33,000.00, NET 30. Next was Document No. 12345-1, 33,000 NET 60, and last Document was 12345-2 34,000 NET 90. All with the same Document Date just different Payment Terms update.

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    Alex Chow Profile Picture
    Alex Chow 4,481 on at

    Is this what you're looking for?

    https://www.youtube.com/watch?v=YE9CWb9UTmE

    This app allows you to create multiple customer ledgers based on a single invoice. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans