Topic Options
#22096 - 05/05/10 06:44 AM Random distorted prices and costs
Acrylon Offline
Adagio Specialist

Registered: 04/12/07
Posts: 384
Loc: Canada
We have been having pricing and cost errors in Adagio Inventory in the past few days. It seems like randomly selected items' prices and costs are being multiplied by factors of 100, 1000, or 10,000. Regional settings have been check and are fine. We were told upgrading to the latest versions of Adagio would fix this but it is still happening.

We are running:
Adagio Inventory 8.1B (091210)
Purchase Orders 8.1A (091029)
OrderEntry 8.1C (090731)

UPDATE:
It appears as though we have found out what is triggering the problem. We believe the source of the problem is in OrderEntry. When we open up an order in OrderEntry and post the order, it multiplies the price and cost of that item in Inventory by 1000 or 10,000. When we open up the item in OrderEntry, the price and cost are multiplied by 10. We have tested it on a few items and it is consistently doing this. How do we fix this?


Edited by Acrylon (05/05/10 07:42 AM)

Top
#22097 - 05/05/10 07:46 AM Re: Random distorted prices and costs [Re: Acrylon]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11532
Loc: Vancouver, BC Canada
Hi, Acrylon,

Upgrading doesn't fix past errors that already exist in data. Often we tweak the DIC in new releases and, therefore, after the upgrade, DIC may be able to detect and possibly fix errors that existed before. Make sure you have a backup and run DIC in all 3 modules.

Upgrading will prevent errors from occurring moving forward from the upgrade if the errors were caused by a program problem we were able to duplicate and fix.
_________________________
Regards,
Softrak Tech Support

Top
#22102 - 05/05/10 10:48 AM Re: Random distorted prices and costs [Re: Softrak Support]
Acrylon Offline
Adagio Specialist

Registered: 04/12/07
Posts: 384
Loc: Canada
Is DIC 'Data Integrity Check'?

If this doesn't fix the problem, what are you suggestions?

Thanks,

Top
#22103 - 05/05/10 10:55 AM Re: Random distorted prices and costs [Re: Softrak Support]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4413
Loc: Vancouver, BC
At best the historical errors may be correctable manually, at worst a database repair (or at least some back door fixes using GV-RW) may be required. You should obtain some expert assistance to sort this out.

For IC you may need the Hot Fix issued 100310 and for OE you may need the Hot Fix issued 100208. These are only available from your Adagio dealer.

If we can assist please call me at 204 944 0302.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#22209 - 05/08/10 08:40 AM Re: Random distorted prices and costs [Re: Douglas Dickie]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Has this issue been resolved?
_________________________
Andrew Bates

Top
#22217 - 05/10/10 09:56 AM Re: Random distorted prices and costs [Re: Retired_Guy]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4413
Loc: Vancouver, BC
Yes. They were able to create the problem on command. Problem was solved by un-installing OE and re-installing the current full version plus the latest update.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#22218 - 05/10/10 10:10 AM Re: Random distorted prices and costs [Re: Douglas Dickie]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Great!

Thanks for the update.
_________________________
Andrew Bates

Top
#22219 - 05/10/10 11:11 AM Re: Random distorted prices and costs [Re: Retired_Guy]
Acrylon Offline
Adagio Specialist

Registered: 04/12/07
Posts: 384
Loc: Canada
Doug was a great help. He fixed this and identified a few other 'areas for opportunity'!

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 48 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70633 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
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