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

stacy16
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • 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
  • 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
  • Varsity I
  • 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
  • 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
  • Varsity I
  • 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
  • December 13, 2022

Can you upload an XML Export of your GI?


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

Please see attached.

Thank you so much for looking into this! 


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

No problem. What version of Acumatica are you running?


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

2021R1 i believe


Forum|alt.badge.img+1
  • Semi-Pro I
  • 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
  • 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
  • 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
  • Varsity I
  • December 13, 2022

We only deal with one currency. 


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

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


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

That seems to have worked! :)

Thank you so much @smilner3 


smilner3
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 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