Microsoft Dynamics GP (Archived)

Vendor Notes

(0) Share

Report

Posted on by Titan - Home

265

I'm looking for the table that contains vendor notes.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

sandipdjadhav 18,306 on at

Like (0)

Report

Titan,

Following are notes tables

select * from SY03900

WHERE NOTEINDX='3060363'

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.

Thanks

Sandip

Was this reply helpful? Yes No
Titan - Home 265 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

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.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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?

Kind regards,

leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Any Ideas?

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

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?

Kind regards,

Leslie

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

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.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Its a modified report. The report Im modifying is Computer Checks Posting Journal.

And about the spreadsheet sorry, I dont know.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Sadly the company Im working didn't buyed the smartlist builder component of gp :(

Any Suggestions?

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.

Thanks.

Was this reply helpful? Yes No