25
Hi,
I am working on project where i needs to add sales order into Microsoft dynamics GP using eConnect.
I am to insert the data into Sale order processing table.(SOP10100) But I want that which Sopnumbe is created how can i get last inserted Sopnumbe.
Thanks,
NIraj
*This post is locked for comments
I don't use lots but I would have thought you don't have enough available stock in the lot you for the quantity that you are trying to order.
Tim
can also tell me the reason behind this issue.
Microsoft.Dynamics.GP.eConnect.eConnectException
Message : Sql procedure error codes returned:
Error Number = 1008 Stored Procedure= taSopLineIvcInsert Error Description = Procedure taSopLot returned an error value
Node Identifier Parameters: taSopLineIvcInsert
SOPNUMBE = ORD0128913
SOPTYPE = 2
Error Number = 2621 Stored Procedure= taSopLot Error Description = The Quantity entered for this Lot is not available in the IV00300
Node Identifier Parameters: taSopLot
SOPNUMBE = ORD0128913
SOPTYPE = 2
ITEMNMBR = 10014238
Related Error Code Parameters for Node : taSopLot
ITEMNMBR = 10014238
LOCNCODE = DISTRIB
QTYTYPE = Note: This parameter was not passed in, no value for the parameter will be returned.
You have choices;
Use the eConnect GetNextDocNumbers method to get the document number before submitting your eConnectDocument, then using that fetched number in your SOPNUMBE fields, so you are "manually" getting the next number and submitting the doc with that number. Thus you know the number created.
see: carldesouza.com/.../
Or you can use the post econnect procedure for the transaction, to write the inserted document number into a custom table that you can then query after inserting the document. You could pass a key in one of the eConnect user defined fields to use to look it back up after the creation so you know its the same one you just created.
eConnect will not return the number to you directly (which would have been nice).
Tim
Hi ,MUHAMMAD FAISAL
I want that using eConnect can you help on this.
Hi Niraj
This query below should give you the last Sale Item.
SELECT TOP 1
HH.DOCDATE Last_Sale,
HH.CUSTNMBR Customer_ID,
HL.ITEMNMBR Item_Number,
HL.ITEMDESC Item_Description
FROM
SOP30200 HH
INNER JOIN
SOP30300 HL
ON HH.SOPTYPE = HL.SOPTYPE
AND HH.SOPNUMBE = HL.SOPNUMBE
WHERE
HH.SOPTYPE = 3
AND HH.VOIDSTTS = 0
ORDER BY HH.DOCDATE DESC
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (