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

How to show credit memo amount value against invoice.

(1) ShareShare
ReportReport
Posted on by 153

Hi Guys,

I have one report. i.e. Sales invoice report.

This report using 2 dataitems:  sales invoice header & sales invoice line.

For below exaample :  My first invoice i.e. TL586-3045-2324 we have applied a credit memo against that invoice.

I want to show on my report : For example : If  we apply a credit memo against a particular invoice, then that credit memo amount is shown on the report. i.e. negative amount is shown on report i.e.- 25640

&  if we don't apply a credit memo against a particular invoice, then that invoice amount is shown on the report i.e. 25640.

& this amount values come from customer ledger entry.

I am writing below logic on the sales invoice header- on the OnAfterGetRecord trigger.

but i didn't get right output. my output shows only positive values.

I

Is any way to do this.

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    98,128 Super User 2026 Season 1 on at

    Hi, what about using OnPostReport (Report) Trigger? Or the easiest way is to add "-" directly to the Layout file, although this is not recommended.

    Hope this helps.

    Thanks.

    ZHU

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,964 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,086 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,039 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans