Smartlist Results Double the Actual Qty

[brendasql]

I am using GP9 and I received an emailed from one user saying that when she would export her smartlist results to excel that only half the items were being exported. I tried several and so far I can only see this problem in Purchase Line Items. At the bottom of the smartlist results grid the results reads

|64 Purchase Line Items|Complete

but there are only 32 rows in the smartlist grid and only 32 rows are exported to excel. Also, I have queried this info directly from query analyzer in sql and my results there are 32 records. So this means that the qty displayed in the bottom result is incorrect. Does anyone have an idea as to why this count would be doubled on the smartlist grid? And the best way to correct?


Thanks,
B

 

[RobertC22]

When I use the Purchase Line Items smartlist object, the number of records shown in the status line is double the number displayed.
Looks like it might be a bug in that Smartlist object.

DynamicsGP 9.00.0114
Smartlist 9.00.0114
------
Robert

 

[brendasql]

Thanks for responding! At least I can now be sure that I didn't do anything wrong. Maybe the next upgrade will take care of this bug.....

 

[VictoriaYudin]

Yes, I believe this is a known bug, but as far as I know this is the only SmartList that behaves this way - all others should be showing correct totals.

Victoria
Flexible Solutions, Inc.