[Winston123 Contributions: 0Level 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.

[KCSF Bud Contributions: 0Level 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?

[Dpanetta@aecageco.com Contributions: 0Level 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.

[KCSF Bud Contributions: 0Level 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