Have any body using Service Connect?

> We have testing the Service Connect8.1 and I want to "import" the

> inventory opening balance via Serivce connect, it is found that there

> has a WebService - InventoryQtyAdjService,it included several process

> in it? which process should I use ? Have anyboby experience on it ?

> thanks



We didn't use ServiceConnect or Web Services, we went directly to the business
objects and used Visual Studio 2003. Here's my Visual Basic code for doing
this. I loaded our physical inventory from the old system into an Access
database. You need to load your reason code first. In the reference field, I
listed the physical inventory tag number. This should give you an idea of
which fields are required and how to call the methods. I did use the tracing
options to see which methods were called as Mr. Walker suggested.



Mark W.



Dim IConn As New Odbc.OdbcConnection("DSN=Import;uid=;pwd=;")

Dim rowQty As Epicor.Mfg.BO.InventoryQtyAdjDataSet.InventoryQtyAdjRow

Dim Cmd As New Odbc.OdbcCommand("select * from physical where tagqty >
0 order by part")

Dim ctr, errCnt, intTag As Integer

Dim strPart, errMsg, strMsg As String

Dim rdr As Odbc.OdbcDataReader



Try

StatusBar1.Text = "Opening Session..."

IConn.Open()

Cmd.Connection = IConn

' Cmd.Connection = Vconn

rdr = Cmd.ExecuteReader()

' Create session

' Live Database

objSess = New Epicor.Mfg.Core.Session("user", "pass",
"AppServerDC://UFMERP:8301", Epicor.Mfg.Core.Session.LicenseType.Default)

' Test Database

' objSess = New Epicor.Mfg.Core.Session("user", "pass",
"AppServerDC://UFMERP:8321", Epicor.Mfg.Core.Session.LicenseType.Default)

' Create Vantage objects...

objPart = New Epicor.Mfg.BO.Part(objSess.ConnectionPool)

objQty = New Epicor.Mfg.BO.InventoryQtyAdj(objSess.ConnectionPool)

dsPart = New Epicor.Mfg.BO.PartDataSet

dsQty = New Epicor.Mfg.BO.InventoryQtyAdjDataSet

Catch ex As Exception

Call MsgBox(ex.Message, MsgBoxStyle.OKOnly, "Error - Setting Up")

Application.Exit()

End Try



Try

While rdr.Read()

strPart = Trim(rdr("partnum"))

intTag = rdr("tag")

' See if part exists

If objPart.PartExists(strPart) Then

dsQty = objQty.GetInventoryQtyAdj(strPart)



objQty.KitPartStatus(strPart, strMsg)

If strMsg = "" Then



dsQty.InventoryQtyAdj.Item(0).BinNum =
Trim(rdr("binnum"))

dsQty.InventoryQtyAdj.Item(0).AdjustQuantity =
CDec(rdr("tagQty"))

dsQty.InventoryQtyAdj.Item(0).ReasonCode = "PHYS"

dsQty.InventoryQtyAdj.Item(0).ReasonCodeDescription =
"Initial Physical"

dsQty.InventoryQtyAdj.Item(0).WhseBinDescription =
Trim(rdr("binDescription"))

dsQty.InventoryQtyAdj.Item(0).RowMod = "U"

dsQty.InventoryQtyAdj.Item(0).Reference = "Tag: " &
Format(intTag)



Try

objQty.SetInventoryQtyAdj(dsQty)

Catch ex As Exception

Console.WriteLine(Format(intTag) & " " & strPart &
" : " & ex.Message)

End Try

End If

dsQty.Clear()

End If

End While

Catch ex As Exception

Call MsgBox(ex.Message, MsgBoxStyle.OKOnly, "Error in Qty Adj " &
Format(intTag))

End Try



[Non-text portions of this message have been removed]
Hi All,

We have testing the Service Connect8.1 and I want to "import" the
inventory opening balance via Serivce connect, it is found that there
has a WebService - InventoryQtyAdjService,it included several process
in it? which process should I use ? Have anyboby experience on it ?
thanks

Joey Ng
THINK Technology Group
Enable tracing by using Tracing Options from the options menu (just
above developer)

Make a manual adjustment using the Vantage inventory adjustments.

Turn off tracing. Go to the client\log folder and you will find a txt
file called tracedata and 4 numbers. Open it up and you will find all
the business object method calls made while tracing was enabled. From
there you will be able to find the methods you need to use in service
connect.

--- In vantage@yahoogroups.com, "joeynsknew" <joeyttg@...> wrote:
>
> Hi All,
>
> We have testing the Service Connect8.1 and I want to "import" the
> inventory opening balance via Serivce connect, it is found that there
> has a WebService - InventoryQtyAdjService,it included several process
> in it? which process should I use ? Have anyboby experience on it ?
> thanks
>
> Joey Ng
> THINK Technology Group
>