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