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?
Item Quanity Report
Mar 19, 2006
1 Replies
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required