Income Statement by location

[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.

[former_member292966]

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,

Brian