ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Sales Tax Missing
http://www.istechforum.com/YaBB.pl?num=1346953802

Message started by Frost on 09/06/12 at 10:50:02

Title: Sales Tax Missing
Post by Frost on 09/06/12 at 10:50:02

We recently had a problem with BKISTAX. The file duplicated it self several times over. We deleted the duplicated files and re-indexed BKISTAX file. Now we have discovered that our sales tax information is missing in AR-K prior to mid August. Does any body know how to retrieve the missing sales tax data?

The sales tax does show up in the GL-A, and the detail trial balance.

We are at our fiscal year end and cannot proceed until we solve this problem.

Thank you for any help or suggestions.

Title: Re: Sales Tax Missing
Post by Kelloggs on 09/06/12 at 12:19:20

If restore from backup option is no aviable,
the information on BISTAX is on the BKARHINV table.

So the data on bistax can be populate, update or inserted from the bkarhinv table.

select * from BKISTAX where bkis_tax_invno = 123456789

select * from "BKARHINV" where bkar_inv_num = 123456789

:P

Kelloggs

PD: the table duplicate itself??? how big is the table?? because if it reaches the limit pervasive will create BKISTAX.000, BKISTAX.001

Title: Re: Sales Tax Missing
Post by Kelloggs on 09/06/12 at 12:46:24

This script matches the columns on the BISTAX
so it can be use to get the data missing....

INSERT INTO BISTAX
SELECT
BKAR_INV_ISTXKY,
BKAR_INV_INVDTE,
BKAR_INV_SUBTOT,
BKAR_INV_TAXAMT,
BKAR_INV_CUSCOD,
BKAR_INV_NUM,
BKAR_INV_ISCUR
FROM BKARHINV WHERE BKAR_INV_INVDTE > '2012-08-14'

If you are not confortable with SQL DON'T DO IT talk to ISTECH

:-[

Kelloggs

Title: Re: Sales Tax Missing
Post by Frost on 09/06/12 at 15:05:31

Thanks for the info Kelloggs,

I'm not up on the SQL :-/

I have emailed and called for help for the last three days and we have not received a response back.

I was hoping there was a DBA program we could run in UT-A that would replace the missing tax or is there a way to us UT-K-B?

Luckily we only need the tax info from August 1st. to the 19th. We can get that info from Inv. listing in SO-H and just make manual entries and move on. We just wont have a complete sales tax report in AR-K or AR-L for August.

Thanks again for your help.

Title: Re: Sales Tax Missing
Post by Kelloggs on 09/06/12 at 16:24:43

There is a few programs that can be access from the UT-A
but no idea what they do:

TAXFIX.RUN
TAXCVT.RUN
TAXINT.RUN
TAXUSA.RUN

One of them could be what you are looking for (wait for ISTECH)

:P

Kelloggs