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