Accounting 2.2 - e-Invoice: Draft document needed to approve but already expired

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, I can use query set to draft 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 recently. As it will automatically set to expired status if you are not approving the document when the expirytimestamp reached.

After run the query, you can check back those transactions will change to draft mode and you may approve the document now.

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.