Topic Options
#27651 - 06/14/11 08:31 AM Smart Finder Qty On Hand Incorrect
Kristin Offline
Operations Manager

Registered: 09/08/08
Posts: 68
Loc: Madison, Virginia
I am using the smart finder to look at quantities on hand for certain items. If I'm not mistaken, the field listed as "Qty On Hand" is supposed to show the sum of Qty on hand 1 thru Qty on hand 5". It is not working for me, instead "Qty On Hand" is displaying the same amount as "Qty on Hand 1". I just upgraded to IC 8.1C and OE 8.1D and hoped it would fix the error, but no luck.
Any suggestions are appreciated!

Top
#27681 - 06/16/11 07:21 PM Re: Smart Finder Qty On Hand Incorrect [Re: Kristin]
BAMPH Offline
Paradise is perspective

Registered: 07/15/01
Posts: 875
Loc: Christ Church, BARBADOS
Add the "Qty Shipped not Costed" field to your SF grid to see if the confusion stems from there. This field should represent the the net quantities on INs and CNs that have not yet been processed by Day End. You can always use the Sample Data to do your testing so that you can have more control over the testing and expected results.

Pete
_________________________
Peter Banfield
BAMPH Consulting Services
Barbados

Top
#27683 - 06/16/11 08:52 PM Re: Smart Finder Qty On Hand Incorrect [Re: Kristin]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Kirstin,

Where are you looking at the SmartFinder? Does the field on the SmartFinder agree with the basic item grid? I know that this was fixed many months ago in some part of Adagio. Perhaps the problem has been re-introduced.
_________________________
Andrew Bates

Top
#27704 - 06/17/11 02:31 PM Re: Smart Finder Qty On Hand Incorrect [Re: Kristin]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Kristin,

Investigation into this today has showed that, while the display is correct in the Grid, SmartFinder is not properly selecting items based on their quantity on hand for lifo/fifo costed items. Filters do correctly select the items, if you can use them in SmartFinder's place.
_________________________
Andrew Bates

Top
#27845 - 07/01/11 10:03 AM Re: Smart Finder Qty On Hand Incorrect [Re: Retired_Guy]
Kristin Offline
Operations Manager

Registered: 09/08/08
Posts: 68
Loc: Madison, Virginia
Great, I will do that! Thanks Andrew

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (1 invisible), 120 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 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