Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents
maxLevel2

Steps

You can delete locked/extracted vouchers via import by specifying "!DELETE!" in the delete column of an Expense file and specifying the appropriate Expense Voucher number (consult the Help Docs - Expense Import section and Excel Tips for finer technical points on creating your import file). You can get the file format by exporting the vouchers in question with an Expense export.

    1. Run the Expense Export for those vouchers, and add a column called "exp_voucher" to the file.
      Anchor
      Run Expense Export
      Run Expense Export
    2. Specify the voucher # that you want to delete in the "exp_voucher" column (To find this voucher number, you can use the Expense Details Report's "Show Voucher Number" criteria option).
    3. Keep in mind that if you delete an expense voucher then ALL of the expenses associated with the voucher will also be deleted.
    4. Then on the Admin > Import > Expense screen choose "Allow deletion of LOCKED or EXTRACTED expense reports." Once you click "Import," it will delete the entire expense voucher associated with any rows for that expense voucher number that contain the "!DELETE!" command. Note that the entire expense voucher, its approval history, as well as any/all line items on it will be deleted.

    If your intent instead is to "edit" the locked/extracted voucher for certain line items (attributes such as amounts or other attributes), see this page: https://knowledgecenter.unanet.com/x/YriAB


Additional Information 

Help Docs - Import Expenses