[Hans Wittig]

I am running a transaction search that lists individual fulfillments for items from a particular vendor for the "previous year". The data that returns is incomplete. It does not show all of the items or all of the fulfillments within that year.

This search has been running for several years without any issues. Possible the recent release and / or the change to multi-location may have caused the failure. The search has been adapted to now include the location. The data does not change whether I include the location or not.

Results ; Item : Preferred Vendor
Group

Date Created
Group

Item : Purchase Price
Group

Item : Vendor Name
Group

Item : Name
Group

Quantity
Sum
Absolute Value

Item : Date Added to Site (Custom)
Group

Item : Reorder Multiple
Group

Item : Location Reorder Point
Group

Item : Location Preferred Stock Level
Group

Item : Sale Unit
Group

Item : Purchase Unit
Group

Item : Location Available
Group

Item : Description
Group

Item : Internal ID
Group

Criteria Type
is any of Assembly Build, Item Fulfillment

Item : Stock Type (Custom)
is any of Stock, Cross Dock, Drop Ship, Import

Date Created
is within previous one year

Item : Preferred Vendor
is ******Company

Item : Vendor Name
does not contain %disc%

Item : Name
starts with R%

Item : Location Preferred Stock Level
is not empty

Any Ideas?

Thanks

Hans
This is a cached copy. Click here to see the original post.

[BrianE]

If some items are outright missing the culprit could be "Item : Location Preferred Stock Level is not empty". Might be worthwhile to create an item search with the criteria your using on items to make sure all show up that you think should.

I would also suggest using "Date is within previous one year". That would reference the transaction date (Field ID: trandate which is usually labeled as just Date) instead of when the transaction record was created which while often the same is not always.

[Author]

Posts