Skip to main content

Is there any way to turn off the "split" warehouse function on a sales order?  We use SA and SO when entering orders and this works the same in both entries.  This is very confusing, and our confirmations print out showing this line twice, which makes no sense.  It seems to split the line when there is stock in another warehouse/location.  I have flagged the warehouse to not "allow sales" and it still splits the line.  I have tried every function/flag possible (that I know of).  My other warehouses are not for resale, they are for instruments that we keep as samples for our internal reference only.  I do not want the system generating anything from our other two warehouses.  How can this be done?   Please see below example.  

I would appreciate any input you can provide or if anyone handles inventory not for resale a different way in Acumatica. 

Hoping someone can help me understand this functionality better and provide a solution. 

Thank you!

Maureen

 

SO/shipment screen: 

confirmation ticket: looks like we are shipping 24 pieces. 

 

 

@maureen45 I am presuming you have unticked the Include in Qty Available and Allow Sales at the location level on these warehouses. If so that should work 

Your picking note print out would look to be incorrect as it would appear to be getting the Qty from the Shipment Line and not from the Shipment line split (hence why you are seeing 24 instead of a total of 12 for the 2 lines


@dcomerford  Thank you for your reply but I do not have the quantity available or the allow sales checked off and it still splits it on the confirmation.  We do not use the pick ticket for our warehouse as this only shows what it available in stock, so if an item shows no stock and there really is, it wouldn’t print on the pick ticket and corrected.  We made a change to have 2 confirmations print, showing all the items on the order.  One for our warehouse to use as a pick ticket and one as a packing slip to our customer. However, this “split” quantity shows up and it’s confusing to our warehouse, and we haven’t even tried sending one to a customer yet.  I would assume that if I checked off “do not allow sales” this meant do not look at this warehouse, but it does.  I only want to see what I have in warehouse 01 on my order and/or confirmation ticket, unless I change the warehouse in the order to another one manually.   Any other suggestions, I’m open to anything that may help.  Thank you again. 


@maureen45 Where are you generating the Confirmation ticket from the Sales Order or the Shipment?


@dcomerford  I am generating it from the sales order, but either way it prints the same.  I can’t figure out why some items do the split and some don’t.  I checked all fields on the items, and nothing stands out to be different.  I just need to remove this “split” logic, so all my orders look at warehouse 01 locations only.  We can’t move on until I can resolve this issue.    Thank you again for your help. 


@maureen45 Can you click on one of the lines that is split and open the line details and what do you see.


@dcomerford   SO view line details

It never shows the split as “allocated” and on the confirmation it shows as the full quantity and also fully backorder. 

this view is the shipment page:

This is the view on the confirmation ticket:

So, it looks like 24 are ordered, 10 shipping ad 14 backordered.  The order is for 12 pcs. 


@maureen45 You will need to fix the printout as that is getting the qty from the line not the split lines.Looking at your screenshots this implies when the Sales Order was created only 10 were available to allocate.


@dcomerford  How would the printout be fixed?  I haven’t done our forms; our provider has done all our forms.  What would I need to advise them that they only should be printing what is allocated and if it's a “split” don’t print that line?  I have been working with them as well trying to fix this issue and haven’t been able to find a fix.  If it’s just a printout that is fine, but that still leaves why does an item split?  I can’t figure out the logic of a “split” and can’t find anything to advise why an item will appear as a split and some don’t.  Thanks for all your help and suggestions. 


Reply