Knowledgebase: Pegasus Opera
VAT return exceptions report showing very old transactions or transactions which should not be there
Posted by Claire Craig, Last modified by Claire Craig on 13/08/20 11:27

This relates to transactions on the ZVTRAN.dbf with a va_except flag of T - true and has been previously committed so should not be appearing.  

To fix, check with the customer what the LAST VAT return committed date was (not what the current one is) and add one day on, so for example the last vat return was 31st March 2020, so the date to use in the following command is 01/04/2020 

Using dataviewer or command line run the following on the ZVTRAN table

REPLACE ALL VA_EXCEPT WITH .F. FOR VA_COMMVAT<{01/04/2020} AND VA_EXCEPT=.T.

the date must be the date of the previous vat return plus one day to ensure you capture the transactions at the last vat return and ensure you do not replace anything which is a true exception in the current vat return.

(1 vote(s))
Helpful
Not helpful

Comments (0)