Retail Cost Vs PO Cost

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Another How To Question: 
When we place orders, we get varying discounts on each item.  I want a report that showed our PO savings versus Retail prices for each item we bought.  That means I need to know how to enter a retail price and PO prices when ordering as well.  How is this done?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
TheWarrior97 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 20 Dec 2011 Points: 14	Post Options Post Reply Quote TheWarrior97 Thanks(0) Quote Reply Topic: Retail Cost Vs PO Cost Posted: 21 Apr 2012 at 3:39pm
	Another How To Question: When we place orders, we get varying discounts on each item. I want a report that showed our PO savings versus Retail prices for each item we bought. That means I need to know how to enter a retail price and PO prices when ordering as well. How is this done?

BillD Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 01 Jul 2011 Location: Nevada, US Points: 474	Post Options Post Reply Quote BillD Thanks(0) Quote Reply Posted: 24 Apr 2012 at 5:33pm
	In the Item Master, specify item list price in the Unit Cost. When you create a PO, the prices will be taken from the Item Unit Cost. Modiy the prices to the real ones. After receiving a purchase order, the real prices are attached to the received units. This is refrected in the Reports/Inventory/Item Master Summary/Inventory Actual Value. The Book Value reflects the list price from the Item Master/Unit Cost and the Inventory Value is excatly how much you paid.

TheWarrior97 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 20 Dec 2011 Points: 14	Post Options Post Reply Quote TheWarrior97 Thanks(0) Quote Reply Posted: 27 Apr 2012 at 12:38pm
	Thanks for the help, I understood all of that. What about showing the savings from each order, rather than looking at each item in stock with the "inventory actual value"?

BillD Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 01 Jul 2011 Location: Nevada, US Points: 474	Post Options Post Reply Quote BillD Thanks(0) Quote Reply Posted: 29 Apr 2012 at 11:41am
	Everybody needs something different, so... When on the All Reports screen, select Inventory Actual Value, supply filters if any, click Excel button at the screen top. In Excel, add Savings coloumn, subtract Inventory Value from the Book Value.