Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Profit and Loss

Posted on by 1,290

Dear All,

I assume that I have one inventory item and one site and two expense accounts (two regions in the GL for the same expense type, example salaries).

Please see the following profit and loss statement:

                         East Region         West Region     

Sales                   1000                       1200
COGS                    500                         600
Gross Profit            500                         600
Salaries                 300                         200
Net Profit               200                         400

The question is what is the best way to get the above mentioned report?

Best Regards,

*This post is locked for comments

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Profit and Loss

    Waleed, that depends on how your Chart of Accounts is structured.  If it was setup to account for Sales & COGS by region, then it would be easy to pull the data from the GL.  If not, then I would create a report in SSRS that accesses the data in Sales Order Processing.

  • Waleed Tibi Profile Picture
    Waleed Tibi 1,290 on at
    Re: Profit and Loss

    Thank you Frank and Mohamed for the input.

    The question here is how technically can we generate sales, COGS and gross profit by region, is it from the GL by creating Sales and COGS accounts for each region in the GL? or linking to sales module is better in this case? or using dimensions? I like to know what companies usually do to solve this issue.

    Thank you

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Profit and Loss

    Waleed, GP's Management Reporter is the tool to use for creating financial reports.  Advanced Financial Analysis can also produce such a report but it is not nearly as flexible or user-friendly as Management Reporter.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Profit and Loss

    Hello Waleed,

    All reporters that are available in GP could get this report, you just need to filter your columns for specific accounts. However, your partner can explain more.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans