Forums

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

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?

Kind regards,

leslie

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?

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

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 :(

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.

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 :)