Topic Options
#2166 - 04/29/02 04:16 PM Re: Sales Analysis (Upgrade?)
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11616
Loc: Vancouver, BC Canada
Hello, Edward!

The most likely scenario is that you installed and converted an Order Entry upgrade and/or installed a new version of Sales Analysis, but did not run Sales Analysis and convert the Sales Analysis database. You then printed and cleared the audit lists in Order Entry, creating batch files for Sales Analysis to retrieve.

Sales Analysis still has the unconverted database and demands that you retrieve old version batch files before converting. However, the batch files are in the new format created by Order Entry.

You can check this by making sure the batch files SRSHIPTX and SRCRNTTX in your data directory are evenly divisible by 272 (this means they are ready for the newer version of SR).

If they are, use the following procedure to convert your SR database without losing your batch files. (Substitute your company data extension for XXX in the following instructions):

1. Rename the batch files:
REN SRSHIPTX.XXX *.OLD
REN SRCRNTTX.XXX *.OLD
Start Sales Analysis and convert the database.

2. Rename the saved files:
REN SRSHIPTX.OLD *.XXX
REN SRCRNTTX.OLD *.XXX
Start Sales Analysis & retrieve data from Order Entry.

If this is not the problem, we would need more information. The message "Unknown Item/Price file" is similar to one received if they were using OE without IC, and then just recently installed IC - if this is the case, then there would be another procedure you could use to try to resolve this issue.

Good luck - let us know what happens.


Top
#2168 - 04/30/02 11:55 AM Re: Sales Analysis (Upgrade?)
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11616
Loc: Vancouver, BC Canada
Good morning, Edward

Is it possible that they have restored from an older backup than what they thought? Or, perhaps restored over top of existing data files? Something thinks that an 'upgrade' is necessary, and this only normally occurs under the previously noted circumstances. This is all I can think of.

My suggestion would be to contact our Database Repair department for an estimate. (Tech support would not be able to help you in this respect.) Our DBR dept. will require the data in order to do this, and may be able to tell you what has occurred. The fact that the DIC is clean is not always indicative of all possible data conditions being stable. If in fact, there is no problem with the data, there would be no charge.

Certainly, you can restore SA data from the end of last month and, if they keep OE History, you will be able to use SA's Scan option to get this month's data from OE into SA (if this is the source of the problem).

Regards,


Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 78 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1872 Members
5 Forums
14527 Topics
70937 Posts

Max Online: 432 @ 01/20/25 10:17 PM
August
Su M Tu W Th F Sa
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31