News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) A Report with Debit &a...

Microsoft Dynamics GP (Archived)

A Report with Debit & Credt Columns Q

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

I'm trying to construct a MR Report with debit & credit columns. "C" column = Last Years values, "D" column = This years. Column "E" then adds or nets these 2 columns. But I now want to display the Results in there appropriate debit or credit column, instead of just 1 column.

I've tried using an If formula in the Formula CALC cell - MR doesn't like that. You have the ability of Column Restrictions if the Column Type is FD, but not if its CALC

How can I do achieve my goal?

0652.Capture.JPG

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: A Report with Debit & Credt Columns Q

Ok, I've figured it out, 25 years working with Excel, 1 week with GP

In Column E, formula cell place this: IF C+D>0 THEN (C+D) ELSE 0

In Column F, formula cell place this: IF C+D<0 THEN (C+D) ELSE 0

This produces 2 neat columns, one debit, one Credit

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