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?
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?
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.
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?
Please see attached.
Thank you so much for looking into this!
No problem. What version of Acumatica are you running?
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
We only deal with one currency.
Try adding the condition for USD and see how it works.
That seems to have worked! :)
Thank you so much
That great news
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.