• DATABASE QUERY: Find qty of a particular sku that has been purchased/received since date.

    As per the subject, could someone help me with the query to find the Quantity Received since a particular date for a particular SKU ? If an order is placed for 10 of SKU(ABC) we receive 1 on date X, I'm assuming TODATEQTY would be 1. we receive…
  • Crystal Reports Record Number

    I am trying to create a Record Number on our Purchase Order. When I insert the "Record Number" (from the special fields) it counts a comment on the purchase order as a Record. Is there a way to modify the Special Field so it does not count the comment…