Department inform missing in Financeaccount table

I have linked MS Access to the Financeaccount table. I can extract values by period, but I do not get any values by department. Even when I use the department filter, I don’t get the right department values.

Are you sure that the relevant informations (department) always have been posted? Please check the GL Entries.

quote:


Originally posted by jsnayberk: Are you sure that the relevant informations (department) always have been posted? Please check the GL Entries.


Thanks for your reply. Yes I’m sure entries are posted with department codes. From the total table, I can select balance by date using the datefilter field. There is both a department field, a department filter field, and a department required field (0/1), but no values in the total tabel. Can the department field be joined with another table to provide me with period totals by department ? Regards Frank

Sorry, but what version are we talking about?