Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GL20000 - ORMSTRID &am...
Microsoft Dynamics GP (Archived)

GL20000 - ORMSTRID & ORMSTRNM

(0) ShareShare
ReportReport
Posted on by Community Member

Can we put whatever we want in ORMSTRID & ORMSTRNM in GL20000 and not break anything in GP?

We are using Infinia to import JE transactions into GP.  Currently, we are not putting anything in these columns.  The transactions we are importing are credit card transactions for company issued credit cards.  We would like to include the Vendor's Name and Card Holder.  My question is if it is a good idea or a bad idea to put Card Holders Name in ORMSTRID and Vendors Name in ORMSTRNM?  Looking at our database, I see all kinds of different information in those columns.  Sometimes it's the Vendor Id, but sometimes just a comment.  So I don't think I will cause a problem doing this.  But I would like to know if anyone has ever ran into a problem doing this.

 

Thanks for your help.

*This post is locked for comments

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: GL20000 - ORMSTRID & ORMSTRNM

    Terry,

    Excellent - glad to help!

  • Community Member Profile Picture
    Community Member on at
    RE: GL20000 - ORMSTRID & ORMSTRNM

    Victoria,

    Thanks for the info.  BTW - I stole the query I used for my report from the GL query you have on your website.  Thanks - that really helped me out.

  • Verified answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: GL20000 - ORMSTRID & ORMSTRNM

    Terry,

    I don't see any reason why this would cause any problems in GP. The only thing those fields are used for is drilling down on transactions that did not originate in the GL. Since your transactions are originating in the GL, I can't see what it would hurt. And it provides a nice place to store the data you need.

    The only issue you might run into is the length of those fields, particularly the ORMSTRID, which is 31 characters. That should be fine for most names, but just something to maybe code into your import, so it truncates at the max.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: GL20000 - ORMSTRID & ORMSTRNM

    These two columns are;

    • ORMSTRID: Originating Master ID
    • ORMSTRNM: Originating Master Name
    They are not supposed to have a comment, they might be vendor id, customer id or any other master id depending on which module the transaction is originating from. Check the following script which links GL20000 table to customer and vendor master tables


    SELECT DISTINCT
    ISNULL(C.VENDORID, '') AS VENDOROD ,
    ISNULL(B.CUSTNMBR, '') AS CUSTNMBR ,
    ORMSTRID ,
    ORMSTRNM ,
    CASE SERIES
    WHEN 1 THEN 'ALL'
    WHEN 2 THEN 'Financial'
    WHEN 3 THEN 'Sales'
    WHEN 4 THEN 'Purchasing'
    WHEN 5 THEN 'Inventory'
    WHEN 6 THEN 'Payroll'
    WHEN 7 THEN 'Project'
    WHEN 10 THEN 'ThirdParty'
    END AS Series
    FROM dbo.GL20000 AS A
    LEFT OUTER JOIN dbo.RM00101 AS B ON A.ORMSTRID = B.CUSTNMBR
    LEFT OUTER JOIN dbo.PM00200 AS C ON ORMSTRID = C.VENDORID

    So I am not quite with your suggestion of filling any type of date, you may use the "Reference" field to store your comment, but you are supposed to retrieve the master number from the originating module to be filled within these fields.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans