Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP WebService CreateSa...
Microsoft Dynamics GP (Archived)

GP WebService CreateSalesInvoice error when working with items trackable by serial number

(0) ShareShare
ReportReport
Posted on by hassan oweidat

Hello All,

I've been trying to execute the webservice method CreateSalesInvoice from the provided example in the help file. However I keep getting the following error:

'Procedure or function 'taSopSerial' expects parameter '@I_vLNITMSEQ', which was not supplied.'

The item I'm trying to invoice is a trackable item by serial number.

 

I'm also not able to specify the price using the following:

Dim UnitPrice As New MoneyAmount()
UnitPrice.Value = 20D
UnitPrice.Currency = "USD"
salesInvoiceLine.UnitPrice = UnitPrice

 

However I'm getting the default price of $15 instead.

Any help is appreciated. 

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: GP WebService CreateSalesInvoice error when working with items trackable by serial number

    For pricing you will need to pass .DEFPRICING = 0 to get the system use your inputs, for the serail issue you need to pass the LNITMSEQ as apart of taSopSerial_ItemsTaSopSerial:

                               Dim objSerial As New taSopSerial_ItemsTaSopSerial

                               With objSerial

                                   .LNITMSEQ = 16384

                               End With

  • hassan oweidat Profile Picture
    hassan oweidat on at
    Re: GP WebService CreateSalesInvoice error when working with items trackable by serial number

    there is no property called LNITMSEQ or any equivalent name in saleslineserial class :(

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: GP WebService CreateSalesInvoice error when working with items trackable by serial number

    Hajji Hassan,

    I think your code is right; you need to pass LNITMSEQ no.

    salesLineSerial.LNITMSEQ =16384

    if for one item there more than one Serial Numbers then you need to put above code in Array.

    Let me know how it goes.

    Thanks

    Sandip

  • hassan oweidat Profile Picture
    hassan oweidat on at
    Re: GP WebService CreateSalesInvoice error when working with items trackable by serial number

    any help please

  • hassan oweidat Profile Picture
    hassan oweidat on at
    Re: GP WebService CreateSalesInvoice error when working with items trackable by serial number

    how to pass it in code?

    i am using the following:

               Dim SerialsLst() As SalesLineSerial = Nothing

               Dim saleslineserial As New SalesLineSerial

               saleslineserial.SerialNumber = "03203551470"

               ReDim SerialsLst(0)

               SerialsLst(0) = saleslineserial

               salesInvoiceLine.Serials = SerialsLst

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: GP WebService CreateSalesInvoice error when working with items trackable by serial number

    Hassan,

    You neeed to pass Line Item SQ No like if your Item No for each item. E.g. if you have 5 different Items says Item No : A,B,C,D,E THEN YOUR Line Item SQ No is for "A" 16384 for B 32768 , C= 49152 like that.

    Check table ■SOP10201  History and ■SOP10107  for Work table to understand SQ No.

    Check existing Entry in SOP line item table : sop30300  'LNITMSQ' FIELD  show same line item on sop10201 for historical transactions.

    Let me know how it goes.

    Thanks

    Sandip

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans