When trying to create a credit memo, Celigo ends up creating two lines for the same product. Has anyone faced this?

Integrator.io
1

When attempting to create a credit memo, Celigo inadvertently creates two lines. Has anyone faced this?

image
image1846×518 91.8 KB

image
image1253×708 37.4 KB

2

Have you tried checking the debug / execution logs to see whats happening under the hood?

3

For some reason, below is the only mapping needed to solve it (still debugging why it creates duplicates without it)

image
image707×535 23.1 KB

4

I guess you set that for the .plu item right?

5

Correct. that was the solution and only solution I have with this.

6

I have the same issue. However, adding the key did not solve my issue. I am still getting duplicate entries

7

After adding the parent key, it still created two lines. When I removed the inventory detail mapping, and let it auto resolve the bins, It provided one line and returned the inventory to the correct location.

8

Hi Patrick,

To resolve this, I had to use item internal Id and Line Id as keys to find existing lines.

image
image3701×1038 165 KB

9

I don’t think it uses a combination of both keys. My understanding is that it uses only one field as the matching key. @tylerlamparter do you happen to know?

10

I'm not too sure. @praveenbasani or @muneswarathotakura do you know this one?

11

Can guarantee it uses both keys. Because we have same item appearing in multiple lines and this is the only way to find the right line for us. So this definitely works.

12

Yeah @tylerlamparter, we do respect adding a combination of multiple keys for NetSuite.