Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2004

    Unanswered: Function to close complete orders

    I need help in creating a function that will check each item on the current open order and calculate how much was received for each item.
    It is possible to receive more then requested.

    Each item can be received on multiple days.
    Every time I add an item to the sub from Quantity received, the function should check all transactions. If each item was received at least the minimum ordered, then set the checkbox “Order closed” to true.
    I’m attaching a sample DB

    Thanks for everyone
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts