web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Apply bulk credit adjustments

(0) ShareShare
ReportReport
Posted on by 4
Hello there
 
I am wondering if someone knows of a way to apply bulk credit adjustments from an XLS.
 
If we have an XLS with some customers who's orders weren't fulfilled we want to credit them on their next invoice.
 
We are wondering if it is possible to import an XLS with the customers and credit amounts into Business Central and have it apply directly to their next invoice?
 
Kind regards,
 
Timothy
  • Suggested answer
    YUN ZHU Profile Picture
    104,117 Super User 2026 Season 2 on at
    Hi, this requires customization.
    You need to import the Credit memo from xls file (Excel), post it and automatically apply it to the next invoice. Unfortunately, the standard can't do that.
    Maybe you can consider using Configuration Package and some manual operations.
    How to Export and Import Data (Using Configuration Packages)
     
    How to use Configuration Package to post documents (Sales Order, Purchase Order, Transfer Order, General Journal, etc.)
     
     
    Hope this helps.
    Thanks.
    ZHU
  • IC-27040904-0 Profile Picture
    4 on at
    Hi Zhu,
     
    I followed the steps in your articles however I am still unsure on how to configure it exactly to be able to post credit adjustments for their next invoice from the XLS.
     
    Regards,
     
    Timothy

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 645 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 432 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 248 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans