web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Solomon report field d...
Microsoft Dynamics SL (Archived)

Solomon report field definitions

(0) ShareShare
ReportReport
Posted on by Colleen Kelly 35

Hi There,

 I just started using MDSL and Solomon, unfortunately there does not seem to be a user manual, does anyone know where I can locate the definitions of the Record.Fieldname within the field list.  Some of them are straight forward, but there are a lot that are not.  Any help would the greatly appreciated.

 Thanks

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi kelly you can open the help files and in the "Contents Tab" you see a book with the name Schema, you select the solomon 6.0 or 6.5 schema and see the financial, distribution, project modules etc, for example enter to the financial management schema and you can see all the tables that this module use, open APDOC and you can see the datatype and the description each field.

  • Paul Phillips Profile Picture
    Paul Phillips 590 on at

    Hi Colleen,

    If you are building a report based on an existing Solomon screen, sometimes it is helpful to view the table and field underlying a screen control. The easiest way to do this is to put the screen into customize mode and open the property window. Then look in the field name property. The table.fieldname will be prefixed with a "b" (which is short for buffer). Sometims a screen control is not bound to a physical database table and field though, and instead refers to a local buffer variable 'owned' by the screen program.

    If you use this technique, be sure not to save your changes when exiting customize mode, otherwise it may disrupt the screen layout for other users. The Customization Manager help files provide more detail on how use this mode.

    Also, the screens are usually organized into levels, each of which contains a primary table. For example, the Invoice and Adjustment Maintenance screen in AR has a Batch, Document, and Transaction level (among others) that roughly correspond to the layout of the screen. These levels refer to the Batch, ARDoc, and ARTran tables in the database. Usually you can join between tables using the primary keys or unique index fields, and the field names on the join are often the same in related tables.

    Another useful technique is to find an existing report that is close to what you need and then view the tables and joins, or copy the file and and modify it.

    Paul Phillips

  • Geovanny Fuentes Profile Picture
    Geovanny Fuentes 5 on at

    Very good in finding the fields values.
    I just need to do a bit FIND alot for all Values stored in the system from different modules under it for the General Entries.

    Thanks, Geovanny

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans