Checking period/posting settings across companies

[dldev]

Hello experts,

Is it possible to run a query to pull the fiscal period and posting settings across multiple companies (databases)? If so, could someone please show me an example of how I would query this? I wasn't sure if there is a system table in the Dynamics db I could query or if I had to query system tables in each company.

Thanks,
Dennis

 

[jazgeek]

its company specific. You'd need to create a union query to pull the various companies together and then report on it in crystal reports or some such.

-----------
and they wonder why they call it Great Pains!

jaz

 

[Dukester0122]

here are the tables to help you:
SY02300 for the posting settings
Sy40100 for the fiscal period