[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 847
  • Last Modified:

Inventory item does not exist eConnect error

I am trying to eConnect a sales order into GP. Although the items exists in GP for this site I get all these errors. Please help:
Error Number = 108  Stored Procedure= taSopLineIvcInsert  Error Description = Inventory item does not exist
Error Number = 771  Stored Procedure= taSopLineIvcInsert  Error Description = Price Level is blank, it must either be passed in or a default must exist for the transaction
Error Number = 4646  Stored Procedure= taSopLineIvcInsert  Error Description = Decimal Places passed in on UNITPRCE does not match setup
Error Number = 5313  Stored Procedure= taSopLineIvcInsert  Error Description = Unit of Measure does not exist for the Unit of Measure Schedule being used
Error Number = 11454  Stored Procedure= taSopLineIvcInsert  Error Description = Decimal Places passed in on QUANTITY does not match what is set up for the Item Number
0
TrialUser
Asked:
TrialUser
1 Solution
 
Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi,

In my experience, those particular errors are accurate, so they should indicate that the inventory item does not exist in the data source and database that you are accessing.

There could be other explanations, but I would start by checking the connection string and database that you are sending eConnect and verify that it is the same database where you are checking your inventory item in GP.

Let me know if that makes sense.

Thanks,

Steve Endow
Microsoft MVP - Dynamics GP
Dynamics GP Certified IT Professional
0
 
TrialUserAuthor Commented:
Thanks a bunch it was the connection string.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now