I am looking for a report that will show me a group of stock items and last cost. Sorted by Vendor or Item Class.
Report of Stock Items with Cost
I don’t recall any reports or inquiries that include last cost.
You will likely need to create this.
However, it would be easy enough to add to an existing report or GI if you find what that gives you everything else you need. Here’s the table and field you want to add.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3c1c4ccd-cc2c-458b-a7ed-b4c1bed6af50.png)
Hi!
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/9fd54a6a-76cc-41a2-b632-bf2a0bcf40a0.png)
Hope this helps!
I don’t recall any reports or inquiries that include last cost.
You will likely need to create this.
However, it would be easy enough to add to an existing report or GI if you find what that gives you everything else you need. Here’s the table and field you want to add.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3c1c4ccd-cc2c-458b-a7ed-b4c1bed6af50.png)
Hello - would you be able to help display how to connect this table to the existing Stock Items GI? I’ve already added in the INItemCost table, but having a hard time figuring out the connections on the Relations tab. This is what my table relations looks like:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/f0c3fd56-aa11-4f6a-853e-bc59ef61461c.png)
Thanks!
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/670c0c77-98ea-43a6-bee1-ef41bd2c4ff1.png)
You can give this a try
That’s what I have at the moment, but in the Results Grid, I can’t seem to get Last Cost to appear as an option.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/74383016-65db-4fc4-af21-a999451adf3b.png)
Thank you!!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.