×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Notes Table ?

Notes Table ?

Notes Table ?

(OP)
What table are the notes kept in for customer maintenance window?

RE: Notes Table ?

The table is called Records Notes Master (SY03900) and holds all the notes for the company.

RE: Notes Table ?

(OP)
I want to delete all notes for 1 company. Do you think it's safe to open this table and delete all rows?

RE: Notes Table ?

No this is not a safe approach.  This is because other tables have a reference to the data in the notes table.  

You would also need to delete the reference to the notes master from these other tables.  I think these fields are called Noteidx and Noteid.  However it's quite a lot of tables that you would have to check.

The safest way to remove notes is to do so from the entry screens.  This removes all references in all linked tables.

RE: Notes Table ?

It would be possible to do a join between the Customer Master table and the Record Note Master and delete only notes that have a Note Index which exists in the Customer Master table.

David Musgrave
Senior Development Consultant
Asia Pacific Professional Services

Microsoft Business Solutions
http://www.microsoft.com/BusinessSolutions

mailto:dmusgrav@nospam-microsoft.com

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.

RE: Notes Table ?

HI All,

Im currently very new with greatplains can somebody tell me what table in the database holds the profile of the customer ?

thanks

RE: Notes Table ?

if it is SQL you might want to look at RM00101 --- it has most of the info, but the rest I use is in RM00102, 103, 104 & 105

btw - you might want to make new posts instead of posting in old threads - this one might get missed.

RE: Notes Table ?

thanks jymm,

well i was just searching for this and found it in this thread so i just gave it a try. hey one more thing have you worked directly with the tables to make it a source of some other database of some other application ? i am into such development at the moment where i might have to make one database as a meta database of all the databases. its getting quite complex for me how to go through it.

RE: Notes Table ?

I used SQL to something similar integrating our CRM product with Dynamics, Outlook and our plant production system.   If you know SQL, things are not that bad.  Finding data in Dynamics though often is a pain --- I had to get a shovel and dig to find some things that were not documented too well.

My applications are all triggers, stored procedures, custom views & DTS that I installed onto our Dynamics databases to pull the info one way or the other.   I also push things to a reporting db for my intranet reporting.

Quite complex (check)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close