Balance sheet by dimension

We have a dimension set up for our Departments.  This represents two retail stores and one "corporate" location.  This corporate location is essentially used for Accounts Payable and a few other balance sheet accounts that haven't made sense to break out to the stores on the balance sheet.  Question...when we process payables is there a way to designate the payable for a specific store to go to the dimension for that store?  So we would have Accounts Payable Store A and Accounts Payable Store B, where the Accounts Payable GL would be the same.  The ultimate goal is to get a balance sheet for just the two stores and not corporate as it would be zero.  Appreciate any thoughts anyone has.

Related