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.
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,
Brian