Item Movement Report Amendment

Jul 07, 2008 1 Replies

Dear all,



My business partner and I have the following requirement:



If we could have the Item Movement Report have the following additions:


  1. Qty On Hand
  2. Qty Committed
  3. Qty Available (Ideally we would have a field that would total Qty Sold and Qty Committed as to us that is what we need to see from an order).
  4. A filter for item.subdescription1

Any help would be 'greattttttly' appreciated.



Ryan


That's an easy one, just have to call that stuff in the report template and save it as a memorized one, for example: add this to SELECT Statement: Item.QuantityCommittedAS QuantityCommitted, then add the column: Begin Column FieldName = "Item.QuantityCommitted" DrillDownFieldName = "" DrillDownReportName = "" Title = "Quantity" VBDataType = vbDouble Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1080 GroupMethod = groupmethodNone End Column email me directly if you need more help. snipped-for-privacy@jrdata.us

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required