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>
Have something to add? Share your thoughts — no account required.
Ask the community — no account required