If two users create work orders but neither saves they will both have the same order and invoice numbers but the record numbers will be different. I have had several instances where clients have created multiple invoices with the same order and invoice numbers because multiple work orders were being created at the same time. There should be a multiple invoice and work order number warning that will notify the user that they are trying to save a record with a number that already exists.

Comments

  • Have an admin person F7 into the Order# and Invoice# fields, and check “require unique”. You will be unable to post duplicate records from that point on.

  • I agree this would be super helpful as our office has to keep some records with the same WO# so we are unable to require unique. Having a pop-up of some sort asking to continue or not would be perfect so that if we need to duplicate, we can but otherwise, don't duplicate.