The ability to see the number of a product sold in the past 30 days as well as the amount on back order when placing Purchase Orders has greatly improved our efficiency in ordering.
Does anyone know how to incorporate Sold in last 30 days into the Multi-Record Editor? Setting Re-Order Point and Re-Order Qty would be so much easier using this information.
Quote:techtoolsupply Does anyone know how to incorporate Sold in last 30 days into the Multi-Record Editor? Setting Re-Order Point and Re-Order Qty would be so much easier using this information.
I would prefer to see the "last 30 days" be a user defined parameter as 30 days is too small of a window for us to base reorder quantities on. Even better would be to leave the 30 day column and add another user defined column. Having them visible in the Multi-Record Editor as techtoolsupply suggested would make setting targets much easier than printing out 30 day and 90 or 120 day sales histories for each vendor.
quote:[i]Originally posted by CycleBuy[/i] [br]Quote:techtoolsupply Does anyone know how to incorporate Sold in last 30 days into the Multi-Record Editor? Setting Re-Order Point and Re-Order Qty would be so much easier using this information.
I would prefer to see the "last 30 days" be a user defined parameter as 30 days is too small of a window for us to base reorder quantities on. Even better would be to leave the 30 day column and add another user defined column. Having them visible in the Multi-Record Editor as techtoolsupply suggested would make setting targets much easier than printing out 30 day and 90 or 120 day sales histories for each vendor.
That would be even better, but I did not want to ask for too much :)
This is one of those things that you wonder how you did without. If only we could use this information to correct our re-order points and quantities.
Sold in Last 30 Days & Backorders
Posted - 11/20/2009 : 10:11:36 AM
