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).
Questions Default Purchase Order Unit Cost - Last Vendor Price - Stock Items
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:
Very helpful post.
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?
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?