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.

hi Sarah,

I think you can achieve this by using Account Schedule with Analysis View.
Here are some good examples: dynamicsnavfinancials.com/…/

Best regards,
Hai