Skip to main content
Solved

22R2 Upgrade Stock Items Returning Duplicates


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 smilner3

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

View original
Did this topic help you find an answer to your question?

16 replies

stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • 83 replies
  • December 13, 2022

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


smilner3
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 28 replies
  • December 13, 2022

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?


stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • 83 replies
  • December 13, 2022

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


smilner3
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 28 replies
  • December 13, 2022

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


stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • 83 replies
  • December 13, 2022

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! 

 


smilner3
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 28 replies
  • December 13, 2022

Can you upload an XML Export of your GI?


stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • 83 replies
  • December 13, 2022

Please see attached.

Thank you so much for looking into this! 


smilner3
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 28 replies
  • December 13, 2022

No problem. What version of Acumatica are you running?


stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • 83 replies
  • December 13, 2022

2021R1 i believe


Forum|alt.badge.img+1
  • Semi-Pro I
  • 97 replies
  • December 13, 2022

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 


smilner3
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 28 replies
  • December 13, 2022

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


smilner3
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 28 replies
  • December 13, 2022

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

 


stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • 83 replies
  • December 13, 2022

We only deal with one currency. 


smilner3
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 28 replies
  • Answer
  • December 13, 2022

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


stacy16
Varsity I
Forum|alt.badge.img+1
  • Author
  • Varsity I
  • 83 replies
  • December 13, 2022

That seems to have worked! :)

Thank you so much @smilner3 


smilner3
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 28 replies
  • December 13, 2022

That great news @stacy16 !


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings