Solved

Report of Stock Items with Cost

  • 20 February 2024
  • 7 replies
  • 72 views
D

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

icon

Best answer by Robert Sternberg 20 February 2024, 21:09

View original

7 replies

L
Rank
Userlevel 6
Badge +6

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.

 

If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Robert Sternberg
Rank
Userlevel 7
Badge +8

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

Hope this helps! 

1 Attachment
Robert Sternberg, Crestwood Associates -- If a community member helped you, please *Like* their post/reply. If they provided an answer to your question, please mark it as *Best Answer*.
B
Rank

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!

L
Rank
Userlevel 6
Badge +6

You can give this a try

If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
B
Rank

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.

L
Rank
Userlevel 6
Badge +6

 

If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
B
Rank

Thank you!!

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved