Sales and Use Tax

For reporting sales and use tax, we are currently using a custom report to
pull information from the F0411 table.
This works great, most of the time...except in the case of voided vouchers.

If a voucher is voided, the amount in original F0411 record is changed to
zero, AND a new record shows the negative of the original amount. The sum
of the two is the negative of the original amount, instead of zero. First
instincts would tell you to ignore the negative amount (void record), and
only report the original voucher. If it has not been voided, it will show
the original amount, and if it has been voided, the amount will be zero.

Here's the problem... if you have a voucher that was entered in period 1,
the report is run for period 1, and the tax is calculated for period 1. In
period 2, go back and void the voucher. Run sales and use tax again, this
time for period 2 - we would want to see the negative entry for the voucher
that was originally entered in period 1.

Are others having this problem? How are you resolving it?

Thanks,

Tanya Magliulo
Highwoods Properties
 

Mike Dupaix

VIP Member
Tanya,

If you are using the tax codes in voucher entry, you can look at the information in F0018. This table stores all tax information including voids.

pull information from the F0411 table.
This works great, most of the time...except in the case of voided vouchers.

If a voucher is voided, the amount in original F0411 record is changed to
zero, AND a new record shows the negative of the original amount. The sum
of the two is the negative of the original amount, instead of zero. First
instincts would tell you to ignore the negative amount (void record), and
only report the original voucher. If it has not been voided, it will show
the original amount, and if it has been voided, the amount will be zero.

Here's the problem... if you have a voucher that was entered in period 1,
the report is run for period 1, and the tax is calculated for period 1. In
period 2, go back and void the voucher. Run sales and use tax again, this
time for period 2 - we would want to see the negative entry for the voucher
that was originally entered in period 1.

Are others having this problem? How are you resolving it?

Thanks,

Tanya Magliulo
Highwoods Properties




--------------------------
 
Thanks, Mike.
Either we are not speaking of the same thing, or there is something wrong
here...
I looked in F0018, and it contains no data. What populates this file?
I am trying to find a report to use when reporting the amount of tax that we
have paid through AP.
 
Top