1. Home
  2. Point-Of-Sale Software
  3. Item Movement Report Amendment

Item Movement Report Amendment

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

Reply to
Ryan Faught
Loading thread data ...

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

Reply to
JerryData

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.