When I imported my items, The cost field was imported into the General tab of the Item Properties window. I did not import the cost into the Supplier Cost field, so it is Zero. When I run the Style 340: PO Planner, all of the costs are Zero. . .
How do I set the Supplier Cost = Cost on the General tab?
David
"dh" ha scritto nel messaggio news: snipped-for-privacy@microsoft.com...
from SO Administrator | database | query
UPDATE SupplierList SET Cost = Item.Cost FROM Item WHERE SupplierList.ItemID = Item.ID AND SupplierList.SupplierID Item.SupplierID
Where do these commands get entered?
Thanx.
"Ant>
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.