Skip to main content
Solved

Report of Stock Items with Cost

  • February 20, 2024
  • 7 replies
  • 146 views

I am looking for a report that will show me a group of stock items and last cost. Sorted by Vendor or Item Class.

Best answer by Robert Sternberg

Hi! @DanaJohnson the attached GI should get you most of the way there. 

Hope this helps! 

View original
Did this topic help you find an answer to your question?

7 replies

Forum|alt.badge.img+5
  • Captain II
  • 292 replies
  • February 20, 2024

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.

 


Robert Sternberg
Captain II
Forum|alt.badge.img+7

Hi! @DanaJohnson the attached GI should get you most of the way there. 

Hope this helps! 


ltussing03 wrote:

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.

 

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:

 

Thanks!


Forum|alt.badge.img+5
  • Captain II
  • 292 replies
  • June 11, 2024

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.


Forum|alt.badge.img+5
  • Captain II
  • 292 replies
  • June 11, 2024

 


Thank you!!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings