Orders Data

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

   Please add a few new columns to the ProductsOrdered table.
Discounted Unit Price: UnitPrice minus unit discount  (qty discount, retail sales discount, whatever)  
IE:  UnitPrice = 12.00, Quantity = 10, [UnitPriceDiscounted] = 11.25
Store discounts change often - going back into the items history - there isn't data to look at line item discounts.

QOH: adding the quantity on hand at the time of the sale would be very useful in MRP calculations and inventory history.  Could even be a huge time saver come tax time.

In analyzing sales data these are often numbers we are seeking to use.

Adding this personal customization is possible - until the store gets constant updates that overwrite the customization. 

Thanks
Josh Shirley

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
joshs Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 07-April-2009 Location: Utah Status: Offline Points: 14	Post Options Post Reply Quote joshs Report Post Thanks(0) Quote Reply Topic: Orders Data Posted: 12-October-2015 at 7:31pm
	Please add a few new columns to the ProductsOrdered table. Discounted Unit Price: UnitPrice minus unit discount (qty discount, retail sales discount, whatever) IE: UnitPrice = 12.00, Quantity = 10, [UnitPriceDiscounted] = 11.25 Store discounts change often - going back into the items history - there isn't data to look at line item discounts. QOH: adding the quantity on hand at the time of the sale would be very useful in MRP calculations and inventory history. Could even be a huge time saver come tax time. In analyzing sales data these are often numbers we are seeking to use. Adding this personal customization is possible - until the store gets constant updates that overwrite the customization. Thanks Josh Shirley
	Josh Shirley josh@windsurfutah.com