Payables PM10000 Question

[Jeff G]

As part of integrating some items into Payables, I'm stuck on one field in
the PM10000 table....the NOTEINDX field. I know it's a Note Index field,
but how is the number generated and what does it cross reference?

Thanks.

Jeff

[Mariano Gomez]

During the integration process, Dynamics GP will assign the next note index
to your transaction. The note index itself is retrieved from the Company
Master table (SY01500) in the DYNAMICS database and is then assigned to the
transaction. When a user adds a note to the transaction in GP, the note is
stored in the SY03900 table along with the assigned index.

Please take a look at my article:

- All About OLE Container at
http://dynamicsgpblogster.blogspot.com/2008/11/all-about-dexterity-ole-container.html

This article details more information on OLE Notes and how the note index is
used to store the file name of the attached OLE note.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com

Post by Jeff G
As part of integrating some items into Payables, I'm stuck on one field in
the PM10000 table....the NOTEINDX field. I know it's a Note Index field,
but how is the number generated and what does it cross reference?
Thanks.
Jeff

[Carlos Garcia]

Try this:

DECLARE @CMPANYID SMALLINT
DECLARE @sCompanyName CHAR(65)
DECLARE @iStatus INT
DECLARE @NOTEINDX NUMERIC(19,5)
DECLARE @iGetNextNoteIdxErrState int

SELECT @CMPANYID = cmpanyid,
@sCompanyName = cmpnynam
FROM dynamics..sy01500 (nolock)
WHERE interid = Db_name()

EXEC @iStatus = dynamics..Tasmgetnextnoteindex
@I_sCompanyID = @CMPANYID,
@I_iSQLSessionID = 0,
@I_noteincrement = 1,
@O_mNoteIndex = @NOTEINDX OUTPUT,
@O_iErrorState = @iGetNextNoteIdxErrState OUTPUT

So, you can use @NOTEINDX

Carlos Garc?a!

Post by Jeff G
As part of integrating some items into Payables, I'm stuck on one field in
the PM10000 table....the NOTEINDX field. I know it's a Note Index field,
but how is the number generated and what does it cross reference?
Thanks.
Jeff

Post by Mariano Gomez
During the integration process, Dynamics GP will assign the next note index
to your transaction. The note index itself is retrieved from the Company
Master table (SY01500) in the DYNAMICS database and is then assigned to the
transaction. When a user adds a note to the transaction in GP, the note is
stored in the SY03900 table along with the assigned index.
- All About OLE Container at
http://dynamicsgpblogster.blogspot.com/2008/11/all-about-dexterity-ole-container.html
This article details more information on OLE Notes and how the note index is
used to store the file name of the attached OLE note.
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com