Yes - we tend to sell per foot. Each manufacturer has different spool lengths we buy in (some in feet, some in meters) and unit conversions handle all that very nicely. Our sales team can see the purchase units quick and on occasion we even sell by the full spool - that really hasn’t been much of an issue for us though.We’re primarily online retail, and this is just one portion of a larger catalog. Orders come in though our commerce connector and need to move to the warehouse as fast as possible through scheduled tasks. For most of our inventory we’re able to have orders picked/packed/shipped within hours of them coming in online - Lot tracing would probably add a lot of administrative complexity, slow down that process and really wouldn’t solve much for us since shipments could still split lots if a person wasn’t careful. Seems to me that it’s a feature Acumatica should consider - I’m not sure which would fit the greater needs beyond our use case, but having some control at either th
Since we’re dealing with a linear product that’s cut to length, what would be ideal for us is to setup locations that do allow sales but contain our small quantities (end of reel remnants) and if the quantity is sufficient it would be at a higher pick priority and shipments would be driven there first, if it was insufficient it would go up the line until it found a single location with enough available to fulfill the entire quantity.
Use Item Default Location for Picking only controls the pick priority one step further - but we still have the same problem. If the Default Location has an insufficient quantity for the line item it will still split the pick across multiple locations with the Default Location being the first it pulls from
One table - PX.Objects.IN.INCategory
Two solutions to suggest -The sales person can select ‘Mark for PO’ on the sales order and then ‘Purchase to Order’ for the PO Source. The buyer then uses the Create Purchase Orders process screen (PO505000) to combine IN Replenishment and the SO to Purchase plan Types to generate a single PO. Alternately - insert a replenishment plan with a 0/0 min/max and then on the prepare replenishment screen (IN508000) you can could setup a filter to view Qty on Demand > 0 + Max Qty = 0 to view all demand against items without a true re-order point
Not sure what your requirements are or what features you’re after but I would recommend you take a look at StarShip from VTechnologies - It’s an incredibly powerful shipping tool with great support and a well thought out Acumatica integration. In fact, it was StarShip that first made me aware of Acumatica. We’ve been a client for year’s and have always been very happy with the product.
We had to import sales categories to our existing stock items prior to our ecom integration since it’s a required field - we had some help on this from our implementation team, well before I understood much of the process, so I really only helped in prepping the data - but I think the trick was using the category ID and not the description It looks like they setup a simple GI to get a list of sales categories + Category ID From there they were able to setup the import scenario using the IDs --Hopefully that gets you pointed in the right direction - let me know if you could use more details on either the GI or Import Scenrio, happy to share what I can deduce from what I see here
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.