Does anyone know why there is no "Available Quantity" column that can be shown in the Items Quanitity Report? I can get to it by subtracting the "Committed" items (say from work orders) from the original column but isn;t there a better way?
You could add that as a column to the report. Make a copy of the Item Quantity report and rename the report like: "Custom - Item Quantity". Right click on the report and choose Properties and uncheck Read Only and press OK. Now open the report using Notepad. Scroll down the report and until you see all the columns and paste this into the report:
Begin Column FieldName = "Available" DrillDownFieldName = "" DrillDownReportName = "" Title = "Available" VBDataType = vbDouble Formula = "Item.Quantity - Item.QuantityCommitted" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1080 GroupMethod = groupmethodSum ColFormat = "#.##" End Column
Save the report and restart Manager if it is open. Go to the Report menu --> Custom and your new report should be there.
Rob
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.