Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change the line item comments/ instruction in purchase order

Status
Not open for further replies.

sara403

Technical User
Jun 10, 2008
58
IN
Hi

I am trying to change the line item comments /instruction for existing POs from other modules.
.i use the following code it works but i have no result.

Dim ITEM_WISE_Note As ACCPACXAPILib.xapiView
Dim Session As ACCPACXAPILib.xapiSession
Set Session = CreateObject("ACCPAC.xapisession")
Session.Open userID, "ADMIN", Company_id, Date, 0
Set ITEM_WISE_Note = Nothing
Set ITEM_WISE_Note = Session.OpenView("PO0610", "PO")
With ITEM_WISE_Note
.Init
.Order = 1
.Browse "porhseq = " & l_porhseq & " and porcseq = " & l_linenumber & " ", True
If .Fetch Then
ITEM_WISE_Note.Fields("comment").Value = Trim(Text1.Text)
.Update
End If
.Cancel
End With

Please help me to solve the issue

Thanks

Saravanan

 
1. Are you sure it's .Fetching?
2. You probably need to .Compose the Header and Line, and .Update them both.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top