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
  • Suggested answer
    Alex Chow Profile Picture
    Alex Chow 4,481 on at
    RE: Customize Business Central for Payment terms for installment payment.

    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. 

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Customize Business Central for Payment terms for installment payment.

    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

  • uzomac Profile Picture
    uzomac 10 on at
    RE: Customize Business Central for Payment terms for installment payment.

    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
    RE: Customize Business Central for Payment terms for installment payment.

    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

  • SrinathNS Profile Picture
    SrinathNS 10 on at
    RE: Customize Business Central for Payment terms for installment payment.

    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
    RE: Customize Business Central for Payment terms for installment payment.

    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

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
YUN ZHU Profile Picture

YUN ZHU 505 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 400

#3
Sagar Dangar, MCP Profile Picture

Sagar Dangar, MCP 384

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans