Skip to main content
Solved

Getting issue on Order sync with Inventory Item contains segment keys

  • Mar 14, 2022 6:20 PM UTC
  • 7 replies
  • 197 views
  • Translate All

jinin
Pro I
Forum|alt.badge.img+12

Hello Everyone,
One of our client configured the InventoryID segment key like below.


When we try to create an order through API with this product, getting the error “The record has been deleted”.  It's not considering the “-” while syncing the order.

If provide the value without the “-” It's working fine.

And also we noticed that if added only one segment key with “_” or “-”  worked fine.

Is it any possible way to sync the product with this Segment Key configuration?. 


 

 

Best answer by jinin

Hi @Naveen Boga 

I got the response from Acumatica. If we pass with separators, then we must pass all the segments. Its working fine now.

e.g.

            "InventoryID": {

                "value": "01-029-0100-   "  // note 3 spaces for the 4th segment

            },

 

 

View original

7 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Mar 15, 2022 4:33 AM UTC

Hi, @jinin  I have added the segments to the InventoryID and created a new stock Item (AA-BB-CC) in the local instance.

When I add the line item in the Sales Order screen manually, without segment like (AABBCC), and the line is accepted and I can able to create the sales order. Since it is working manually, hoping that same way it should with REST API as well.

 

 

 

Translate

jinin
Pro I
Forum|alt.badge.img+12
  • Author
  • Pro I
  • Mar 15, 2022 4:44 AM UTC

Hi @Naveen Boga 

As I mentioned above, No issue with adding a Single Segment key or without a separator in request. Am facing an issue with Multiple segmentID with InventoryID (refer to the screenshot above). 

The expectation is the external system sends the inventoryID with “-” and Acumatica System should accept with the same value. 
 

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Mar 15, 2022 5:27 AM UTC

Hi @jinin 

I have created a brand new instance and added multiple segments and am able to add manually at line level.

Also, verified with the REST API, it is working fine. Please find the screenshot for reference.

 

 

 

 

Translate

jinin
Pro I
Forum|alt.badge.img+12
  • Author
  • Pro I
  • Mar 15, 2022 6:12 AM UTC

Hi @Naveen Boga 

Thanks for the update.

But still, we are facing the issue with the client instance. Not sure the exact reason for the issue. 

Translate

jinin
Pro I
Forum|alt.badge.img+12
  • Author
  • Pro I
  • Mar 21, 2022 4:56 AM UTC

We raised a support case for this issue. Will share the details once the issue is resolved.

Translate

jinin
Pro I
Forum|alt.badge.img+12
  • Author
  • Pro I
  • Answer
  • Mar 26, 2022 4:08 AM UTC

Hi @Naveen Boga 

I got the response from Acumatica. If we pass with separators, then we must pass all the segments. Its working fine now.

e.g.

            "InventoryID": {

                "value": "01-029-0100-   "  // note 3 spaces for the 4th segment

            },

 

 

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Mar 26, 2022 8:09 AM UTC

Oh Okay @jinin  Thanks for sharing the update.

Translate