GREAT PLAINS REPORTS DATA DICTIONARIES

[BHAT100]

Is there way to find dictionaries in great plains for reports.

 

[winthropdc]

Could you explain further what you mean?

The location of the reports dictionary is pointed to by the path in the DYNAMICS.SET Launch file. Note that the paths are generic pathnames and are meant to have a colon before and after the drive letter, no root slash and use forward slashes.

If you are looking for sample reports, there is a reports library that you can download from on CustomerSource or PartnerSource.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[BHAT100]

Actually I am looking for script and tables fields and tables names used to generate reports. for example, I am making historical stock status report by location by GL DATE. I am really strugging to know the tables names and fields used in report because if I go to report writer, it shows temp as main table and legend for GL POSTING DATE. This legend moreover is not calculated field. if I go to dexsql.log, it does not shows how transactions are pulled by GL POSTING DATE and what fields they have used for gl posting date.

Any idea would be really help to me

-bhat

 

[winthropdc]

There is probably dexterity code running to build the contents of the TEMP table. It would be that code that is checking the date range to use.

Legends are string fields passed to the report when the Dexterity code launches the report.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[BHAT100]

is there any way in sql server or great plains to see query or store procedure codes in temp or other tables

Thanks
-bhat

 

[jymm]

struggling through what field names are in which table can be fun at best --- I gave up on Report Writer LONG ago and switched for this type of report to Crystal.

Here is a link to a previous discussion about which table is which - I am sure that if you have this knowledge that you can find what you are looking for - if not - we are here.

http://www.tek-tips.com/viewthread.cfm?qid=383658

 

[winthropdc]

Have a look at my FAQ entry on this site faq632-4746. I explains how to find what you need.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.