AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
Stock Item Average ...
 
Notifications
Clear all

Questions [Solved] Stock Item Average cost

 
Everything Else
Last Post by DKD 5 years ago
5 Posts
5 Users
4 Reactions
4,514 Views
RSS
Posts: 1
 Riegel Rey Alcaraz
Topic starter
May 3, 2019 5:21 am
(@riegel-rey-alcaraz)
Member
Joined: 6 years ago

Hi

I would like to ask how does average cost of stock items work ? on our accumatica we have min and max cost . the average cost  doesn't return any  value

thank you 


4 Replies
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
May 7, 2019 9:17 pm
(@timrodman)
Famed Member
Joined: 10 years ago

The Valuation Method field on the GENERAL SETTINGS tab of the Stock Items (IN202500) screen has to be set to Average:

 

Then the Average Cost field on the PRICE/COST INFO tab of the Stock Items (IN202500) screen should be populated with a value.


Reply
ncantral reacted
Michael Triffon
 Michael Triffon
(@michaeltriffon)
Joined: 6 years ago

Eminent Member
Posts: 23
March 30, 2020 2:34 pm
Reply toTim RodmanTim Rodman

@timrodman I am having an issue with reports not working properly because the Average cost is 0 when a new item has only been ordered once. How do we make the Average cost = the last cost when a new item has only been ordered once?


Reply
jmasi
Posts: 26
 jmasi
April 3, 2020 10:54 am
(@jmasi)
Eminent Member
Joined: 6 years ago

Michael,

I've never seen this behavior, Are you sure the Purchase Receipt has been released?  Whether it is ordered only once or 1,000 times as long as the proper valuation is established on the stock item and the receipt is released Average Cost is updated.

 

 

New Item

 

Zero Average Cost

 

First PO for Item

 

PR Released

 

Average Cost Updated

 

 


Reply
Tim Rodman and ncantral reacted
DKD
 DKD
(@donna-deskins)
Joined: 6 years ago

New Member
Posts: 1
June 11, 2020 4:45 pm
Reply tojmasijmasi

I thought I had the same issue.

The item in the screen shots below has been received and has an on hand balance of 6

image

This item has an average cost valuation method:

image

But the Average Cost is 0, and the last cost is $.98

image

It turns out that a user had manually entered the last cost of $.98 and the receipt was received with $0 cost

 


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 10 Online
  • 2,324 Members
Our newest member: Michael Kiley
Latest Post: Pick List report suddenly not splitting on Shipment
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×