Receiving inventory and pricing updates

Question

When using purchase/receive inventory window to receipt purchase orders, the inventory item costs are updated. The sell prices are not update automatically, is there a procedure to update the sell prices from the purchase/receive screen? Since you can not go directly to the maintain inventory window from the part numbers in the purchase/receive window, the process to update the sell pricing becomes very cumbersome. Also, once the purchase order is received you can not double click on the part numbers to bring up the inventory window to recalculate the sell prices.

KimClement · Answer

For GAAP, the PO is used as a Document between you and the Vendor as an acknowledgement the Vendor agrees to sell this item at the agreed PO pricing. Therefore when you receive the Vendor's Invoice the item pricing would not change from the original PO price. Based on this understanding, you can enter a PO, save it, then call the PO back up again and drill down on each item which open the item Maintenance Screen, choose the Arrow on the Sales Price, and hit the recalc button at the top of the item screen, hit ok, then save the item, which takes you back to the PO. Also, if you are on version 2015SR2 or higher you can go directly to the PO when you are receiving it (new feature) and drill down on each item, which opens the item Maintenance Screen, choose the Arrow on the Sales Price, and hit the recalc button at the top of the item screen, hit ok, then save the item, which takes you back to the PO. Go to each item and recalc, then you can hit the "Receive" button at the top of the screen and the PO will be received. Just make sure you do the "Receive" part last after you have recalculated all the items on the PO. Hope this helps. Did not find any other way because you can't recalc a sales price of an Item based on a PO that has not already been saved.

KimClement · Answer

When you are ready to receive the items on the PO, rather than go to Purchase/Receive Inventory, go back to the PO like you are going to edit the PO. Double click each item you want to recalculate. If you are on Sage 50 version 2015 r2 of higher, you have a new feature that allows you to Receive that PO by choosing the "Invoice" button at the top of the PO screen. 
If you don't have the version of Sage that allows you to "receive" from the original PO, then call me and I will demo how this works. 
I did not try this in a multiuser mode but since you are recalculating items from a PO I think you will be able do it in a multiuser environment. Kim 800 303-7770

KimClement · Answer

I wish I could give you a better answer but all I could come up with is this work around. 
I set up a test PO and I can see that the recalc of the item does not calculate the correct sales price as it was still using the last cost. So after you receive the Items on that PO like you say, you can't drill down on that item to reach the maintenance screen. The only way you can do this is from a PO level is to bring up the original PO (after it has been received) and hit the "Copy" button, which will create a copy of the original PO. On the "Copy PO" I can drill down to each item (the recalc button is available) hit recalc on the price, save the item screen (not the PO), and it does calculate the sales price off the new last cost correctly. Just be sure to delete the copied PO. 
Hopefully this will be an acceptable work around for you because the Maintain Item Prices does not give you enough filters such as a PO number.

Sage 50 US

Receiving inventory and pricing updates

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING