Supplier Cost is zero

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Supplier Cost is zero dh 08-23-2005  Re: Supplier Cost is zero Antonio Mazzeo 08-24-2005  Re: Supplier Cost is zero hitmanú­™©ÝŠÇ.²È¨žÉ¢rº,¡û\¢ 08-25-2005  Re: Supplier Cost is zero dh 08-25-2005
Posted by dh on August 23, 2005, 10:21 pm Please log in for more thread options 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 Posted by Antonio Mazzeo on August 24, 2005, 10:44 am Please log in for more thread options > How do I set the Supplier Cost = Cost on the General tab? from SO Administrator | database | query UPDATE SupplierList SET Cost = Item.Cost FROM Item WHERE SupplierList.ItemID = Item.ID AND SupplierList.SupplierID = Item.SupplierID Posted by hitmanú­™©ÝŠÇ.²È¨žÉ¢rº,¡û\¢ on August 25, 2005, 3:54 pm Please log in for more thread options Where do these commands get entered? Thanx. "Antonio Mazzeo" wrote: > > > How do I set the Supplier Cost = Cost on the General tab? > from SO Administrator | database | query > > UPDATE SupplierList SET Cost = Item.Cost > FROM Item WHERE SupplierList.ItemID = Item.ID AND SupplierList.SupplierID = > Item.SupplierID > > > Posted by dh on August 25, 2005, 11:25 pm Please log in for more thread options Enter these commands in the Query window of Administrator "hitman" wrote: > Where do these commands get entered? > > Thanx. > > "Antonio Mazzeo" wrote: > > > > > > How do I set the Supplier Cost = Cost on the General tab? > > from SO Administrator | database | query > > > > UPDATE SupplierList SET Cost = Item.Cost > > FROM Item WHERE SupplierList.ItemID = Item.ID AND SupplierList.SupplierID = > > Item.SupplierID > > > > > > Similar Threads Posted copy item cost to supplier cost field November 1, 2006, 1:37 pm Help with SQL statement- Supplier List cost into cost field in Ite February 12, 2008, 9:46 am How can i update item cost based on Supplier cost and MPQ. August 13, 2008, 3:23 pm Item cost/Supplier cost purchase order February 20, 2009, 9:06 am supplier cost to update item cost September 24, 2007, 3:06 pm Help Please!!! Supplier Cost Local Cost Issues February 20, 2008, 5:30 am Supplier Cost still zero April 29, 2008, 4:32 am Supplier Cost May 26, 2008, 4:29 am Supplier Cost ? October 15, 2009, 1:06 pm Lowest-cost Supplier November 16, 2005, 11:12 pm