Browse By Tags

  • 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…
  • Purchase History Button Purchase Order Entry

    Hi Guys I am trying to get a window to display on purchase order entry which will shows everything we purchased from the vendor in the past. On sales order you have the binoculars to do this but all you have on Purchase Order is Alias Item Lookup…
  • Restricting Graphical Requester to Accessible Sites Only

    We have set up the Purchasing dashboard for staff across the business to use and access orders. The issue we are facing is that the default gadget on the home page that displays the orders to receipt shows all available orders - this needs restricting…
  • Desperately Need a Way to Depict/Analyze Future Inventory levels based on Items on Order by Promise Dates/Purchase Order Dates

    I am looking (did I mention Desperately) for a solution to this: We key orders and quotes with increasing frequency as the summer approaches and through the summer seasonal business. We sell many BOM standard kits and custom kits with 10 to 50 different…