Distribution, Manufacturing, and Internet Modules

[mjf001]

MAS90 4.4       I have read several post about doing cost changes in Inventory management. We have several vendors that we purchase the same items from. If we get a notice that the price is going to change from one of these vendors, we would like to be able to go into that vendor and change the cost of that one item. We may or may not use that Vendor in the near future but would like the new cost in the system in case we do. Also if if you notice a pricing discrepancy of a couple of cents on an item, it would be nice to be able to go into inventory maint. And just change it for next time. Is there a simple way to do a item cost change?

[DFeller]

If you have different costs for different vendors, the place to put this is vendor price level maintenance.

If you have just one cost for the item as a whole, then you can put that right in inventory maintenance.

Dawn

[mjf001]

I tried that and it works. Thanks.

It would be nice to be able to see that pricing information on the Inventory item maintenance page.

[Broadfoot]

In later releases, drop the arrow in the upper right and click Vendors.  You should see a list of vendors that have been used for this product with lead time, last cost, etc.

[mjf001]

Yea, It would be nice if you could do a price change for a vendor in that drop down window

[Broadfoot]

I may be missing the point, but the Item Vendors Maintenance screen only shows the Last Cost which changes automatically with each receipt. 

If you want to change the Vendors Price structure for that item, click on the Vendor Pricing button on the right or do an ALT-P.  You should end up in Vendor Price Level Maintenance where you can setup a matrix based on one of several pricing methods.

[mjf001]

ALT-P did the trick. Thanks.

[mjf001]

What is the reason for having the Last Cost grayed out on the Item Vendor Maintenance screen so you can't change it? This is were the PO pulls the cost from. If you could do price changes there, it would make things a lot easier on our system.

[Broadfoot]

The Last Cost is generated when you do a receipt.  If you changed it, it would no longer be the Last Cost. 

Perhaps what you would like is an option to decide where the PO default cost comes from. 

Most of our clients seem to like that fact that Last Cost comes up so the get a heads up on what they paid for it last time.  At least in the later releases, in PO Entry > Line Entry, there is a button/dropdown that lets you go strait to Vendor Pricing anyway.  If Vendor Level Pricing is setup properly, then as soon as you enter a quantity, the default Last Cost changes to the cost setup in Vendor Level Pricing.

[mjf001]

I will have to have our re-seller fix it like they did our 4.3. The Last Cost is on the inventory maintenance page so you could see what you paid for it last time. The Last Cost on the Item Vender Maintenance page was used for the PO to pull from. It could be changed so that if you got a price increase you could put it in there and the next time you ordered it, the PO would order it at the correct price. The problem I am having going the Vendor pricing route is that if you do a receipt of an item at a different cost than what it is set at in the Vender Pricing page, it doesn't automatically change the cost in the Vendor Pricing. Then the next time you write a PO it pulls the old cost out of Vendor Pricing.

All reports that look at Last cost pulls that info from the Inventory Maintenance page, so changing the Last Cost on the Item Vendor Maintenance page doesn't affect that.(least on our system) We use the Last Cost on the Item Vendor Maintenance page as more of a Current / Future Cost.