This topic contains 1 reply, has 0 voices, and was last updated by BrianE 6 years, 9 months ago.
-
AuthorPosts
-
Hans Wittig- Contributions: 0
- Level 1
- ☆
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
GroupDate Created
GroupItem : Purchase Price
GroupItem : Vendor Name
GroupItem : Name
GroupQuantity
Sum
Absolute ValueItem : Date Added to Site (Custom)
GroupItem : Reorder Multiple
GroupItem : Location Reorder Point
GroupItem : Location Preferred Stock Level
GroupItem : Sale Unit
GroupItem : Purchase Unit
GroupItem : Location Available
GroupItem : Description
GroupItem : Internal ID
GroupCriteria Type
is any of Assembly Build, Item FulfillmentItem : Stock Type (Custom)
is any of Stock, Cross Dock, Drop Ship, ImportDate Created
is within previous one yearItem : Preferred Vendor
is ******CompanyItem : Vendor Name
does not contain %disc%Item : Name
starts with R%Item : Location Preferred Stock Level
is not emptyAny Ideas?
Thanks
Hans
This is a cached copy. Click here to see the original post. -
BrianE- Contributions: 0
- Level 1
- ☆
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.
-
AuthorPosts
You must be logged in to reply to this topic.