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
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.
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
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156