Topic Options
#7728 - 10/12/06 11:08 AM Data Integrity error
Fong Offline
Adagio Ace

Registered: 09/11/06
Posts: 201
Loc: Canada
How to get rid of these errors manually? Thanks in advance.

Data Repair Phase


Correcting Phase 2 Errors
Item 19711 quantity of lost sales LY is below zero, must be corrected manually.
Item 34006 quantity of lost sales LY is below zero, must be corrected manually.
Item S12255 quantity of lost sales LY is below zero, must be corrected manually.
Item XX0067 quantity of lost sales LY is below zero, must be corrected manually.

Top
#7729 - 10/12/06 11:24 AM Re: Data Integrity error
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11559
Loc: Vancouver, BC Canada
Hi Fong,

In Adagio Inventory, from the Edit menu and Item Maintenance, pick Sales History. Type into the item number field one of the codes that are giving an error.

There are statistical fields for Qty of Lost Sales YTD and Qty of Lost Sales LY, and neither should be below zero. Because they are simply statistical, the Data Integrity Check can't fix the values as there is nothing to compare and determine what the correct value should be. From this screen is how you can correct this manually.

If you don't use these Lost Sales quantities for anything, they could be edited to zero and that would make the errors you found go away.
_________________________
Regards,
Softrak Tech Support

Top
#7730 - 10/13/06 01:22 PM Re: Data Integrity error
Fong Offline
Adagio Ace

Registered: 09/11/06
Posts: 201
Loc: Canada
Thank you very much!

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 56 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14474 Topics
70689 Posts

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