This topic contains 3 replies, has 0 voices, and was last updated by KCSF Bud 8 years, 9 months ago.
-
AuthorPosts
-
October 19, 2015 at 9:21 am #5431
Winston123Hi
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
KCSF BudYou 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
Dpanetta@aecageco.comWinston123, 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
KCSF BudItem 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.
-
AuthorPosts
You must be logged in to reply to this topic.