When creating a Purchase Order it seems to pull the cost of the product from the Supplier tab in Item Properties. This cost never seems to be updated by a purchase order receipt and if you were not sure of the cost when you created the item and left it at $0.00 that is what shows up on the PO forever. I then have to go and look at cost in each item and then add it to the PO which is extremely time consuming. This means that my totals on my PO are never going to be accurate and in these days of watching every inventory dollar that is important. I realize that pulling the cost from the general tab would not necessarily be accurate either as it is a blended cost but at least it would be close. Am I missing something?
costs
Feb 06, 2009
5 Replies
I'm not sure of the process you use to create PO's, but if you select the supplier first it will bring up the cost from the supplier tab, which would be the last price you paid for the item from that supplier. Once you receive the invoice and are reconciling it with the PO you will put in the cost from that invoice you are reconciling the PO with. That cost will update the cost field in the supplier tab to what you just entered on the PO. It is then averaged with the cost on the General tab, and will update the cost on that tab with the averaged cost. That is if you are using weighted averages in your configuration. Craig
Merle,
In Store Operations, file, configuration, there is a setting you where you can allow purchase orders to update supplier cost. Once you set that 'on', any costs you change on a PO will update supplier cost when you commit the PO. If you want a shortcut to set supplier costs and your item cost is a good enough starting point, you can use a query to set supplier cost to item cost. There are others here that are better suited to tell you how to do that. I THINK the query below is correct, but I use an access front-end and I am not good at writing queries by hand ;)
UPDATE dbo_Item INNER JOIN dbo_SupplierList ON dbo_Item.ID dbo_SupplierList.ItemID SET dbo_SupplierList.Cost = [dbo_Item]![Cost]
I am sure someone else can jump in and offer more help if you want to do that.
Marc
I have that setting checked but I still have supplier tab costs that are 0.00 even though I have ordered them several times. Again the logic thread seems wrong because it seems to update some and then not others so I can't quite get a handle on it. I do create my purchase orders and po recieving as suggested by Craig.
I think there was a Hotfix a while back for the issue of PO not updating costs. If you are not fairly current on your updates it may be worth checking into. You can find a list of Hotfixes and the issues they resolved on CustomerSource.
Marc
Check this out MAnger/ File/Configuration/Options/Purchase Order Options and Makesure you have check on UPDATE SUPPLIER COST AND TAX RATE FROM PURCHASE ORDER
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required