Link Search Menu Expand Document
excel-invoice-writer

Changelog

https://keepachangelog.com/en/1.0.0/

Unreleased

5.20-alpha 2020-12-01

  • Currently working on next version. See Issues for new features and bug fixes.

5.12 2021-02-18

Changed

  • Fixed incorrect date issue where date is correct in Excel, but appending as US format to Oracle. Used CodeProject article as reference. [6]

5.11 2020-11-12

Added

  • Added Settings worksheet to allow developer to choose multiple connectionstring to Oracle.[4]

    Changed

  • Fixed incorrect date issue where date is correct in Excel, but appending as US format to Oracle. Used CodeProject article as reference. [6]

5.10 2020-11-10

Added

  • Added delete button to delete uploaded batch from eFinancials. Only the batch number reference in the Batch Reference field.
    • CLINK_IW_BATCHES
    • CLINK_IW_INVOICES
    • CLINK_IW_INVOICE_ANALYSIS
    • CLINK_IW_INVOICE_LINES
    • CLINK_IW_INVOICE_LINE_TEXT
    • CLINK_IW_INVOICE_TEXT_LINES
    • CLINK_IW_STAGE_PAYMENTS

Changed

  • Replaced deprecated Oracle OO4O data access code with Microsoft ActiveX Data Objects 2.8.
  • Created TNS-Less Oracle connection. No TNS_ADMIN or tnsnames.ora file required.
  • Changed license date to expire 2021-03-31.

Security

  • Added VBA Password to protect code.
  • Locked VBA project for viewing.

4.14 2020-11-10

Added

  • Initial GitHub release for Imperial College Healthcare NHS Trust.
  • Added Invoice Prefix column to enable user to choose a different invoice prefix per invoice.
  • Added Invoice Sub Type column to enable user to choose a different sub type per invoice.
  • Added Payment Terms column to enable user to choose a different payment term per invoice.

Security

  • Added VBA Password to protect code.
  • Locked VBA project for viewing.