Forums › Cached › Customization › Searches / List Views

This topic contains 3 replies, has 0 voices, and was last updated by KCSF Bud 8 years, 8 months ago.

  • Author
    Posts
  • October 19, 2015 at 9:21 am #5431 Score: 0

    Winston123
    • Contributions: 0
    • Level 1
    • ☆

    Hi

    I am trying to create a save search for an EDI 846 document for Wayfair, which requires available quantity per inventory location. The problem I am facing right now is that I can’t find a solution to do Kit/Package available quantity per location. The only thing I can achieve is getting a consolidate quantity available for the kit/package item, not inventory location specific. Does anyone has done this before? Appreciate for any comment or suggestion.

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

  • October 22, 2015 at 10:00 pm #5432 Score: 0

    KCSF Bud
    • Contributions: 0
    • Level 1
    • ☆

    You might try to use the ‘Location Available’ field instead of ‘Available’. (We renamed Locations to Warehouses so I use ‘Warehouse Available’ when necessary). I haven’t looked at this in a while, so curious how you are getting the Kit available quantity? It was a little tricky before, so we use a formula field grouped by ‘Minimum’ with this formula: CASE WHEN {type} = ‘Kit/Package’ THEN (NVL(TRUNC({memberitem.quantityavailable}/{memberquantity},0),0))ELSE NVL({quantityavailable},0)END. Note that you would use locationquantityavailable (I think) instead of quantityavailable.

    Any other creative you have to get that available quantity?

  • February 19, 2016 at 2:48 pm #5433 Score: 0

    Dpanetta@aecageco.com
    • Contributions: 0
    • Level 1
    • ☆

    Winston123, i too am having trouble with kits showing available and KCSF Bud’s approach didn’t work for me. I wanted to see if you had a solution. Who is your edi provider? Mine is HighJump/True Commerce.

  • February 22, 2016 at 9:51 am #5434 Score: 0

    KCSF Bud
    • Contributions: 0
    • Level 1
    • ☆

    Item search for kits only with formula (Numeric) of (NVL(TRUNC({memberitem.quantityavailable}/{memberquantity},0),0)) and Summary Type of Minimum, also result fields Grouped by Item and Grouped by Member Item:Inventory Location shows one row for each location and the number of kits available in that location. I can help with specific questions if that result is what you are needing for the EDI document.

  • Author
    Posts

You must be logged in to reply to this topic.