This topic contains 1 reply, has 0 voices, and was last updated by BrianE 6 years, 9 months ago.

  • Author
    Posts
  • #22633 Score: 0

    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
    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.

  • #22634 Score: 0

    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.

You must be logged in to reply to this topic.