+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
View original
+1
I grouped by Inventory ID and that seemed to work… I am worried it wont be accurate information though??
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?
+1
No.. can i just remove the branch all together? i dont need to see “b7y branch” info on the stock items screen
If you’re not using any fields from the Branch table, I would remove it.
+1
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!
Can you upload an XML Export of your GI?
+1
Please see attached.
Thank you so much for looking into this!
No problem. What version of Acumatica are you running?
+1
2021R1 i believe
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
Are you multi-currency? You would get one record per currency ID from the INItemCost table.
If it’s USD only you’re after, you can add a condition to the GI
+1
We only deal with one currency.
Try adding the condition for USD and see how it works.
+1
That seems to have worked! :)
Thank you so much
That great news
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
