I'm looking for the table that contains vendor notes.
Following are notes tables
select * from SY03900
select * from Dynamics..Sy02600
select * from Sy00700
Table SY03900 holding Record Notes information; Find NoteIndx from Vendor Master Table i.e. PM00200 and use that one in Sy03900.
I need to switch 1000 + vendors from ACTIVE to INACTIVE. I'd like to accomplish this task using a SQL script. The challenge is Accounting has requested a note be added to reach vendors master record. Is this doable? If so, do you have suggestions on the structure of the script? The simple part is updating PM00200. The notes tables are the challenging part.
This would not be supported as we do not recommend making these types of changes through the backend. You have to worry about a note index which is pulled from other tables and update as well.
The note index for each vendor is in the NOTEINDX field of the PM00200 table. If a note already exists for the vendor, a record will exist in the SY03900 table with the same NOTEINDX. Changing the status and adding a record to the SY03900 table is easy if there is not already a record there.
If a note already exists for that vendor, you will need to do some concantenation action if you don't want to loose any existing note.
Another option is to use the Comment1 or Comment2 fields on the customer card to record whatever accounting wants you to record.
Don't forget you can also use the DUOS table to record any custom strrings.
I see this as a very doable assignment.
Have you resolved this issue already?
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * email@example.com
Im trying to get this thing going in vendors but it doesnt work. I have a calculated field in which I call the RW_GetNoteText function and the PM_Vendor_MSTR.Note Index as a parameter. I want to read the note and include it in the report but every single time I click print the note is deleted, even if I delete the calculated field of the report.
Is this a custom report you created in Report Writer or a modified report? If it is a modified report, which report is it.
Reading your message reminds me that i have a task to complete for you. You sent me a spreadsheet to be imported. Has it already been imported, or can I still help you with that?
Hi again, the RW_GetNoteText() user defined function has three parameters.
first - the note index of the note
second - the number of characters per line
third - the line number
So if you want 4 lines of 80 characters each you would need four calculated fields:
CalculatedField1: RW_GetNoteText( PM_Transaction_OPEN.Note Index 80 1)
CalculatedField2: RW_GetNoteText( PM_Transaction_OPEN.Note Index 80 2)
CalculatedField3: RW_GetNoteText( PM_Transaction_OPEN.Note Index 80 3)
CalculatedField4: RW_GetNoteText( PM_Transaction_OPEN.Note Index 80 4)
Does this help? Replace the table name with whichever one you are interested in retrieving the record notyes from.
Also, if you have SmartList Builder you can include the notes fairly easily.
Its a modified report. The report Im modifying is Computer Checks Posting Journal.
And about the spreadsheet sorry, I dont know.
I hadn't seen the post about smart builder. I don't know what it is it seems powerful. Im going to check it out know... Any advice?
Sadly the company Im working didn't buyed the smartlist builder component of gp :(
Anyway, thats whats happening to me.
First I enter to Report Writer and modify the report. (http://imageshack.us/f/39/94198337.png/)
I create the calculated field with the params and add it to the report (http://imageshack.us/f/341/11695289.png/)
Then I go to Purchasing, edit payable checks and add a note (http://imageshack.us/f/220/65018267.png/)
But when I print it in the screen the payment number change and the note dont appear in the report (http://imageshack.us/f/689/85960215.png/)
Im just starting my journey in gp, I don't have experience with it.
Hi, I found a solution. The problem was there are a few NoteIndex fields and I was taking the wrong one.
Thanks L Vail for the help!
Or as they say around here... ¡Muchísimas gracias por la ayuda!
Greetings from Dominican Republic :)
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13