AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Everything Else
Default Purchase Or...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions Default Purchase Order Unit Cost - Last Vendor Price - Stock Items

Everything Else
Last Post by Brendan Shepperd 4 weeks ago
7 Posts
4 Users
2 Likes
2,633 Views
RSS
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
Topic starter
August 16, 2019 4:58 pm
(@timrodman)
Member
Joined: 7 years ago

When you add a Stock Item to a Purchase Order Line in Acumatica, there may be a default Unit Cost that gets populated automatically. There are several places where this might come from.

Acumatica looks for a Unit Cost in the following order, stopping at the first one it can find.

 


 

0. Note that if Acumatica can't find a default Unit Cost, you will get the following message:

Unit cost has been set to zero because no effective unit cost was found.

 


 

1. An applicable value from the Vendor Prices (AP202000) screen according to the hierarchy defined there.

 


 

2. The Last Vendor Price field from the VENDOR DETAILS tab on the Stock Items (IN202500) screen if there is a matching Vendor for the specific Vendor on your Purchase Order:

 

Note that how this field gets updated depends on the option you selected in the Vendor Price Update field on the PRICE/DISCOUNT SETTINGS tab on the Accounts Payable Preferences (AP101000) screen:

 


 

3. The Last Cost field from the COST STATISTICS section on the PRICE/COST INFORMATION tab on the Item Warehouse Details (IN204500) screen:

 


 

4. The Last Cost field from the COST STATISTICS section on the PRICE/COST INFO tab on the Stock Items (IN202500) screen:

 


 

All of this is covered in more detail on the bottom of this Acumatica help article, including a nice overview graphic:

https://help-2019r1.acumatica.com/Help?ScreenId=ShowWiki&pageid=4aa635bc-2723-49fc-8ce0-41d035e5821e

6 Replies
Ellie
Posts: 127
 Ellie
August 16, 2019 11:07 pm
(@ellie)
Member
Joined: 3 years ago

Very helpful post. 

Thank you! 

Reply
Tim Rodman reacted
Michael Ho
Posts: 16
 Michael Ho
May 27, 2022 12:35 pm
(@mho)
Member
Joined: 9 months ago

Hi @Tim - hoping you can clarify something for me that has never quite made sense. We are using the Average valuation method. We have a lot of "special order" products that we don't necessarily stock but will may need to order based on customer demand, and pricing can change often.

My understanding is we need to create a vendor price worksheet every time a cost changes, but this can become onerous with the number of cost changes we're dealing with, especially because our industry is one ruled by MAP pricing so if a cost changes then that usually means the MSRP and MAP/Sell price is changing as well. And if that's the case then we have to do an import scenario for the MSRP and Sell prices, and then do a separate import for the vendor price worksheet.

Is there really no way to manage the cost of a product from the Price/Cost tab if we're using the Average valuation method?

Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 7 years ago

Member
Posts: 2957
December 28, 2022 11:23 pm
Reply toMichael HoMichael Ho

@mho You don't have to creat a Vendor Price Worksheet every time. It will pickup the cost that you enter on the Purchase Order.

Reply
Brendan Shepperd
Posts: 4
 Brendan Shepperd
August 18, 2022 3:59 am
(@brendan-shepperd)
Member
Joined: 2 years ago

Hi All,

 

Quick query, where does the Purchase Order pickup the unit cost from? I'm guessing it the the Last Vendor Price?

If that's so, can we force the PO to use the Last Cost on the Inventory Item Statistics instead of Last Vendor Price?

Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 7 years ago

Member
Posts: 2957
December 28, 2022 11:24 pm
Reply toBrendan ShepperdBrendan Shepperd

@brendan-shepperd It follows the hierarchy mentioned above.

Reply
Brendan Shepperd
 Brendan Shepperd
(@brendan-shepperd)
Joined: 2 years ago

Member
Posts: 4
January 9, 2023 8:04 pm
Reply toTim RodmanTim Rodman
Brendan Shepperd

@timrodman thanks 👍

Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,239 Topics
  • 9,872 Posts
  • 7 Online
  • 1,813 Members
Our newest member: Marion Hooley
Latest Post: Export Scenario - Export same row twice (Conditionnal)
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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×