Skip to Content

Income Statement by location

Nov 17, 2017 at 04:39 PM


avatar image
Former Member

We need A P&L Statement, by Location Code, on one spreadsheet. I attempted the cross Tab reporting, as well as attempting to writ sub reports for each location. The issue is that I am unable to isolate the Location when listing the GL Account History.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Brian Dong Nov 17, 2017 at 06:21 PM

Hi Teri,

This is a bit hard to answer because we don't know your data and how it's setup. Usually, I would recommend creating a group in the report based on Location. Then you can create the Profit & Loss. If you can't get a location from the Account History there may be another table, like a Customer table, that has that information you can link to your Account History.

Good luck,


10 |10000 characters needed characters left characters exceeded