Sales report missing rep info (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 14 SEP 2001 10:28:01AM Tom Reeves wrote:

AREV Specific

Hi,

We are using an old version of AREV 2.1 and have a Sumit Software accounting application attached to the system.

A sales report that is generated by batching rep info from a profile that is AREV specific is batching every rep automatically as it should, except for a new rep that was recently added.

I need help with this and need ideas.

Thanks in advance.

At 14 SEP 2001 12:02PM Don Miller - C3 Inc. wrote:

Maybe a blown index? Can you get tech support from the vendor?

Don Miller

C3 Inc.

At 14 SEP 2001 01:06PM Tom Reeves wrote:

I haven't checked with Sumit Accounting for Revelation. The developer that originally wrote a lot of the code many times cannot get to us on a timely basis and I thought I could get some hnts about what to ook for in this forum.

Thanks

At 14 SEP 2001 01:57PM Don Miller - C3 Inc. wrote:

Do you have a Developer copy of AREV or only a RUNTIME? If you have a developer copy, you should be able to use LH_VERIFY to analyze your tables for any errors. Usually you can determine whether an index is blown by trying the following:

Press F5 to get to TCL

Type DUMP and press

Look in the upper left corner to get the count of records. Write this down.

Press the key to leave DUMP. Don't do anything else.

Next type:

SELECT BY and press

Write down the number found. If it's not the same as the DUMP count +- 1 record, then the index is blown and must be rebuilt. The difference of 1 record is usually the %RECORDS% item if a QUICKDEX has been installed on the table.

The procedure to rebuild the INDEXES for a table is a little beyond the scope of a quickie post. If you're comfortable with AREV then go ahead. Otherwise, get a consultant to help.

Don Miller

C3 Inc.

At 14 SEP 2001 02:38PM Tom Reeves wrote:

Don,

Yes..we do have a developer's copy of AREV and the Sumit Accounting software. The accountant is pretty much convinced it's an indexing problem. I have rebuilt indexes for files, but not tables. Maybe with the help menu, and your help, we can identufy the problem.

Thanks very much…this gives me a good place to start. I'll try this when the accountant is here and let you know if we can identify errors and fix them. Monday wil be the next day that this process will be used. Thanks very much. Tom Reeves

At 15 SEP 2001 12:41PM Warren wrote:

In database parlance tables=files

View this thread on the forum...