Skip to main content
Solved

22R2 Upgrade Stock Items Returning Duplicates

  • Dec 13, 2022 5:25 PM UTC
  • 16 replies
  • 257 views
  • Translate All

stacy16
Varsity I
Forum|alt.badge.img+1

I am working in the sandbox right now and trying to add “last cost” “avg. cost” and “qty on hand” to the generic inquiry.. as soon as i add “INItemCost” it returns duplicate lines on my inquiry results. Here are the relationsi i currently have (before i add INItemCost) Anyone have any ideas?

 

Best answer by Steve Milner

Try adding the condition for USD and see how it works.

View original

16 replies

stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • Dec 13, 2022 5:29 PM UTC

I grouped by Inventory ID and that seemed to work… I am worried it wont be accurate information though??

Translate

Steve Milner
Varsity III
Forum|alt.badge.img+7
  • Varsity III
  • Dec 13, 2022 5:38 PM UTC

I suspect it’s the cross join on Branch that’s causing the duplicates. Are you defining the Branch relationship when adding the INItemCost table?

Translate

stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • Dec 13, 2022 5:43 PM UTC

No.. can i just remove the branch all together? i dont need to see “b7y branch” info on the stock items screen

Translate

Steve Milner
Varsity III
Forum|alt.badge.img+7
  • Varsity III
  • Dec 13, 2022 5:54 PM UTC

If you’re not using any fields from the Branch table, I would remove it.

Translate

stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • Dec 13, 2022 5:57 PM UTC

I removed it.. it didnt help :/ 

I am trying to figure out if i am joining something incorrectly but i just cant figure it out! 

 

Translate

Steve Milner
Varsity III
Forum|alt.badge.img+7
  • Varsity III
  • Dec 13, 2022 5:58 PM UTC

Can you upload an XML Export of your GI?

Translate

stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • Dec 13, 2022 6:10 PM UTC

Please see attached.

Thank you so much for looking into this! 

Translate

Steve Milner
Varsity III
Forum|alt.badge.img+7
  • Varsity III
  • Dec 13, 2022 6:12 PM UTC

No problem. What version of Acumatica are you running?

Translate

stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • Dec 13, 2022 6:37 PM UTC

2021R1 i believe

Translate

Forum|alt.badge.img+4
  • Captain II
  • Dec 13, 2022 6:48 PM UTC

Do you have multiple currencies? I know we had similar issues after our last upgrade with the introduction of INItemCost.CuryID  - we were able to isolate GI’s to our base currency to fix this 

Translate

Steve Milner
Varsity III
Forum|alt.badge.img+7
  • Varsity III
  • Dec 13, 2022 6:50 PM UTC

Are you multi-currency? You would get one record per currency ID from the INItemCost table.

Translate

Steve Milner
Varsity III
Forum|alt.badge.img+7
  • Varsity III
  • Dec 13, 2022 6:52 PM UTC

If it’s USD only you’re after, you can add a condition to the GI

 

Translate

stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • Dec 13, 2022 7:02 PM UTC

We only deal with one currency. 

Translate

Steve Milner
Varsity III
Forum|alt.badge.img+7
  • Varsity III
  • Answer
  • Dec 13, 2022 7:04 PM UTC

Try adding the condition for USD and see how it works.

Translate

stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • Dec 13, 2022 7:06 PM UTC

That seems to have worked! :)

Thank you so much @smilner3 

Translate

Steve Milner
Varsity III
Forum|alt.badge.img+7
  • Varsity III
  • Dec 13, 2022 7:45 PM UTC

That great news @stacy16 !

Translate