QUESTION: Hello, we no longer have the option to select an invoice cancellation date. We can only choose the original invoice date or today’s date. We need to be able to select a certain date in between. Please advise.
RESPONSE: To mitigate the occurrence of database imbalances we implemented additional programmatic controls to support the three types of situations where an invoice cancellation is used.
-
The first - Minimum Invoice Cancellation date - is when an invoice cancellation is needed to rectify internal records used for compensation measures. In this case, the best date for the cancellation date is the invoice transaction date. However this may be limited by the cancellation date of a subsequent action on the invoice (for example a payment or credit note).
-
The second - Today’s Date - is when the invoice was not sent to the client, in this case the cancellation date is often the current date so that the cancellation does not destroy the aging history of the previous invoice and the new one.
-
The third - Last day of the oldest month open - not always visible depending on the date of the invoice, is when the invoice is not sent to the client… in this case the cancellation date is often the current date but when the current date is in a new month with the previous month still opened, therefore back dating to the last date of the not yet closed month is also desirable. This option may not be visible if the last date of the not yet closed month is older than the invoice date.
Please let us know the desired outcome needed which cannot be completed with either option so we can provide our design time with the information. Also, our SME may be able to provide insight on how to achieve the same result.