Question: I have a draft Invoice need to approve but already expired, what should I do?

Version: 2.2

Answer:

Currently there is no way to set expired invoice back to draft mode again in the application. However, you can use query to set it to draft mode and approve it again.

1) Backup the account book.

2) Open your SQL Management Studio and run the following query.

By document

update IV set ExpiryTimeStamp = '2024-09-30', DocStatus = 'D' where DocNo = 'I-000001'

OR

Set all Expired document

update IV set ExpiryTimeStamp = '2024-09-30', DocStatus = 'D' where DocStatus = 'E'

You may set the ExpiryTimeStamp to longer future date if you cannot approve now or in near future. This is because if the expiry date reached, it will automatically set to expired status if the document is still in Draft mode.

After running the query, you can check back those transactions. Those transactions should already change to draft mode and you may approve the document now.

• IMPORTANT: Please do not use query to set the document status to approve. This will not perform any posting into your stock or GL which will cause your stock costing and account posting to messed up.
  

• IMPORTANT: Do not set ExpiryTimeStamp to empty value, this will cause the time stamp become 1900-01-01 where your document will also become expired

By: Cai Wen 240829, Lay Swan 240926, Jae Sen 20240926