News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How can I make the Ext...

Microsoft Dynamics GP (Archived)

How can I make the Extended Price and Extended Cost in Excel Report Builder come out as a negative amount? I'm using the SalesLIneItems table only. In Set Field Options nothing appears in the dropdown of Field.

(0) Share

Report

Report

Posted on by Lea Magbuhat

40

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

Re: How can I make the Extended Price and Extended Cost in Excel Report Builder come out as a negative amount? I'm using the SalesLIneItems table only. In Set Field Options nothing appears in the dropdown of Field.

I assume you want credit memos to appear as a negative value. You'd also need to make the calculation conditional based on the Doc Type if that's what you're trying to achieve.
Suggested answer

Mike Smith 6,840 on at

Like (0)

Report

Re: How can I make the Extended Price and Extended Cost in Excel Report Builder come out as a negative amount? I'm using the SalesLIneItems table only. In Set Field Options nothing appears in the dropdown of Field.

You could use the "Calculations" area to create a calculated field that multiplies the selected data fields by a -1

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans