Hi There,
Sorry if this is the wrong place to post this, but I was wondering if anyone has had experience fixing a similar issue that seems to have presented itself.
One of our accounts staff has generated a voucher where it was posted from PO, with a Purchase Amount of $425, no sales Tax (Which there is supposed to be 15%) and an invoice amount of $488.75.
I've jumped on xtreme and found what looks to be a similar issue, where the resulting 'fix' was to edit the column value in the DB, which I am very reluctant to do. I also not that this fix is listed for Versions 7 and 8, but not 9.01 which I am using.
Ideally I'd just like to add in the sales tax and be on our way, but perhaps there is a more 'correct' solution here.
I'll paste the KB Article below. Please let me know if this is not allowed.
| Description: |
|
Posting Vouchers generated by Generate AP transactions
Vouchers will not post with error message that the tax distribution is not valid or similar
Values on voucher header are incorrect.
Distribution record for VAT is missing from voucher.
On the voucher header there should be three values a purch amount a VAT amount and an invoice total. The invoice total should be purch amount + VAT
Does the invoice total show only the purch amount? That is it excludes the VAT.
All three fields will be grayed out yes?
|
|
| Resolution: |
|
The voucher cannot be correct because 'Posted from PO' is checked
The current vouchers need to be fixed.
If this is the situation you need to do the following.
Is the VAT distribution missing?
If so you need to add the VAT distribution as follows-
Add the VAT distribution record, click on distributions.
Tax System Probably 1
Tax basis is the Purchase amount
Tax Code Your tax code probably S
Amount VAT value for this voucher
Account The Input VAT GL Code
Save.
You may get message 'voucher not fully distributed' (or similar). Ignore.
Now you need to fix the invoice amount. To do this you will need to update directly via the SQL database.
Find table 'aptrx' column inv_amt
For this voucher change the value to the invoice value Purch amt + VAT.
Refresh the record in Sytline it should show correct value for invoice.
Post as normal.
|
Any Help is appreciated.
