1
MAX MIN CALCULATION SUPPORT
Idea shared by Frank B Austin - 10/8/2022 at 12:40 PM
Under Consideration
Is there a way to get sales over a period of time for inventory similar to
REPORTS, SERVICE SUMMARY INVENTORY THAT GIVES
STOCK CODE --  DESCRIPTION--  MANUFACTURER--   AVERAGE PRICE  -- TOTAL QUANTITY -- TOTAL COST   --TOTAL NET
But includes all inventory sold by SALES AND SERVICE ORDERS?

Seems like a standard report for Service orders should be duplicated for Sales and then one for all items sold.

3 Replies

Reply to Thread
0
Terry Swiers Replied
Employee Post
There is not, but I'll add this to the suggestion list.

0
With regards the Inventory/min/max Maintenance 
This is not very useful the way it is.
I have a spreadsheet that does the calculation #sales over a period x weeks/x weeks to get average sales quantity per week. Then multiplies by number of weeks of inventory you want and number of weeks inventory minimum. Fairly simple calculation. The Atrex system basically does that.
However what is missing is allowing someone to put in minimums ie if I sold less than 4 items per month I could have max and min set to zero.
Also the calculation of max/min should only allow whole numbers. Round down.
This would allow a person to set the max/min all at once for items sold enough to carry inventory.
Also in the existing system to find a stock code you have to scroll down a long list. 
iif you start typing the stock code it does not jump to it. 
Thanks
0
Mark Culos Replied
Employee Post
Frank,

I have attempted to reply to each point, do let me know if I missed any.

However what is missing is allowing someone to put in minimums ie if I sold less than 4 items per month I could have max and min set to zero.
 
If I understand correctly you are wanting to edit the current values with any you choose.  This is already possible by typing in the fields that are directly opposite the Qty/Week display for each stock code.
 
Also the calculation of max/min should only allow whole numbers. Round down.
 
While whole numbers may apply to your inventory, it does not all apply to all.
 
This would allow a person to set the max/min all at once for items sold enough to carry inventory.
 
Are you suggesting to have an auto-accept option?  If so, because the function provides live edits and there is no option to double-check or reverse the action, this could result in unintended updates.
 
Also in the existing system to find a stock code you have to scroll down a long list. 
iif you start typing the stock code it does not jump to it. 

As the function provides live edits to the stock codes, the intention is to populate the grid in small batches of stock codes and work through those line-by-line.  Also note the check box to limit the display to exclude any stock code that is within range.  

Reply to Thread