How about in addition to number changers for accounts, customers, vendors, and items, you include a document number changer? Something capable of taking all occurences of a shipment, invoice, order, quote, PO, Receipt, etc. and setting it either to a user specified number or to the next available system generated number (without having to kick everyone out of the module to allocate).

Comments

  • Wouldn't this be a no-no for audit reasons?

  • absolutely no

  • That is precisely the point of having a number changer program. Something that could "tombstone" the erroneous number (filtering it out of finder searches) and point to the new number, maintaining traceability but keeping the system clean.

  • Would have to keep the history in a new series of tables. Complex. So loses from a cost-benefit perspective

  • It is helpful when a user puts some characters in the document number field by mistake and posts it. e.g. in PO Receipts.

  • at first glance a definite no no. However, if there is a permanent transaction entry assigning content of one document to another with a permanent audit trail, it will be a good idea for those typos.