It is because the context of your date table is Sales date. Since the date is linked only with Sales date as 1 to many ( Which is best way for most of the cases but not his one) . The context is taking from the sales date not the balance sheets date. You need to create dynamic date links.
This was discussed in length recently in this forum. I hope this will serve